I_InspCharcsKeyFigCube

Characteristics Analytics - Key Figures | view: IINSPCHARKEYFIG | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist

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

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

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

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
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
MasterInspCharcsKey	null
InspectionSpecificationText	Short Text for Inspection Characteristic	QKURZTEXT
WorkCenter	Work Center	ARBPL
WorkCenterPlantName	Plant Name	TEXT30
NumberOfInspections	null
NmbrOfVltdInspections	null
NumberOfAcceptedInspCharcs	null
NumberOfRejectedInspCharcs	null
NumberOfSkipInspCharcs	null
NumberOfNotSkipInspCharcs	null
InspSkipRatePercent	null
InspRsltRjcnRatePercent	null
InspRsltNonconformingValsNmbr	null
InspResultValidValuesNumber	null

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