EPREIH

Transparent Table Customizing Table
12 Fields 2 CDS Views

History Table for All Prices

EPREIH is an SAP database table in S/4HANA. History Table for All Prices. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_UtilsPriceItem view from BASIC Utilities Price Blocks/Items
I_UtilsPriceItemHistory view from BASIC Utilities Price Blocks/Items History

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY twaers TWAERS Trans. currency
KEY preis E_PREIS Price
KEY preistyp PREISTYP Price category
KEY preistuf PREISTUF Price level
KEY bisdatum BISZEITSCH Valid to
KEY vonzone VONZONE From-block
biszone BISZONE To-block
abdatum ABZEITSCH Valid From
preisbtr PRSBTR Price amount
zonb E_ZONB Ignore consump.
mngbasis MENGENBAS Quantity base

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.

-- History Table for All Prices
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EPREIH (
    MANDT,     -- Client [MANDT]
    TWAERS,    -- Trans. currency [TWAERS]
    PREIS,     -- Price [E_PREIS]
    PREISTYP,  -- Price category [PREISTYP]
    PREISTUF,  -- Price level [PREISTUF]
    BISDATUM,  -- Valid to [BISZEITSCH]
    VONZONE,   -- From-block [VONZONE]
    BISZONE,   -- To-block [BISZONE]
    ABDATUM,   -- Valid From [ABZEITSCH]
    PREISBTR,  -- Price amount [PRSBTR]
    ZONB,      -- Ignore consump. [E_ZONB]
    MNGBASIS,  -- Quantity base [MENGENBAS]
    PRIMARY KEY (MANDT, TWAERS, PREIS, PREISTYP, PREISTUF, BISDATUM, VONZONE)
);

Learn More