I_QltyMgmtInfoSystInspLot

Inspection Lot Analytics | view: IQMISINSPLOT | 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
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity Inspection Lot Quantity
InspectionLotSkipQuantity Inspection Lot Quantity
InspectionLotRejectedQuantity Inspection Lot Quantity
📏 Sample Unit of Measure (InspectionLotSampleUnit):
InspectionLotSampleQuantity Inspection Sample Size
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
InspectionLotCount null
NmbrOfVltdInspections null
InspectionLotIsSkipped null
InspectionLotIsNotSkipped null
InspectionSkipRate null
NumberOfAcceptedInspectionLots null
NumberOfRejectedInspectionLots null
InspectionLotRejectedRate null
InspLotSkipQuantityInPercent null
InspLotRjctdQuantityInPercent null
InspectionLotQualityScore Quality Score QKENNZAHL
InspLotMeanProcgDurationInDays null
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.CUSTOMER == KNA1.KUNNR
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == KNA1.MANDT
Inspection Lot Origin I_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Base Unit of Measure for Inspection Lot Quantity
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == T006.MANDT
Sample Unit of Measure
  • Sample Unit of Measure
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == T006.MANDT
Inspection Type
  • Inspection Type
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTTYPE == TQ30.ART
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == TQ30.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.MANUFACTURER == LFA1.LIFNR
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == LFA1.MANDT
Material Number
  • Material Number
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.MATERIAL == MARA.MATNR
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.PLANT == T001W.WERKS
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_QLTYMGMTINFOSYSTINSPLOT.SUPPLIER == LFA1.LIFNR
  • I_QLTYMGMTINFOSYSTINSPLOT.MANDT == LFA1.MANDT