I_QualityLevelTP

Quality Level | view: IQLTYLVLTP | ATTR | Extraction: Not supported | Component: Quality Control
Tables used: QDQL
Column Name Description
Plant FK Plant
Material FK Material Number
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
QltyLvlIndirectlyChangedOn Change Date of the Quality Level
QltyLvlManuallyChangedOn Change Date (Manual) of the Quality Level
QualityLevelLastInspectionOn Date of Last Inspection
QualityLevelDeletionOn Deletion Date of the Quality Level
QualityLevelResetOn Reset Date of Quality Level
Column Name Description
InspLotUsageDecisionValuation Valuation (Usage Decision) of the Last Inspection Lot Show values
InspLotUsgeDcsnDynValuation Dynamic Modification Valuation of the Last Inspection Lot Show values
InspResultDynModifValuation Dynamic Modification Valuation (Accept/Reject) of Char. Show values
InspectionValuationResult Valuation of the Characteristic from Results Recording Show values
Column Name Description Domain name
InspectionOperation Operation Number in the Quality Level VORNR
InspectionCharacteristic Characteristic Number in the Quality Level QMERKNRP
QltyLvlIndirectlyChangedBy User who Last Changed the Quality Level QAENDERER
QltyLvlManuallyChangedBy User who Manually Changed the Quality Level QAENDERER
InspectionLot Number of Last Inspection Lot with Usage Decision NUMC12
InspLotsWithoutUsageDecision Number of Inspection Lots Without Usage Decision QDYNANZ2
InspLotsSinceStageChg Number of Inspections Since Inspection Stage Change QDYNANZ2
RjctdInspLotsSinceStgeChg Number of Not-OK Inspections (Rejections) Since Stage Change QDYNANZ2
QualityLevelLastOpenInspLot Number of Last Inspection Lot Without Usage Decision NUMC12
QltyLevelCanceledInspections No. of Cancelled Inspections per Char. Since Last Inspection QDYNANZ2
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Key for Task List Group
  • Client
  • Group Counter
  • Task List Type
  • Key for Task List Group
  • ?
  • I_QUALITYLEVELTP.MANDT == PLKO.MANDT
  • I_QUALITYLEVELTP.BILLOFOPERATIONSVARIANT == PLKO.PLNAL
  • I_QUALITYLEVELTP.BILLOFOPERATIONSTYPE == PLKO.PLNTY
  • I_QUALITYLEVELTP.BILLOFOPERATIONSGROUP == PLKO.PLNNR
  • I_QUALITYLEVELTP.[column in domain "CIM_COUNT"] == PLKO.ZAEHL
Task List Type
  • Client
  • Task List Type
  • I_QUALITYLEVELTP.MANDT == TCA01.MANDT
  • I_QUALITYLEVELTP.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Customer Account Number
  • Client
  • Customer Account Number
  • I_QUALITYLEVELTP.MANDT == KNA1.MANDT
  • I_QUALITYLEVELTP.CUSTOMER == KNA1.KUNNR
Inspection Type
  • Client
  • Inspection Type
  • I_QUALITYLEVELTP.MANDT == TQ30.MANDT
  • I_QUALITYLEVELTP.INSPECTIONLOTTYPE == TQ30.ART
Dynamic Modification Rule
  • Dynamic Modification Rule
  • Client
  • I_QUALITYLEVELTP.INSPLOTDYNAMICRULE == QDDR.DYNREGEL
  • I_QUALITYLEVELTP.MANDT == QDDR.MANDT
Manufacturer Account Number
  • Manufacturer Account Number
  • Client
  • I_QUALITYLEVELTP.MANUFACTURER == LFA1.LIFNR
  • I_QUALITYLEVELTP.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • I_QUALITYLEVELTP.MANDT == MARA.MANDT
  • I_QUALITYLEVELTP.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_QUALITYLEVELTP.MANDT == T001W.MANDT
  • I_QUALITYLEVELTP.PLANT == T001W.WERKS
Inspection Stage for Next Inspection
  • Dynamic Modification Rule
  • Client
  • Inspection Stage for Next Inspection
  • I_QUALITYLEVELTP.INSPLOTDYNAMICRULE == QDPS.DYNREGEL
  • I_QUALITYLEVELTP.MANDT == QDPS.MANDT
  • I_QUALITYLEVELTP.QLTYLEVELNEXTDYNRULESTAGE == QDPS.PRSTUFE
Sampling Procedure
  • Client
  • Sampling Procedure
  • I_QUALITYLEVELTP.MANDT == QDSV.MANDT
  • I_QUALITYLEVELTP.SAMPLINGPROCEDURE == QDSV.STICHPRVER
Supplier Account Number
  • Supplier Account Number
  • Client
  • I_QUALITYLEVELTP.SUPPLIER == LFA1.LIFNR
  • I_QUALITYLEVELTP.MANDT == LFA1.MANDT