SAP table M_MERKB (Generated Table for View)

SAP table M_MERKB has 7 primary key fields being MANDT,ATNAM,DATUV,ATKLA,ATFOR,SPRAS,ATBEZ.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ATNAM Characteristic Name CHAR 30 0 ATNAM
DATUV Valid-From Date DATS 8 0 DATUV
ATKLA Characteristics Group CHAR 10 0 TCMG ATKLA
ATFOR Data type of characteristic CHAR 4 0 ATFOR
CHAR Character Format
CURR Currency Format
DATE Date Format
NUM Numeric Format
TIME Time Format
UDEF User-Defined Data Type
SPRAS Language Key LANG 1 0 T002 SPRAS
ATBEZ Characteristic description CHAR 30 0 ATBEZ

M_MERKB foreign key relationships

Table Field Check Table Check Field
0 M_MERKB ATKLA TCMG Characteristics Groups MANDT
0 M_MERKB ATKLA TCMG Characteristics Groups ATKLA
1 M_MERKB MANDT T000 Clients MANDT
0 M_MERKB SPRAS T002 Language Keys (Component BC-I18) SPRAS