I_InspectionLotQuantitiesCube

Inspection Lot Analytics - Quantity | view: IINSPLOTQUAN | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QALS, QAVE

🔑 Keys (1)
💰 Amounts
∑ Quantities (4)
📅 Dates (2)
☰ Categorical (1)
Other (2)
🔗 Relations (10)

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
📏 Base Unit of Measure for Inspection Lot Quantity (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
InspLotSkipQuantityInPercent	null
InspLotRjctdQuantityInPercent	null

Master Data Relations	Join Conditions
Customer (Ship-To Party) Customer (Ship-To Party) Client	`I_INSPECTIONLOTQUANTITIESCUBE.CUSTOMER == KNA1.KUNNR` `I_INSPECTIONLOTQUANTITIESCUBE.MANDT == KNA1.MANDT`
Inspection Lot Origin	`I_INSPECTIONLOTQUANTITIESCUBE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Client	`I_INSPECTIONLOTQUANTITIESCUBE.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `I_INSPECTIONLOTQUANTITIESCUBE.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI` `I_INSPECTIONLOTQUANTITIESCUBE.MANDT == T006.MANDT`
Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Client	`I_INSPECTIONLOTQUANTITIESCUBE.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `I_INSPECTIONLOTQUANTITIESCUBE.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI` `I_INSPECTIONLOTQUANTITIESCUBE.MANDT == T006.MANDT`
Inspection Type Inspection Type Client	`I_INSPECTIONLOTQUANTITIESCUBE.INSPECTIONLOTTYPE == TQ30.ART` `I_INSPECTIONLOTQUANTITIESCUBE.MANDT == TQ30.MANDT`
Number of Manufacturer Number of Manufacturer Client	`I_INSPECTIONLOTQUANTITIESCUBE.MANUFACTURER == LFA1.LIFNR` `I_INSPECTIONLOTQUANTITIESCUBE.MANDT == LFA1.MANDT`
Material Number Client Material Number	`I_INSPECTIONLOTQUANTITIESCUBE.MANDT == MARA.MANDT` `I_INSPECTIONLOTQUANTITIESCUBE.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`I_INSPECTIONLOTQUANTITIESCUBE.MANDT == TQ01B.MANDT` `I_INSPECTIONLOTQUANTITIESCUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`I_INSPECTIONLOTQUANTITIESCUBE.MANDT == T001W.MANDT` `I_INSPECTIONLOTQUANTITIESCUBE.PLANT == T001W.WERKS`
Vendor's account number Vendor's account number Client	`I_INSPECTIONLOTQUANTITIESCUBE.SUPPLIER == LFA1.LIFNR` `I_INSPECTIONLOTQUANTITIESCUBE.MANDT == LFA1.MANDT`