I_InspCharcsQtyCube

Characteristic Analytics - Quantities | view: IINSPCHARQTY | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QASV, QASR, T001W, CRHD

🔑 Keys (4)
💰 Amounts
∑ Quantities (4)
📅 Dates (1)
☰ Categorical (3)
Other (13)
🔗 Relations (14)

Column Name	Description
InspectionLot FK	Inspection Lot Number
InspPlanOperationInternalID	Current Node Number from Order Counter
InspectionCharacteristic	Inspection Characteristic Number
InspectionSubsetInternalID	Inspection Sample 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
CreationDate	Result Recorded On

Column Name	Description
InspResultAggregationLevel	Inspection Result Aggregation Level	Show values
InspectionSubsetType	Inspection Point Type	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
InspectionOperation	Operation/Activity Number	VORNR
InspResultHistoryCharc	null
MasterInspCharcsKey	null
InspectionSpecificationText	Short Text for Inspection Characteristic	QKURZTEXT
WorkCenter	Work Center	ARBPL
WorkCenterPlantName	Plant Name	TEXT30
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
BOOOperationInternalID	Number of the Task List Node	KNTNR
InspectionSpecificationPlant	Plant for Master Inspection Characteristic	QZAEHLER
InspectionSpecificationVersion	Version Number of Master Inspection Characteristic	QVERSNR
InspLotSkipQuantityInPercent	null
InspLotRjctdQuantityInPercent	null

Master Data Relations	Join Conditions
Bill of Operations Type Bill of Operations Type Client	`I_INSPCHARCSQTYCUBE.BILLOFOPERATIONSTYPE == TCA01.PLNTY` `I_INSPCHARCSQTYCUBE.MANDT == TCA01.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`I_INSPCHARCSQTYCUBE.CUSTOMER == KNA1.KUNNR` `I_INSPCHARCSQTYCUBE.MANDT == KNA1.MANDT`
Inspection Lot Origin	`I_INSPCHARCSQTYCUBE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity	`I_INSPCHARCSQTYCUBE.MANDT == T006.MANDT` `I_INSPCHARCSQTYCUBE.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `I_INSPCHARCSQTYCUBE.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity	`I_INSPCHARCSQTYCUBE.MANDT == T006.MANDT` `I_INSPCHARCSQTYCUBE.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `I_INSPCHARCSQTYCUBE.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI`
Inspection Type Inspection Type Client	`I_INSPCHARCSQTYCUBE.INSPECTIONLOTTYPE == TQ30.ART` `I_INSPCHARCSQTYCUBE.MANDT == TQ30.MANDT`
Plant Plant Client	`I_INSPCHARCSQTYCUBE.INSPECTIONOPERATIONPLANT == T001W.WERKS` `I_INSPCHARCSQTYCUBE.MANDT == T001W.MANDT`
Master Inspection Characteristic Master Inspection Characteristic Client ? Plant for Master Inspection Characteristic	`I_INSPCHARCSQTYCUBE.INSPECTIONSPECIFICATION == QPMK.MKMNR` `I_INSPCHARCSQTYCUBE.MANDT == QPMK.MANDT` `I_INSPCHARCSQTYCUBE.[column in domain "QVERSNRMK"] == QPMK.VERSION` `I_INSPCHARCSQTYCUBE.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER`
Material Number Client Material Number	`I_INSPCHARCSQTYCUBE.MANDT == MARA.MANDT` `I_INSPCHARCSQTYCUBE.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`I_INSPCHARCSQTYCUBE.MANDT == TQ01B.MANDT` `I_INSPCHARCSQTYCUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`I_INSPCHARCSQTYCUBE.MANDT == T001W.MANDT` `I_INSPCHARCSQTYCUBE.PLANT == T001W.WERKS`
Vendor's account number Client Vendor's account number	`I_INSPCHARCSQTYCUBE.MANDT == LFA1.MANDT` `I_INSPCHARCSQTYCUBE.SUPPLIER == LFA1.LIFNR`
Object ID of the resource Object ID of the resource ? Client	`I_INSPCHARCSQTYCUBE.WORKCENTERINTERNALID == CRID.OBJID` `I_INSPCHARCSQTYCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY` `I_INSPCHARCSQTYCUBE.MANDT == CRID.MANDT`