I_InspSpecificationVersion

Inspection Specification Version | view: IINSPSPECVERS | Extraction: Not supported | Component: Quality Planning
Tables used: QPMK
Column Name Description
InspectionSpecificationPlant Plant for the Master Inspection Characteristic
InspectionSpecification Master Inspection Characteristic
InspectionSpecificationVersion Version Number of Master Inspection Characteristic
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
InspSpecCreationDate System Date on Which Data Record Was Created
InspSpecChangeDate System Date on Which Data Record Was Changed
InspSpecToleranceChgValidFrom Date from Which the Tolerance Change Is Valid
InspSpecToleranceChgValidTo Date Until Which the Tolerance Change Is Valid
Column Name Description
InspectionSpecificationStatus Status of Master Record Show values
InspSpecTransferType Copy Model/Reference Characteristic Show values
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspSpecCharacteristicType Characteristic Type Show values
InspSpecIsTargetValueInLimit Check Target Value Show values
InspectionScope Inspection Scope Show values
InspSpecRecordingType Recording Type Show values
InspResultIsDocumentationRqd Documentation Required for Inspection Result Show values
InspSpecCharcCategory Characteristic Category Show values
InspSpecIsSampleQtyAdditive Inspection Sample Quantity Is Added Show values
InspSpecResultCalculation Characteristic Result Calculation Show values
InspSpecIsSamplingProcedRqd Sampling Procedure Is Required Show values
InspSpecHasFixedCtrlIndicators Default Control Indicators Cannot Be Changed Show values
InspSpecIsDefectRecordingRqd Recording the Number of Defects Show values
InspSpecPrintControl Inspection Print Control 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
InspSpecHasFirstUpperSpecLimit Value Not Initial if Set Show values
InspSpecHasFirstLowerSpecLimit Value Not Initial if Set Show values
InspSpecHasSecondUprSpecLimit Value Not Initial if Set Show values
InspSpecHasSecondLowrSpecLimit Value Not Initial if Set Show values
InspSpecHasUprPlausibilityLmt Value Not Initial if Set Show values
InspSpecHasLowrPlausibilityLmt Value Not Initial if Set Show values
InspSpecHasUprSpecLimitChange Value Not Initial if Set Show values
InspSpecHasLowrSpecLimitChange Value Not Initial if Set Show values
Column Name Description Domain name
InspectionSpecificationSrchTxt Search Field CHAR40
InspSpecGlobalName Characteristic Description for Quality Data Exchange QCHARACT_ID
InspSpecCreatedByUser Name of User Who Created the Data Record QAENDERER
InspSpecChangedByUser Name of User Who Last Changed Data Record QAENDERER
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InspSpecControlIndicators Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded
InspSpecIsSelectedSetRequired Reference to Characteristic Attribute Required
InspSpecIsUpperLimitRequired Upper Specification Limit
InspSpecIsLowerLimitRequired Lower Specification Limit
InspSpecIsLongTermInspection Long-Term Inspection
InspSpecIsDestructive Destructive Inspection
InspSpecIsScrapRelevant Characteristic Relevant for Quality Score and Scrap Share
InspSpecIsTestEquipmentRqd Assignment of Test Equipment Required
InspSpecIsDefectsRecgAutomatic Defects Recording Automatically Called Up
InspSpecIsChgDocRequired Create Change Documents During Results Recording
InspSpecIsControlChartUsed SPC Characteristic
InspSpecInformationField1 Text Line for Additional Information QTXT10
InspSpecInformationField2 Text Line for Additional Information QTXT20
InspSpecInformationField3 Text Line for Additional Information QTXT40
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit
InspSpecLowerLimit Lower Specification Limit
InspSpecFirstUpperSpecLimit First Upper Specification Limit QSOLLWERTE
InspSpecFirstLowerSpecLimit First Lower Specification Limit QSOLLWERTE
InspSpecSecondUpperSpecLimit Second Upper Specification Limit QSOLLWERTE
InspSpecSecondLowerSpecLimit Second Lower Specification Limit QSOLLWERTE
InspSpecUpperPlausibilityLimit Upper Plausibility Limit QSOLLWERTE
InspSpecLowerPlausibilityLimit Lower Plausibility Limit QSOLLWERTE
InspSpecUpperSpecLimitChange Change to Upper Specification Limit QSOLLWERTE
InspSpecLowerSpecLimitChange Change to Lower Specification Limit QSOLLWERTE
CharcInternalID Characteristic Internal ID ATINN_NO_CONV
InspSpecIsDetnRuleActive Active Indicator for Specification Determination Rule
Master Data Relations Join Conditions
Fraction Calculation
  • Fraction Calculation
  • Client
  • I_INSPSPECIFICATIONVERSION.DEFECTFRACTIONESTIMATIONPROCED == TQ72.ANTVERF
  • I_INSPSPECIFICATIONVERSION.MANDT == TQ72.MANDT
Unit of Measurement in Which Quantitative Data Is Stored
  • Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • I_INSPSPECIFICATIONVERSION.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
  • I_INSPSPECIFICATIONVERSION.MANDT == T006.MANDT
