DBVM

Transparent Table Application Table
14 Fields 1 CDS Views

Planning File Entry, MRP Area

DBVM is an SAP database table in S/4HANA. Planning File Entry, MRP Area. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
MDOV_DDL_DBVM view from CDS-View original DBVM table

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mafid mafid Record type
KEY disst disst Low-Level Code
KEY matnr matnr Material
KEY berid berid MRP Area
gsaen gsaen Net Change Plng
akken akken NChge - plgHor.
resdt resdt Reset ord.props
erdat erdat Created On
resal resal Re-explode BOM
mpskz mpskz MPS item ind.
rhytd rhytd Planning date
ustmp ustmp Up. Time Stamp
dstmp dstmp MRP Timestamp

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.

-- Planning File Entry, MRP Area
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DBVM (
    MANDT,  -- Client [mandt]
    MAFID,  -- Record type [mafid]
    DISST,  -- Low-Level Code [disst]
    MATNR,  -- Material [matnr]
    BERID,  -- MRP Area [berid]
    GSAEN,  -- Net Change Plng [gsaen]
    AKKEN,  -- NChge - plgHor. [akken]
    RESDT,  -- Reset ord.props [resdt]
    ERDAT,  -- Created On [erdat]
    RESAL,  -- Re-explode BOM [resal]
    MPSKZ,  -- MPS item ind. [mpskz]
    RHYTD,  -- Planning date [rhytd]
    USTMP,  -- Up. Time Stamp [ustmp]
    DSTMP,  -- MRP Timestamp [dstmp]
    PRIMARY KEY (MANDT, MAFID, DISST, MATNR, BERID)
);

Learn More