SAP table MAMT (Material Master Texts per Unit of Measure and Text ID)

SAP table MAMT has 6 primary key fields being MANDT,MATNR,SPRAS,MEINH,MTXID,LFDNR.

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
MATNR Material Number CHAR 40 0 MARA MATNR
SPRAS Language Key LANG 1 0 T002 SPRAS
MEINH Alternative Unit of Measure for Stockkeeping Unit UNIT 3 0 T006 LRMEI
MTXID Material master: short text ID per unit of measure CHAR 2 0 MTXID
02 Cash register receipt text
10 Short text ID for additionals (only used internally)
11 Short text ID for additionals (only used internally)
12 Short text ID for additionals (only used internally)
13 Short text ID for additionals (only used internally)
14 Short text ID for additionals (only used internally)
15 Short text ID for additionals (only used internally)
16 Short text ID for additionals (only used internally)
17 Short text ID for additionals (only used internally)
18 Short text ID for additionals (only used internally)
19 Short text ID for additionals (only used internally)
20 Short text ID for additionals (only used internally)
21 Short text ID for additionals (only used internally)
22 Short text ID for additionals (only used internally)
23 Short text ID for additionals (only used internally)
24 Short text ID for additionals (only used internally)
25 Short text ID for additionals (only used internally)
26 Short text ID for additionals (only used internally)
27 Short text ID for additionals (only used internally)
28 Short text ID for additionals (only used internally)
29 Short text ID for additionals (only used internally)
30 Short text ID for additionals (only used internally)
31 Short text ID for additionals (only used internally)
32 Short text ID for additionals (only used internally)
33 Short text ID for additionals (only used internally)
34 Short text ID for additionals (only used internally)
35 Short text ID for additionals (only used internally)
36 Short text ID for additionals (only used internally)
37 Short text ID for additionals (only used internally)
38 Short text ID for additionals (only used internally)
39 Short text ID for additionals (only used internally)
40 Short text ID for additionals (only used internally)
41 Short text ID for additionals (only used internally)
42 Short text ID for additionals (only used internally)
43 Short text ID for additionals (only used internally)
44 Short text ID for additionals (only used internally)
45 Short text ID for additionals (only used internally)
46 Short text ID for additionals (only used internally)
47 Short text ID for additionals (only used internally)
48 Short text ID for additionals (only used internally)
49 Short text ID for additionals (only used internally)
LFDNR Consecutive Number for MAMT (2-Digit) NUMC 2 0 LFDNR_MAMT
MAKTM Material description for unit of measure CHAR 40 0 MAKTM

MAMT foreign key relationships

Table Field Check Table Check Field
0 MAMT MANDT T000 Clients MANDT
1 MAMT MATNR MARA General Material Data MANDT
1 MAMT MATNR MARA General Material Data MATNR
0 MAMT MEINH T006 Units of Measurement MANDT
0 MAMT MEINH T006 Units of Measurement MSEHI