SAP table MAEX (Material Master: Legal Control)

SAP table MAEX has 4 primary key fields being MANDT,MATNR,ALAND,GEGRU.

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
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
GEGRU Legal Regulation for Legal Control CHAR 2 0 T606G GEGRU
ALNUM Export control class according the legal reg. for legal ctrl CHAR 14 0 T606H ALNUM
EMBGR Grouping for Legal Control CHAR 14 0 T606I EMBGR
PMAST Individual maint. of matl master for legal control possible CHAR 1 0 PMAST
SECGK Legal Control: Special Characteristics Code for Goods CHAR 5 0 T606D SECGK

MAEX foreign key relationships

Table Field Check Table Check Field
0 MAEX ALAND T005 Countries MANDT
0 MAEX ALAND T005 Countries LAND1
1 MAEX ALNUM T606H Legal Control: Export Control Classes MANDT
1 MAEX ALNUM T606H Legal Control: Export Control Classes ALNUM
0 MAEX EMBGR T606I Legal Control: Export Control Class / Grouping MANDT
0 MAEX EMBGR T606I Legal Control: Export Control Class / Grouping ALNUM
0 MAEX EMBGR T606I Legal Control: Export Control Class / Grouping EMBGR
1 MAEX GEGRU T606G Legal Control: Legal Regulations GEGRU
0 MAEX MANDT T000 Clients MANDT
1 MAEX MATNR MARA General Material Data MANDT
1 MAEX MATNR MARA General Material Data MATNR
0 MAEX SECGK T606D Legal Control: Special Characteristic Code for Goods MANDT
0 MAEX SECGK T606D Legal Control: Special Characteristic Code for Goods ALNUM