I_EHSDtaCollLocResponsibleRole

DDL: I_EHSDTACOLLLOCRESPONSIBLEROLE Type: view_entity BASIC
3 Fields 1 Data Sources

Mapping between a Role and a Data Collection Privileges

I_EHSDtaCollLocResponsibleRole is a Basic CDS View that provides data about "Mapping between a Role and a Data Collection Privileges" in SAP S/4HANA. It reads from 1 data source (ehenvc_mdef_ro) and exposes 3 fields with key fields EHSLocationPersonRespRole, EHSLocRespRoleIsDataCollector, EHSLocRespRoleIsDataScheduler.

Data Sources (1)

SourceAliasJoin Type
ehenvc_mdef_ro ehenvc_mdef_ro from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Mapping between a Role and a Data Collection Privileges view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationPersonRespRole Water Hazard Cl.
KEY EHSLocRespRoleIsDataCollector is_collector Collector Role
KEY EHSLocRespRoleIsDataScheduler is_scheduler Manager Role

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EHSDtaCollLocResponsibleRole.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EHSDtaCollLocResponsibleRole AS
SELECT
  cast( code as ehfnd_loc_role_code_nc preserving type ) AS EHSLocationPersonRespRole,
  is_collector AS EHSLocRespRoleIsDataCollector,
  is_scheduler AS EHSLocRespRoleIsDataScheduler
FROM ehenvc_mdef_ro
;

Learn More