SAP table MTK_CLASS_DATA (Data about classes in material-routing assignment)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
ZKRIZ Counter for Additional Criteria NUMC 7 0 DZKRIZ
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-From Date DATS 8 0 DATUV
TECHV Technical status from CHAR 12 0 TECHV
AENNR Change Number CHAR 12 0 AENR AENNR
LOEKZ Deletion Indicator CHAR 1 0 LKENZ
PARKZ Indicator: inactive changes CHAR 1 0 PARKZ
ANDAT Date Record Created On DATS 8 0 ANDAT
ANNAM User who created record CHAR 12 0 ANNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
KUNR Account number of customer CHAR 10 0 KNA1 CPKUNR
SUCHFELD Search Field for Customer-Specific Task List Selection CHAR 20 0 QSUCHFELD
VBELN Sales Document CHAR 10 0 * VBELN_VA
POSNR Sales Document Item NUMC 6 0 * POSNR_VA
PSPNR Work breakdown structure element (WBS element) NUMC 8 0 * CS_PSPNR
VALID_TO Valid-to date DATS 8 0 DATUB
LOEKZ_INHERITED Deletion Indicator CHAR 1 0 LKENZ
VERSN Routing Version CHAR 4 0 PLNVERSN
VERSN_SOURCE Source Routing Version CHAR 4 0 PLNVERSN_SOURCE_VERSN
VERSN_SOURCE_ZKRIZ Task List Version: Source number mat. assgnmt. to task NUMC 7 0 PLNVERSN_SOURCE_ZKRIZ
MS_OBJECT Object for Multiple Specifications CHAR 30 0 TQMS2 Q_MS_OBJECT
MS_OBJTYPE Type of Object for Multiple Specifications CHAR 2 0 TQMS1 Q_MS_OBJTYPE
DATUB Valid-to date DATS 8 0 DATUB
AENNR_AUS To change number CHAR 12 0 * CPCS_ECN_TO
MAKTX Material Description CHAR 40 0 MAKTX
FLG_LOCK Header is locked CHAR 1 0 TSK_LOCK
HANDLE Internal ID of an object INT4 10 0 HANDLE

MTK_CLASS_DATA foreign key relationships

Table Field Check Table Check Field
0 MTK_CLASS_DATA AENNR AENR Change Master AENNR
1 MTK_CLASS_DATA KUNR KNA1 General Data in Customer Master MANDT
1 MTK_CLASS_DATA KUNR KNA1 General Data in Customer Master KUNNR
0 MTK_CLASS_DATA LIFNR LFA1 Supplier Master (General Section) MANDT
0 MTK_CLASS_DATA LIFNR LFA1 Supplier Master (General Section) LIFNR
1 MTK_CLASS_DATA MANDT T000 Clients MANDT
0 MTK_CLASS_DATA MATNR MARA General Material Data MANDT
0 MTK_CLASS_DATA MATNR MARA General Material Data MATNR
1 MTK_CLASS_DATA MS_OBJECT TQMS2 Objects for Multiple Specifications OBJECT
0 MTK_CLASS_DATA MS_OBJTYPE TQMS1 Types for Multiple Specification Objects OBJECTTYPE
1 MTK_CLASS_DATA PLNTY TCA01 Task list types MANDT
0 MTK_CLASS_DATA WERKS T001W Plants/Branches MANDT
0 MTK_CLASS_DATA WERKS T001W Plants/Branches WERKS