P_InspectionResultStatistic

Inspection Result Statistic | view: PINSPRSLTSTAT | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QAMVQALSAFVCQAOPQAMRQASVQASRCRHD
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 System Date on Which Data Record Was Created
Column Name Description
InspectionValuationResult Inspection Result Valuation Show values
InspCharcIsNotPlanned Unplanned Characteristic Show values
InspectionResultHasMeanValue Value Not Initial if Set Show values
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspSpecCharacteristicType Characteristic Type Show values
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
BOOOperationInternalID Number of the Task List Node KNTNR
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultMaximumValue Maximum Value of Valid Measured Values QSTATWERT
InspectionResultMinimumValue Minimum Value of Valid Measured Values QSTATWERT
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL4
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL4
InspRsltAboveToleranceValsNmbr Number of Measured Values Above Tolerance Range QANZAHL4
InspRsltBelowToleranceValsNmbr Number of Measured Values Below Tolerance Range QANZAHL4
InspectionResultText Inspection Description for Summarized Result QKURZTEXT
Inspector Name of Inspector QPRUEFER
InspResultVariance null
InspRsltWeightedVarianceValue null
InspCharCount null
InspResultTotalVariance null
InspRsltAboveToleranceFraction Estimated Fraction Above Tolerance Range QSTATWERT
InspRsltBelowToleranceFraction Estimated Fraction Below Tolerance Range QSTATWERT
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspSpecSampleQuantityFactor Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
BOOCharacteristicVersion Internal counter CIM_COUNT
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Client
  • Batch Number
  • P_INSPECTIONRESULTSTATISTIC.INSPLOTSELECTIONMATERIAL == MCH1.MATNR
  • P_INSPECTIONRESULTSTATISTIC.MANDT == MCH1.MANDT
  • P_INSPECTIONRESULTSTATISTIC.BATCH == MCH1.CHARG
Bill of Operations Type
  • Bill of Operations Type
  • Client
  • P_INSPECTIONRESULTSTATISTIC.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • P_INSPECTIONRESULTSTATISTIC.MANDT == TCA01.MANDT
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • P_INSPECTIONRESULTSTATISTIC.MANDT == T006.MANDT
  • P_INSPECTIONRESULTSTATISTIC.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
Inspection Lot Origin P_INSPECTIONRESULTSTATISTIC.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • P_INSPECTIONRESULTSTATISTIC.INSPECTIONLOTTYPE == TQ30.ART
  • P_INSPECTIONRESULTSTATISTIC.MANDT == TQ30.MANDT
Results Record Status P_INSPECTIONRESULTSTATISTIC.INSPECTIONRESULTSTATUS == TQ76.STATUS
Master Inspection Characteristic
  • Client
  • Plant for Master Inspection Characteristic
  • ?
  • Master Inspection Characteristic
  • P_INSPECTIONRESULTSTATISTIC.MANDT == QPMK.MANDT
  • P_INSPECTIONRESULTSTATISTIC.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • P_INSPECTIONRESULTSTATISTIC.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • P_INSPECTIONRESULTSTATISTIC.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • P_INSPECTIONRESULTSTATISTIC.MANDT == T006.MANDT
  • P_INSPECTIONRESULTSTATISTIC.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Account number of customer
  • Account number of customer
  • Client
  • P_INSPECTIONRESULTSTATISTIC.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
  • P_INSPECTIONRESULTSTATISTIC.MANDT == KNA1.MANDT
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • P_INSPECTIONRESULTSTATISTIC.MANDT == LFA1.MANDT
  • P_INSPECTIONRESULTSTATISTIC.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • P_INSPECTIONRESULTSTATISTIC.INSPLOTSELECTIONMATERIAL == MARA.MATNR
  • P_INSPECTIONRESULTSTATISTIC.MANDT == MARA.MANDT
Vendor's account number
  • Client
  • Vendor's account number
  • P_INSPECTIONRESULTSTATISTIC.MANDT == LFA1.MANDT
  • P_INSPECTIONRESULTSTATISTIC.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Plant
  • Client
  • Plant
  • P_INSPECTIONRESULTSTATISTIC.MANDT == T001W.MANDT
  • P_INSPECTIONRESULTSTATISTIC.PLANT == T001W.WERKS