_EHSRISKROOT

30 Fields

_EHSRISKROOT is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
KEY EHSJobUUID EHSJobUUID 8
KEY EHSLocationUUID EHSLocationUUID 5
_BusinessArea _BusinessArea 1
_EHSJob _EHSJob 2
_EHSLocationRoot _EHSLocationRoot 1
_EHSMethodOfUse _EHSMethodOfUse 2
_EHSOperationalStatus _EHSOperationalStatus 3
_EHSRiskAssessmentType _EHSRiskAssessmentType 1
_EHSRiskLevel _EHSRiskLevel 4
_Hazard _Hazard 5
_HazardCategory _HazardCategory 4
_Plant _Plant 1
AirborneAgentUUID AirborneAgentUUID 1
BusinessArea BusinessArea 3
ChemicalUUID ChemicalUUID 2
CompanyCode CompanyCode 3
ControllingArea ControllingArea 1
CostCenter CostCenter 3
EHSAgentUUID EHSAgentUUID 2
EHSJobStep EHSJobStep 3
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 3
EHSRiskAssessmentType EHSRiskAssessmentType 3
EHSRiskID EHSRiskID 2
EHSRiskLevel EHSRiskLevel 6
Hazard Hazard 5
HazardCategory HazardCategory 4
MethodOfUse MethodOfUse 2
OperationalStatus OperationalStatus 5
PhysicalAgentUUID PhysicalAgentUUID 1
Plant Plant 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _EHSRISKROOT (
    EHSJOBUUID,
    EHSLOCATIONUUID,
    _BUSINESSAREA,
    _EHSJOB,
    _EHSLOCATIONROOT,
    _EHSMETHODOFUSE,
    _EHSOPERATIONALSTATUS,
    _EHSRISKASSESSMENTTYPE,
    _EHSRISKLEVEL,
    _HAZARD,
    _HAZARDCATEGORY,
    _PLANT,
    AIRBORNEAGENTUUID,
    BUSINESSAREA,
    CHEMICALUUID,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    EHSAGENTUUID,
    EHSJOBSTEP,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSRISKASSESSMENTTYPE,
    EHSRISKID,
    EHSRISKLEVEL,
    HAZARD,
    HAZARDCATEGORY,
    METHODOFUSE,
    OPERATIONALSTATUS,
    PHYSICALAGENTUUID,
    PLANT,
    PRIMARY KEY (EHSJOBUUID, EHSLOCATIONUUID)
);

Learn More