EHHSSW_FSI_ROOT

Transparent Table Application Table
31 Fields 1 CDS Views

I_SAFETYINSTRUCTIONTP I_SAFETYINSTRUCTIONTP

EHHSSW_FSI_ROOT is an SAP database table in S/4HANA. I_SAFETYINSTRUCTIONTP I_SAFETYINSTRUCTIONTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SafetyInstructionDraft view from BASIC FSI: Interface View - Draft

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY safetyinstructionuuid /BOBF/CONF_KEY NodeID
safetyinstruction EHHSS_FSI_ID Safety Instr. ID
safetyinstructionstatus EHHSS_FSI_STATUS Status
safetyinstructionmajorrevision abap.char
safetyinstructionminorrevision abap.char
factoryehslocationuuid EHFND_LOCATION_UUID_REF Location
chemicaluuid EHFND_CHM_UUID_REF Chemical
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
jobfreetext EHHSS_FSI_JOB_TEXT Job Description
factoryareafreetext EHHSS_FSI_WA_TEXT Fact. Area Descr.
language EHFND_EHS_LANGU Language Key
creationutcdatetime EHFND_BO_CREA_DATE_TIME Created On
createdbyuser EHFND_BO_CREA_UNAME Created By
safetyinstructionreldate EHHSS_FSI_RELEASE_DATETIME Released On
releasedbyuser EHHSS_FSI_RELEASE_USER Released By
lastchangeutcdatetime EHFND_BO_LCHG_DATE_TIME Last Changed On
lastchangedbyuser EHFND_BO_LCHG_UNAME Last Changed By
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
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_SAFETYINSTRUCTIONTP I_SAFETYINSTRUCTIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSW_FSI_ROOT (
    MANDT,                           -- Client [MANDT]
    SAFETYINSTRUCTIONUUID,           -- NodeID [/BOBF/CONF_KEY]
    SAFETYINSTRUCTION,               -- Safety Instr. ID [EHHSS_FSI_ID]
    SAFETYINSTRUCTIONSTATUS,         -- Status [EHHSS_FSI_STATUS]
    SAFETYINSTRUCTIONMAJORREVISION,  -- abap.char
    SAFETYINSTRUCTIONMINORREVISION,  -- abap.char
    FACTORYEHSLOCATIONUUID,          -- Location [EHFND_LOCATION_UUID_REF]
    CHEMICALUUID,                    -- Chemical [EHFND_CHM_UUID_REF]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [EHFND_CCI_UUID]
    JOBFREETEXT,                     -- Job Description [EHHSS_FSI_JOB_TEXT]
    FACTORYAREAFREETEXT,             -- Fact. Area Descr. [EHHSS_FSI_WA_TEXT]
    LANGUAGE,                        -- Language Key [EHFND_EHS_LANGU]
    CREATIONUTCDATETIME,             -- Created On [EHFND_BO_CREA_DATE_TIME]
    CREATEDBYUSER,                   -- Created By [EHFND_BO_CREA_UNAME]
    SAFETYINSTRUCTIONRELDATE,        -- Released On [EHHSS_FSI_RELEASE_DATETIME]
    RELEASEDBYUSER,                  -- Released By [EHHSS_FSI_RELEASE_USER]
    LASTCHANGEUTCDATETIME,           -- Last Changed On [EHFND_BO_LCHG_DATE_TIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [EHFND_BO_LCHG_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]
    ACTIVEUUID,                      -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, SAFETYINSTRUCTIONUUID)
);

Learn More