C_EHSMyLocation

DDL: C_EHSMYLOCATION SQL: CMYLOCATION Type: view CONSUMPTION
12 Fields 1 Data Sources 1 Fiori Apps

My EHS Location

C_EHSMyLocation (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_EHSMyLocation is a Consumption CDS View that provides data about "My EHS Location" in SAP S/4HANA. It reads from 1 data source (I_MyEHSLocation) and exposes 12 fields with key field EHSLocationUUID. It is used in 1 Fiori application: Environment Management Overview.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-FND-EHS
CapabilitiesTransactional Provider
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MyEHSLocation MyEHSLocation from

Annotations (11)

NameValueLevelField
EndUserText.label My EHS Location view
OData.publish true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CMYLOCATION view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fiori Apps (1)

App IDApp NameTypeDescription
F7543 Environment Management Overview Analytical

Environment Management Overview

Business Role: Others

This feature introduces an environmental dashboard where you can view all data issues with exceedances, warnings, and missing data from the last six months, collected within the Environment Management component.

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID I_MyEHSLocation EHSLocationUUID Location
EHSLocationID EHSLocation EHSLocationID Location ID
EHSLocationName Location Revision Text
EHSLocationStatusText Location Status Description
EHSLocationTypeText Location Type Description
EHSLocationType EHSLocation EHSLocationType Location Type
EHSLocationStatus EHSLocation EHSLocationStatus Location Status
EHSLocationAuthorizationGroup Location Authorization Group
Plant EHSLocation Plant Valuation Area
CostCenter EHSLocation CostCenter Cost Center
CompanyCode EHSLocation CompanyCode Receiver Company Code
BusinessArea EHSLocation BusinessArea Business Area

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 C_EHSMyLocation.
-- 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.
-- SQL view name: CMYLOCATION

CREATE VIEW C_EHSMyLocation AS
SELECT
  MyEHSLocation.EHSLocationUUID AS EHSLocationUUID,
  EHSLocation.EHSLocationID AS EHSLocationID,
  MyEHSLocation._EHSLocationName[1:Language = $session.system_language].EHSLocationName AS EHSLocationName,
  EHSLocation._EHSLocationStatus._Text[1:Language = $session.system_language].EHSLocationStatusText AS EHSLocationStatusText,
  EHSLocation._EHSLocationType._Text[1:Language = $session.system_language].EHSLocationTypeText AS EHSLocationTypeText,
  EHSLocation.EHSLocationType AS EHSLocationType,
  EHSLocation.EHSLocationStatus AS EHSLocationStatus,
  cast( EHSLocation.EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  EHSLocation.Plant AS Plant,
  EHSLocation.CostCenter AS CostCenter,
  EHSLocation.CompanyCode AS CompanyCode,
  EHSLocation.BusinessArea AS BusinessArea
FROM I_MyEHSLocation AS MyEHSLocation
;

Learn More