MVER

Transparent Table Application Table
58 Fields 2 CDS Views

Material Consumption

MVER is an SAP database table in S/4HANA. Material Consumption. It contains 58 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CIC_PRD_CONSUMPTION_QTY view_entity from CDS for Prd Consumption Qty
I_ProductConsumption view_entity from BASIC Product Consumption

Fields (58)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY gjahr GJAHR Fiscal Year
KEY perkz PERKZ Period Ind.
KEY zahlr DZAHLR Follow-on recs.
gsv01 GSVBR Tot.consumption
gsv02 GSVBR Tot.consumption
gsv03 GSVBR Tot.consumption
gsv04 GSVBR Tot.consumption
gsv05 GSVBR Tot.consumption
gsv06 GSVBR Tot.consumption
gsv07 GSVBR Tot.consumption
gsv08 GSVBR Tot.consumption
gsv09 GSVBR Tot.consumption
gsv10 GSVBR Tot.consumption
gsv11 GSVBR Tot.consumption
gsv12 GSVBR Tot.consumption
gsv13 GSVBR Tot.consumption
unv01 UNVBR Unplnd consump.
unv02 UNVBR Unplnd consump.
unv03 UNVBR Unplnd consump.
unv04 UNVBR Unplnd consump.
unv05 UNVBR Unplnd consump.
unv06 UNVBR Unplnd consump.
unv07 UNVBR Unplnd consump.
unv08 UNVBR Unplnd consump.
unv09 UNVBR Unplnd consump.
unv10 UNVBR Unplnd consump.
unv11 UNVBR Unplnd consump.
unv12 UNVBR Unplnd consump.
unv13 UNVBR Unplnd consump.
mgv01 MGVBR Corr.tot.consum
mgv02 MGVBR Corr.tot.consum
mgv03 MGVBR Corr.tot.consum
mgv04 MGVBR Corr.tot.consum
mgv05 MGVBR Corr.tot.consum
mgv06 MGVBR Corr.tot.consum
mgv07 MGVBR Corr.tot.consum
mgv08 MGVBR Corr.tot.consum
mgv09 MGVBR Corr.tot.consum
mgv10 MGVBR Corr.tot.consum
mgv11 MGVBR Corr.tot.consum
mgv12 MGVBR Corr.tot.consum
mgv13 MGVBR Corr.tot.consum
muv01 MUVBR Corr.unpl.cons.
muv02 MUVBR Corr.unpl.cons.
muv03 MUVBR Corr.unpl.cons.
muv04 MUVBR Corr.unpl.cons.
muv05 MUVBR Corr.unpl.cons.
muv06 MUVBR Corr.unpl.cons.
muv07 MUVBR Corr.unpl.cons.
muv08 MUVBR Corr.unpl.cons.
muv09 MUVBR Corr.unpl.cons.
muv10 MUVBR Corr.unpl.cons.
muv11 MUVBR Corr.unpl.cons.
muv12 MUVBR Corr.unpl.cons.
muv13 MUVBR Corr.unpl.cons.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Consumption
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MVER (
    MANDT,  -- Client [MANDT]
    MATNR,  -- Material [MATNR]
    WERKS,  -- Plant [WERKS_D]
    GJAHR,  -- Fiscal Year [GJAHR]
    PERKZ,  -- Period Ind. [PERKZ]
    ZAHLR,  -- Follow-on recs. [DZAHLR]
    GSV01,  -- Tot.consumption [GSVBR]
    GSV02,  -- Tot.consumption [GSVBR]
    GSV03,  -- Tot.consumption [GSVBR]
    GSV04,  -- Tot.consumption [GSVBR]
    GSV05,  -- Tot.consumption [GSVBR]
    GSV06,  -- Tot.consumption [GSVBR]
    GSV07,  -- Tot.consumption [GSVBR]
    GSV08,  -- Tot.consumption [GSVBR]
    GSV09,  -- Tot.consumption [GSVBR]
    GSV10,  -- Tot.consumption [GSVBR]
    GSV11,  -- Tot.consumption [GSVBR]
    GSV12,  -- Tot.consumption [GSVBR]
    GSV13,  -- Tot.consumption [GSVBR]
    UNV01,  -- Unplnd consump. [UNVBR]
    UNV02,  -- Unplnd consump. [UNVBR]
    UNV03,  -- Unplnd consump. [UNVBR]
    UNV04,  -- Unplnd consump. [UNVBR]
    UNV05,  -- Unplnd consump. [UNVBR]
    UNV06,  -- Unplnd consump. [UNVBR]
    UNV07,  -- Unplnd consump. [UNVBR]
    UNV08,  -- Unplnd consump. [UNVBR]
    UNV09,  -- Unplnd consump. [UNVBR]
    UNV10,  -- Unplnd consump. [UNVBR]
    UNV11,  -- Unplnd consump. [UNVBR]
    UNV12,  -- Unplnd consump. [UNVBR]
    UNV13,  -- Unplnd consump. [UNVBR]
    MGV01,  -- Corr.tot.consum [MGVBR]
    MGV02,  -- Corr.tot.consum [MGVBR]
    MGV03,  -- Corr.tot.consum [MGVBR]
    MGV04,  -- Corr.tot.consum [MGVBR]
    MGV05,  -- Corr.tot.consum [MGVBR]
    MGV06,  -- Corr.tot.consum [MGVBR]
    MGV07,  -- Corr.tot.consum [MGVBR]
    MGV08,  -- Corr.tot.consum [MGVBR]
    MGV09,  -- Corr.tot.consum [MGVBR]
    MGV10,  -- Corr.tot.consum [MGVBR]
    MGV11,  -- Corr.tot.consum [MGVBR]
    MGV12,  -- Corr.tot.consum [MGVBR]
    MGV13,  -- Corr.tot.consum [MGVBR]
    MUV01,  -- Corr.unpl.cons. [MUVBR]
    MUV02,  -- Corr.unpl.cons. [MUVBR]
    MUV03,  -- Corr.unpl.cons. [MUVBR]
    MUV04,  -- Corr.unpl.cons. [MUVBR]
    MUV05,  -- Corr.unpl.cons. [MUVBR]
    MUV06,  -- Corr.unpl.cons. [MUVBR]
    MUV07,  -- Corr.unpl.cons. [MUVBR]
    MUV08,  -- Corr.unpl.cons. [MUVBR]
    MUV09,  -- Corr.unpl.cons. [MUVBR]
    MUV10,  -- Corr.unpl.cons. [MUVBR]
    MUV11,  -- Corr.unpl.cons. [MUVBR]
    MUV12,  -- Corr.unpl.cons. [MUVBR]
    MUV13,  -- Corr.unpl.cons. [MUVBR]
    PRIMARY KEY (MANDT, MATNR, WERKS, GJAHR, PERKZ, ZAHLR)
);

Learn More