C_DefectMngCharacteristicsSbst

Defect: Characteristics with Insp. Point | view: CDEFECTMNGSBST | Extraction: Not supported | Component: Defects Recording
Tables used: QAMVQALSAFVCQAOPQAPPQASVQASRQPAMQPAMTXTQPCDQPCTTQ76TQ76T
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionSubsetInternalID FK Sample Number (Based on an Inspection Point)
MaterialSample FK Material Sample Number
InspectionCharacteristic Inspection Characteristic Number
Column Name Description
Column Name Description
Column Name Description
InspectionSubsetDate User Field for Date
InspectionSubsetTime User Field for Time
Column Name Description
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspSpecRecordingType Recording Type Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspectionValuationResult Inspection Result Valuation Show values
InspectionResultHasMeanValue Value Not Initial if Set Show values
Column Name Description Domain name
InspectionSubset Inspection Point QPRUEFPKT
InspectionOperation Operation or Phase Number VDM_VORNR
OperationText Operation Short Text TEXT40
InspectionSubsetLongCharKey User Field for 18 Characters QUSRCHAR18
InspectionSubsetShortCharKey User Field for 10 Characters QUSRCHAR10
InspSubsetLongNumericKey User Field for 10 Digits QUSRNUMC10
InspSubsetShortNumericKey User Field for 3 Digits QUSRNUMC3
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspSpecSampleQuantityFactor Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
SelectedCodeSetText Short Description of Selected Set QKURZTEXT
InspValnResultCriticality null
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultMeanValueText Summarized Results QKURZTEXT
InspSpecToleranceLimitsText Inspection Specification VDM_QM_TEXT80
CharacteristicAttributeCode Summarized Results QKURZTEXT
CharacteristicAttributeCodeGrp Code Group QCODEGRP
CharacteristicAttributeCodeTxt Text for Code QKURZTEXT
InspectionResultStatusText Results Record Status Text QKURZTEXT
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL2
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL2
Master Data Relations Join Conditions
Equipment Number
  • Equipment Number
  • Client
  • C_DEFECTMNGCHARACTERISTICSSBST.EQUIPMENT == EQUI.EQUNR
  • C_DEFECTMNGCHARACTERISTICSSBST.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • C_DEFECTMNGCHARACTERISTICSSBST.MANDT == IFLOT.MANDT
  • C_DEFECTMNGCHARACTERISTICSSBST.FUNCTIONALLOCATION == IFLOT.TPLNR
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • C_DEFECTMNGCHARACTERISTICSSBST.MANDT == T006.MANDT
  • C_DEFECTMNGCHARACTERISTICSSBST.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_DEFECTMNGCHARACTERISTICSSBST.MANDT == T006.MANDT
  • C_DEFECTMNGCHARACTERISTICSSBST.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Inspection Point Identification
  • Client
  • Identifier for Inspection Point Field Combination
  • C_DEFECTMNGCHARACTERISTICSSBST.MANDT == TQ79.MANDT
  • C_DEFECTMNGCHARACTERISTICSSBST.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