C_QltyMgmtInfoSystInspLot

Inspection Lot Analytics | view: CQMISINSPLOT | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: SCAL_TT_DATEQALSQAVEKNA1TQ30TMAKTT001WLFA1
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 Skip Quantity
InspectionLotRejectedQuantity Inspection Lot Rejected 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
InspectionLotTypeText Inspection Type Text QKURZTEXT
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
CustomerFullName Customer Full Name TEXT220
ManufacturerName Name of Supplier TEXT80
InspectionLotCount Number of Inspection Lots VDM_QM_COUNTER
NmbrOfVltdInspections Number of Inspections with Valuation VDM_QM_COUNTER
InspectionLotIsSkipped Inspection Lots Skipped VDM_QM_COUNTER
InspectionLotIsNotSkipped Inspection Lots Not Skipped VDM_QM_COUNTER
InspectionSkipRate Skip Rate of Inspection Lots VDM_QM_FLTP
NumberOfAcceptedInspectionLots Number of Accepted Inspection Lots VDM_QM_COUNTER
NumberOfRejectedInspectionLots Number of Rejected Inspection Lots VDM_QM_COUNTER
InspectionLotRejectedRate Inspection Lot Rejection Rate VDM_QM_FLTP
InspLotSampleQuantityInPercent Skip Quantity (in %) VDM_QM_FLTP
InspLotSkipQuantityInPercent null
InspLotRjctdQuantityInPercent null
MeanQualityScore Mean Quality Score VDM_QM_FLTP
InspLotMeanProcgDurationInDays Mean Processing Time (in Days) VDM_QM_FLTP
InspectionLotCreatedOnYear Year of Lot Creation NUM4
InspectionLotCreatedOnQuarter Quarter of Lot Creation NUM1
InspectionLotCreatedOnQtrName Short Text for Fixed Values DDTEXT
InspectionLotCreatedOnMonth Month of Lot Creation NUM2
InspectionLotCreatedOnMnthName Short Text for Fixed Values DDTEXT
InspectionLotCreatedOnWeek Week of Lot Creation NUM2
InspLotUsgeDecidedOnYear Year of Usage Decision NUM4
InspLotUsgeDecidedOnQuarter Quarter of Usage Decision NUM1
InspLotUsgeDecidedOnQtrName Short Text for Fixed Values DDTEXT
InspLotUsgeDecidedOnMonth Month of Usage Decision NUM2
InspLotUsgeDecidedOnMnthName Short Text for Fixed Values DDTEXT
InspLotUsgeDecidedOnWeek Week of Usage Decision NUM2
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_QLTYMGMTINFOSYSTINSPLOT.CUSTOMER == KNA1.KUNNR
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == KNA1.MANDT
Inspection Lot Origin C_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Base Unit of Measure for Inspection Lot Quantity
  • Client
  • C_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == T006.MANDT
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == T006.MANDT
  • C_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
Inspection Type
  • Inspection Type
  • Client
  • C_QLTYMGMTINFOSYSTINSPLOT.INSPECTIONLOTTYPE == TQ30.ART
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == TQ30.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_QLTYMGMTINFOSYSTINSPLOT.MANUFACTURER == LFA1.LIFNR
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == LFA1.MANDT
Material Number
  • Material Number
  • Client
  • C_QLTYMGMTINFOSYSTINSPLOT.MATERIAL == MARA.MATNR
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == TQ01B.MANDT
  • C_QLTYMGMTINFOSYSTINSPLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == T001W.MANDT
  • C_QLTYMGMTINFOSYSTINSPLOT.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • C_QLTYMGMTINFOSYSTINSPLOT.MANDT == LFA1.MANDT
  • C_QLTYMGMTINFOSYSTINSPLOT.SUPPLIER == LFA1.LIFNR