I_WasteStreamLocationText

DDL: I_WASTESTREAMLOCATIONTEXT Type: view BASIC Package: EHEWA_RAP_WASTESTREAM

Waste Stream Location - Text

I_WasteStreamLocationText is a Basic CDS View that provides data about "Waste Stream Location - Text" in SAP S/4HANA. It reads from 1 data source (I_EHSLocationRevisionNameT) and exposes 4 fields with key fields EHSLocationUUID, Language. Part of development package EHEWA_RAP_WASTESTREAM.

Data Sources (1)

SourceAliasJoin Type
I_EHSLocationRevisionNameT I_EHSLocationRevisionNameT from

Annotations (13)

NameValueLevelField
EndUserText.label Waste Stream Location - Text view
AbapCatalog.sqlViewName IWSTSTRLOCTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey EHSLocationUUID view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID EHSLocationUUID
KEY Language Language
EHSLocationName EHSLocationName Location Name
_Language _Language
@EndUserText.label: 'Waste Stream Location - Text'


@AbapCatalog:
{
  sqlViewName: 'IWSTSTRLOCTEXT',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

@VDM.viewType: #BASIC

@ObjectModel:
{
  dataCategory: #TEXT,
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  },
  representativeKey: 'EHSLocationUUID'
}
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE


define view I_WasteStreamLocationText
       as select from  I_EHSLocationRevisionNameT 
       
 {
     key EHSLocationUUID,
  
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
     key Language,

      @EndUserText.label: 'Location Name'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      @Search.ranking: #HIGH      
      @Semantics.text: true
      EHSLocationName,
      
      _Language
      
}   where RevisionEndDate >= $session.system_date and
          RevisionStartDate <= $session.system_date