I_InspectionResultHistory

Inspection Result History | view: IINSPRSLTHSTRY | TRAN | Extraction: Not supported | Component: Quality Inspection
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
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspCharcIsNotPlanned Unplanned Characteristic Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecRecordingType Recording Type Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) 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
IsBusinessPurposeCompleted Business Purpose Completed Flag 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
BOOCharacteristicVersion Internal counter CIM_COUNT
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 Dispersion (Variance) of Valid Measured Values QSTATWERT
CharacteristicAttributeCodeGrp Code Group QCODEGRP
CharacteristicAttributeCode Code QCODE
InspRsltAboveToleranceFraction Estimated Fraction Above Tolerance Range QSTATWERT
InspRsltBelowToleranceFraction Estimated Fraction Below Tolerance Range QSTATWERT
InspectionResultOriginalValue Original Value Before Input Processing CHAR25
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
InspectionPartialSampleSize Number of Partial Samples for Characteristic QANZAHL2
WorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • I_INSPECTIONRESULTHISTORY.MANDT == MCH1.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONMATERIAL == MCH1.MATNR
  • I_INSPECTIONRESULTHISTORY.BATCH == MCH1.CHARG
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • I_INSPECTIONRESULTHISTORY.MANDT == TCA01.MANDT
  • I_INSPECTIONRESULTHISTORY.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • I_INSPECTIONRESULTHISTORY.MANDT == T006.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
Inspection Lot Origin I_INSPECTIONRESULTHISTORY.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • I_INSPECTIONRESULTHISTORY.INSPECTIONLOTTYPE == TQ30.ART
  • I_INSPECTIONRESULTHISTORY.MANDT == TQ30.MANDT
Results Record Status I_INSPECTIONRESULTHISTORY.INSPECTIONRESULTSTATUS == TQ76.STATUS
Master Inspection Characteristic
  • Client
  • Plant for Master Inspection Characteristic
  • ?
  • Master Inspection Characteristic
  • I_INSPECTIONRESULTHISTORY.MANDT == QPMK.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_INSPECTIONRESULTHISTORY.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • I_INSPECTIONRESULTHISTORY.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • I_INSPECTIONRESULTHISTORY.MANDT == T006.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Account number of customer
  • Client
  • Account number of customer
  • I_INSPECTIONRESULTHISTORY.MANDT == KNA1.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • I_INSPECTIONRESULTHISTORY.MANDT == LFA1.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • I_INSPECTIONRESULTHISTORY.MANDT == MARA.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONMATERIAL == MARA.MATNR
Vendor's account number
  • Client
  • Vendor's account number
  • I_INSPECTIONRESULTHISTORY.MANDT == LFA1.MANDT
  • I_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_INSPECTIONRESULTHISTORY.MANDT == TQ01B.MANDT
  • I_INSPECTIONRESULTHISTORY.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • I_INSPECTIONRESULTHISTORY.MANDT == T001W.MANDT
  • I_INSPECTIONRESULTHISTORY.PLANT == T001W.WERKS
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • I_INSPECTIONRESULTHISTORY.WORKCENTERINTERNALID == CRID.OBJID
  • I_INSPECTIONRESULTHISTORY.MANDT == CRID.MANDT
  • I_INSPECTIONRESULTHISTORY.[column in domain "CR_OBJTY"] == CRID.OBJTY