DBPR

Transparent Table Application Table
8 Fields 1 CDS Views

Material Index MRP Area for Forecast

DBPR is an SAP database table in S/4HANA. Material Index MRP Area for Forecast. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
PPH_E_PROW view inner read PROW

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY berid berid MRP Area
KEY matnr matnr Material
pnum1 pnum1 Pointer param
perkz perkz Period Ind.
periv periv FY Variant
datum sydatum Current Date
uzeit syuzeit Time

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 Index MRP Area for Forecast
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DBPR (
    MANDT,  -- Client [mandt]
    BERID,  -- MRP Area [berid]
    MATNR,  -- Material [matnr]
    PNUM1,  -- Pointer param [pnum1]
    PERKZ,  -- Period Ind. [perkz]
    PERIV,  -- FY Variant [periv]
    DATUM,  -- Current Date [sydatum]
    UZEIT,  -- Time [syuzeit]
    PRIMARY KEY (MANDT, BERID, MATNR)
);

Learn More