EHHSSD_RAS2_ROOT

Transparent Table Application Table
23 Fields 1 CDS Views

Risk Assessment V2 Root

EHHSSD_RAS2_ROOT is an SAP database table in S/4HANA. Risk Assessment V2 Root. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSRskAssmt2 view_entity from BASIC Risk Assessment V2 Root

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ehsriskassessmentuuid sysuuid_x UUID
ehsriskassessment2id ehhss_ras2_id
ehsriskassessment2status ehhss_ras2_status
ehsriskassessmenttitle ehhss_ras2_title
ehsriskassessmentrevision ehhss_ras_revision Revision
ehsriskassessmenttype ehhss_ras_type_code_nc Assessment Type
ehsriskassessmentdescription ehhss_ras_desc Description
ehsriskassessmentnote ehhss_ras_note
ehsrskassmtapprovedatetime ehhss_ras_approve_datetime
ehsrskassmtapprovedbyuser ehhss_ras_approved_by_user
ehsriskassessmentauthzngrp ehhss_ras_auth_group_nc
numberofehsrisksinprocess ehhss_ras_no_risks_in_proc
numberofehsrisksreleased ehhss_ras_no_risks_released
plant ehfnd_plant_id Plant ID
businessarea ehfnd_business_area_id Business Area
ehsrskassmtsethistdatetime ehhss_ras_historic_datetime
ehsrskassmtsethistbyuser ehhss_ras_historic_by_user
ehsriskassessmenthasjob ehhss_ras_has_job
ehsriskassessmentisblocked ehhss_ras_is_blocked
ehsriskmatrix ehhss_ras2_risk_matrix
ehsriskassessmentreminderdate ehhss_ras_reminder_date
ehsriskassessmentreasonnote ehhss_ras_reason

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.

-- Risk Assessment V2 Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_RAS2_ROOT (
    MANDT,                          -- Client [mandt]
    EHSRISKASSESSMENTUUID,          -- UUID [sysuuid_x]
    EHSRISKASSESSMENT2ID,           -- ehhss_ras2_id
    EHSRISKASSESSMENT2STATUS,       -- ehhss_ras2_status
    EHSRISKASSESSMENTTITLE,         -- ehhss_ras2_title
    EHSRISKASSESSMENTREVISION,      -- Revision [ehhss_ras_revision]
    EHSRISKASSESSMENTTYPE,          -- Assessment Type [ehhss_ras_type_code_nc]
    EHSRISKASSESSMENTDESCRIPTION,   -- Description [ehhss_ras_desc]
    EHSRISKASSESSMENTNOTE,          -- ehhss_ras_note
    EHSRSKASSMTAPPROVEDATETIME,     -- ehhss_ras_approve_datetime
    EHSRSKASSMTAPPROVEDBYUSER,      -- ehhss_ras_approved_by_user
    EHSRISKASSESSMENTAUTHZNGRP,     -- ehhss_ras_auth_group_nc
    NUMBEROFEHSRISKSINPROCESS,      -- ehhss_ras_no_risks_in_proc
    NUMBEROFEHSRISKSRELEASED,       -- ehhss_ras_no_risks_released
    PLANT,                          -- Plant ID [ehfnd_plant_id]
    BUSINESSAREA,                   -- Business Area [ehfnd_business_area_id]
    EHSRSKASSMTSETHISTDATETIME,     -- ehhss_ras_historic_datetime
    EHSRSKASSMTSETHISTBYUSER,       -- ehhss_ras_historic_by_user
    EHSRISKASSESSMENTHASJOB,        -- ehhss_ras_has_job
    EHSRISKASSESSMENTISBLOCKED,     -- ehhss_ras_is_blocked
    EHSRISKMATRIX,                  -- ehhss_ras2_risk_matrix
    EHSRISKASSESSMENTREMINDERDATE,  -- ehhss_ras_reminder_date
    EHSRISKASSESSMENTREASONNOTE,    -- ehhss_ras_reason
    PRIMARY KEY (MANDT, EHSRISKASSESSMENTUUID)
);

Learn More