C_QltyLvlHistByChar

Quality Lvl Hist By Char | view: CQLTYHISTCHAR | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAVE, QASV, QDQL, TQ30, TQ30T, QDPS, 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
InspectionLotIsSkipped	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	Inspection Stage	QPRSTUFE

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