C_QltyLvlHistByInspLot

Quality Lvl Hist By InspLot | view: CQLTYHISTINSP | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QALS, QAVE, QDQL, TQ30, TQ30T, QDPS, QPCD, QPCT
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
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
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
InspectionLotIsSkipped Skip Lot 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
  • Group Counter
  • Client
  • Key for Task List Group
  • ?
  • Task List Type
  • C_QLTYLVLHISTBYINSPLOT.BILLOFOPERATIONSVARIANT == PLKO.PLNAL
  • C_QLTYLVLHISTBYINSPLOT.MANDT == PLKO.MANDT
  • C_QLTYLVLHISTBYINSPLOT.BILLOFOPERATIONSGROUP == PLKO.PLNNR
  • C_QLTYLVLHISTBYINSPLOT.[column in domain "CIM_COUNT"] == PLKO.ZAEHL
  • C_QLTYLVLHISTBYINSPLOT.BILLOFOPERATIONSTYPE == PLKO.PLNTY
Task List Type
  • Client
  • Task List Type
  • C_QLTYLVLHISTBYINSPLOT.MANDT == TCA01.MANDT
  • C_QLTYLVLHISTBYINSPLOT.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Customer Account Number
  • Customer Account Number
  • Client
  • C_QLTYLVLHISTBYINSPLOT.CUSTOMER == KNA1.KUNNR
  • C_QLTYLVLHISTBYINSPLOT.MANDT == KNA1.MANDT
Inspection Stage
  • Dynamic Modification Rule
  • Inspection Stage
  • Inspection Stage
  • Client
  • C_QLTYLVLHISTBYINSPLOT.INSPLOTDYNAMICRULE == QDPS.DYNREGEL
  • C_QLTYLVLHISTBYINSPLOT.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE
  • C_QLTYLVLHISTBYINSPLOT.INSPLOTDYNRULESKIPSTAGE == QDPS.PRSTUFE
  • C_QLTYLVLHISTBYINSPLOT.MANDT == QDPS.MANDT
Level at Which Dynamic Modification Parameters Are Defined C_QLTYLVLHISTBYINSPLOT.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL
Base Unit of Measure for Inspection Lot Quantity
  • Base Unit of Measure for Inspection Lot Quantity
  • Client
  • C_QLTYLVLHISTBYINSPLOT.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_QLTYLVLHISTBYINSPLOT.MANDT == T006.MANDT
Sample Unit of Measure
  • Sample Unit of Measure
  • Client
  • C_QLTYLVLHISTBYINSPLOT.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
  • C_QLTYLVLHISTBYINSPLOT.MANDT == T006.MANDT
Inspection Type
  • Inspection Type
  • Client
  • C_QLTYLVLHISTBYINSPLOT.INSPECTIONLOTTYPE == TQ30.ART
  • C_QLTYLVLHISTBYINSPLOT.MANDT == TQ30.MANDT
Usage Decision Code
  • ?
  • Usage Decision Code
  • ?
  • ?
  • Client
  • C_QLTYLVLHISTBYINSPLOT.[column in domain "QVERSNR"] == QPCD.VERSION
  • C_QLTYLVLHISTBYINSPLOT.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • C_QLTYLVLHISTBYINSPLOT.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE
  • C_QLTYLVLHISTBYINSPLOT.[column in domain "QKATART"] == QPCD.KATALOGART
  • C_QLTYLVLHISTBYINSPLOT.MANDT == QPCD.MANDT
Dynamic Modification Rule
  • Dynamic Modification Rule
  • Client
  • C_QLTYLVLHISTBYINSPLOT.INSPLOTDYNAMICRULE == QDDR.DYNREGEL
  • C_QLTYLVLHISTBYINSPLOT.MANDT == QDDR.MANDT
Manufacturer Account Number
  • Manufacturer Account Number
  • Client
  • C_QLTYLVLHISTBYINSPLOT.MANUFACTURER == LFA1.LIFNR
  • C_QLTYLVLHISTBYINSPLOT.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • C_QLTYLVLHISTBYINSPLOT.MANDT == MARA.MANDT
  • C_QLTYLVLHISTBYINSPLOT.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • C_QLTYLVLHISTBYINSPLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • C_QLTYLVLHISTBYINSPLOT.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • C_QLTYLVLHISTBYINSPLOT.MANDT == T001W.MANDT
  • C_QLTYLVLHISTBYINSPLOT.PLANT == T001W.WERKS
Supplier Account Number
  • Client
  • Supplier Account Number
  • C_QLTYLVLHISTBYINSPLOT.MANDT == LFA1.MANDT
  • C_QLTYLVLHISTBYINSPLOT.SUPPLIER == LFA1.LIFNR