I_WorkflowTaskCustomAttribText

DDL: I_WORKFLOWTASKCUSTOMATTRIBTEXT SQL: IWFTSKCUSTATTTXT Type: view BASIC

Workflow Task Custom Attribute Text

I_WorkflowTaskCustomAttribText is a Basic CDS View that provides data about "Workflow Task Custom Attribute Text" in SAP S/4HANA. It reads from 2 data sources (swddusratttxt, swd_usratttxt) and exposes 4 fields with key fields taskendasWorkflowTaskDefinition, nodeidendasWorkflowStepNode, languageendasLanguage. It has 1 association to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
swddusratttxt CustomAttributeText left_outer
swd_usratttxt CustomAttributeTextCust left_outer

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IWFTSKCUSTATTTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workflow Task Custom Attribute Text view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey WorkflowTaskCustomAttributeID view
ObjectModel.dataCategory #TEXT view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY taskendasWorkflowTaskDefinition
KEY nodeidendasWorkflowStepNode
KEY languageendasLanguage
_Language _Language 
@AbapCatalog.sqlViewName: 'IWFTSKCUSTATTTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Workflow Task Custom Attribute Text'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType : {
  dataClass: #META,
  serviceQuality: #C,
  sizeCategory: #L
}
@ObjectModel.representativeKey: 'WorkflowTaskCustomAttributeID'
@ObjectModel.dataCategory: #TEXT
define view I_WorkflowTaskCustomAttribText
  as select distinct from sww_usratt    as CustomAttribute
    left outer join       swd_usratttxt as CustomAttributeTextCust on  CustomAttributeTextCust.task           = CustomAttribute.def_task
                                                                   and CustomAttributeTextCust.nodeid         = CustomAttribute.def_nodeid
                                                                   and CustomAttributeTextCust.attribute_name = CustomAttribute.attribute_name
    left outer join       swddusratttxt as CustomAttributeText     on  CustomAttributeText.task           = CustomAttribute.def_task
                                                                   and CustomAttributeText.nodeid         = CustomAttribute.def_nodeid
                                                                   and CustomAttributeText.attribute_name = CustomAttribute.attribute_name
  association [1..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  key case
        when   CustomAttributeTextCust.task is not null
          then CustomAttributeTextCust.task
          else CustomAttributeText.task
      end as WorkflowTaskDefinition,
  key case
        when   CustomAttributeTextCust.nodeid is not null
          then CustomAttributeTextCust.nodeid
          else CustomAttributeText.nodeid
      end as WorkflowStepNode,
  key case
        when   CustomAttributeTextCust.attribute_name is not null
          then CustomAttributeTextCust.attribute_name
          else CustomAttributeText.attribute_name
      end as WorkflowTaskCustomAttributeID,
      @Semantics:   { language: true }
      @ObjectModel: { foreignKey.association: '_Language' }
  key case
        when CustomAttributeTextCust.language is not null
          then CustomAttributeTextCust.language
          else CustomAttributeText.language
      end as Language,
      case
        when CustomAttributeTextCust.description is not null
          then CustomAttributeTextCust.description
          else CustomAttributeText.description
      end as WorkflowTaskCustomAttribName,
      @Semantics:   { text: true }
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SWDDUSRATTTXT",
"SWD_USRATTTXT",
"SWW_USRATT"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More