EHFNDD_LOC_REV

Transparent Table Application Table
3 Fields 7 CDS Views

Location - Revisions

EHFNDD_LOC_REV is an SAP database table in S/4HANA. Location - Revisions. It contains 3 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
Ehenv_Location_All view from Retrieves current revision locations
Ehenv_Location_Filter view inner Retrieves current revision location and its sublocations
Ehenv_Scen_Loc_Active view from Active Scenarios for a User
Ehenv_Scen_Usr_Active view from Active Scenarios for a User
Ehfnd_Loc_Curr_Rev_All view from Current revision of a locations
Ehfnd_Loc_Current_Revision view from Current revision of a location
I_EHSLocationRevisionBasic view_entity from BASIC Location Revision

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY db_key ehfnd_loc_rev_key Loc. - Revision
parent_key ehfnd_loc_root_key Loc. - Root

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.

-- Location - Revisions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LOC_REV (
    MANDT,       -- Client [mandt]
    DB_KEY,      -- Loc. - Revision [ehfnd_loc_rev_key]
    PARENT_KEY,  -- Loc. - Root [ehfnd_loc_root_key]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More