I_InspSpecificationVersionTP

Master Inspection Characteristic | view: IINSPSPECVERSTP | Extraction: Not supported | Component: Quality Planning

Tables used: CABN, CABNT, QPMK

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (38)
Other (25)
🔗 Relations (14)

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
InspSpecIsMeasuredValueRqd	Measured Values Must Be Recorded	Show values
InspSpecIsSelectedSetRequired	Reference to Characteristic Attribute Required	Show values
InspSpecIsUpperLimitRequired	Upper Specification Limit	Show values
InspSpecIsLowerLimitRequired	Lower Specification Limit	Show values
InspSpecIsTargetValueInLimit	Check Target Value	Show values
InspectionScope	Inspection Scope	Show values
InspSpecIsLongTermInspection	Long-Term Inspection	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
InspSpecIsDestructive	Destructive Inspection	Show values
InspSpecResultCalculation	Characteristic Result Calculation	Show values
InspSpecIsSamplingProcedRqd	Sampling Procedure Is Required	Show values
InspSpecIsScrapRelevant	Characteristic Relevant for Quality Score and Scrap Share	Show values
InspSpecHasFixedCtrlIndicators	Default Control Indicators Cannot Be Changed	Show values
InspSpecIsTestEquipmentRqd	Assignment of Test Equipment Required	Show values
InspSpecIsDefectsRecgAutomatic	Defects Recording Automatically Called Up	Show values
InspSpecIsChgDocRequired	Create Change Documents During Results Recording	Show values
InspSpecIsControlChartUsed	SPC Characteristic	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
InspSpecIsDetnRuleActive	Active Indicator for Specification Determination Rule	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
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	QSOLLWERTE
InspSpecLowerLimit	Lower Specification Limit	QSOLLWERTE
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
CharacteristicInternalID	Characteristic Internal ID	ATINN_NO_CONV
Characteristic	Characteristic Name	ATNAM
CharcDescription	Characteristic Description	TEXT30
CharacteristicDescription	Characteristic Description	TEXT30

Master Data Relations	Join Conditions
Fraction Calculation Fraction Calculation Client	`I_INSPSPECIFICATIONVERSIONTP.DEFECTFRACTIONESTIMATIONPROCED == TQ72.ANTVERF` `I_INSPSPECIFICATIONVERSIONTP.MANDT == TQ72.MANDT`
Unit of Measurement in Which Quantitative Data Is Stored Client Unit of Measurement in Which Quantitative Data Is Stored	`I_INSPSPECIFICATIONVERSIONTP.MANDT == T006.MANDT` `I_INSPSPECIFICATIONVERSIONTP.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI`
Inspector Qualification Inspector Qualification Client	`I_INSPSPECIFICATIONVERSIONTP.INSPECTORQUALIFICATION == TQ11.PRFQL` `I_INSPSPECIFICATIONVERSIONTP.MANDT == TQ11.MANDT`
Defect Code Group for General Rejection Defect Code Group for General Rejection ? Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEGRPREJECTION == QPGR.CODEGRUPPE` `I_INSPSPECIFICATIONVERSIONTP.[column in domain "QKATART"] == QPGR.KATALOGART` `I_INSPSPECIFICATIONVERSIONTP.MANDT == QPGR.MANDT`
Defect Code Group for Rejection at Lower Tolerance Defect Code Group for Rejection at Lower Tolerance ? Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEGRPRJCNLOWER == QPGR.CODEGRUPPE` `I_INSPSPECIFICATIONVERSIONTP.[column in domain "QKATART"] == QPGR.KATALOGART` `I_INSPSPECIFICATIONVERSIONTP.MANDT == QPGR.MANDT`
Defect Code Group for Rejection at Upper Tolerance Defect Code Group for Rejection at Upper Tolerance ? Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEGRPRJCNUPPER == QPGR.CODEGRUPPE` `I_INSPSPECIFICATIONVERSIONTP.[column in domain "QKATART"] == QPGR.KATALOGART` `I_INSPSPECIFICATIONVERSIONTP.MANDT == QPGR.MANDT`
Defect Code for Rejection: General Defect Code Group for Rejection at Lower Tolerance Defect Code for Rejection: General Version Number of Master Inspection Characteristic ? Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEGRPRJCNLOWER == QPCD.CODEGRUPPE` `I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEREJECTION == QPCD.CODE` `I_INSPSPECIFICATIONVERSIONTP.INSPECTIONSPECIFICATIONVERSION == QPCD.VERSION` `I_INSPSPECIFICATIONVERSIONTP.[column in domain "QKATART"] == QPCD.KATALOGART` `I_INSPSPECIFICATIONVERSIONTP.MANDT == QPCD.MANDT`
Defect Code for Rejection at Lower Specification Limit Defect Code for Rejection at Lower Specification Limit Defect Code Group for Rejection at Lower Tolerance Version Number of Master Inspection Characteristic ? Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODERJCNLOWER == QPCD.CODE` `I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEGRPRJCNLOWER == QPCD.CODEGRUPPE` `I_INSPSPECIFICATIONVERSIONTP.INSPECTIONSPECIFICATIONVERSION == QPCD.VERSION` `I_INSPSPECIFICATIONVERSIONTP.[column in domain "QKATART"] == QPCD.KATALOGART` `I_INSPSPECIFICATIONVERSIONTP.MANDT == QPCD.MANDT`
Defect Code for Rejection at Upper Specification Limit Defect Code Group for Rejection at Lower Tolerance Version Number of Master Inspection Characteristic ? Defect Code for Rejection at Upper Specification Limit Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODEGRPRJCNLOWER == QPCD.CODEGRUPPE` `I_INSPSPECIFICATIONVERSIONTP.INSPECTIONSPECIFICATIONVERSION == QPCD.VERSION` `I_INSPSPECIFICATIONVERSIONTP.[column in domain "QKATART"] == QPCD.KATALOGART` `I_INSPSPECIFICATIONVERSIONTP.INSPSPECDEFECTCODERJCNUPPER == QPCD.CODE` `I_INSPSPECIFICATIONVERSIONTP.MANDT == QPCD.MANDT`
Specification Determination Rule	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECDETERMINATIONRULE == QASDRI_SPECDET.SPEC_DET_RULE`
Weighting of Characteristic Weighting of Characteristic Client	`I_INSPSPECIFICATIONVERSIONTP.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE` `I_INSPSPECIFICATIONVERSIONTP.MANDT == TQ17A.MANDT`
Tolerance Key Tolerance Key Client	`I_INSPSPECIFICATIONVERSIONTP.INSPTOLERANCESPECIFICATION == TQ29.TOLERANZSL` `I_INSPSPECIFICATIONVERSIONTP.MANDT == TQ29.MANDT`
Plant Plant Client	`I_INSPSPECIFICATIONVERSIONTP.PLANT == T001W.WERKS` `I_INSPSPECIFICATIONVERSIONTP.MANDT == T001W.MANDT`
Authorization Group QM Master Data Authorization Group QM Master Data Client	`I_INSPSPECIFICATIONVERSIONTP.QLTYMSTRDATAAUTHORIZATIONGROUP == TQ01D.QMASTAUTH` `I_INSPSPECIFICATIONVERSIONTP.MANDT == TQ01D.MANDT`