I_InspSampleResultTP

Inspection Result for Inspection Point | view: IINSPSAMPLERESTP | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALSAFVCQAOPQAMRQASRQAMVQAMRQASRCRHDTQSS1
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
InspectionSubsetInternalID FK Number of Partial Sample
Column Name Description
Column Name Description
Column Name Description
InspectionStartDate Start Date in Local Time Zone of Inspection
InspectionStartTime Start Time in Local Time Zone of Inspection
InspectionEndDate End Date in Local Time Zone of Inspection
InspectionEndTime End Time in Local Time Zone of Inspection
CreationDate System Date on Which Data Record Was Created
CreationTime System Time at Which Data Record Was Created
LastChangeDate System Date on Which Data Record Was Changed
ChangedTime System Time at Which Data Record Was Changed
Column Name Description
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspectionValuationResult Inspection Result Valuation Show values
InspResultDynModifValuation Valuation of the Characteristic for Dynamic Modification Show values
InspectionResultHasMeanValue Value Not Initial if Set Show values
InspResultHasMaximumValue Value Not Initial if Set Show values
InspResultHasMinimumValue Value Not Initial if Set Show values
InspectionResultHasLongText Inspection Characteristic Long Text Exists Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
Inspector Name of Inspector QPRUEFER
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspResultFrmtdMeanValue Arithmetic Mean of Valid Measured Values (Formatted) QSTATWERT_F
InspectionResultMaximumValue Maximum Value of Valid Measured Values QSTATWERT
InspResultFrmtdMaximumValue Maximum Value of Valid Measured Values - formatted QSTATWERT_F
InspectionResultMinimumValue Minimum Value of Valid Measured Values QSTATWERT
InspResultFrmtdMinimumValue Minimum Value of Valid Measured Values (Formatted) QSTATWERT_F
InspectionResultOriginalValue Original Value Before Input Processing CHAR25
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL2
InspectionResultText Inspection Description for Sample Result QKURZTEXT
InspRsltFreeDefinedTestEquip General Information QEQUNR
InspRsltBelowToleranceValsNmbr Number of Measured Values Below Tolerance Range QANZAHL2
InspRsltAboveToleranceValsNmbr Number of Measured Values Above Tolerance Range QANZAHL2
InspRsltAboveToleranceFraction Estimated Fraction Above Tolerance Range QSTATWERT
InspRsltFrmtdAbvTolFraction Estimated Fraction Above Tolerance Range (Formatted) QSTATWERT_F
InspRsltBelowToleranceFraction Estimated Fraction Below Tolerance Range QSTATWERT
InspRsltFrmtdBelowTolFraction Estimated Fraction Below Tolerance Range (Formatted) QSTATWERT_F
InspResultVariance Dispersion (Variance) of Valid Measured Values QSTATWERT
InspResultFrmtdVariance Dispersion (Variance) of Valid Measured Values (Formatted) QSTATWERT_F
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL2
InspResultNmbrOfRecordedRslts Number of Recorded Sample Units QANZAHL4
InspectionNumberOfDefects Number of Defects Found QANZAHL2
CharcAttributeCodeVers Version Number QVERSNR
InspectionResultCode2Vers Version Number QVERSNR
InspectionResultCode3Vers Version Number QVERSNR
InspectionResultCode4Vers Version Number QVERSNR
InspectionResultCode5Vers Version Number QVERSNR
CharacteristicAttributeCodeGrp Code Group QCODEGRP
InspectionResultCodeGroup2 Code Group QCODEGRP
InspectionResultCodeGroup3 Code Group QCODEGRP
InspectionResultCodeGroup4 Code Group QCODEGRP
InspectionResultCodeGroup5 Code Group QCODEGRP
CharacteristicAttributeCode Code QCODE
InspectionResultCode2 Code QCODE
InspectionResultCode3 Code QCODE
InspectionResultCode4 Code QCODE
InspectionResultCode5 Code QCODE
CreatedByUser Name of User Who Created the Data Record QAENDERER
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPSAMPLERESULTTP.CHARACTERISTICATTRIBUTECATALOG == TQ15.KATALOGART
  • I_INSPSAMPLERESULTTP.MANDT == TQ15.MANDT
Defect Class
  • Defect Class
  • Client
  • I_INSPSAMPLERESULTTP.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_INSPSAMPLERESULTTP.MANDT == TQ17.MANDT
Inspection Type
  • Inspection Type
  • Client
  • I_INSPSAMPLERESULTTP.INSPECTIONLOTTYPE == TQ30.ART
  • I_INSPSAMPLERESULTTP.MANDT == TQ30.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPSAMPLERESULTTP.MANDT == TQ15.MANDT
  • I_INSPSAMPLERESULTTP.INSPECTIONRESULTCATALOG2 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPSAMPLERESULTTP.MANDT == TQ15.MANDT
  • I_INSPSAMPLERESULTTP.INSPECTIONRESULTCATALOG3 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPSAMPLERESULTTP.INSPECTIONRESULTCATALOG4 == TQ15.KATALOGART
  • I_INSPSAMPLERESULTTP.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPSAMPLERESULTTP.INSPECTIONRESULTCATALOG5 == TQ15.KATALOGART
  • I_INSPSAMPLERESULTTP.MANDT == TQ15.MANDT
Origin of Results Data
  • Origin of Results Data
  • Client
  • I_INSPSAMPLERESULTTP.INSPECTIONRESULTORIGIN == TQ73.QERGDATH
  • I_INSPSAMPLERESULTTP.MANDT == TQ73.MANDT
Results Record Status I_INSPSAMPLERESULTTP.INSPECTIONRESULTSTATUS == TQ76.STATUS
Language Key I_INSPSAMPLERESULTTP.LANGUAGE == T002.SPRAS
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_INSPSAMPLERESULTTP.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_INSPSAMPLERESULTTP.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_INSPSAMPLERESULTTP.PLANT == T001W.WERKS
  • I_INSPSAMPLERESULTTP.MANDT == T001W.MANDT