EPREI

Transparent Table Customizing Table
34 Fields 2 CDS Views

Mstr Pricing Table for All Prices

EPREI is an SAP database table in S/4HANA. Mstr Pricing Table for All Prices. It contains 34 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_UtilsPriceHeader view from BASIC Utilities Price Master
I_UtilsPriceItem view inner BASIC Utilities Price Blocks/Items

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY preis E_PREIS Price
KEY preistyp PREISTYP Price category
KEY preistuf PREISTUF Price level
sparte SPARTE Division
mass E_MASS Unit of meas.
aklasse AKLASSE Billing Class
timbasis TIMBASIS Time basis
timtyp TIMTYP Time category
preigkl PREIGKL PriceAdj.clause
mittelpr MITTELPR Average price
dpreikz DPREIKZ Average price
rundart RUNDART Rounding Cat.
rundung E_RUNDUNG Rounding
preisart E_PREISART Price type
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
indexp INDEXP IndBased price
nextint NEXTINT Whole Number
fran_type FRAN_TYPE Franch.fee cat.
extprice EXTPRICE External price
prczonaj PRCZONAJ PrBlockAdjustmt
prczomin PRCZOMIN Low.lim.interv.
prczomax PRCZOMAX Upp.lim.interv.
ka_grenzpreis KA_GRENZPREIS FF price lmt
grossprice GROSSPRICE Gross price
priceorigin PRICEORIGIN Price Origin
anlage ANLAGE Installation
rabart RABART Discount type
rabtyp RABTYP Discount cat.

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.

-- Mstr Pricing Table for All Prices
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EPREI (
    MANDT,          -- Client [MANDT]
    PREIS,          -- Price [E_PREIS]
    PREISTYP,       -- Price category [PREISTYP]
    PREISTUF,       -- Price level [PREISTUF]
    SPARTE,         -- Division [SPARTE]
    MASS,           -- Unit of meas. [E_MASS]
    AKLASSE,        -- Billing Class [AKLASSE]
    TIMBASIS,       -- Time basis [TIMBASIS]
    TIMTYP,         -- Time category [TIMTYP]
    PREIGKL,        -- PriceAdj.clause [PREIGKL]
    MITTELPR,       -- Average price [MITTELPR]
    DPREIKZ,        -- Average price [DPREIKZ]
    RUNDART,        -- Rounding Cat. [RUNDART]
    RUNDUNG,        -- Rounding [E_RUNDUNG]
    PREISART,       -- Price type [E_PREISART]
    ERDAT,          -- Created On [ERDAT]
    ERNAM,          -- Created By [ERNAM]
    AEDAT,          -- Changed On [AEDAT]
    AENAM,          -- Changed By [AENAM]
    BEGRU,          -- AuthorizGroup [BEGRU]
    LOEVM,          -- Delete [LOEVM]
    INDEXP,         -- IndBased price [INDEXP]
    NEXTINT,        -- Whole Number [NEXTINT]
    FRAN_TYPE,      -- Franch.fee cat. [FRAN_TYPE]
    EXTPRICE,       -- External price [EXTPRICE]
    PRCZONAJ,       -- PrBlockAdjustmt [PRCZONAJ]
    PRCZOMIN,       -- Low.lim.interv. [PRCZOMIN]
    PRCZOMAX,       -- Upp.lim.interv. [PRCZOMAX]
    KA_GRENZPREIS,  -- FF price lmt [KA_GRENZPREIS]
    GROSSPRICE,     -- Gross price [GROSSPRICE]
    PRICEORIGIN,    -- Price Origin [PRICEORIGIN]
    ANLAGE,         -- Installation [ANLAGE]
    RABART,         -- Discount type [RABART]
    RABTYP,         -- Discount cat. [RABTYP]
    PRIMARY KEY (MANDT, PREIS, PREISTYP, PREISTUF)
);

Learn More