I_EHSLOCATIONRESPONSIBLE

CDS View
5 Fields 5 CDS Views

EHS Location Root

I_EHSLOCATIONRESPONSIBLE is a CDS View in S/4HANA. EHS Location Root. It contains 5 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_EHSLocationRoleAssignment view from COMPOSITE EHS Location Role Assignments
I_EHSLocEnvrnmtlDtaResponsible view_entity from COMPOSITE Location Environmental Data Responsible
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_LOCTECHNICIANSCOUNT view left_outer COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY EHSLocRespTechnicianUUID EHSLocationResponsibleUUID,EHSLocRespTechnicianUUID 2
EHSLocationPersonRespRole EHSLocationPersonRespRole 1
EHSLocationRevisionUUID EHSLocationRevisionUUID 1
EHSLocationUUID EHSLocationUUID 2
EHSLocRespTechnicianID EHSLocResponsiblePersonID 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 Location Root
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSLOCATIONRESPONSIBLE (
    EHSLOCRESPTECHNICIANUUID,
    EHSLOCATIONPERSONRESPROLE,
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONUUID,
    EHSLOCRESPTECHNICIANID,
    PRIMARY KEY (EHSLOCRESPTECHNICIANUUID)
);

Learn More