C_QualityLevelAnalysis

Quality Level History | view: CQLTYLVLANALYZE | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: SCAL_TT_DATEQAMVQALSQAVEQASV
Column Name Description
Column Name Description
Column Name Description
Column Name Description
InspectionLotCreatedOn System Date on Which Data Record Was Created
Column Name Description
IsInspectionLotSkippedText Inspection Lot Is Skipped Show values
Column Name Description Domain name
InspectionLot Inspection Lot Number QPLOS
InspectionCharacteristic Inspection Characteristic QMERKNRP
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
InspLotDynamicRule Dynamic Modification Rule QDYNREGEL
InspectionDynamicStage Inspection Stage QPRSTUFE
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionSeverity Inspection Severity QPRSCHAERF
InspectionLotCount Number of Inspection Lots VDM_QM_COUNTER
InspCharCount No. of Characteristics VDM_QM_COUNTER
InspectionLotIsSkipped Inspection Lots Skipped VDM_QM_COUNTER
InspectionLotIsNotSkipped Inspection Lots Not Skipped VDM_QM_COUNTER
InspCharcSkipCount Characteristics Skipped VDM_QM_COUNTER
InspCharcNotSkipCount Characteristics Not Skipped VDM_QM_COUNTER
InspectionNotSkippedCount Inspection Lots and Characteristics Not Skipped VDM_QM_COUNTER
QualityLevelCount Quality Levels VDM_QM_COUNTER
InspectionSkipRate null
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Bill of Operations Type
  • Bill of Operations Type
  • Client
  • C_QUALITYLEVELANALYSIS.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • C_QUALITYLEVELANALYSIS.MANDT == TCA01.MANDT
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • C_QUALITYLEVELANALYSIS.MANDT == KNA1.MANDT
  • C_QUALITYLEVELANALYSIS.CUSTOMER == KNA1.KUNNR
Level at Which Dynamic Modification Parameters Are Defined C_QUALITYLEVELANALYSIS.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL
Inspection Type
  • Inspection Type
  • Client
  • C_QUALITYLEVELANALYSIS.INSPECTIONLOTTYPE == TQ30.ART
  • C_QUALITYLEVELANALYSIS.MANDT == TQ30.MANDT
Usage Decision Code
  • ?
  • Client
  • ?
  • Usage Decision Code
  • ?
  • C_QUALITYLEVELANALYSIS.[column in domain "QVERSNR"] == QPCD.VERSION
  • C_QUALITYLEVELANALYSIS.MANDT == QPCD.MANDT
  • C_QUALITYLEVELANALYSIS.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE
  • C_QUALITYLEVELANALYSIS.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • C_QUALITYLEVELANALYSIS.[column in domain "QKATART"] == QPCD.KATALOGART
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • C_QUALITYLEVELANALYSIS.MANDT == LFA1.MANDT
  • C_QUALITYLEVELANALYSIS.MANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • C_QUALITYLEVELANALYSIS.MANDT == MARA.MANDT
  • C_QUALITYLEVELANALYSIS.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_QUALITYLEVELANALYSIS.MANDT == T001W.MANDT
  • C_QUALITYLEVELANALYSIS.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • C_QUALITYLEVELANALYSIS.MANDT == LFA1.MANDT
  • C_QUALITYLEVELANALYSIS.SUPPLIER == LFA1.LIFNR