EHFNDD_LEARNING

Transparent Table Application Table
12 Fields 1 CDS Views

EHS Learning Items

EHFNDD_LEARNING is an SAP database table in S/4HANA. EHS Learning Items. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSLearning view_entity from BASIC Learnings cache table basic layer

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ehslearninguuid EHFND_LEARNING_UUID Learning UUID
ehslearningdescriptiontext EHFND_LEARNING_DESCRIPTION_TXT Description Text
ehslearningisactive EHFND_LEARNING_IS_ACTIVE Learning is active
ehslearningsourceid EHFND_LEARNING_SOURCE_ID Learning ID
ehslearningsourcesystem EHFND_LEARNING_SRC_SYS Source System
ehslearningitemtypeid EHFND_LEARNING_ITEM_TYPE_ID Item Type
ehslearningrevisiondate EHFND_LEARNING_RESP_REV_DATE Revision Date
creationutcdatetime TIMESTAMP Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMP Time Stamp
lastchangedbyuser UNAME User Name

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.

-- EHS Learning Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LEARNING (
    MANDT,                       -- Client [MANDT]
    EHSLEARNINGUUID,             -- Learning UUID [EHFND_LEARNING_UUID]
    EHSLEARNINGDESCRIPTIONTEXT,  -- Description Text [EHFND_LEARNING_DESCRIPTION_TXT]
    EHSLEARNINGISACTIVE,         -- Learning is active [EHFND_LEARNING_IS_ACTIVE]
    EHSLEARNINGSOURCEID,         -- Learning ID [EHFND_LEARNING_SOURCE_ID]
    EHSLEARNINGSOURCESYSTEM,     -- Source System [EHFND_LEARNING_SRC_SYS]
    EHSLEARNINGITEMTYPEID,       -- Item Type [EHFND_LEARNING_ITEM_TYPE_ID]
    EHSLEARNINGREVISIONDATE,     -- Revision Date [EHFND_LEARNING_RESP_REV_DATE]
    CREATIONUTCDATETIME,         -- Time Stamp [TIMESTAMP]
    CREATEDBYUSER,               -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,       -- Time Stamp [TIMESTAMP]
    LASTCHANGEDBYUSER,           -- User Name [UNAME]
    PRIMARY KEY (MANDT, EHSLEARNINGUUID)
);

Learn More