C_QualityLvlMng

Manage Quality Level | view: CQLTYLVLMNG | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QALS, QAVE, QDQL, PLPO, TCA01, TCA02, PLMK, PLMK, KNA1, TQ30, TQ30T, QDEP, QDEPT, QDDR, QDDRT, QDPS, QDPST, MARA, MAKT, T001W, LFA1, QPCD, QPCT, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, CRHD

🔑 Keys (8)
💰 Amounts
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (8)
Other (32)
🔗 Relations (24)

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

Column Name	Description

Column Name	Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity	Inspection Lot Quantity

Column Name	Description
QltyLvlIndirectlyChangedOn	Change Date of the Quality Level
QltyLvlManuallyChangedOn	Change Date (Manual) of the Quality Level
QualityLevelLastInspectionOn	Date of Last Inspection
QualityLevelResetOn	Reset Date of Quality Level
QualityLevelDeletionOn	Deletion Date of the Quality Level

Column Name	Description
InspectionLotIsSkipped	Inspection Lot Is Skipped	Show values
InspectionLotStatusSkip	Inspection Lot Is Skipped	Show values
InspectionValuationResult	Valuation of the Characteristic from Results Recording	Show values
InspLotHasSubsets	Checkbox	Show values
InspectionLotHasUsageDecision	Checkbox	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values
InspLotUsgeDcsnDynValuation	Dynamic Modification Valuation of the Last Inspection Lot	Show values
InspResultDynModifValuation	Dynamic Modification Valuation (Accept/Reject) of Char.	Show values

Column Name	Description	Domain name
BillOfOperationsTypeName	Description of the Task List Type	TEXT30
InspLotDynamicRuleText	Short Text	QKURZTEXT
InspectionSeverityText	Short Text	QKURZTEXT
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
MaterialByCustomer	Customer Material	IDNEX
MaterialName	Material Description	TEXT40
PlantName	Plant Name	TEXT30
InspLotDynRuleStageText	Short Text	QKURZTEXT
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
InspLotsWithoutUsageDecision	Number of Inspection Lots Without Usage Decision	QDYNANZ2
BOOCharacteristic	Inspection Characteristic Number	QMERKNRP
InspectionCharacteristic	Characteristic Number in the Quality Level	QMERKNRP
InspectionSpecificationText	Short Text for Inspection Characteristic	QKURZTEXT
InspectionOperation	Operation Number in the Quality Level	VORNR
InspLotsSinceStageChg	Number of Inspections Since Inspection Stage Change	QDYNANZ2
InspectionLot	Number of Last Inspection Lot with Usage Decision	NUMC12
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	Material Document Item	MBLPO
MaterialDocumentYear	Material Document Year	GJAHR
InventorySpclStkSalesDocument	Inventory Special Stock Sales Document	VBELN
InventorySpclStkSalesDocItm	Sales Order Item of Valuated Sales Order Stock	NUM06
WorkCenter	Work Center	ARBPL
UsageDecisionCodeText	Text for Code	QKURZTEXT
InspectionLotQualityScore	Quality Score	QKENNZAHL
QltyLvlIndirectlyChangedBy	User who Last Changed the Quality Level	QAENDERER
QltyLvlManuallyChangedBy	User who Manually Changed the Quality Level	QAENDERER
ChangedDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
LastChangedByUserFullName	Full Name of Person	TEXT80
QltyLevelCanceledInspections	No. of Cancelled Inspections per Char. Since Last Inspection	QDYNANZ2
RjctdInspLotsSinceStgeChg	Number of Not-OK Inspections (Rejections) Since Stage Change	QDYNANZ2
QualityLevelLastOpenInspLot	Number of Last Inspection Lot Without Usage Decision	NUMC12

