EHFNDD_LOC_SL

Transparent Table Application Table

Location - Storage Location

EHFNDD_LOC_SL is an SAP database table in S/4HANA. Location - Storage Location. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSLocationStorageLocation view from BASIC EHS Location Storage Location

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
plant_id EHFND_PLANT_ID Plant ID
storage_loc EHFND_STORAGE_LOC Storage Location
eww_loc_storage_location_d DUMMY Dummy function in length 1

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 - Storage Location
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LOC_SL (
    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]
    PLANT_ID,                    -- Plant ID [EHFND_PLANT_ID]
    STORAGE_LOC,                 -- Storage Location [EHFND_STORAGE_LOC]
    EWW_LOC_STORAGE_LOCATION_D,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);