C_InspectionResultAggregate

Aggregate of Inspection Result | view: CINSPRESAGR | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QAMVQALSAFVCQAOPQAMRQASVQASRCRHD
Column Name Description
InspectionResultHistory Sort Number for Item
InspectionResultHistoryFilter Filter for Results History
InspResultAggregationLevel Inspection Result Aggregation Level Show values
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on Which Data Record Was Created (Characteristic)
Column Name Description
InspResultAggregationLevel Inspection Result Aggregation Level Show values
InspCharcIsNotPlanned Unplanned Characteristic Show values
InspectionResultHasMeanValue Mean Value Not Initial (KPI) Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspectionValuationResult Inspection Result Valuation Show values
InspSpecCharacteristicType Characteristic Type Show values
Column Name Description Domain name
InspResultHistoryCharc Inspection Characteristic Key for Results History
BillOfOperationsGroup Key for Bill of Operations Group (Characteristic) PLNNR
BillOfOperationsVariant Bill of Operations Group Counter (Characteristic) ALTNR
BOOOperationInternalID Number of the Task List Node KNTNR
InspectionOperation Operation Number (Characteristic) VORNR
InspectionCharacteristic Inspection Characteristic Number (Characteristic) QMERKNRP
InspectionSpecificationPlant Plant for the Master Inspection Characteristic (Charc) QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic (Charc) QVERSNR
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
UnitOfMeasureTechnicalName External Unit of Measurement in Technical Format (6-Char.) MSEH6
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values (KPI) QSTATWERT
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspResultValidValuesNumber Number of Inspected Sample Units (KPI) QANZAHL4
CtrlChartProcessCapability Process Capability Index - Cp (KPI) QSTATWERTC
CtrlChartMeanProcessCapability Process Capability Index - Cpk (KPI) QSTATWERTC
InspectionNonconformingRatio Average Fraction of Nonconforming Units (KPI) QSTATWERTC
InspectionPartialSampleSize Number of Partial Samples for Characteristic (KPI) QANZAHL4
InspectionSampleSize Total Sample Size (KPI) QANZAHL4
InspResultVariance Dispersion (Variance) of Valid Measured Values (KPI) QSTATWERT
InspectionLotCount Number of Inspection Lots (KPI)
InspectionResultMeanValueText null
InspSpecToleranceLimitsText null
InspResultAggregationLevelText Short Text QKURZTEXT
BillOfOperationsTypeName Description of the Task List Type TEXT30
InspectionValuationResultText Inspection Result Valuation Text DDTEXT
InspSpecCharacteristicTypeText Characteristic Type Text DDTEXT
Master Data Relations Join Conditions
Batch Number (Characteristic)
  • Client
  • Batch Number (Characteristic)
  • Material (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == MCH1.MANDT
  • C_INSPECTIONRESULTAGGREGATE.BATCH == MCH1.CHARG
  • C_INSPECTIONRESULTAGGREGATE.INSPLOTSELECTIONMATERIAL == MCH1.MATNR
Bill of Operations Type (Characteristic)
  • Client
  • Bill of Operations Type (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == TCA01.MANDT
  • C_INSPECTIONRESULTAGGREGATE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • C_INSPECTIONRESULTAGGREGATE.MANDT == T006.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
Inspection Lot Origin (Characteristic) C_INSPECTIONRESULTAGGREGATE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type (Characteristic)
  • Inspection Type (Characteristic)
  • Client
  • C_INSPECTIONRESULTAGGREGATE.INSPECTIONLOTTYPE == TQ30.ART
  • C_INSPECTIONRESULTAGGREGATE.MANDT == TQ30.MANDT
Master Inspection Characteristics (Characteristic)
  • Client
  • Plant for the Master Inspection Characteristic (Charc)
  • ?
  • Master Inspection Characteristics (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == QPMK.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • C_INSPECTIONRESULTAGGREGATE.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • C_INSPECTIONRESULTAGGREGATE.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_INSPECTIONRESULTAGGREGATE.MANDT == T006.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Customer Account Number (Characteristic)
  • Client
  • Customer Account Number (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == KNA1.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
Manufacturer (Characteristic)
  • Client
  • Manufacturer (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == LFA1.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR
Material (Characteristic)
  • Client
  • Material (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == MARA.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPLOTSELECTIONMATERIAL == MARA.MATNR
Supplier Account Number (Characteristic)
  • Client
  • Supplier Account Number (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == LFA1.MANDT
  • C_INSPECTIONRESULTAGGREGATE.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Inspection Lot Plant (Characteristic)
  • Client
  • Inspection Lot Plant (Characteristic)
  • C_INSPECTIONRESULTAGGREGATE.MANDT == T001W.MANDT
  • C_INSPECTIONRESULTAGGREGATE.PLANT == T001W.WERKS