C_QltyLvlHistCharcs

Quality Level History by Characteristics | view: CQLTYLVLHISTCHAR | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAVE, QASV, QDQL, TQ30, TQ30T, QPCD, QPCT

🔑 Keys (11)
💰 Amounts
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (2)
Other (3)
🔗 Relations (15)

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
InspectionLot	Inspection Lot Number
InspPlanOperationInternalID	Current Node Number from Order Counter
InspectionCharacteristic	Inspection Characteristic Number

Column Name	Description

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

Column Name	Description
InspectionLotCreatedOn	System Date on Which Data Record Was Created
InspectionLotCreatedOnTime	System Time of Creation

Column Name	Description
InspCharIsSkipped	Checkbox	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
UsageDecisionCodeText	Text for Code	QKURZTEXT
InspLotDynRuleSkipStage	null

Master Data Relations	Join Conditions
Key for Task List Group Client Task List Type Group Counter ? Key for Task List Group	`C_QLTYLVLHISTCHARCS.MANDT == PLKO.MANDT` `C_QLTYLVLHISTCHARCS.BILLOFOPERATIONSTYPE == PLKO.PLNTY` `C_QLTYLVLHISTCHARCS.BILLOFOPERATIONSVARIANT == PLKO.PLNAL` `C_QLTYLVLHISTCHARCS.[column in domain "CIM_COUNT"] == PLKO.ZAEHL` `C_QLTYLVLHISTCHARCS.BILLOFOPERATIONSGROUP == PLKO.PLNNR`
Task List Type Client Task List Type	`C_QLTYLVLHISTCHARCS.MANDT == TCA01.MANDT` `C_QLTYLVLHISTCHARCS.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Customer Account Number Client Customer Account Number	`C_QLTYLVLHISTCHARCS.MANDT == KNA1.MANDT` `C_QLTYLVLHISTCHARCS.CUSTOMER == KNA1.KUNNR`
Inspection Stage Client ? Inspection Stage	`C_QLTYLVLHISTCHARCS.MANDT == QDPS.MANDT` `C_QLTYLVLHISTCHARCS.[column in domain "QDYNREGEL"] == QDPS.DYNREGEL` `C_QLTYLVLHISTCHARCS.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE`
Level at Which Dynamic Modification Parameters Are Defined	`C_QLTYLVLHISTCHARCS.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`C_QLTYLVLHISTCHARCS.MANDT == T006.MANDT` `C_QLTYLVLHISTCHARCS.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Sample Unit of Measure Sample Unit of Measure Client	`C_QLTYLVLHISTCHARCS.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI` `C_QLTYLVLHISTCHARCS.MANDT == T006.MANDT`
Inspection Type Client Inspection Type	`C_QLTYLVLHISTCHARCS.MANDT == TQ30.MANDT` `C_QLTYLVLHISTCHARCS.INSPECTIONLOTTYPE == TQ30.ART`
Usage Decision Code ? Client Usage Decision Code ? ?	`C_QLTYLVLHISTCHARCS.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE` `C_QLTYLVLHISTCHARCS.MANDT == QPCD.MANDT` `C_QLTYLVLHISTCHARCS.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE` `C_QLTYLVLHISTCHARCS.[column in domain "QKATART"] == QPCD.KATALOGART` `C_QLTYLVLHISTCHARCS.[column in domain "QVERSNR"] == QPCD.VERSION`
Dynamic Modification Rule Dynamic Modification Rule Client	`C_QLTYLVLHISTCHARCS.INSPLOTDYNAMICRULE == QDDR.DYNREGEL` `C_QLTYLVLHISTCHARCS.MANDT == QDDR.MANDT`
Manufacturer Account Number Client Manufacturer Account Number	`C_QLTYLVLHISTCHARCS.MANDT == LFA1.MANDT` `C_QLTYLVLHISTCHARCS.MANUFACTURER == LFA1.LIFNR`
Material Number Client Material Number	`C_QLTYLVLHISTCHARCS.MANDT == MARA.MANDT` `C_QLTYLVLHISTCHARCS.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_QLTYLVLHISTCHARCS.MANDT == TQ01B.MANDT` `C_QLTYLVLHISTCHARCS.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_QLTYLVLHISTCHARCS.MANDT == T001W.MANDT` `C_QLTYLVLHISTCHARCS.PLANT == T001W.WERKS`
Supplier Account Number Supplier Account Number Client	`C_QLTYLVLHISTCHARCS.SUPPLIER == LFA1.LIFNR` `C_QLTYLVLHISTCHARCS.MANDT == LFA1.MANDT`