SAP table TMW01 (Pur. Group/Mat. Group: Objects for Web Scenario (Purchasing))

SAP table TMW01 has 3 primary key fields being MANDT,EKGRP,MATKL.

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
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
MATKL Material Group CHAR 9 0 T023 MATKL
PROC1 Internal procurement type CHAR 1 0 PROC1
1 Material types subj. to inventory mgmt.: always reservation
2 Reservation generated if stock available
3 Always external procurement
PROC2 Control indicator in the case of external procurement CHAR 1 0 PROC2
1 Always purchase requisition
2 Purchase order if item data complete

TMW01 foreign key relationships

Table Field Check Table Check Field
0 TMW01 EKGRP T024 Purchasing Groups EKGRP
1 TMW01 MATKL T023 Material Groups MATKL