I_EHSRISKASSESSMENT

CDS View
11 Fields 7 CDS Views

EHS Risk Assessment

I_EHSRISKASSESSMENT is a CDS View in S/4HANA. EHS Risk Assessment. It contains 11 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_EHSRiskAssessment view from CONSUMPTION EHS Risk Assessment
C_EHSRiskAssessmentForTaskList view from CONSUMPTION EHS Risk Assessment for Task List
I_EHSRiskAssessmentStdVH view from COMPOSITE EHS Risk Assessment
I_EHSRskAssessmentAuthznFields view from BASIC EHS Risk Assessment Authorization Fields
I_SftyRlvtChgAffcdObjUser view left_outer COMPOSITE SRC: Relevant Affected Objects for Users
I_SftyRlvtChgAffcdObjUser_2 view inner COMPOSITE SRC: Relevant Affected Objects for Users
P_EHSRiskAssessmentCreatedByMe view from COMPOSITE Determine the Risk Assessments I have created

Fields (11)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser SafetyRelevantChgNotifProcgUsr 1
KEY EHSRiskAssessmentUUID EHSRiskAssessmentUUID 1
_EHSRiskAssessmentLead _EHSRiskAssessmentLead 1
_EHSRiskAssessmentStatus _EHSRiskAssessmentStatus 1
_EHSRiskAssessmentType _EHSRiskAssessmentType 1
EHSLocationUUID EHSLocationUUID 1
EHSRiskAssessmentID EHSRiskAssessmentID 1
EHSRiskAssessmentStatus EHSRiskAssessmentStatus 1
EHSRiskAssessmentTitle EHSRiskAssessmentTitle 1
EHSRiskAssessmentType EHSRiskAssessmentType 1
OperationalStatus OperationalStatus 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.

-- EHS Risk Assessment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSRISKASSESSMENT (
    CREATEDBYUSER,
    EHSRISKASSESSMENTUUID,
    _EHSRISKASSESSMENTLEAD,
    _EHSRISKASSESSMENTSTATUS,
    _EHSRISKASSESSMENTTYPE,
    EHSLOCATIONUUID,
    EHSRISKASSESSMENTID,
    EHSRISKASSESSMENTSTATUS,
    EHSRISKASSESSMENTTITLE,
    EHSRISKASSESSMENTTYPE,
    OPERATIONALSTATUS,
    PRIMARY KEY (CREATEDBYUSER, EHSRISKASSESSMENTUUID)
);

Learn More