EHHSSD_EXPAS_REV

Transparent Table Application Table
23 Fields 1 CDS Views

Exposure Assessment Revision - #GENERATED#

EHHSSD_EXPAS_REV is an SAP database table in S/4HANA. Exposure Assessment Revision - #GENERATED#. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Ehhss_Exposure_Assessment view inner Results of exposure assessments

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
datetime_cr /BOBF/DATETIME_CR Created On/At
user_id_cr /BOBF/USER_ID_CR Created By
datetime_ch /BOBF/DATETIME_CH Changed On/At
user_id_ch /BOBF/USER_ID_CH Changed By
revision_descr EHFND_REVISION_DESCRIPTION Revision
split_date EHFND_REVISION_SPLIT_DATE Rev. Start Date
split_time EHFND_REVISION_SPLIT_TIME Split Time
end_date EHFND_REVISION_END_DATE Rev. End Date
rating_code EHHSS_RAS_RATING Exposure Rating Code
confidence_level_code EHHSS_EXPAS_CONFID_LEVEL_CODE Conf. Level
source_doc_ref /BOBF/CONF_KEY NodeID
phys_expr_const EHHSS_HSP_PHYS_EXPR_CONST Phys Exp Rating Cons
status EHHSS_EXPAS_STATUS Status
reglist_key /BOBF/CONF_KEY NodeID
shift_pattern EHFND_SHIFT_PATTERN Shift Pattern
value_meas EHFND_OEL_VALUE_MEAS Limit
value_unit EHFND_UNIT_CODE Unit of Measurement
stadj_value EHHSS_EXPAS_STADJ_VALUE Stat. Value
stadj_value_unit EHHSS_EXPAS_STADJ_VALUE_UNIT Unit
eew_expas_rev_d DUMMY Dummy function in length 1

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.

-- Exposure Assessment Revision - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_EXPAS_REV (
    MANDT,                  -- Client [MANDT]
    DB_KEY,                 -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,             -- NodeID [/BOBF/CONF_KEY]
    DATETIME_CR,            -- Created On/At [/BOBF/DATETIME_CR]
    USER_ID_CR,             -- Created By [/BOBF/USER_ID_CR]
    DATETIME_CH,            -- Changed On/At [/BOBF/DATETIME_CH]
    USER_ID_CH,             -- Changed By [/BOBF/USER_ID_CH]
    REVISION_DESCR,         -- Revision [EHFND_REVISION_DESCRIPTION]
    SPLIT_DATE,             -- Rev. Start Date [EHFND_REVISION_SPLIT_DATE]
    SPLIT_TIME,             -- Split Time [EHFND_REVISION_SPLIT_TIME]
    END_DATE,               -- Rev. End Date [EHFND_REVISION_END_DATE]
    RATING_CODE,            -- Exposure Rating Code [EHHSS_RAS_RATING]
    CONFIDENCE_LEVEL_CODE,  -- Conf. Level [EHHSS_EXPAS_CONFID_LEVEL_CODE]
    SOURCE_DOC_REF,         -- NodeID [/BOBF/CONF_KEY]
    PHYS_EXPR_CONST,        -- Phys Exp Rating Cons [EHHSS_HSP_PHYS_EXPR_CONST]
    STATUS,                 -- Status [EHHSS_EXPAS_STATUS]
    REGLIST_KEY,            -- NodeID [/BOBF/CONF_KEY]
    SHIFT_PATTERN,          -- Shift Pattern [EHFND_SHIFT_PATTERN]
    VALUE_MEAS,             -- Limit [EHFND_OEL_VALUE_MEAS]
    VALUE_UNIT,             -- Unit of Measurement [EHFND_UNIT_CODE]
    STADJ_VALUE,            -- Stat. Value [EHHSS_EXPAS_STADJ_VALUE]
    STADJ_VALUE_UNIT,       -- Unit [EHHSS_EXPAS_STADJ_VALUE_UNIT]
    EEW_EXPAS_REV_D,        -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More