A_InspectionSpecification

Master Inspection Characteristics | view: AINSPSPEC | Extraction: Not supported | Component: Quality Planning

Tables used: QPMK

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (36)
Other (19)
🔗 Relations (13)

Column Name	Description
InspectionSpecification	Master Inspection Characteristic
InspectionSpecificationVersion	Version Number of Master Inspection Characteristic
InspectionSpecificationPlant	Plant for the 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
InspSpecIsDefectsRecgAutomatic	Defects Recording Automatically Called Up	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
InspSpecIsTestEquipmentRqd	Assignment of Test Equipment Required	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
InspSpecHasLowerLimit	Value Not Initial if Set	Show values
InspSpecHasLowrPlausibilityLmt	Value Not Initial if Set	Show values
InspSpecHasFirstLowerSpecLimit	Value Not Initial if Set	Show values
InspSpecHasSecondLowrSpecLimit	Value Not Initial if Set	Show values
InspSpecHasLowrSpecLimitChange	Value Not Initial if Set	Show values
InspSpecHasUpperLimit	Value Not Initial if Set	Show values
InspSpecHasUprPlausibilityLmt	Value Not Initial if Set	Show values
InspSpecHasFirstUpperSpecLimit	Value Not Initial if Set	Show values
InspSpecHasSecondUprSpecLimit	Value Not Initial if Set	Show values
InspSpecHasUprSpecLimitChange	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
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
InspSpecLowerLimit	Lower Specification Limit	QSOLLWERTE
InspSpecLowerPlausibilityLimit	Lower Plausibility Limit	QSOLLWERTE
InspSpecFirstLowerSpecLimit	First Lower Specification Limit	QSOLLWERTE
InspSpecSecondLowerSpecLimit	Second Lower Specification Limit	QSOLLWERTE
InspSpecLowerSpecLimitChange	Change to Lower Specification Limit	QSOLLWERTE
InspSpecUpperLimit	Upper Specification Limit	QSOLLWERTE
InspSpecUpperPlausibilityLimit	Upper Plausibility Limit	QSOLLWERTE
InspSpecFirstUpperSpecLimit	First Upper Specification Limit	QSOLLWERTE
InspSpecSecondUpperSpecLimit	Second Upper Specification Limit	QSOLLWERTE
InspSpecUpperSpecLimitChange	Change to Upper Specification Limit	QSOLLWERTE
CharacteristicInternalID	Internal characteristic	ATINN

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