- Home
- Resources
- SAP Tables
- MTK_CLASS_DATA - Data about classes in material-routing assignment
SAP Table MTK_CLASS_DATA
Data about classes in material-routing assignment
MTK_CLASS_DATA (Data about classes in material-routing assignment) 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_DATA to other SAP tables.
Source: MTK_CLASS_DATA (Data about classes in material-routing assignment)
MTK_CLASS_DATA table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| MATNR |
Material Number |
MATNR |
MARA
|
CHAR |
|
18 |
0 |
|
| WERKS |
Plant |
WERKS_D |
T001W
|
CHAR |
|
4 |
0 |
|
| PLNTY |
Task List Type |
PLNTY |
TCA01
|
CHAR |
|
1 |
0 |
|
| PLNNR |
Key for Task List Group |
PLNNR |
|
CHAR |
|
8 |
0 |
|
| PLNAL |
Group Counter |
PLNAL |
|
CHAR |
|
2 |
0 |
|
| ZKRIZ |
Counter for additional criteria |
DZKRIZ |
|
NUMC |
|
7 |
0 |
|
| ZAEHL |
Internal counter |
CIM_COUNT |
|
NUMC |
|
8 |
0 |
|
| DATUV |
Valid-From Date |
DATUV |
|
DATS |
|
8 |
0 |
|
| TECHV |
Technical status from |
TECHV |
|
CHAR |
|
12 |
0 |
|
| AENNR |
Change Number |
AENNR |
AENR
|
CHAR |
|
12 |
0 |
|
| LOEKZ |
Deletion Indicator |
LKENZ |
|
CHAR |
|
1 |
0 |
Possible values
|
| PARKZ |
Indicator: inactive changes |
PARKZ |
|
CHAR |
|
1 |
0 |
Possible values
|
| ANDAT |
Date record created on |
ANDAT |
|
DATS |
|
8 |
0 |
|
| ANNAM |
User who created record |
ANNAM |
|
CHAR |
|
12 |
0 |
|
| AEDAT |
Changed On |
AEDAT |
|
DATS |
|
8 |
0 |
|
| AENAM |
Name of Person Who Changed Object |
AENAM |
|
CHAR |
|
12 |
0 |
|
| LIFNR |
Vendor Account Number |
ELIFN |
LFA1
|
CHAR |
|
10 |
0 |
|
| KUNR |
Account number of customer |
CPKUNR |
KNA1
|
CHAR |
|
10 |
0 |
|
| SUCHFELD |
Search Field for Customer-Specific Task List Selection |
QSUCHFELD |
|
CHAR |
|
20 |
0 |
|
| VBELN |
Sales Document |
VBELN_VA |
VBUK
|
CHAR |
|
10 |
0 |
|
| POSNR |
Sales Document Item |
POSNR_VA |
VBUP
|
NUMC |
|
6 |
0 |
|
| PSPNR |
Work breakdown structure element (WBS element) |
CS_PSPNR |
|
NUMC |
|
8 |
0 |
|
| MS_OBJECT |
Object for Multiple Specifications |
Q_MS_OBJECT |
TQMS2
|
CHAR |
|
30 |
0 |
|
| MS_OBJTYPE |
Type of Object for Multiple Specifications |
Q_MS_OBJTYPE |
TQMS1
|
CHAR |
|
2 |
0 |
|
| DATUB |
Valid-to date |
DATUB |
|
DATS |
|
8 |
0 |
|
| AENNR_AUS |
To change number |
CPCS_ECN_TO |
|
CHAR |
|
12 |
0 |
|
| MAKTX |
Material Description (Short Text) |
MAKTX |
|
CHAR |
|
40 |
0 |
|
| FLG_LOCK |
Header is locked |
TSK_LOCK |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Flag set. Event has occurred. |
| NULL |
Flag is Not Set |
|
| HANDLE |
Internal ID of an object |
HANDLE |
|
INT4 |
|
10 |
0 |
|
MTK_CLASS_DATA foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| MTK_CLASS_DATA |
AENNR |
MTK_CLASS_DATA |
MANDT |
AENR |
Change Master |
MANDT |
| MTK_CLASS_DATA |
AENNR |
MTK_CLASS_DATA |
AENNR |
AENR |
Change Master |
AENNR |
| MTK_CLASS_DATA |
KUNR |
MTK_CLASS_DATA |
KUNR |
KNA1 |
General Data in Customer Master |
KUNNR |
| MTK_CLASS_DATA |
KUNR |
MTK_CLASS_DATA |
MANDT |
KNA1 |
General Data in Customer Master |
MANDT |
| MTK_CLASS_DATA |
LIFNR |
MTK_CLASS_DATA |
LIFNR |
LFA1 |
Vendor Master (General Section) |
LIFNR |
| MTK_CLASS_DATA |
LIFNR |
MTK_CLASS_DATA |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
| MTK_CLASS_DATA |
MANDT |
MTK_CLASS_DATA |
MANDT |
T000 |
Clients |
MANDT |
| MTK_CLASS_DATA |
MATNR |
MTK_CLASS_DATA |
MANDT |
MARA |
General Material Data |
MANDT |
| MTK_CLASS_DATA |
MATNR |
MTK_CLASS_DATA |
MATNR |
MARA |
General Material Data |
MATNR |
| MTK_CLASS_DATA |
MS_OBJECT |
MTK_CLASS_DATA |
MS_OBJECT |
TQMS2 |
Objects for Multiple Specifications |
OBJECT |
| MTK_CLASS_DATA |
MS_OBJECT |
MTK_CLASS_DATA |
MANDT |
TQMS2 |
Objects for Multiple Specifications |
MANDT |
| MTK_CLASS_DATA |
MS_OBJTYPE |
MTK_CLASS_DATA |
MS_OBJTYPE |
TQMS1 |
Types for Multiple Specification Objects |
OBJECTTYPE |
| MTK_CLASS_DATA |
MS_OBJTYPE |
MTK_CLASS_DATA |
MANDT |
TQMS1 |
Types for Multiple Specification Objects |
MANDT |
| MTK_CLASS_DATA |
PLNTY |
MTK_CLASS_DATA |
MANDT |
TCA01 |
Task list types |
MANDT |
| MTK_CLASS_DATA |
PLNTY |
MTK_CLASS_DATA |
PLNTY |
TCA01 |
Task list types |
PLNTY |
| MTK_CLASS_DATA |
POSNR |
MTK_CLASS_DATA |
MANDT |
VBUP |
Sales Document: Item Status |
MANDT |
| MTK_CLASS_DATA |
POSNR |
MTK_CLASS_DATA |
VBELN |
VBUP |
Sales Document: Item Status |
VBELN |
| MTK_CLASS_DATA |
POSNR |
MTK_CLASS_DATA |
POSNR |
VBUP |
Sales Document: Item Status |
POSNR |
| MTK_CLASS_DATA |
VBELN |
MTK_CLASS_DATA |
MANDT |
VBUK |
Sales Document: Header Status and Administrative Data |
MANDT |
| MTK_CLASS_DATA |
VBELN |
MTK_CLASS_DATA |
VBELN |
VBUK |
Sales Document: Header Status and Administrative Data |
VBELN |
| MTK_CLASS_DATA |
WERKS |
MTK_CLASS_DATA |
WERKS |
T001W |
Plants/Branches |
WERKS |
| MTK_CLASS_DATA |
WERKS |
MTK_CLASS_DATA |
MANDT |
T001W |
Plants/Branches |
MANDT |