Inspector Qualification
  • Client
  • Inspector Qualification
  • I_INSPSPECIFICATIONVERSION.MANDT == TQ11.MANDT
  • I_INSPSPECIFICATIONVERSION.INSPECTORQUALIFICATION == TQ11.PRFQL
Defect Code Group for General Rejection
  • ?
  • Defect Code Group for General Rejection
  • Client
  • I_INSPSPECIFICATIONVERSION.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEGRPREJECTION == QPGR.CODEGRUPPE
  • I_INSPSPECIFICATIONVERSION.MANDT == QPGR.MANDT
Defect Code Group for Rejection at Lower Tolerance
  • ?
  • Defect Code Group for Rejection at Lower Tolerance
  • Client
  • I_INSPSPECIFICATIONVERSION.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEGRPRJCNLOWER == QPGR.CODEGRUPPE
  • I_INSPSPECIFICATIONVERSION.MANDT == QPGR.MANDT
Defect Code Group for Rejection at Upper Tolerance
  • ?
  • Defect Code Group for Rejection at Upper Tolerance
  • Client
  • I_INSPSPECIFICATIONVERSION.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEGRPRJCNUPPER == QPGR.CODEGRUPPE
  • I_INSPSPECIFICATIONVERSION.MANDT == QPGR.MANDT
Defect Code for Rejection: General
  • ?
  • Defect Code for Rejection: General
  • Version Number of Master Inspection Characteristic
  • Defect Code Group for Rejection at Lower Tolerance
  • Client
  • I_INSPSPECIFICATIONVERSION.[column in domain "QKATART"] == QPCD.KATALOGART
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEREJECTION == QPCD.CODE
  • I_INSPSPECIFICATIONVERSION.INSPECTIONSPECIFICATIONVERSION == QPCD.VERSION
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEGRPRJCNLOWER == QPCD.CODEGRUPPE
  • I_INSPSPECIFICATIONVERSION.MANDT == QPCD.MANDT
Defect Code for Rejection at Lower Specification Limit
  • ?
  • Version Number of Master Inspection Characteristic
  • Defect Code for Rejection at Lower Specification Limit
  • Defect Code Group for Rejection at Lower Tolerance
  • Client
  • I_INSPSPECIFICATIONVERSION.[column in domain "QKATART"] == QPCD.KATALOGART
  • I_INSPSPECIFICATIONVERSION.INSPECTIONSPECIFICATIONVERSION == QPCD.VERSION
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODERJCNLOWER == QPCD.CODE
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEGRPRJCNLOWER == QPCD.CODEGRUPPE
  • I_INSPSPECIFICATIONVERSION.MANDT == QPCD.MANDT
Defect Code for Rejection at Upper Specification Limit
  • ?
  • Defect Code for Rejection at Upper Specification Limit
  • Version Number of Master Inspection Characteristic
  • Defect Code Group for Rejection at Lower Tolerance
  • Client
  • I_INSPSPECIFICATIONVERSION.[column in domain "QKATART"] == QPCD.KATALOGART
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODERJCNUPPER == QPCD.CODE
  • I_INSPSPECIFICATIONVERSION.INSPECTIONSPECIFICATIONVERSION == QPCD.VERSION
  • I_INSPSPECIFICATIONVERSION.INSPSPECDEFECTCODEGRPRJCNLOWER == QPCD.CODEGRUPPE
  • I_INSPSPECIFICATIONVERSION.MANDT == QPCD.MANDT
Specification Determination Rule I_INSPSPECIFICATIONVERSION.INSPSPECDETERMINATIONRULE == QASDRI_SPECDET.SPEC_DET_RULE
Weighting of Characteristic
  • Weighting of Characteristic
  • Client
  • I_INSPSPECIFICATIONVERSION.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
  • I_INSPSPECIFICATIONVERSION.MANDT == TQ17A.MANDT
Parameters for Input Processing in QM Results Recording
  • Parameters for Input Processing in QM Results Recording
  • Client
  • I_INSPSPECIFICATIONVERSION.INSPSPECINPUTPROCEDURE == TQ71.INPPROC
  • I_INSPSPECIFICATIONVERSION.MANDT == TQ71.MANDT
Tolerance Key
  • Client
  • Tolerance Key
  • I_INSPSPECIFICATIONVERSION.MANDT == TQ29.MANDT
  • I_INSPSPECIFICATIONVERSION.INSPTOLERANCESPECIFICATION == TQ29.TOLERANZSL
Plant
  • Client
  • Plant
  • I_INSPSPECIFICATIONVERSION.MANDT == T001W.MANDT
  • I_INSPSPECIFICATIONVERSION.PLANT == T001W.WERKS
Authorization Group QM Master Data
  • Authorization Group QM Master Data
  • Client
  • I_INSPSPECIFICATIONVERSION.QLTYMSTRDATAAUTHORIZATIONGROUP == TQ01D.QMASTAUTH
  • I_INSPSPECIFICATIONVERSION.MANDT == TQ01D.MANDT