EHHSSW_FSI_ROOT

Transparent Table Application Table
29 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 29 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 (29)

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
objecthasaigeneratedcontent ehhss_fsi_has_ai_gnrtd_cntnt
sftyinstrnaignrtnsystemprpttxt ehfnd_llm_system_prompt
sftyinstrnaignrtnuserprpttxt ehfnd_llm_user_prompt
safetyinstructionnote ehhss_fsi_note Note
sftyinstrnmigrationsource ehhss_fsi_migration_source Migration Source
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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]
    OBJECTHASAIGENERATEDCONTENT,     -- ehhss_fsi_has_ai_gnrtd_cntnt
    SFTYINSTRNAIGNRTNSYSTEMPRPTTXT,  -- ehfnd_llm_system_prompt
    SFTYINSTRNAIGNRTNUSERPRPTTXT,    -- ehfnd_llm_user_prompt
    SAFETYINSTRUCTIONNOTE,           -- Note [ehhss_fsi_note]
    SFTYINSTRNMIGRATIONSOURCE,       -- Migration Source [ehhss_fsi_migration_source]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, SAFETYINSTRUCTIONUUID)
);

Learn More