SAP table DVER (Material Consumption for MRP Area)

SAP table DVER has 6 primary key fields being MANDT,MATNR,BERID,GJAHR,PERKZ,ZAHLR.

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
BERID MRP Area CHAR 10 0 MDLV BERID
GJAHR Fiscal Year NUMC 4 0 GJAHR
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
ZAHLR Number of follow-on records in Table MVER NUMC 2 0 DZAHLR
GSV01 Total consumption QUAN 13 3 GSVBR
GSV02 Total consumption QUAN 13 3 GSVBR
GSV03 Total consumption QUAN 13 3 GSVBR
GSV04 Total consumption QUAN 13 3 GSVBR
GSV05 Total consumption QUAN 13 3 GSVBR
GSV06 Total consumption QUAN 13 3 GSVBR
GSV07 Total consumption QUAN 13 3 GSVBR
GSV08 Total consumption QUAN 13 3 GSVBR
GSV09 Total consumption QUAN 13 3 GSVBR
GSV10 Total consumption QUAN 13 3 GSVBR
GSV11 Total consumption QUAN 13 3 GSVBR
GSV12 Total consumption QUAN 13 3 GSVBR
GSV13 Total consumption QUAN 13 3 GSVBR
UNV01 Unplanned consumption QUAN 13 3 UNVBR
UNV02 Unplanned consumption QUAN 13 3 UNVBR
UNV03 Unplanned consumption QUAN 13 3 UNVBR
UNV04 Unplanned consumption QUAN 13 3 UNVBR
UNV05 Unplanned consumption QUAN 13 3 UNVBR
UNV06 Unplanned consumption QUAN 13 3 UNVBR
UNV07 Unplanned consumption QUAN 13 3 UNVBR
UNV08 Unplanned consumption QUAN 13 3 UNVBR
UNV09 Unplanned consumption QUAN 13 3 UNVBR
UNV10 Unplanned consumption QUAN 13 3 UNVBR
UNV11 Unplanned consumption QUAN 13 3 UNVBR
UNV12 Unplanned consumption QUAN 13 3 UNVBR
UNV13 Unplanned consumption QUAN 13 3 UNVBR
MGV01 Manually corrected total consumption QUAN 13 3 MGVBR
MGV02 Manually corrected total consumption QUAN 13 3 MGVBR
MGV03 Manually corrected total consumption QUAN 13 3 MGVBR
MGV04 Manually corrected total consumption QUAN 13 3 MGVBR
MGV05 Manually corrected total consumption QUAN 13 3 MGVBR
MGV06 Manually corrected total consumption QUAN 13 3 MGVBR
MGV07 Manually corrected total consumption QUAN 13 3 MGVBR
MGV08 Manually corrected total consumption QUAN 13 3 MGVBR
MGV09 Manually corrected total consumption QUAN 13 3 MGVBR
MGV10 Manually corrected total consumption QUAN 13 3 MGVBR
MGV11 Manually corrected total consumption QUAN 13 3 MGVBR
MGV12 Manually corrected total consumption QUAN 13 3 MGVBR
MGV13 Manually corrected total consumption QUAN 13 3 MGVBR
MUV01 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV02 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV03 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV04 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV05 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV06 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV07 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV08 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV09 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV10 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV11 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV12 Manually corrected unplanned consumption QUAN 13 3 MUVBR
MUV13 Manually corrected unplanned consumption QUAN 13 3 MUVBR

DVER foreign key relationships

Table Field Check Table Check Field
0 DVER BERID MDLV Customizing MRP Area MANDT
0 DVER BERID MDLV Customizing MRP Area BERID
1 DVER MANDT T000 Clients MANDT
0 DVER MATNR MARA General Material Data MANDT
0 DVER MATNR MARA General Material Data MATNR