I_EHSRISKCONTROL

CDS View

EHS Risk Control

I_EHSRISKCONTROL is a CDS View in S/4HANA. EHS Risk Control. It contains 12 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
A_EHSRiskControlForSafetyInfo view from COMPOSITE Risk Controls for Safety Relevant Information
C_AdhocEHSCtrlForIdentifyRisks view from CONSUMPTION Adhoc EHS Control For Identify Risks
C_EHSControlImplmtnForTaskList view from CONSUMPTION EHS Control Implementation for Task List
C_StdEHSCtrlForIdentifyRisks view from CONSUMPTION Standard EHS Control
I_EHSControlImpl view from COMPOSITE EHS Risk Control Implementation
I_EHSCtrlImplmtnAuthznFields view from BASIC EHS Control Implementation Authorization Fields
P_EHSControlImplResponsible view from CONSUMPTION Control Implementation Responsible
P_EHSControlsCount view from CONSUMPTION
P_EHSRiskAssessmentControls view inner COMPOSITE
P_ImplmtdRiskCtrlCountByType view from COMPOSITE
P_RiskControlCountByType view from COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY EHSControlInstanceUUID EHSControlInstanceUUID 2
KEY EHSRiskRevisionUUID EHSRiskRevisionUUID 4
_EHSControlAdhocSubtype _EHSControlAdhocSubtype 1
_EHSControlAdhocType _EHSControlAdhocType 1
_EHSControlRemarkText _EHSControlRemarkText 1
EHSControlAdhocSubtype EHSControlAdhocSubtype 1
EHSControlAdhocTitle EHSControlAdhocTitle 1
EHSControlAdhocType EHSControlAdhocType 1
EHSControlRemarkUUID EHSControlRemarkUUID 1
EHSControlUUID EHSControlUUID 2
EHSRiskUUID EHSRiskUUID 1
ResponsiblePerson ResponsiblePerson 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 Control
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSRISKCONTROL (
    EHSCONTROLINSTANCEUUID,
    EHSRISKREVISIONUUID,
    _EHSCONTROLADHOCSUBTYPE,
    _EHSCONTROLADHOCTYPE,
    _EHSCONTROLREMARKTEXT,
    EHSCONTROLADHOCSUBTYPE,
    EHSCONTROLADHOCTITLE,
    EHSCONTROLADHOCTYPE,
    EHSCONTROLREMARKUUID,
    EHSCONTROLUUID,
    EHSRISKUUID,
    RESPONSIBLEPERSON,
    PRIMARY KEY (EHSCONTROLINSTANCEUUID, EHSRISKREVISIONUUID)
);