SAP table MAPE (Material Master: Export Control File)
SAP table MAPE has 4 primary key fields being MANDT,MATNR,WERKS,GZOLX.
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
Client
CLNT
3
0
T000
MANDT
Material Number
CHAR
40
0
MARA
MATNR
Plant
CHAR
4
0
T001W
WERKS_D
Preference zone
CHAR
4
0
GZOLX
PREFE
Customs Preference
CHAR
1
0
PREFE
Possible values
A
Not Checked
B
Checked - price influenced
C
Generally allowed
D
Generally not allowed
E
Authorized for preference: set manually
F
Not authorized for preference: component of mixed origins
PREDA
Date of preference determination
DATS
8
0
PREDA
PRENE
Indicator: Vendor declaration exists
CHAR
1
0
PRENE
Possible values
A
Not Checked
B
Checked: OK
C
Checked: Long-Term Declaration Exists
D
Checked: Not OK
PRENG
Validity date of vendor declaration
DATS
8
0
PRENG
WAERS
Currency Key
CUKY
5
0
TCURC
WAERS
PREUR
Value of originating part from assembly calculation
CURR
15
2
PREUR
PRENU
Value of non-originating part from assembly calculation
CURR
15
2
PRENU
BASME
Base Unit of Measure for BOM
UNIT
3
0
*
BASME
BASMG
Base quantity
QUAN
13
3
BASMN
MAPE foreign key relationships
Table
Field
Check Table
Check Field
0 MAPE
MANDT
T000 Clients
MANDT
1 MAPE
MATNR
MARA General Material Data
MANDT
1 MAPE
MATNR
MARA General Material Data
MATNR
0 MAPE
WAERS
TCURC Currency Codes
MANDT
0 MAPE
WAERS
TCURC Currency Codes
WAERS
1 MAPE
WERKS
T001W Plants/Branches
MANDT
1 MAPE
WERKS
T001W Plants/Branches
WERKS