EHSDSV_CS_GEN

43 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrbtScenGenData view from BASIC General Data

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY pcesgeneraldatauuid EHSDS_CS_GENERAL_DATA_UUID General Data UUID
cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
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
pcesenvrmtrelcatphrs1uuid EHSDS_CS_ENV_RELEASE_CAT Environmental Release Category
pcesenvrmtrelcatphrs2uuid EHSDS_CS_ENV_RELEASE_CAT Environmental Release Category
pcesenvrmtrelcatphrs3uuid EHSDS_CS_ENV_RELEASE_CAT Environmental Release Category
pcesenvrmtrelcatphrs4uuid EHSDS_CS_ENV_RELEASE_CAT Environmental Release Category
pcesenvrmtrelcatphrs5uuid EHSDS_CS_ENV_RELEASE_CAT Environmental Release Category
pcesenvrmtrelcatphrs6uuid EHSDS_CS_ENV_RELEASE_CAT Environmental Release Category
pcesprocesscatphrs1uuid EHSDS_CS_PROCESS_CAT Process Category Phrase UUID
pcesprocesscatphrs2uuid EHSDS_CS_PROCESS_CAT Process Category Phrase UUID
pcesprocesscatphrs3uuid EHSDS_CS_PROCESS_CAT Process Category Phrase UUID
pcesprocesscatphrs4uuid EHSDS_CS_PROCESS_CAT Process Category Phrase UUID
pcesprocesscatphrs5uuid EHSDS_CS_PROCESS_CAT Process Category Phrase UUID
pcesprocesscatphrs6uuid EHSDS_CS_PROCESS_CAT Process Category Phrase UUID
pcesproductcatphrs1uuid EHSDS_CS_PRODUCT_CAT Product Category Phrase UUID
pcesproductcatphrs2uuid EHSDS_CS_PRODUCT_CAT Product Category Phrase UUID
pcesproductcatphrs3uuid EHSDS_CS_PRODUCT_CAT Product Category Phrase UUID
pcesproductcatphrs4uuid EHSDS_CS_PRODUCT_CAT Product Category Phrase UUID
pcesproductcatphrs5uuid EHSDS_CS_PRODUCT_CAT Product Category Phrase UUID
pcesproductcatphrs6uuid EHSDS_CS_PRODUCT_CAT Product Category Phrase UUID
pcesproductsubcatphrs1uuid EHSDS_CS_PRODUCT_SUBCAT Product Subcategory Phrase UUID
pcesproductsubcatphrs2uuid EHSDS_CS_PRODUCT_SUBCAT Product Subcategory Phrase UUID
pcesproductsubcatphrs3uuid EHSDS_CS_PRODUCT_SUBCAT Product Subcategory Phrase UUID
pcesarticlecatphrs1uuid EHSDS_CS_ARTICLE_CAT Article Category
pcesarticlecatphrs2uuid EHSDS_CS_ARTICLE_CAT Article Category
pcesarticlecatphrs3uuid EHSDS_CS_ARTICLE_CAT Article Category
pcesarticlecatphrs4uuid EHSDS_CS_ARTICLE_CAT Article Category
pcesarticlecatphrs5uuid EHSDS_CS_ARTICLE_CAT Article Category
pcesarticlecatphrs6uuid EHSDS_CS_ARTICLE_CAT Article Category
pcesarticlesubcatphrs1uuid EHSDS_CS_ARTICLE_SUBCAT Article Subcategory
pcesarticlesubcatphrs2uuid EHSDS_CS_ARTICLE_SUBCAT Article Subcategory
pcesarticlesubcatphrs3uuid EHSDS_CS_ARTICLE_SUBCAT Article Subcategory
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_CS_GEN (
    CLIENT,                      -- Client [MANDT]
    PCESGENERALDATAUUID,         -- General Data UUID [EHSDS_CS_GENERAL_DATA_UUID]
    CMPLRQRSLTUUID,              -- Compliance Assessment UUID [EHFND_CRR_UUID]
    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]
    PCESENVRMTRELCATPHRS1UUID,   -- Environmental Release Category [EHSDS_CS_ENV_RELEASE_CAT]
    PCESENVRMTRELCATPHRS2UUID,   -- Environmental Release Category [EHSDS_CS_ENV_RELEASE_CAT]
    PCESENVRMTRELCATPHRS3UUID,   -- Environmental Release Category [EHSDS_CS_ENV_RELEASE_CAT]
    PCESENVRMTRELCATPHRS4UUID,   -- Environmental Release Category [EHSDS_CS_ENV_RELEASE_CAT]
    PCESENVRMTRELCATPHRS5UUID,   -- Environmental Release Category [EHSDS_CS_ENV_RELEASE_CAT]
    PCESENVRMTRELCATPHRS6UUID,   -- Environmental Release Category [EHSDS_CS_ENV_RELEASE_CAT]
    PCESPROCESSCATPHRS1UUID,     -- Process Category Phrase UUID [EHSDS_CS_PROCESS_CAT]
    PCESPROCESSCATPHRS2UUID,     -- Process Category Phrase UUID [EHSDS_CS_PROCESS_CAT]
    PCESPROCESSCATPHRS3UUID,     -- Process Category Phrase UUID [EHSDS_CS_PROCESS_CAT]
    PCESPROCESSCATPHRS4UUID,     -- Process Category Phrase UUID [EHSDS_CS_PROCESS_CAT]
    PCESPROCESSCATPHRS5UUID,     -- Process Category Phrase UUID [EHSDS_CS_PROCESS_CAT]
    PCESPROCESSCATPHRS6UUID,     -- Process Category Phrase UUID [EHSDS_CS_PROCESS_CAT]
    PCESPRODUCTCATPHRS1UUID,     -- Product Category Phrase UUID [EHSDS_CS_PRODUCT_CAT]
    PCESPRODUCTCATPHRS2UUID,     -- Product Category Phrase UUID [EHSDS_CS_PRODUCT_CAT]
    PCESPRODUCTCATPHRS3UUID,     -- Product Category Phrase UUID [EHSDS_CS_PRODUCT_CAT]
    PCESPRODUCTCATPHRS4UUID,     -- Product Category Phrase UUID [EHSDS_CS_PRODUCT_CAT]
    PCESPRODUCTCATPHRS5UUID,     -- Product Category Phrase UUID [EHSDS_CS_PRODUCT_CAT]
    PCESPRODUCTCATPHRS6UUID,     -- Product Category Phrase UUID [EHSDS_CS_PRODUCT_CAT]
    PCESPRODUCTSUBCATPHRS1UUID,  -- Product Subcategory Phrase UUID [EHSDS_CS_PRODUCT_SUBCAT]
    PCESPRODUCTSUBCATPHRS2UUID,  -- Product Subcategory Phrase UUID [EHSDS_CS_PRODUCT_SUBCAT]
    PCESPRODUCTSUBCATPHRS3UUID,  -- Product Subcategory Phrase UUID [EHSDS_CS_PRODUCT_SUBCAT]
    PCESARTICLECATPHRS1UUID,     -- Article Category [EHSDS_CS_ARTICLE_CAT]
    PCESARTICLECATPHRS2UUID,     -- Article Category [EHSDS_CS_ARTICLE_CAT]
    PCESARTICLECATPHRS3UUID,     -- Article Category [EHSDS_CS_ARTICLE_CAT]
    PCESARTICLECATPHRS4UUID,     -- Article Category [EHSDS_CS_ARTICLE_CAT]
    PCESARTICLECATPHRS5UUID,     -- Article Category [EHSDS_CS_ARTICLE_CAT]
    PCESARTICLECATPHRS6UUID,     -- Article Category [EHSDS_CS_ARTICLE_CAT]
    PCESARTICLESUBCATPHRS1UUID,  -- Article Subcategory [EHSDS_CS_ARTICLE_SUBCAT]
    PCESARTICLESUBCATPHRS2UUID,  -- Article Subcategory [EHSDS_CS_ARTICLE_SUBCAT]
    PCESARTICLESUBCATPHRS3UUID,  -- Article Subcategory [EHSDS_CS_ARTICLE_SUBCAT]
    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