I_EHSLocationRevisionBasic

DDL: I_EHSLOCATIONREVISIONBASIC Type: view_entity BASIC
31 Fields 1 Data Sources

Location Revision

I_EHSLocationRevisionBasic (Basic)

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

Cross Applications

I_EHSLocationRevisionBasic is a Basic CDS View that provides data about "Location Revision" in SAP S/4HANA. It reads from 1 data source (ehfndd_loc_rev) and exposes 31 fields with key field EHSLocationRevisionUUID.

SAP Help Documentation

CategoryCDS Views for Location Data
StatusLocation status
Purpose
This CDS view allows customer extensions to access location revision data. It can be used in key user extensions as an association target or for selection of location data. This CDS view provides the data to answer the following business questions: How can I use location revisions in my key user extensions? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations One of the following business template roles needs to be assigned to a user to be able to use this CDS view: SAP_BR_ADMINISTRATOR

Structure
Fields used for filtering The main filters are as follows: EHSLocationUUID RevisionStartDate RevisionEndDate EHSLocationType EHSLocationStatus CostCenter OrganizationalUnit Further important fields Important fields in this view include the following: Field Name Description EHSLocationRevisionUUID Location revision key EHSLocationUUID Location key CreationDateTime Created on CreatedByUser Created by LastChangeDateTime Last changed on LastChangedByUser Last changed by RevisionDescription Revision description RevisionStartDate Revision start date RevisionEndDate Revision end date EHSLocationType Location type EHSLocationStatus Location status EHSFunctionalLocation Functional location Equipment Equipment Plant Plant CompanyCode Company code BusinessArea Business area CostCenter Cost center ControllingArea Controlling area OrganizationalUnit Organizational unit EHSLocationAuthorizationGroup Location authorization group CityName City PostalCode Postal code StreetName Street Country Country/region Region Region EHSLocationPhone Phone number Longitude Longitude Latitude Latitude LongitudeUnit Longitude unit LatitudeUnit Latitude unit StorageLocation Storage location

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-FND-EHS
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
ehfndd_loc_rev ehfndd_loc_rev from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Location Revision view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationRevisionUUID db_key EHS Location - Revision UUID
EHSLocationUUID Location
CreationDateTime crea_date_time Time Stamp
CreatedByUser crea_uname Created By
LastChangeDateTime lchg_date_time Last Changed On
LastChangedByUser lchg_uname Last Change By
RevisionDescription revision_descr Revision Description
RevisionStartDate split_date Revision Start Date
RevisionEndDate end_date Revision End Date
EHSLocationType Worklist Type
EHSLocationStatus Workflow Status
EHSFunctionalLocation Functional Location ID
Equipment equipment_id Equipment ID
Plant plant_id Plant ID
CompanyCode company_code Company Code
BusinessArea buss_area Business Area
CostCenter cost_center Posted Cost Center
ControllingArea controlling_area Controlling Area
OrganizationalUnit Organizational Unit ID
EHSLocationAuthorizationGroup Location Authorization Group
CityName city1 City
PostalCode post_code1 City Postal Code
StreetName street Street Address
Country country Venue: Ctry/Reg
Region region Venue Region
EHSLocationPhone phone Telephone Number
Longitude Geographic Longitude
Latitude Geographic Latitude
LongitudeUnit Longitude Unit
LatitudeUnit Latitude Unit
StorageLocation storage_loc Storage Location

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_EHSLocationRevisionBasic.
-- 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_EHSLocationRevisionBasic AS
SELECT
  db_key AS EHSLocationRevisionUUID,
  cast( parent_key as ehfnd_location_uuid_ref preserving type ) AS EHSLocationUUID,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS LastChangeDateTime,
  lchg_uname AS LastChangedByUser,
  revision_descr AS RevisionDescription,
  split_date AS RevisionStartDate,
  end_date AS RevisionEndDate,
  cast( type as ehfnd_loc_type_code_nc preserving type ) AS EHSLocationType,
  cast( status as ehfnd_loc_status_nc preserving type ) AS EHSLocationStatus,
  cast( funct_loc_id as ehfnd_funct_loc_id_nc preserving type ) AS EHSFunctionalLocation,
  equipment_id AS Equipment,
  plant_id AS Plant,
  company_code AS CompanyCode,
  buss_area AS BusinessArea,
  cost_center AS CostCenter,
  controlling_area AS ControllingArea,
  cast( org_unit as ehfnd_org_unit_id_nc preserving type ) AS OrganizationalUnit,
  cast( auth_group as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  city1 AS CityName,
  post_code1 AS PostalCode,
  street AS StreetName,
  Country,
  Region,
  phone AS EHSLocationPhone,
  cast( longitute as ehfnd_geoloc_longitude_nc preserving type ) AS Longitude,
  cast( latitude as ehfnd_geoloc_latitude_nc preserving type ) AS Latitude,
  cast( 'DEG' as ehfnd_geo_unit_code ) AS LongitudeUnit,
  cast( 'DEG' as ehfnd_geo_unit_code ) AS LatitudeUnit,
  storage_loc AS StorageLocation
FROM ehfndd_loc_rev
;

Learn More