I_WorkflowTaskCustomAttribText

DDL: I_WORKFLOWTASKCUSTOMATTRIBTEXT SQL: IWFTSKCUSTATTTXT Type: view BASIC
4 Fields 2 Data Sources 1 Associations

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.

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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkflowTaskCustomAttribText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IWFTSKCUSTATTTXT

CREATE VIEW I_WorkflowTaskCustomAttribText AS
SELECT
  case when CustomAttributeTextCust.task is not null then CustomAttributeTextCust.task else CustomAttributeText.task end as WorkflowTaskDefinition AS taskendasWorkflowTaskDefinition,
  case when CustomAttributeTextCust.nodeid is not null then CustomAttributeTextCust.nodeid else CustomAttributeText.nodeid end as WorkflowStepNode AS nodeidendasWorkflowStepNode,
  case when CustomAttributeTextCust.language is not null then CustomAttributeTextCust.language else CustomAttributeText.language end as Language AS languageendasLanguage
LEFT OUTER JOIN swd_usratttxt AS CustomAttributeTextCust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swddusratttxt AS CustomAttributeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [1..1]
;

Learn More