I_EHSTaskInstanceTitleText

DDL: I_EHSTASKINSTANCETITLETEXT SQL: IEHSTITITLE Type: view COMPOSITE

EHS Task Instance Title Text

I_EHSTaskInstanceTitleText is a Composite CDS View that provides data about "EHS Task Instance Title Text" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowTaskTitle, swwwihead) and exposes 7 fields with key fields WorkflowTaskInternalID, Language, Language. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkflowTaskTitle I_WorkflowTaskTitle from
swwwihead swwwihead union

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTITITLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey WorkflowTaskInternalID view
EndUserText.label EHS Task Instance Title Text view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID
KEY Language Language
WorkflowTaskName WorkflowTaskName
Languagekeywi_idasWorkflowTaskInternalID
KEY Language wi_lang
WorkflowTaskName wi_text
_Language _Language 
@AbapCatalog.sqlViewName: 'IEHSTITITLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling: {
  algorithm: #SESSION_VARIABLE 
}
@ObjectModel.dataCategory: #TEXT
@ObjectModel: {
  representativeKey: 'WorkflowTaskInternalID'
}
@EndUserText.label: 'EHS Task Instance Title Text'

// used for BOBF Master Data Object

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

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #TRANSACTIONAL }
@VDM: {
  viewType: #COMPOSITE 
}      
                    
define view I_EHSTaskInstanceTitleText as select from I_WorkflowTaskTitle
 {
  key WorkflowTaskInternalID,
  @Semantics.language: true
  @ObjectModel.foreignKey.association: '_Language' 
  key Language,
  @Semantics.text: true
  WorkflowTaskName,
  _Language
  
} union select from swwwihead
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language //_Language.Language

{
  key wi_id as WorkflowTaskInternalID,
  @Semantics.language: true
  @ObjectModel.foreignKey.association: '_Language' 
  key wi_lang as Language,
  @Semantics.text: true
  wi_text as WorkflowTaskName, 
  _Language
}

Learn More