I_EHSRISKCONTROL

CDS View
12 Fields 11 CDS Views

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 Private view for the count of the EHS Controls
P_EHSRiskAssessmentControls view inner COMPOSITE Controls at Risk Assessment
P_ImplmtdRiskCtrlCountByType view from COMPOSITE Number of implemented controls per type for a risk revision
P_RiskControlCountByType view from COMPOSITE Number of controls per risk revision and control type

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)
);

Learn More