I_AssgmtInspMethInspSpec

Assgnmt. - Insp. Meth./Insp. Spec. | view: IASSGMTIMETHSPEC | Extraction: Not supported | Component: Quality Planning

Tables used: QPMZ

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (1)
Other (9)
🔗 Relations (13)

Column Name	Description
InspectionSpecificationPlant	Plant for the Master Inspection Characteristic
InspectionSpecification FK	Master Inspection Characteristic
InspectionSpecificationVersion	Version Number of Master Inspection Characteristic
InspectionMethodPlant FK	Plant of the Inspection Method
InspectionMethod FK	Inspection Method
InspectionMethodVersion	Version Number of Inspection Method

Column Name	Description

Column Name	Description

Column Name	Description
ValidityStartDate	Valid-From Date

Column Name	Description
InspMethIsAssgmtToSpecInactive	Data Record Was Deleted	Show values

Column Name	Description	Domain name
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

Master Data Relations	Join Conditions
Inspection Method Client Inspection Method Version Number of Master Inspection Characteristic Plant of the Inspection Method	`I_ASSGMTINSPMETHINSPSPEC.MANDT == QMTB.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONMETHOD == QMTB.PMTNR` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONSPECIFICATIONVERSION == QMTB.VERSION` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONMETHODPLANT == QMTB.WERKS`
Plant of the Inspection Method Client Plant of the Inspection Method	`I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONMETHODPLANT == T001W.WERKS`
Master Inspection Characteristic Client Plant for the Master Inspection Characteristic Master Inspection Characteristic Version Number of Master Inspection Characteristic	`I_ASSGMTINSPMETHINSPSPEC.MANDT == QPMK.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONSPECIFICATION == QPMK.MKMNR` `I_ASSGMTINSPMETHINSPSPEC.INSPECTIONSPECIFICATIONVERSION == QPMK.VERSION`
Catalog Type of Assigned Code Group or Selected Set Client Catalog Type of Assigned Code Group or Selected Set	`I_ASSGMTINSPMETHINSPSPEC.MANDT == TQ15.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDITIONALCATALOG2 == TQ15.KATALOGART`
Catalog Type of Assigned Code Group or Selected Set Catalog Type of Assigned Code Group or Selected Set Client	`I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDITIONALCATALOG3 == TQ15.KATALOGART` `I_ASSGMTINSPMETHINSPSPEC.MANDT == TQ15.MANDT`
Catalog Type of Assigned Code Group or Selected Set Client Catalog Type of Assigned Code Group or Selected Set	`I_ASSGMTINSPMETHINSPSPEC.MANDT == TQ15.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDITIONALCATALOG4 == TQ15.KATALOGART`
Catalog Type of Assigned Code Group or Selected Set Catalog Type of Assigned Code Group or Selected Set Client	`I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDITIONALCATALOG5 == TQ15.KATALOGART` `I_ASSGMTINSPMETHINSPSPEC.MANDT == TQ15.MANDT`
Plant of the Assigned Selected Set Client Plant of the Assigned Selected Set	`I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDLSELDCODESETPLANT2 == T001W.WERKS`
Plant of the Assigned Selected Set Plant of the Assigned Selected Set Client	`I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDLSELDCODESETPLANT3 == T001W.WERKS` `I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT`
Plant of the Assigned Selected Set Client Plant of the Assigned Selected Set	`I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT` `I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDLSELDCODESETPLANT4 == T001W.WERKS`
Plant of the Assigned Selected Set Plant of the Assigned Selected Set Client	`I_ASSGMTINSPMETHINSPSPEC.INSPSPECADDLSELDCODESETPLANT5 == T001W.WERKS` `I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT`
Plant Client Plant	`I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT` `I_ASSGMTINSPMETHINSPSPEC.PLANT == T001W.WERKS`
Plant of the Assigned Selected Set Client Plant of the Assigned Selected Set	`I_ASSGMTINSPMETHINSPSPEC.MANDT == T001W.MANDT` `I_ASSGMTINSPMETHINSPSPEC.SELECTEDCODESETPLANT == T001W.WERKS`