SWF_FLEX_TEXT_ORIGINAL

DDL: SWF_FLEX_TEXT_ORIGINAL SQL: SWFFLEXTEXTORIG Type: view

Retrieve texts

SWF_FLEX_TEXT_ORIGINAL is a CDS View that provides data about "Retrieve texts" in SAP S/4HANA. It reads from 4 data sources (swf_flex_text_hd, swf_flex_text, swf_flex_text, swf_flex_text_wf) and exposes 3 fields.

Data Sources (4)

SourceAliasJoin Type
swf_flex_text_hd header from
swf_flex_text text_copied left_outer
swf_flex_text text_original left_outer
swf_flex_text_wf workflow inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SWFFLEXTEXTORIG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Retrieve texts view

Fields (3)

KeyFieldSource TableSource FieldDescription
TextId swf_flex_text_hd id WorklistID
Text
languendasLanguage

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 SWF_FLEX_TEXT_ORIGINAL.
-- 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: SWFFLEXTEXTORIG

CREATE VIEW SWF_FLEX_TEXT_ORIGINAL AS
SELECT
  header.id AS TextId,
  coalesce( text_copied.text, text_original.text ) AS Text,
  case when text_copied.text is null then workflow.original_langu else text_copied.langu end as Language AS languendasLanguage
FROM swf_flex_text_hd AS header
INNER JOIN swf_flex_text_wf AS workflow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swf_flex_text AS text_copied ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swf_flex_text AS text_original ON /* join condition not captured in parsed metadata */
;