I_CurrentEHSLocationNameText

DDL: I_CURRENTEHSLOCATIONNAMETEXT SQL: ICURLOCNAMET Type: view BASIC

Current EHS Location Name Text

I_CurrentEHSLocationNameText is a Basic CDS View that provides data about "Current EHS Location Name Text" in SAP S/4HANA. It reads from 1 data source (I_EHSLocationRevisionNameT) and exposes 5 fields with key fields EHSLocationUUID, Language.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_EHSLocationRevisionNameT I_EHSLocationRevisionNameT from

Annotations (12)

NameValueLevelField
EndUserText.label Current EHS Location Name Text view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey EHSLocationUUID view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICURLOCNAMET view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID EHSLocationUUID
_EHSLocationRoot _EHSLocationRoot
KEY Language Language
_Language _Language
EHSLocationName EHSLocationName 
@EndUserText.label: 'Current EHS Location Name Text'
@Analytics.dataExtraction.enabled:true
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'EHSLocationUUID'
@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'ICURLOCNAMET'
@AbapCatalog.compiler.compareFilter: true

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER }
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view I_CurrentEHSLocationNameText
  as select from I_EHSLocationRevisionNameT
 {
 

      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_EHSLocationValueHelp', element: 'EHSLocationUUID' }}]
      @ObjectModel.text.element: ['EHSLocationName']
    
  key EHSLocationUUID,
      _EHSLocationRoot,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key Language,
      _Language,
      @Semantics.text: true
      EHSLocationName
} where RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date     
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSLOCATIONREVISIONNAMET"
],
"ASSOCIATED":
[
"I_EHSLOCATIONROOT",
"I_LANGUAGE"
],
"BASE":
[
"I_EHSLOCATIONREVISIONNAMET"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More