I_EHSLocNameCurrentRevision

DDL: I_EHSLOCNAMECURRENTREVISION Type: view_entity BASIC

Location name along with its current revision

I_EHSLocNameCurrentRevision is a Basic CDS View that provides data about "Location name along with its current revision" in SAP S/4HANA. It reads from 1 data source (ehfndd_loc_text) and exposes 11 fields with key fields EHSLocationRevisionNameUUID, Language, EHSLocationUUID. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_loc_text ehfndd_loc_text from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EHSLocationRevisionBasic _EHSLocationRevisionBasic $projection.EHSLocationRevisionUUID = _EHSLocationRevisionBasic.EHSLocationRevisionUUID and $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Location name along with its current revision view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationRevisionNameUUID db_key
KEY Language language
KEY EHSLocationUUID root_key
EHSLocationRevisionUUID parent_key
CreationDateTime crea_date_time
CreatedByUser crea_uname
LastChangeDateTime lchg_date_time
LastChangedByUser lchg_uname
EHSLocationName text
_EHSLocationRevisionBasic _EHSLocationRevisionBasic
_Language _Language 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Location name along with its current revision'
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MASTER
}

@VDM.viewType: #BASIC

define view entity I_EHSLocNameCurrentRevision
  as select from ehfndd_loc_text
  association [1..1] to I_EHSLocationRevisionBasic as _EHSLocationRevisionBasic on  $projection.EHSLocationRevisionUUID = _EHSLocationRevisionBasic.EHSLocationRevisionUUID
                                                                                and $projection.EHSLocationUUID         = _EHSLocationRevisionBasic.EHSLocationUUID
  association [1..1] to I_Language                 as _Language                 on  $projection.Language = _Language.Language
{

         @ObjectModel.filter.enabled: false
         @ObjectModel.sort.enabled: false
  key    db_key         as EHSLocationRevisionNameUUID,
         @ObjectModel.foreignKey.association: '_Language'
         @Semantics.language: true
  key    language       as Language,
  key    root_key       as EHSLocationUUID,
         parent_key     as EHSLocationRevisionUUID,
         @Consumption.hidden: true
         crea_date_time as CreationDateTime,
         @Consumption.hidden: true
         crea_uname     as CreatedByUser,
         @Consumption.hidden: true
         lchg_date_time as LastChangeDateTime,
         @Consumption.hidden: true
         lchg_uname     as LastChangedByUser,

         @Semantics.text: true
         text           as EHSLocationName,

         _EHSLocationRevisionBasic,
         _Language
}
where
      _EHSLocationRevisionBasic.RevisionStartDate <= $session.system_date
  and _EHSLocationRevisionBasic.RevisionEndDate   >= $session.system_date

Learn More