EHFNDD_LOC_TEXT

Transparent Table Application Table
11 Fields 4 CDS Views

Location - Text Name

EHFNDD_LOC_TEXT is an SAP database table in S/4HANA. Location - Text Name. It contains 11 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Ehfnd_Loc_Curr_Rev_All view left_outer Current revision of a locations
I_EHSLocationName view_entity from BASIC EHS Location Revision Name
I_EHSLocationNameSimple view_entity from BASIC Location Name
I_EHSLocNameCurrentRevision view_entity from BASIC Location name along with its current revision

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
language EHFND_LANGU Language
text EHFND_LOC_REVISION_TEXT Text
text_normed EHFND_LOC_REVISION_TEXT Text

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 - Text Name
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LOC_TEXT (
    MANDT,           -- Client [MANDT]
    DB_KEY,          -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,        -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,      -- NodeID [/BOBF/CONF_KEY]
    CREA_DATE_TIME,  -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,      -- User Name [UNAME]
    LCHG_DATE_TIME,  -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,      -- User Name [UNAME]
    LANGUAGE,        -- Language [EHFND_LANGU]
    TEXT,            -- Text [EHFND_LOC_REVISION_TEXT]
    TEXT_NORMED,     -- Text [EHFND_LOC_REVISION_TEXT]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More