C_InspectionResultHistory

Inspection Result History | view: CINSPRSLTHSTRY | TRAN | 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
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspCharcIsNotPlanned Unplanned Characteristic Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecRecordingType Recording Type 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
BOOCharacteristicVersion Internal counter CIM_COUNT
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
InspRsltWeightedMeanValue null
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
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
InspectionSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
CharacteristicAttributeCodeGrp Code Group QCODEGRP
CharacteristicAttributeCode Code QCODE
InspectionPartialSampleSize Number of Partial Samples for Characteristic QANZAHL2
WorkCenter Work Center ARBPL
InspResultFrmtdMeanValue Arithmetic Mean of Valid Measured Values (Formatted) QSTATWERT_F
InspResultFrmtdMinimumValue Minimum Value of Valid Measured Values (Formatted) QSTATWERT_F
InspResultFrmtdMaximumValue Maximum Value of Valid Measured Values - formatted QSTATWERT_F
InspResultFrmtdVariance Dispersion (Variance) of Valid Measured Values (Formatted) QSTATWERT_F
InspRsltFrmtdAbvTolFraction Dispersion (Variance) of Valid Measured Values (Formatted) QSTATWERT_F
InspRsltFrmtdBelowTolFraction Dispersion (Variance) of Valid Measured Values (Formatted) QSTATWERT_F
Master Data Relations Join Conditions
Batch Number
  • Client
  • Batch Number
  • Material Number
  • C_INSPECTIONRESULTHISTORY.MANDT == MCH1.MANDT
  • C_INSPECTIONRESULTHISTORY.BATCH == MCH1.CHARG
  • C_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONMATERIAL == MCH1.MATNR
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • C_INSPECTIONRESULTHISTORY.MANDT == TCA01.MANDT
  • C_INSPECTIONRESULTHISTORY.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • C_INSPECTIONRESULTHISTORY.MANDT == T006.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
Inspection Lot Origin C_INSPECTIONRESULTHISTORY.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • C_INSPECTIONRESULTHISTORY.MANDT == TQ30.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPECTIONLOTTYPE == TQ30.ART
Results Record Status C_INSPECTIONRESULTHISTORY.INSPECTIONRESULTSTATUS == TQ76.STATUS
Master Inspection Characteristic
  • Client
  • ?
  • Master Inspection Characteristic
  • Plant for Master Inspection Characteristic
  • C_INSPECTIONRESULTHISTORY.MANDT == QPMK.MANDT
  • C_INSPECTIONRESULTHISTORY.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • C_INSPECTIONRESULTHISTORY.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • C_INSPECTIONRESULTHISTORY.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_INSPECTIONRESULTHISTORY.MANDT == T006.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Account number of customer
  • Client
  • Account number of customer
  • C_INSPECTIONRESULTHISTORY.MANDT == KNA1.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • C_INSPECTIONRESULTHISTORY.MANDT == LFA1.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • C_INSPECTIONRESULTHISTORY.MANDT == MARA.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONMATERIAL == MARA.MATNR
Vendor's account number
  • Client
  • Vendor's account number
  • C_INSPECTIONRESULTHISTORY.MANDT == LFA1.MANDT
  • C_INSPECTIONRESULTHISTORY.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_INSPECTIONRESULTHISTORY.MANDT == TQ01B.MANDT
  • C_INSPECTIONRESULTHISTORY.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_INSPECTIONRESULTHISTORY.MANDT == T001W.MANDT
  • C_INSPECTIONRESULTHISTORY.PLANT == T001W.WERKS
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • C_INSPECTIONRESULTHISTORY.MANDT == CRID.MANDT
  • C_INSPECTIONRESULTHISTORY.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_INSPECTIONRESULTHISTORY.WORKCENTERINTERNALID == CRID.OBJID