C_QualityLvlCalc

Quality Level Calculation | view: CQLTYLVLCALC | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QALS, QDQL, QDPS

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (2)
Other (2)
🔗 Relations (18)

Column Name	Description
Material FK	Material Number
Plant FK	Plant
BillOfOperationsType FK	Task List Type
BillOfOperationsGroup FK	Key for Task List Group
BillOfOperationsVariant	Group Counter
BOOOperationInternalID	Number of Task List Node
Sequence	Sequence of Operations Within a Plan
QualityLevelInternalID	Sequential Counter for Different Quality Levels

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
InspectionLotIsSkipped	Checkbox	Show values
InspectionLotHasQuantity	Posted to Inspection Stock	Show values

Column Name	Description	Domain name
InspectionLot	Number of Last Inspection Lot with Usage Decision	NUMC12
QualityLevelLastOpenInspLot	Number of Last Inspection Lot Without Usage Decision	NUMC12

Master Data Relations	Join Conditions
Storage Location for Batch Storage Location for Batch ? Client Material Number ?	`C_QUALITYLVLCALC.BATCHSTORAGELOCATION == MCHB.LGORT` `C_QUALITYLVLCALC.[column in domain "CHARG_D"] == MCHB.CHARG` `C_QUALITYLVLCALC.MANDT == MCHB.MANDT` `C_QUALITYLVLCALC.MATERIAL == MCHB.MATNR` `C_QUALITYLVLCALC.[column in domain "WERKS_D"] == MCHB.WERKS`
Key for Task List Group ? Client Task List Type Group Counter Key for Task List Group	`C_QUALITYLVLCALC.[column in domain "CIM_COUNT"] == PLKO.ZAEHL` `C_QUALITYLVLCALC.MANDT == PLKO.MANDT` `C_QUALITYLVLCALC.BILLOFOPERATIONSTYPE == PLKO.PLNTY` `C_QUALITYLVLCALC.BILLOFOPERATIONSVARIANT == PLKO.PLNAL` `C_QUALITYLVLCALC.BILLOFOPERATIONSGROUP == PLKO.PLNNR`
Task List Type Client Task List Type	`C_QUALITYLVLCALC.MANDT == TCA01.MANDT` `C_QUALITYLVLCALC.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Customer Account Number Client Customer Account Number	`C_QUALITYLVLCALC.MANDT == KNA1.MANDT` `C_QUALITYLVLCALC.CUSTOMER == KNA1.KUNNR`
Level at Which Dynamic Modification Parameters Are Defined	`C_QUALITYLVLCALC.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL`
Inspection Lot Origin	`C_QUALITYLVLCALC.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Client Inspection Type	`C_QUALITYLVLCALC.MANDT == TQ30.MANDT` `C_QUALITYLVLCALC.INSPECTIONLOTTYPE == TQ30.ART`
Dynamic Modification Rule Dynamic Modification Rule Client	`C_QUALITYLVLCALC.INSPLOTDYNAMICRULE == QDDR.DYNREGEL` `C_QUALITYLVLCALC.MANDT == QDDR.MANDT`
Manufacturer Account Number Client Manufacturer Account Number	`C_QUALITYLVLCALC.MANDT == LFA1.MANDT` `C_QUALITYLVLCALC.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Manufacturer Material Client	`C_QUALITYLVLCALC.MANUFACTURERPARTNMBR == MARA.MATNR` `C_QUALITYLVLCALC.MANDT == MARA.MANDT`
Material Number Client Material Number	`C_QUALITYLVLCALC.MANDT == MARA.MANDT` `C_QUALITYLVLCALC.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_QUALITYLVLCALC.MANDT == TQ01B.MANDT` `C_QUALITYLVLCALC.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_QUALITYLVLCALC.MANDT == T001W.MANDT` `C_QUALITYLVLCALC.PLANT == T001W.WERKS`
Purchasing Organization Client Purchasing Organization	`C_QUALITYLVLCALC.MANDT == T024E.MANDT` `C_QUALITYLVLCALC.PURCHASINGORGANIZATION == T024E.EKORG`
Inspection Stage for Next Inspection Dynamic Modification Rule Client Inspection Stage for Next Inspection	`C_QUALITYLVLCALC.INSPLOTDYNAMICRULE == QDPS.DYNREGEL` `C_QUALITYLVLCALC.MANDT == QDPS.MANDT` `C_QUALITYLVLCALC.QLTYLEVELNEXTDYNRULESTAGE == QDPS.PRSTUFE`
Sales Organization Client Sales Organization	`C_QUALITYLVLCALC.MANDT == TVKO.MANDT` `C_QUALITYLVLCALC.SALESORGANIZATION == TVKO.VKORG`
Customer (Sold-To Party) Customer (Sold-To Party) Client	`C_QUALITYLVLCALC.SOLDTOPARTY == KNA1.KUNNR` `C_QUALITYLVLCALC.MANDT == KNA1.MANDT`
Supplier Account Number Client Supplier Account Number	`C_QUALITYLVLCALC.MANDT == LFA1.MANDT` `C_QUALITYLVLCALC.SUPPLIER == LFA1.LIFNR`