SAP table MAPR (Material Index for Forecast)

SAP table MAPR has 3 primary key fields being MANDT,WERKS,MATNR.

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
WERKS Plant CHAR 4 0 T001W WERKS_D
MATNR Material Number CHAR 40 0 MARA MATNR
PNUM1 Pointer: forecast parameters NUMC 10 0 PROP PNUM1
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
DATUM System Date DATS 8 0 SYDATUM
UZEIT System Time TIMS 6 0 SYUZEIT

MAPR foreign key relationships

Table Field Check Table Check Field
0 MAPR MANDT T000 Clients MANDT
1 MAPR MATNR MARA General Material Data MANDT
1 MAPR MATNR MARA General Material Data MATNR
0 MAPR PERIV T009 Fiscal Year Variants MANDT
0 MAPR PERIV T009 Fiscal Year Variants PERIV
1 MAPR PNUM1 PROP Forecast Parameters MANDT
1 MAPR PNUM1 PROP Forecast Parameters HSNUM
1 MAPR PNUM1 PROP Forecast Parameters VERSP
0 MAPR WERKS T001W Plants/Branches MANDT
0 MAPR WERKS T001W Plants/Branches WERKS