EHSDSW_CRR_CSENV

Transparent Table Application Table
31 Fields 1 CDS Views

I_CMPLRQRSLTPCESENVRMTASSMTTP I_CMPLRQRSLTPCESENVRMTASSMTTP

EHSDSW_CRR_CSENV is an SAP database table in S/4HANA. I_CMPLRQRSLTPCESENVRMTASSMTTP I_CMPLRQRSLTPCESENVRMTASSMTTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrbtScenEnvrmtDrft view from BASIC Contributing Scenaio Environment - Draft

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cmplrqrsltuuid ehfnd_crr_uuid Compliance Assessment UUID
activecmplrqrsltuuid ehfnd_crr_active_uuid Active Compliance Assessment UUID
cmplrqversuuid ehfnd_crv_uuid Compl Req UUID
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
pcesscenariouuid ehfnd_es_scenario_uuid Scenario UUID
pcesexposurescenariotype ehsds_es_expsr_scenario_type Scenario Type
pcesscenariotype ehsds_es_scenario_type Scenario Type
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
compliancerequirement ehfnd_req_identifier Compliance Requirement
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
cmplrqrsltprocessingstatus cmplrqrsltprocessingstatus Processing Status
cmplrqrsltprocessor ehfnd_crr_processing_user_bp Processor
releasedbyuser ehfnd_crr_released_by_user_bp Released By
validitystartdatetime ehfnd_valid_from_tstmp Valid From
validityenddatetime ehfnd_valid_to_tstmp Valid To
cmplrqrsltreldcmplncsts ehfnd_crr_relstat Released Compliance Status
cmplrqrsltcalculatedstatus ehfnd_crr_calc_stat Calculated Compliance Status
cmplrqrsltmanualstatus ehfnd_crr_man_stat_nd Manually Set Compliance Status
cmplrqrsltprelimcmplncsts ehfnd_crr_prelim_comp_stat Preliminary Compliance Status
cmplrqrsltstatusremark ehfnd_crr_stat_remark Remarks
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_CMPLRQRSLTPCESENVRMTASSMTTP I_CMPLRQRSLTPCESENVRMTASSMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSW_CRR_CSENV (
    MANDT,                       -- Client [mandt]
    CMPLRQRSLTUUID,              -- Compliance Assessment UUID [ehfnd_crr_uuid]
    ACTIVECMPLRQRSLTUUID,        -- Active Compliance Assessment UUID [ehfnd_crr_active_uuid]
    CMPLRQVERSUUID,              -- Compl Req UUID [ehfnd_crv_uuid]
    CHMLCMPLNCINFOUUID,          -- Chemical Compliance Information [ehfnd_cci_uuid]
    PCESSCENARIOUUID,            -- Scenario UUID [ehfnd_es_scenario_uuid]
    PCESEXPOSURESCENARIOTYPE,    -- Scenario Type [ehsds_es_expsr_scenario_type]
    PCESSCENARIOTYPE,            -- Scenario Type [ehsds_es_scenario_type]
    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]
    COMPLIANCEREQUIREMENT,       -- Compliance Requirement [ehfnd_req_identifier]
    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]
    CMPLRQRSLTPROCESSINGSTATUS,  -- Processing Status [cmplrqrsltprocessingstatus]
    CMPLRQRSLTPROCESSOR,         -- Processor [ehfnd_crr_processing_user_bp]
    RELEASEDBYUSER,              -- Released By [ehfnd_crr_released_by_user_bp]
    VALIDITYSTARTDATETIME,       -- Valid From [ehfnd_valid_from_tstmp]
    VALIDITYENDDATETIME,         -- Valid To [ehfnd_valid_to_tstmp]
    CMPLRQRSLTRELDCMPLNCSTS,     -- Released Compliance Status [ehfnd_crr_relstat]
    CMPLRQRSLTCALCULATEDSTATUS,  -- Calculated Compliance Status [ehfnd_crr_calc_stat]
    CMPLRQRSLTMANUALSTATUS,      -- Manually Set Compliance Status [ehfnd_crr_man_stat_nd]
    CMPLRQRSLTPRELIMCMPLNCSTS,   -- Preliminary Compliance Status [ehfnd_crr_prelim_comp_stat]
    CMPLRQRSLTSTATUSREMARK,      -- Remarks [ehfnd_crr_stat_remark]
    ACTIVEUUID,                  -- Key [/bobf/uuid]
    HASACTIVEENTITY,             -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CMPLRQRSLTUUID)
);

Learn More