C_InspSubsetCharcResult

IPRR: Inspection Point Results | view: CINSPSUBCHARCRES | Extraction: Not supported | Component: Inspection Lot Worklist
Tables used: QAMV, QALS, AFVC, QAOP, QASE, QAPP, QASV, QASR, QPAM, QPAMTXT, QPCT, QMTB, QMTT, TQ77, TQ76, TQ76T, TQ77T, TQ17A, TQ17U, T006, T006A, CRHD, TQSS1
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionSubsetInternalID Inspection Sample Number
InspectionCharacteristic Inspection Characteristic Number
Column Name Description
Column Name Description
📏 Sample Unit of Measure (InspCharacteristicSampleUnit):
InspectionScope Quantity to Be Inspected
Column Name Description
Column Name Description
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspectionValuationResult Inspection Result Valuation 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
InspSpecAddlDecimalPlaces Number of Additional Decimal Places for Statistical Values Show values
HasInspCharcPrtlSmpl Partial Samples Possible Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecHasTargetValue Value Not Initial if Set Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded Show values
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspSpecIsLongTermInspection Long-Term Inspection Show values
InspSpecRecordingType Recording Type Show values
InspSpecCharcCategory Characteristic Category Show values
InspSpecResultCalculation Calculated Characteristic Show values
InspResultIsDocumentationRqd Documentation Required for Inspection Results Show values
Column Name Description Domain name
InspSampleAcceptanceNumber Acceptance Number QINT2NEG
InspSampleRejectionNumber Rejection Number QANZAHL2
InspectionSampleSize Sample Size that Must Be Inspected QANZAHL4
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
CreatedByUser Name of User Who Created the Data Record QAENDERER
Inspector Name of Inspector QPRUEFER
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultMaximumValue Maximum Value of Valid Measured Values QSTATWERT
InspectionResultMinimumValue Minimum Value of Valid Measured Values QSTATWERT
InspectionResultOriginalValue Original Value Before Input Processing CHAR25
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL2
InspectionResultText null
InspRsltFreeDefinedTestEquip General Information QEQUNR
InspRsltBelowToleranceValsNmbr Number of Measured Values Below Tolerance Range QANZAHL2
InspRsltAboveToleranceValsNmbr Number of Measured Values Above Tolerance Range QANZAHL2
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL2
InspRsltAboveToleranceFraction Estimated Fraction Above Tolerance Range QSTATWERT
InspRsltBelowToleranceFraction Estimated Fraction Below Tolerance Range QSTATWERT
InspResultVariance Dispersion (Variance) of Valid Measured Values QSTATWERT
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
InspSpecSummarizedDcmlPlaces null
InspectionOperation Operation/Activity Number VORNR
InspCharAcceptedCount null
InspCharRejectedCount null
CharcStatusName Inspection Result Status Text QKURZTEXT
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspLotTestEquipInternalID Assigned Test Equipment PZLFH
InspectionMethod Inspection Method QPMETHODE
InspectionMethodText Short Text QKURZTEXT
InspectionMethodVersion Version Number of Inspection Method QVERSNR
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspSpecSampleQuantityFactor Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
InspSpecControlIndicators Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
UnitOfMeasureTechnicalName External Unit of Measurement in Technical Format (6-Char.) MSEH6
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
SelectedCodeSet Assigned Code Group or Selected Set QCGRAUSW
SelectedCodeSetText Short Description of Selected Set QKURZTEXT
InspectionResultAttributeText Short Text QKURZTEXT
CharacteristicAttributeCodeTxt Text for Code QKURZTEXT
InspectionNonconformingRatio null
InspResultValueCount null
InspSpecImportanceCodeText Short Text QKURZTEXT
Master Data Relations Join Conditions
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • C_INSPSUBSETCHARCRESULT.CHARACTERISTICATTRIBUTECATALOG == TQ15.KATALOGART
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ15.MANDT
Sample Unit of Measure
  • Sample Unit of Measure
  • Sample Unit of Measure
  • Client
  • C_INSPSUBSETCHARCRESULT.QUANTITYUNIT == T006.MSEHI
  • C_INSPSUBSETCHARCRESULT.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • C_INSPSUBSETCHARCRESULT.MANDT == T006.MANDT
Specification Record Status
  • Specification Record Status
  • Results Record Status
  • C_INSPSUBSETCHARCRESULT.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTSTATUS == TQ76.STATUS
Plant for Inspection Method
  • Client
  • Plant for Inspection Method
  • C_INSPSUBSETCHARCRESULT.MANDT == T001W.MANDT
  • C_INSPSUBSETCHARCRESULT.INSPECTIONMETHODPLANT == T001W.WERKS
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTCATALOG2 == TQ15.KATALOGART
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTCATALOG3 == TQ15.KATALOGART
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTCATALOG4 == TQ15.KATALOGART
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTCATALOG5 == TQ15.KATALOGART
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ15.MANDT
Origin of Results Data
  • Origin of Results Data
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTORIGIN == TQ73.QERGDATH
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ73.MANDT
Results Record Status
  • Specification Record Status
  • Results Record Status
  • C_INSPSUBSETCHARCRESULT.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS
  • C_INSPSUBSETCHARCRESULT.INSPECTIONRESULTSTATUS == TQ76.STATUS
Inspection Severity
  • Inspection Severity
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONSEVERITY == QDEP.PRSCHAERFE
  • C_INSPSUBSETCHARCRESULT.MANDT == QDEP.MANDT
Master Inspection Characteristic
  • Version Number of Inspection Method
  • Client
  • Plant for Master Inspection Characteristic
  • Master Inspection Characteristic
  • C_INSPSUBSETCHARCRESULT.INSPECTIONMETHODVERSION == QPMK.VERSION
  • C_INSPSUBSETCHARCRESULT.MANDT == QPMK.MANDT
  • C_INSPSUBSETCHARCRESULT.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • C_INSPSUBSETCHARCRESULT.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
  • C_INSPSUBSETCHARCRESULT.MANDT == T006.MANDT
Inspection Stage
  • Inspection Stage
  • ?
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPLOTDYNRULESTAGE == QDPS.PRSTUFE
  • C_INSPSUBSETCHARCRESULT.[column in domain "QDYNREGEL"] == QDPS.DYNREGEL
  • C_INSPSUBSETCHARCRESULT.MANDT == QDPS.MANDT
Valuation Rule
  • Valuation Rule
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPSAMPLEVALUATIONRULE == QDFM.FBKEY
  • C_INSPSUBSETCHARCRESULT.MANDT == QDFM.MANDT
Weighting of Characteristic
  • Weighting of Characteristic
  • Client
  • C_INSPSUBSETCHARCRESULT.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
  • C_INSPSUBSETCHARCRESULT.MANDT == TQ17A.MANDT
Sample Unit of Measure
  • Sample Unit of Measure
  • Sample Unit of Measure
  • Client
  • C_INSPSUBSETCHARCRESULT.QUANTITYUNIT == T006.MSEHI
  • C_INSPSUBSETCHARCRESULT.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • C_INSPSUBSETCHARCRESULT.MANDT == T006.MANDT
Plant of the Assigned Selected Set
  • Plant of the Assigned Selected Set
  • Client
  • C_INSPSUBSETCHARCRESULT.SELECTEDCODESETPLANT == T001W.WERKS
  • C_INSPSUBSETCHARCRESULT.MANDT == T001W.MANDT