I_WorkflowTaskTitleFallback

DDL: I_WORKFLOWTASKTITLEFALLBACK SQL: IWRKFLTSKTITLEFB Type: view

Work item title fallback

I_WorkflowTaskTitleFallback is a CDS View that provides data about "Work item title fallback" in SAP S/4HANA. It reads from 2 data sources (I_Language, swwwihead) and exposes 5 fields with key field WorkflowTaskInternalID.

Data Sources (2)

SourceAliasJoin Type
I_Language I_Language inner
swwwihead swwwihead from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLTSKTITLEFB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work item title fallback view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID swwwihead wi_id
WorkflowTaskName swwwihead wi_text
Language I_Language Language
LanguageName
LanguageISOCode I_Language LanguageISOCode
@AbapCatalog.sqlViewName: 'IWRKFLTSKTITLEFB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work item title fallback'
define view I_WorkflowTaskTitleFallback as select from swwwihead 
 inner join I_Language on swwwihead.wi_lang = I_Language.Language {
  key swwwihead.wi_id as WorkflowTaskInternalID,
  swwwihead.wi_text as WorkflowTaskName,
  I_Language.Language as Language,
  I_Language._Text[1:Language=$session.system_language].LanguageName as LanguageName,
  I_Language.LanguageISOCode as LanguageISOCode      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"I_LANGUAGETEXT",
"SWWWIHEAD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/