I_EHSTextCollectionText

DDL: I_EHSTEXTCOLLECTIONTEXT SQL: IEHSTXCTEXT Type: view BASIC Package: EHFND_BOPF_COMN

EHS Text Collection Text

I_EHSTextCollectionText is a Basic CDS View that provides data about "EHS Text Collection Text" in SAP S/4HANA. It reads from 1 data source (/bobf/d_txccon) and exposes 4 fields with key fields TextCollectionUUID, Language. Part of development package EHFND_BOPF_COMN.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
/bobf/d_txccon TxcContent from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTXCTEXT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label EHS Text Collection Text view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TextCollectionUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TextCollectionUUID TxcText parent_key
KEY Language TxcText language_code
_Language _Language
TextCollectionText /bobf/d_txccon text 
@AbapCatalog.sqlViewName: 'IEHSTXCTEXT'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'EHS Text Collection Text'
@VDM.viewType: #BASIC

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'TextCollectionUUID'

// used for BOBF Master Data Object

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

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #TRANSACTIONAL }
                         
// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE                         

@AccessControl.authorizationCheck:#NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_EHSTextCollectionText as select from /bobf/d_txccon as TxcContent 
        join /bobf/d_txctxt as TxcText on TxcContent.parent_key = TxcText.db_key        
   association[0..1] to I_Language as _Language on $projection.Language = _Language.Language 
   {
      key TxcText.parent_key as TextCollectionUUID,
      
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
      key TxcText.language_code as Language,
      _Language,
      @Semantics.text:true
      @UI.multiLineText
      TxcContent.text as TextCollectionText
} where TxcText.text_type = '101'

Learn More