I_InspectionLotQltyScoreCube

Inspection Lot Analytics - Quality Score | view: IINSPLOTQSCORE | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QALS, QAVE
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
InspectionLotCreatedOn System Date on Which Data Record Was Created
InspectionLotUsageDecidedOn Date When Usage Decision Was Made
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspectionLotQualityScore Quality Score QKENNZAHL
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == KNA1.MANDT
  • I_INSPECTIONLOTQLTYSCORECUBE.CUSTOMER == KNA1.KUNNR
Inspection Lot Origin I_INSPECTIONLOTQLTYSCORECUBE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == TQ30.MANDT
  • I_INSPECTIONLOTQLTYSCORECUBE.INSPECTIONLOTTYPE == TQ30.ART
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • I_INSPECTIONLOTQLTYSCORECUBE.MANUFACTURER == LFA1.LIFNR
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == LFA1.MANDT
Material Number
  • Material Number
  • Client
  • I_INSPECTIONLOTQLTYSCORECUBE.MATERIAL == MARA.MATNR
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == TQ01B.MANDT
  • I_INSPECTIONLOTQLTYSCORECUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == T001W.MANDT
  • I_INSPECTIONLOTQLTYSCORECUBE.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • I_INSPECTIONLOTQLTYSCORECUBE.MANDT == LFA1.MANDT
  • I_INSPECTIONLOTQLTYSCORECUBE.SUPPLIER == LFA1.LIFNR