I_InspectionCharacteristic

Characteristic in Inspection Lot | view: IINSPCHAR | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QAMV
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
📏 Sample Unit of Measure (InspCharacteristicSampleUnit):
InspectionScope Quantity to Be Inspected
Column Name Description
InspCharcCreationDate System Date on Which Data Record Was Created
Column Name Description
HasInspCharcPrtlSmpl Partial Samples Possible Show values
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded Show values
InspSpecIsSelectedSetRequired Reference to Characteristic Attribute Required Show values
InspSpecIsLongTermInspection Long-Term Inspection Show values
InspSpecRecordingType Recording Type Show values
InspResultIsDocumentationRqd Documentation Required for Inspection Results Show values
InspSpecCharcCategory Characteristic Category Show values
InspSpecResultCalculation Calculated Characteristic Show values
InspSpecHasSamplingProcedure Sampling Procedure Is Required Show values
InspSpecIsDefectRecordingRqd Recording the Number of Defects Show values
InspSpecIsDefectsRecgAutomatic Defects Recording Automatically Called Up Show values
InspSpecIsChgDocRequired Create Change Documents During Results Recording Show values
InspSpecHasControlChart SPC Characteristic Show values
InspCharcIsNotPlanned Unplanned Characteristic 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
InspSpecificationHasLongText X and Blank Show values
SamplingProcedureInspSubset Sampling Procedure for Inspection Points Show values
Column Name Description Domain name
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspectionMethodVersion Version Number of Inspection Method QVERSNR
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
InspCharcPrtlSmpl Number of the Partial Sample QPROBENR
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspSpecSampleQuantityFactor Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspLotTestEquipInternalID Assigned Test Equipment PZLFH
SelectedCodeSet Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet2 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup2 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet3 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup3 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet4 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup4 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet5 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup5 Assigned Code Group or Selected Set QCGRAUSW
InspSpecFormula1 Formula Field QFORMEL
InspSpecFormula2 Formula Field QFORMEL
InspSpecInformationField1 Text Line for Additional Information QTXT10
InspSpecInformationField2 Text Line for Additional Information QTXT20
InspSpecInformationField3 Text Line for Additional Information QTXT40
InspSpecDefectCodeGrpRjcnLower Defect Code Group for Rejection at Lower Tolerance QCODEGRP
InspSpecDefectCodeRjcnLower Defect Code for Rejection at Lower Specification Limit QCODE
InspSpecDefectCodeGrpRjcnUpper Defect Code Group for Rejection at Upper Tolerance QCODEGRP
InspSpecDefectCodeRjcnUpper Defect Code for Rejection at Upper Specification Limit QCODE
InspSpecDefectCodeGrpRejection Defect Code Group for General Rejection QCODEGRP
InspSpecDefectCodeRejection Defect Code for Rejection: General QCODE
InspSpecControlIndicators Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL
QualityLevelInternalID Sequential Counter for Different Quality Levels QDYNANZ4
BOOCharcGroup Characteristic Group QCHARGROUP
BOOCharcSourceCharc Source Characteristic of Characteristic Group Division QMERKNRP
BOOCharcGroupDivision Internal Division ID QDIVISIONINT
ProductionOrderOperationActy Identifies an Operation Activity MPE_OAN_ELEMENT_ID
ProductionOrderOpActyVers Number of an Operation Actiivity Version
InspCharcConfirmationNumber Confirmation Number for Inspection Characteristic QRUECKNR
BOOCharacteristicVersion Internal counter CIM_COUNT
InspCharcCreatedBy Name of User Who Created the Data Record QAENDERER
Master Data Relations Join Conditions
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ15.MANDT
  • I_INSPECTIONCHARACTERISTIC.CHARACTERISTICATTRIBUTECATALOG == TQ15.KATALOGART
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • I_INSPECTIONCHARACTERISTIC.MANDT == T006.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • I_INSPECTIONCHARACTERISTIC.QUANTITYUNIT == T006.MSEHI
Specification Record Status I_INSPECTIONCHARACTERISTIC.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS
Inspection Method
  • Client
  • Version Number of Inspection Method
  • Inspection Method
  • Plant for Inspection Method
  • I_INSPECTIONCHARACTERISTIC.MANDT == QMTB.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONMETHODVERSION == QMTB.VERSION
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONMETHOD == QMTB.PMTNR
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONMETHODPLANT == QMTB.WERKS
Plant for Inspection Method
  • Client
  • Plant for Inspection Method
  • I_INSPECTIONCHARACTERISTIC.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONMETHODPLANT == T001W.WERKS
Master Inspection Characteristic
  • Client
  • Version Number of Inspection Method
  • Plant for Master Inspection Characteristic
  • Master Inspection Characteristic
  • I_INSPECTIONCHARACTERISTIC.MANDT == QPMK.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONMETHODVERSION == QPMK.VERSION
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • I_INSPECTIONCHARACTERISTIC.MANDT == T006.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Inspector Qualification
  • Client
  • Inspector Qualification
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ11.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPECTORQUALIFICATION == TQ11.PRFQL
Dynamic Modification Rule
  • Client
  • Dynamic Modification Rule
  • I_INSPECTIONCHARACTERISTIC.MANDT == QDDR.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPLOTDYNAMICRULE == QDDR.DYNREGEL
Valuation Rule
  • Client
  • Valuation Rule
  • I_INSPECTIONCHARACTERISTIC.MANDT == QDFM.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSAMPLEVALUATIONRULE == QDFM.FBKEY
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ15.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDITIONALCATALOG2 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ15.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDITIONALCATALOG3 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ15.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDITIONALCATALOG4 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ15.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDITIONALCATALOG5 == TQ15.KATALOGART
Plant of the Assigned Selected Set
  • Client
  • Plant of the Assigned Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDLSELDCODESETPLANT2 == T001W.WERKS
Plant of the Assigned Selected Set
  • Client
  • Plant of the Assigned Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDLSELDCODESETPLANT3 == T001W.WERKS
Plant of the Assigned Selected Set
  • Client
  • Plant of the Assigned Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDLSELDCODESETPLANT4 == T001W.WERKS
Plant of the Assigned Selected Set
  • Client
  • Plant of the Assigned Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECADDLSELDCODESETPLANT5 == T001W.WERKS
Weighting of Characteristic
  • Client
  • Weighting of Characteristic
  • I_INSPECTIONCHARACTERISTIC.MANDT == TQ17A.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • I_INSPECTIONCHARACTERISTIC.MANDT == T006.MANDT
  • I_INSPECTIONCHARACTERISTIC.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • I_INSPECTIONCHARACTERISTIC.QUANTITYUNIT == T006.MSEHI
Plant of the Assigned Selected Set
  • Client
  • Plant of the Assigned Selected Set
  • I_INSPECTIONCHARACTERISTIC.MANDT == T001W.MANDT
  • I_INSPECTIONCHARACTERISTIC.SELECTEDCODESETPLANT == T001W.WERKS