QDQL

Quality level | #transactional | Component: Active Quality Control
Column Name Description
MANDT FK Client
WERKS FK Plant
MATNR FK Material Number
PLNTY FK Task List Type
PLNNR FK Key for Task List Group
PLNAL Group Counter
PLNFL Sequence of Operations Within a Plan
PLNKN Number of Task List Node
ZAEHLERQL Sequential Counter for Different Quality Levels
Column Name Description
Column Name Description
Column Name Description
AEDATLOSA Change Date of the Quality Level
AEDATLOSM Change Date (Manual) of the Quality Level
AEZEILOSA Change Time of Q-Level
AEZEILOSM Change Time (Manual) of Q-Level
DATLPRUEF Date of Last Inspection
DELDATUM Deletion Date of the Quality Level
RESDATUM Reset Date of Quality Level
Column Name Description
BWLOS Valuation (Usage Decision) of the Last Inspection Lot Show values
BWLOSDYN Dynamic Modification Valuation of the Last Inspection Lot Show values
DBEWERTG Dynamic Modification Valuation (Accept/Reject) of Char. Show values
MBEWERTG Valuation of the Characteristic from Results Recording Show values
Column Name Description Domain name
VORNR Operation Number in the Quality Level VORNR
MERKNR Characteristic Number in the Quality Level QMERKNRP
VPLNR Group of the referenced task list PLNNR
VPLAL Group counter of the referenced task list ALTNR
VPLFL Referenced sequence in routing PLNFOLGE
VPLNKN Number of the Task List Node KNTNR
AENDLOSA User who Last Changed the Quality Level QAENDERER
AENDLOSM User who Manually Changed the Quality Level QAENDERER
PRUEFLOS Number of the Last Inspection Lot with Usage Decision NUMC12
ANZLOSEOVE Number of Inspection Lots Without Usage Decision QDYNANZ2
ANZPRAEN Number of Inspections Since Inspection Stage Change QDYNANZ2
ANZNIOAEN Number of Not-OK Inspections (Rejections) Since Stage Change QDYNANZ2
PLOSOVE Number of Last Inspection Lot Without Usage Decision NUMC12
ANZPRSTOP No. of Cancelled Inspections per Char. Since Last Inspection QDYNANZ2
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Dynamic Modification Rule
  • QDQL.MANDT == QDDR.MANDT
  • QDQL.DYNREGEL == QDDR.DYNREGEL
Manufacturer Account Number
  • QDQL.MANDT == LFA1.MANDT
  • QDQL.HERSTELLER == LFA1.LIFNR
Customer Account Number
  • QDQL.MANDT == KNA1.MANDT
  • QDQL.KUNNR == KNA1.KUNNR
Supplier Account Number
  • QDQL.MANDT == LFA1.MANDT
  • QDQL.LIFNR == LFA1.LIFNR
Client QDQL.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QDQL.MATNR == MARA.MATNR
  • QDQL.MANDT == MARA.MANDT
Key for Task List Group
  • Key for Task List Group
  • ?
  • Client
  • Task List Type
  • Group Counter
  • QDQL.PLNNR == PLKO.PLNNR
  • QDQL.[column in domain "CIM_COUNT"] == PLKO.ZAEHL
  • QDQL.MANDT == PLKO.MANDT
  • QDQL.PLNTY == PLKO.PLNTY
  • QDQL.PLNAL == PLKO.PLNAL
Task List Type
  • QDQL.MANDT == TCA01.MANDT
  • QDQL.PLNTY == TCA01.PLNTY
Inspection Stage for Next Inspection
  • Inspection Stage for Next Inspection
  • Client
  • Dynamic Modification Rule
  • QDQL.PRSTUFENAE == QDPS.PRSTUFE
  • QDQL.MANDT == QDPS.MANDT
  • QDQL.DYNREGEL == QDPS.DYNREGEL
Inspection Type
  • QDQL.MANDT == TQ30.MANDT
  • QDQL.PRUEFART == TQ30.ART
Sampling Procedure
  • Sampling Procedure
  • Client
  • QDQL.STICHPRVER == QDSV.STICHPRVER
  • QDQL.MANDT == QDSV.MANDT
Type of the referenced task list
  • QDQL.MANDT == TCA01.MANDT
  • QDQL.VPLTY == TCA01.PLNTY
Plant
  • QDQL.MANDT == T001W.MANDT
  • QDQL.WERKS == T001W.WERKS