EREV

Transparent Table Application Table

Version in Purchasing

EREV is an SAP database table in S/4HANA. Version in Purchasing. It contains 5 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CntrlPurContrVersionHistory view from BASIC Basic View for CCTR Version History
I_PPS_PurgDocVersionHistory view_entity from BASIC Purchase Contract Version History
I_PPS_PurReqnItemVersion view_entity from BASIC Purchase Requestion Item Version
I_PurContrVersionHistory view from BASIC Purchase Contract Version History
R_PPS_PurOrdVersionHistory view_entity from BASIC Purchase Order Version History

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bstyp bstyp_dcm Doc. Category
KEY edokn edokn Purchasing Doc.
KEY edokp edokp Item
KEY revno revno Version

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.

-- Version in Purchasing
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EREV (
    MANDT,  -- Client [mandt]
    BSTYP,  -- Doc. Category [bstyp_dcm]
    EDOKN,  -- Purchasing Doc. [edokn]
    EDOKP,  -- Item [edokp]
    REVNO,  -- Version [revno]
    PRIMARY KEY (MANDT, BSTYP, EDOKN, EDOKP, REVNO)
);