I_InspCharQuantitativeCube

Chracteristics Analytics - Quantitative Analysis | view: IINSPCHARQUANTCH | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, PLMK, QPMK, T001W, CRHD

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

Column Name	Description
InspectionLot FK	Inspection Lot Number
InspPlanOperationInternalID	Current Node Number from Order Counter
InspectionCharacteristic	Inspection Characteristic Number

Column Name	Description

Column Name	Description

Column Name	Description
CreationDate	Result Recorded On

Column Name	Description
InspResultAggregationLevel	Inspection Result Aggregation Level	Show values
InspSpecHasLowerLimit	Value Not Initial if Set	Show values
InspSpecHasUpperLimit	Value Not Initial if Set	Show values
BOOCharcHasInspSpecReference	Reference to Master Insp. Characteristic in Task List	Show values
InspCharcsHasLowerLimit	Value Not Initial if Set	Show values
InspCharcsHasUpperLimit	Value Not Initial if Set	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
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
BOOOperationInternalID	Number of the Task List Node	KNTNR
InspResultHistoryCharc	null
MasterInspCharcsKey	null
InspectionSpecificationText	Short Text for Inspection Characteristic	QKURZTEXT
InspectionSpecificationPlant	Plant for Master Inspection Characteristic	QZAEHLER
InspectionSpecificationVersion	Version Number of Master Inspection Characteristic	QVERSNR
WorkCenter	Work Center	ARBPL
WorkCenterPlantName	Plant Name	TEXT30
NumberOfInspections	null
InspectionResultMeanValue	Arithmetic Mean of Valid Measured Values	QSTATWERT
InspResultVariance	null
InspRsltBelowToleranceValsNmbr	Number of Measured Values Below Tolerance Range	QANZAHL4
InspRsltAboveToleranceValsNmbr	Number of Measured Values Above Tolerance Range	QANZAHL4
InspRsltFrmtdStandardDeviation	Standard Deviation of Valid Measured Values (KPI)	QSTATWERT
InspSpecUpperLimit	Upper Specification Limit	QSOLLWERTE
InspSpecLowerLimit	Lower Specification Limit	QSOLLWERTE
InspCharcsUpperLimit	Upper Specification Limit	QSOLLWERTE
InspCharcsLowerLimit	Lower Specification Limit	QSOLLWERTE

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