I_QualityLevelAnalysisCube

Quality Level History - Cube | view: IQLTYLVLANALYZE | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: SCAL_TT_DATE, QAMV, QALS, QAVE, QASV
Column Name Description
InspectionLot Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic
Column Name Description
Column Name Description
Column Name Description
InspectionLotCreatedOn System Date on Which Data Record Was Created
Column Name Description
InspectionLotStatusSkip Skip Lot Show values
IsInspectionLotSkippedText Checkbox Show values
IndicatorValue Checkbox Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
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
InspectionSeverity Inspection Severity QPRSCHAERF
InspectionLotCount null
InspCharCount null
InspectionLotIsSkipped null
InspectionLotIsNotSkipped null
InspCharcSkipCount null
InspCharcNotSkipCount null
InspectionNotSkippedCount null
QualityLevelCount 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
  • Client
  • Bill of Operations Type
  • I_QUALITYLEVELANALYSISCUBE.MANDT == TCA01.MANDT
  • I_QUALITYLEVELANALYSISCUBE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • I_QUALITYLEVELANALYSISCUBE.CUSTOMER == KNA1.KUNNR
  • I_QUALITYLEVELANALYSISCUBE.MANDT == KNA1.MANDT
Level at Which Dynamic Modification Parameters Are Defined I_QUALITYLEVELANALYSISCUBE.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL
Inspection Type
  • Inspection Type
  • Client
  • I_QUALITYLEVELANALYSISCUBE.INSPECTIONLOTTYPE == TQ30.ART
  • I_QUALITYLEVELANALYSISCUBE.MANDT == TQ30.MANDT
Usage Decision Code
  • ?
  • Usage Decision Code
  • Usage Decision Code Group
  • Client
  • ?
  • I_QUALITYLEVELANALYSISCUBE.[column in domain "QKATART"] == QPCD.KATALOGART
  • I_QUALITYLEVELANALYSISCUBE.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • I_QUALITYLEVELANALYSISCUBE.INSPLOTUSAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE
  • I_QUALITYLEVELANALYSISCUBE.MANDT == QPCD.MANDT
  • I_QUALITYLEVELANALYSISCUBE.[column in domain "QVERSNR"] == QPCD.VERSION
Usage Decision Code Group
  • ?
  • Usage Decision Code Group
  • Client
  • I_QUALITYLEVELANALYSISCUBE.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_QUALITYLEVELANALYSISCUBE.INSPLOTUSAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE
  • I_QUALITYLEVELANALYSISCUBE.MANDT == QPGR.MANDT
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • I_QUALITYLEVELANALYSISCUBE.MANDT == LFA1.MANDT
  • I_QUALITYLEVELANALYSISCUBE.MANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • I_QUALITYLEVELANALYSISCUBE.MANDT == MARA.MANDT
  • I_QUALITYLEVELANALYSISCUBE.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_QUALITYLEVELANALYSISCUBE.MANDT == TQ01B.MANDT
  • I_QUALITYLEVELANALYSISCUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • I_QUALITYLEVELANALYSISCUBE.PLANT == T001W.WERKS
  • I_QUALITYLEVELANALYSISCUBE.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_QUALITYLEVELANALYSISCUBE.SUPPLIER == LFA1.LIFNR
  • I_QUALITYLEVELANALYSISCUBE.MANDT == LFA1.MANDT