EHFNDD_LOC_RESP

Transparent Table Application Table
11 Fields 5 CDS Views

Location - Responsible Person

EHFNDD_LOC_RESP is an SAP database table in S/4HANA. Location - Responsible Person. It contains 11 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
Ehenv_Scen_Usr_Active view inner Active Scenarios for a User
Ehenv_Scen_Usra_Loc_Curr_Rev view inner Active Scenarios per user and location current revision
I_EHSLocationResponsible view from BASIC EHS Location Root
I_EHSLocRespManager view from BASIC Location Responsible Manager
I_EHSLocRespTechnician view from BASIC Location Responsible Technician

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
person_id EHFND_LOC_PARTY_ID Name
role EHFND_LOC_ROLE_CODE Role
eew_loc_resp_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 - Responsible Person
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LOC_RESP (
    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]
    PERSON_ID,       -- Name [EHFND_LOC_PARTY_ID]
    ROLE,            -- Role [EHFND_LOC_ROLE_CODE]
    EEW_LOC_RESP_D,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More