EHHSSV_FSI_ROOT

24 Fields 1 CDS Views

Generated Table for View

EHHSSV_FSI_ROOT is an SAP database table in S/4HANA. Generated Table for View. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SafetyInstruction view from BASIC Safety Instruction Interface View

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY safetyinstructionuuid /BOBF/CONF_KEY NodeID
safetyinstruction EHHSS_FSI_ID Safety Instr. ID
factoryehslocationuuid EHFND_LOCATION_UUID_REF Location
chemicaluuid EHFND_CHM_UUID_REF Chemical
jobfreetext EHHSS_FSI_JOB_TEXT Job Description
factoryareafreetext EHHSS_FSI_WA_TEXT Fact. Area Descr.
language EHFND_EHS_LANGU Language Key
safetyinstructionstatus EHHSS_FSI_STATUS Status
safetyinstructionmajorrevision EHHSS_FSI_MAJOR_REVISION Major Revision
safetyinstructionminorrevision EHHSS_FSI_SUB_REVISION Minor Revision
safetyinstructionreldate EHHSS_FSI_RELEASE_DATETIME Released On
releasedbyuser EHHSS_FSI_RELEASE_USER Released By
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
safetyinstructiontype EHHSS_FSI_TYPE SI Type
safetyinstructionsubtype EHHSS_FSI_SUBTYPE SI Subtype
safetyinstructionsubjectdesc EHHSS_FSI_SUBJECT_DESC Subject Description
safetyinstructionistemplate EHHSS_FSI_IS_TEMPLATE Is Template
safetyinstructionnote EHHSS_FSI_NOTE Note
sftyinstrnmigrationsource EHHSS_FSI_MIGRATION_SOURCE Migration Source
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSV_FSI_ROOT (
    MANDT,                           -- Client [MANDT]
    SAFETYINSTRUCTIONUUID,           -- NodeID [/BOBF/CONF_KEY]
    SAFETYINSTRUCTION,               -- Safety Instr. ID [EHHSS_FSI_ID]
    FACTORYEHSLOCATIONUUID,          -- Location [EHFND_LOCATION_UUID_REF]
    CHEMICALUUID,                    -- Chemical [EHFND_CHM_UUID_REF]
    JOBFREETEXT,                     -- Job Description [EHHSS_FSI_JOB_TEXT]
    FACTORYAREAFREETEXT,             -- Fact. Area Descr. [EHHSS_FSI_WA_TEXT]
    LANGUAGE,                        -- Language Key [EHFND_EHS_LANGU]
    SAFETYINSTRUCTIONSTATUS,         -- Status [EHHSS_FSI_STATUS]
    SAFETYINSTRUCTIONMAJORREVISION,  -- Major Revision [EHHSS_FSI_MAJOR_REVISION]
    SAFETYINSTRUCTIONMINORREVISION,  -- Minor Revision [EHHSS_FSI_SUB_REVISION]
    SAFETYINSTRUCTIONRELDATE,        -- Released On [EHHSS_FSI_RELEASE_DATETIME]
    RELEASEDBYUSER,                  -- Released By [EHHSS_FSI_RELEASE_USER]
    CREATIONUTCDATETIME,             -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                   -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,               -- User Name [UNAME]
    SAFETYINSTRUCTIONTYPE,           -- SI Type [EHHSS_FSI_TYPE]
    SAFETYINSTRUCTIONSUBTYPE,        -- SI Subtype [EHHSS_FSI_SUBTYPE]
    SAFETYINSTRUCTIONSUBJECTDESC,    -- Subject Description [EHHSS_FSI_SUBJECT_DESC]
    SAFETYINSTRUCTIONISTEMPLATE,     -- Is Template [EHHSS_FSI_IS_TEMPLATE]
    SAFETYINSTRUCTIONNOTE,           -- Note [EHHSS_FSI_NOTE]
    SFTYINSTRNMIGRATIONSOURCE,       -- Migration Source [EHHSS_FSI_MIGRATION_SOURCE]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [EHFND_CCI_UUID]
    PRIMARY KEY (MANDT, SAFETYINSTRUCTIONUUID)
);

Learn More