MAPR

Transparent Table Application Table
8 Fields 4 CDS Views

Material Index for Forecast

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProdPlntFcstParameters view from BASIC Basic view for Forecast Parameters
PPH_E_PROW view inner
rrp_e_FcRlt view right_outer RRP: Select Forecast Values for RLT
rrp_e_FcTrc view right_outer RRP: Select Forecast Values for TRC

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY werks werks_d Plant
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 for Forecast
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAPR (
    MANDT,  -- Client [mandt]
    WERKS,  -- Plant [werks_d]
    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, WERKS, MATNR)
);

Learn More