PPH_DBVM

Transparent Table Application Table
23 Fields 13 CDS Views

Planning File Entry, MRP Area

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

CDS Views using this table (13)

ViewTypeJoinVDMDescription
FSH_V_PLANNING_FILE_ENTRIES view inner Planning File entries for Fashion
I_MRPAreaPlanningFileEntry view from BASIC MRP Area Planning File Entry
MDCV_E_DBVL view from Compatibility View for DBVL
MDCV_E_DBVM view from Compatibility View for DBVM
P_DD_MAT_ADDLINFO view_entity from BASIC Demand Driven Material information
P_MatlMRPArea view from BASIC
P_MRPMATERIAL view from BASIC
P_PPH_MRP_ISSUES view from BASIC
P_PPH_MRP_ISSUES_ND view from BASIC Selection for NODISP Materials
P_PPH_MRP_MAT view from BASIC
PPH_DD_MAT_CTRL_0 view from DD Materials
PPH_DDL_MAT_CTRL_0 view from View for reading master data
Pphmrp_Error_Mats view from Attributes for Displaying Materials with Issues in last MRP

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY berid berid MRP Area
KEY plscn plscn Planning Scenario
nodisp pph_nodis No MRP
sc_empty pph_sc_empty SC MRP Area Empty
phantom dumps Phantom item
d_use_checked pph_d_use_checked Usage Checked
gsaen gsaen Net Change Plng
resdt resdt Reset ord.props
resal resal Re-explode BOM
erdat erdat Created On
rhytd rhytd Planning date
dstmp dstmp MRP Timestamp
lstmp ustmp Up. Time Stamp
msgid msgid Message ID
msgty msgty Message Type
msgno msgno Message Number
msgv1 msgv1 Message var.
msgv2 msgv2 Message var.
msgv3 msgv3 Message var.
msgv4 msgv4 Message var.

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 PPH_DBVM (
    MANDT,          -- Client [mandt]
    MATNR,          -- Material [matnr]
    WERKS,          -- Plant [werks_d]
    BERID,          -- MRP Area [berid]
    PLSCN,          -- Planning Scenario [plscn]
    NODISP,         -- No MRP [pph_nodis]
    SC_EMPTY,       -- SC MRP Area Empty [pph_sc_empty]
    PHANTOM,        -- Phantom item [dumps]
    D_USE_CHECKED,  -- Usage Checked [pph_d_use_checked]
    GSAEN,          -- Net Change Plng [gsaen]
    RESDT,          -- Reset ord.props [resdt]
    RESAL,          -- Re-explode BOM [resal]
    ERDAT,          -- Created On [erdat]
    RHYTD,          -- Planning date [rhytd]
    DSTMP,          -- MRP Timestamp [dstmp]
    LSTMP,          -- Up. Time Stamp [ustmp]
    MSGID,          -- Message ID [msgid]
    MSGTY,          -- Message Type [msgty]
    MSGNO,          -- Message Number [msgno]
    MSGV1,          -- Message var. [msgv1]
    MSGV2,          -- Message var. [msgv2]
    MSGV3,          -- Message var. [msgv3]
    MSGV4,          -- Message var. [msgv4]
    PRIMARY KEY (MANDT, MATNR, WERKS, BERID, PLSCN)
);

Learn More