EHSDSW_ES_GEN

Transparent Table Application Table
28 Fields 1 CDS Views

I_CMPLRQRSLTPCESASSMTTP I_EXPSRSCENGENDATATP

EHSDSW_ES_GEN is an SAP database table in S/4HANA. I_CMPLRQRSLTPCESASSMTTP I_EXPSRSCENGENDATATP. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExpsrScenGenDataDrft view from BASIC General Data - Draft

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pcesgeneraldatauuid EHSDS_ES_GENERAL_DATA_UUID General Data UUID
cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
pcesversiondate EHSDS_ES_VERSION_DATE Version Date
pcesshorttitlephrs1uuid EHSDS_ES_SHORT_TITLE Short Title
pcesshorttitlephrs2uuid EHSDS_ES_SHORT_TITLE Short Title
pcesshorttitlephrs3uuid EHSDS_ES_SHORT_TITLE Short Title
pcesshorttitlephrs4uuid EHSDS_ES_SHORT_TITLE Short Title
pcesshorttitlephrs5uuid EHSDS_ES_SHORT_TITLE Short Title
pcesshorttitlephrs6uuid EHSDS_ES_SHORT_TITLE Short Title
pceslifecyclestagephrsuuid EHSDS_ES_LIFE_CYCLE_STAGE Life Cycle Stage
pcessectorofusephrs1uuid EHSDS_ES_SECTOR_OF_USE Sector of Use
pcessectorofusephrs2uuid EHSDS_ES_SECTOR_OF_USE Sector of Use
pcessectorofusephrs3uuid EHSDS_ES_SECTOR_OF_USE Sector of Use
pcessectorofusephrs4uuid EHSDS_ES_SECTOR_OF_USE Sector of Use
pcessectorofusephrs5uuid EHSDS_ES_SECTOR_OF_USE Sector of Use
pcessectorofusephrs6uuid EHSDS_ES_SECTOR_OF_USE Sector of Use
creationdatetime EHFND_BO_CREA_DATE_TIME Created On
createdbyuser EHFND_BO_CREA_UNAME Created By
lastchangedatetime EHFND_BO_LCHG_DATE_TIME Last Changed On
lastchangedbyuser EHFND_BO_LCHG_UNAME Last Changed By
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_CMPLRQRSLTPCESASSMTTP I_EXPSRSCENGENDATATP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSW_ES_GEN (
    MANDT,                          -- Client [MANDT]
    PCESGENERALDATAUUID,            -- General Data UUID [EHSDS_ES_GENERAL_DATA_UUID]
    CMPLRQRSLTUUID,                 -- Compliance Assessment UUID [EHFND_CRR_UUID]
    PCESVERSIONDATE,                -- Version Date [EHSDS_ES_VERSION_DATE]
    PCESSHORTTITLEPHRS1UUID,        -- Short Title [EHSDS_ES_SHORT_TITLE]
    PCESSHORTTITLEPHRS2UUID,        -- Short Title [EHSDS_ES_SHORT_TITLE]
    PCESSHORTTITLEPHRS3UUID,        -- Short Title [EHSDS_ES_SHORT_TITLE]
    PCESSHORTTITLEPHRS4UUID,        -- Short Title [EHSDS_ES_SHORT_TITLE]
    PCESSHORTTITLEPHRS5UUID,        -- Short Title [EHSDS_ES_SHORT_TITLE]
    PCESSHORTTITLEPHRS6UUID,        -- Short Title [EHSDS_ES_SHORT_TITLE]
    PCESLIFECYCLESTAGEPHRSUUID,     -- Life Cycle Stage [EHSDS_ES_LIFE_CYCLE_STAGE]
    PCESSECTOROFUSEPHRS1UUID,       -- Sector of Use [EHSDS_ES_SECTOR_OF_USE]
    PCESSECTOROFUSEPHRS2UUID,       -- Sector of Use [EHSDS_ES_SECTOR_OF_USE]
    PCESSECTOROFUSEPHRS3UUID,       -- Sector of Use [EHSDS_ES_SECTOR_OF_USE]
    PCESSECTOROFUSEPHRS4UUID,       -- Sector of Use [EHSDS_ES_SECTOR_OF_USE]
    PCESSECTOROFUSEPHRS5UUID,       -- Sector of Use [EHSDS_ES_SECTOR_OF_USE]
    PCESSECTOROFUSEPHRS6UUID,       -- Sector of Use [EHSDS_ES_SECTOR_OF_USE]
    CREATIONDATETIME,               -- Created On [EHFND_BO_CREA_DATE_TIME]
    CREATEDBYUSER,                  -- Created By [EHFND_BO_CREA_UNAME]
    LASTCHANGEDATETIME,             -- Last Changed On [EHFND_BO_LCHG_DATE_TIME]
    LASTCHANGEDBYUSER,              -- Last Changed By [EHFND_BO_LCHG_UNAME]
    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, PCESGENERALDATAUUID)
);

Learn More