I_QltyMgmtInfoSystCharcsCube

Characteristics Detailed Analytics | view: IQMISCHARANLYS | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist

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

🔑 Keys (4)
💰 Amounts
∑ Quantities (4)
📅 Dates (1)
☰ Categorical (5)
Other (30)
🔗 Relations (15)

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
InspSpecHasLowerLimit	Value Not Initial if Set	Show values
InspSpecHasUpperLimit	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
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
NumberOfInspections	null
NmbrOfVltdInspections	null
NumberOfAcceptedInspCharcs	null
NumberOfRejectedInspCharcs	null
NumberOfSkipInspCharcs	null
NumberOfNotSkipInspCharcs	null
InspSkipRatePercent	null
InspRsltRjcnRatePercent	null
InspRsltNonconformingValsNmbr	null
InspResultValidValuesNumber	null
InspLotSkipQuantityInPercent	null
InspLotRjctdQuantityInPercent	null
InspectionResultMeanValue	Arithmetic Mean of Valid Measured Values	QSTATWERT
InspResultVariance	Dispersion (Variance) of Valid Measured Values	QSTATWERT
InspRsltFrmtdStandardDeviation	Standard Deviation of Valid Measured Values (KPI)	QSTATWERT
InspRsltBelowToleranceValsNmbr	Number of Measured Values Below Tolerance Range	QANZAHL4
InspRsltAboveToleranceValsNmbr	Number of Measured Values Above Tolerance Range	QANZAHL4
InspSpecLowerLimit	Lower Specification Limit	QSOLLWERTE
InspSpecUpperLimit	Upper Specification Limit	QSOLLWERTE

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