I_InspectionCharacteristicCube

Inspection Characteristic Cube | view: IINSPCHARC | TRAN | Extraction: Not supported | Component: Information System
Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QASV, QASR
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
InspectionSubsetInternalID null
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
InspectionOperation Operation/Activity Number VORNR
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
BillOfOperationsChangeStateID Internal counter CIM_COUNT
InspCharOpenSampleCount null
InspCharcAcceptedSampleCount null
InspCharRejectedSampleCount null
InspectionResultMinimumValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultMaximumValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultMeanValueSum null
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL4
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL4
Master Data Relations Join Conditions
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == TCA01.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Bill of Operations Usage
  • Client
  • Bill of Operations Usage
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == T411.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.BILLOFOPERATIONSUSAGE == T411.VERWE
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == KNA1.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.CUSTOMER == KNA1.KUNNR
Inspection Type
  • Client
  • Inspection Type
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == TQ30.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.INSPECTIONLOTTYPE == TQ30.ART
Master Inspection Characteristic
  • ?
  • Master Inspection Characteristic
  • Client
  • Plant for Master Inspection Characteristic
  • I_INSPECTIONCHARACTERISTICCUBE.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • I_INSPECTIONCHARACTERISTICCUBE.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == QPMK.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
Unit of Measurement in Which Quantitative Data Is Stored
  • Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • I_INSPECTIONCHARACTERISTICCUBE.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • I_INSPECTIONCHARACTERISTICCUBE.MATERIAL == MARA.MATNR
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == TQ01B.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTICCUBE.PLANT == T001W.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • I_INSPECTIONCHARACTERISTICCUBE.SUPPLIER == LFA1.LIFNR
  • I_INSPECTIONCHARACTERISTICCUBE.MANDT == LFA1.MANDT