Master Data Relations	Join Conditions
Key for Task List Group Group Counter Task List Type ? Client Key for Task List Group	`C_QUALITYLVLMNG.BILLOFOPERATIONSVARIANT == PLKO.PLNAL` `C_QUALITYLVLMNG.BILLOFOPERATIONSTYPE == PLKO.PLNTY` `C_QUALITYLVLMNG.[column in domain "CIM_COUNT"] == PLKO.ZAEHL` `C_QUALITYLVLMNG.MANDT == PLKO.MANDT` `C_QUALITYLVLMNG.BILLOFOPERATIONSGROUP == PLKO.PLNNR`
Task List Type Task List Type Client	`C_QUALITYLVLMNG.BILLOFOPERATIONSTYPE == TCA01.PLNTY` `C_QUALITYLVLMNG.MANDT == TCA01.MANDT`
Customer Account Number Customer Account Number Client	`C_QUALITYLVLMNG.CUSTOMER == KNA1.KUNNR` `C_QUALITYLVLMNG.MANDT == KNA1.MANDT`
Inspection Stage Dynamic Modification Rule Client Inspection Stage	`C_QUALITYLVLMNG.INSPLOTDYNAMICRULE == QDPS.DYNREGEL` `C_QUALITYLVLMNG.MANDT == QDPS.MANDT` `C_QUALITYLVLMNG.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE`
Level at Which Dynamic Modification Parameters Are Defined	`C_QUALITYLVLMNG.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL`
Inspection Lot Origin	`C_QUALITYLVLMNG.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Client	`C_QUALITYLVLMNG.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `C_QUALITYLVLMNG.MANDT == T006.MANDT`
Inspection Type Inspection Type Client	`C_QUALITYLVLMNG.INSPECTIONLOTTYPE == TQ30.ART` `C_QUALITYLVLMNG.MANDT == TQ30.MANDT`
Usage Decision Code ? ? ? Client Usage Decision Code	`C_QUALITYLVLMNG.[column in domain "QKATART"] == QPCD.KATALOGART` `C_QUALITYLVLMNG.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE` `C_QUALITYLVLMNG.[column in domain "QVERSNR"] == QPCD.VERSION` `C_QUALITYLVLMNG.MANDT == QPCD.MANDT` `C_QUALITYLVLMNG.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE`
Inspection Severity Inspection Severity Client	`C_QUALITYLVLMNG.INSPECTIONSEVERITY == QDEP.PRSCHAERFE` `C_QUALITYLVLMNG.MANDT == QDEP.MANDT`
Dynamic Modification Rule Dynamic Modification Rule Client	`C_QUALITYLVLMNG.INSPLOTDYNAMICRULE == QDDR.DYNREGEL` `C_QUALITYLVLMNG.MANDT == QDDR.MANDT`
Manufacturer Account Number Manufacturer Account Number Client	`C_QUALITYLVLMNG.MANUFACTURER == LFA1.LIFNR` `C_QUALITYLVLMNG.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`C_QUALITYLVLMNG.MANUFACTURERPARTNMBR == MARA.MATNR` `C_QUALITYLVLMNG.MANDT == MARA.MANDT`
Order Number (Production Order) Order Number (Production Order) Client	`C_QUALITYLVLMNG.MANUFACTURINGORDER == AUFK.AUFNR` `C_QUALITYLVLMNG.MANDT == AUFK.MANDT`
Material Number Material Number Client	`C_QUALITYLVLMNG.MATERIAL == MARA.MATNR` `C_QUALITYLVLMNG.MANDT == MARA.MANDT`
Material Authorization Group for Activities in QM Material Authorization Group for Activities in QM Client	`C_QUALITYLVLMNG.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH` `C_QUALITYLVLMNG.MANDT == TQ01B.MANDT`
Plant Plant Client	`C_QUALITYLVLMNG.PLANT == T001W.WERKS` `C_QUALITYLVLMNG.MANDT == T001W.MANDT`
Purchasing Organization Purchasing Organization Client	`C_QUALITYLVLMNG.PURCHASINGORGANIZATION == T024E.EKORG` `C_QUALITYLVLMNG.MANDT == T024E.MANDT`
Inspection Stage for Next Inspection Dynamic Modification Rule Inspection Stage for Next Inspection Client	`C_QUALITYLVLMNG.INSPLOTDYNAMICRULE == QDPS.DYNREGEL` `C_QUALITYLVLMNG.QLTYLEVELNEXTDYNRULESTAGE == QDPS.PRSTUFE` `C_QUALITYLVLMNG.MANDT == QDPS.MANDT`
Sales Organization Sales Organization Client	`C_QUALITYLVLMNG.SALESORGANIZATION == TVKO.VKORG` `C_QUALITYLVLMNG.MANDT == TVKO.MANDT`
Sampling Procedure Sampling Procedure Client	`C_QUALITYLVLMNG.SAMPLINGPROCEDURE == QDSV.STICHPRVER` `C_QUALITYLVLMNG.MANDT == QDSV.MANDT`
Supplier Account Number Supplier Account Number Client	`C_QUALITYLVLMNG.SUPPLIER == LFA1.LIFNR` `C_QUALITYLVLMNG.MANDT == LFA1.MANDT`