I_InspectionResultValueTP

Inspection Result Single Value | view: IINSPRSLTVALTP | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALSAFVCQAOPQAMRQASEQAMVQAMRQASECRHDTQSS1
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
InspResultValueInternalID Number of Individual Result
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
LastChangeDate System Date on Which Data Record Was Changed
ChangedTime System Time at Which Data Record Was Changed
CreationTime System Time at Which Data Record Was Created
Column Name Description
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspResultHasMeasuredValue Measured Value Is Not Initial Show values
InspectionValuationResult Inspection Result Valuation Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspectionResultMeasuredValue Measured Value for a Sample Unit QURWERT
InspResultFrmtdMeasuredValue Measured Value for a Sample Unit - formatted QURWERT_F
InspectionResultOriginalValue Original Value Before Input Processing CHAR25
InspectionNumberOfDefects Number of Defects Found QANZAHL1
InspResultItemInternalID Counter for Inspection Unit Number QZAEHL
InspectionResultText Inspection Description for Single Value QKURZTEXT
InspectionResultItem Single-Unit Number for the Unit to Be Inspected QSERIALNR
InspRsltFreeDefinedTestEquip General Information QEQUNR
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
CharcAttributeCodeVers Version Number QVERSNR
InspectionResultCode2Vers Version Number QVERSNR
InspectionResultCode3Vers Version Number QVERSNR
InspectionResultCode4Vers Version Number QVERSNR
InspectionResultCode5Vers Version Number QVERSNR
Inspector Name of Inspector QPRUEFER
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CreatedByUser Name of User Who Created the Data Record QAENDERER
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
WorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Catalog
  • Client
  • Catalog
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ15.MANDT
  • I_INSPECTIONRESULTVALUETP.CHARACTERISTICATTRIBUTECATALOG == TQ15.KATALOGART
Defect Class
  • Defect Class
  • Client
  • I_INSPECTIONRESULTVALUETP.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ17.MANDT
Inspection Type
  • Inspection Type
  • Client
  • I_INSPECTIONRESULTVALUETP.INSPECTIONLOTTYPE == TQ30.ART
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ30.MANDT
Catalog
  • Client
  • Catalog
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ15.MANDT
  • I_INSPECTIONRESULTVALUETP.INSPECTIONRESULTCATALOG2 == TQ15.KATALOGART
Catalog
  • Catalog
  • Client
  • I_INSPECTIONRESULTVALUETP.INSPECTIONRESULTCATALOG3 == TQ15.KATALOGART
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ15.MANDT
Catalog
  • Catalog
  • Client
  • I_INSPECTIONRESULTVALUETP.INSPECTIONRESULTCATALOG4 == TQ15.KATALOGART
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ15.MANDT
Catalog
  • Catalog
  • Client
  • I_INSPECTIONRESULTVALUETP.INSPECTIONRESULTCATALOG5 == TQ15.KATALOGART
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ15.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_INSPECTIONRESULTVALUETP.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_INSPECTIONRESULTVALUETP.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_INSPECTIONRESULTVALUETP.PLANT == T001W.WERKS
  • I_INSPECTIONRESULTVALUETP.MANDT == T001W.MANDT