I_EHSLocNameByIdentifierText

DDL: I_EHSLOCNAMEBYIDENTIFIERTEXT Type: view_entity BASIC

Location name by id - Text

I_EHSLocNameByIdentifierText is a Basic CDS View that provides data about "Location name by id - Text" in SAP S/4HANA. It reads from 1 data source (I_EHSLocationName) and exposes 10 fields with key fields Language, EHSLocationID, RevisionEndDate. It has 3 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_EHSLocationName I_EHSLocationName from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_EHSLocationRoot _EHSLocationRoot $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..*] I_EHSLocationRevision _EHSLocationRevision $projection.EHSLocationRevisionUUID = _EHSLocationRevision.EHSLocationRevisionUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Location name by id - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey EHSLocationID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Language Language
KEY EHSLocationID _EHSLocationRoot EHSLocationID
KEY RevisionEndDate _EHSLocationRevision RevisionEndDate
EHSLocationRevisionUUID EHSLocationRevisionUUID
RevisionStartDate _EHSLocationRevision RevisionStartDate
EHSLocationUUID
EHSLocationName
_EHSLocationRoot _EHSLocationRoot
_Language _Language
_EHSLocationRevision _EHSLocationRevision 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Location name by id - Text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities:[#LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE, #SEARCHABLE_ENTITY]
@ObjectModel:{
    dataCategory: #TEXT,
    representativeKey: 'EHSLocationID',
    usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER }
}

@VDM.viewType: #BASIC
define view entity I_EHSLocNameByIdentifierText
  as select from I_EHSLocationName
  association [1..1] to I_EHSLocationRoot     as _EHSLocationRoot     on $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
  association [0..1] to I_Language            as _Language            on $projection.Language = _Language.Language
  association [0..*] to I_EHSLocationRevision as _EHSLocationRevision on $projection.EHSLocationRevisionUUID = _EHSLocationRevision.EHSLocationRevisionUUID

{
             @ObjectModel.foreignKey.association: '_Language'
             @Semantics.language: true
  key        Language,
  key        _EHSLocationRoot.EHSLocationID,
             @Semantics.businessDate.to
  key        _EHSLocationRevision.RevisionEndDate,
             EHSLocationRevisionUUID,
             @Semantics.businessDate.from
             _EHSLocationRevision.RevisionStartDate,
             cast( EHSLocationUUID as ehfnd_location_uuid_ref preserving type ) as EHSLocationUUID,
             @Semantics.text:true
             cast ( EHSLocationName as ehfnd_loc_name preserving type )         as EHSLocationName,


             _EHSLocationRoot,
             _Language,
             _EHSLocationRevision
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSLOCATIONNAME",
"I_EHSLOCATIONREVISION",
"I_EHSLOCATIONROOT"
],
"ASSOCIATED":
[
"I_EHSLOCATIONREVISION",
"I_EHSLOCATIONROOT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More