EHSDSV_ES_GEN

21 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExpsrScenGenData view from BASIC General Data

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client 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 /BOBF/CREATIONDATETIME Created On
createdbyuser /BOBF/CREATEDBYUSER Created By
lastchangedatetime /BOBF/LASTCHANGEDATETIME Last Changed On
lastchangedbyuser /BOBF/LASTCHANGEDBYUSER Last Changed By

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 EHSDSV_ES_GEN (
    CLIENT,                      -- 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 [/BOBF/CREATIONDATETIME]
    CREATEDBYUSER,               -- Created By [/BOBF/CREATEDBYUSER]
    LASTCHANGEDATETIME,          -- Last Changed On [/BOBF/LASTCHANGEDATETIME]
    LASTCHANGEDBYUSER,           -- Last Changed By [/BOBF/LASTCHANGEDBYUSER]
    PRIMARY KEY (CLIENT, PCESGENERALDATAUUID)
);

Learn More