SAP Table MTK_CLASS_SEL
Selection structure for material attributes
MTK_CLASS_SEL (Selection structure for material attributes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MTK_CLASS_SEL to other SAP tables.
Source: MTK_CLASS_SEL (Selection structure for material attributes)
MTK_CLASS_SEL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLASS | Class number | KLASSE_D | CHAR | 18 | 0 | |||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| VBELN | Sales Order | CS_VBELN | VBUK | CHAR | 10 | 0 | ||||||||
| POSNR | Sales order item | CS_VBPOS | VBUP | NUMC | 6 | 0 | ||||||||
| VERID | Production Version | VERID | MKAL | CHAR | 4 | 0 | ||||||||
| PSPNR | Work breakdown structure element (WBS element) | CS_PSPNR | NUMC | 8 | 0 | |||||||||
| KLART | Class Type | KLASSENART | TCLA | CHAR | 3 | 0 | ||||||||
| FREE_SEL_FLG | Dynamic selection exists for object | FREE_SEL_FLG | CHAR | 1 | 0 |
Possible values
|
||||||||
MTK_CLASS_SEL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MTK_CLASS_SEL | KLART | SY | MANDT | TCLA | Class Types | MANDT |
| MTK_CLASS_SEL | KLART | MTK_CLASS_SEL | KLART | TCLA | Class Types | KLART |
| MTK_CLASS_SEL | MATNR | SY | MANDT | MARA | General Material Data | MANDT |
| MTK_CLASS_SEL | MATNR | MTK_CLASS_SEL | MATNR | MARA | General Material Data | MATNR |
| MTK_CLASS_SEL | POSNR | SY | MANDT | VBUP | Sales Document: Item Status | MANDT |
| MTK_CLASS_SEL | POSNR | MTK_CLASS_SEL | VBELN | VBUP | Sales Document: Item Status | VBELN |
| MTK_CLASS_SEL | POSNR | MTK_CLASS_SEL | POSNR | VBUP | Sales Document: Item Status | POSNR |
| MTK_CLASS_SEL | VBELN | SY | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| MTK_CLASS_SEL | VBELN | MTK_CLASS_SEL | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| MTK_CLASS_SEL | VERID | SY | MANDT | MKAL | Production Versions of Material | MANDT |
| MTK_CLASS_SEL | VERID | MTK_CLASS_SEL | MATNR | MKAL | Production Versions of Material | MATNR |
| MTK_CLASS_SEL | VERID | MTK_CLASS_SEL | WERKS | MKAL | Production Versions of Material | WERKS |
| MTK_CLASS_SEL | VERID | MTK_CLASS_SEL | VERID | MKAL | Production Versions of Material | VERID |
| MTK_CLASS_SEL | WERKS | SY | MANDT | T001W | Plants/Branches | MANDT |
| MTK_CLASS_SEL | WERKS | MTK_CLASS_SEL | WERKS | T001W | Plants/Branches | WERKS |
