I_WorkflowTmplTxtTrnsltn

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_WorkflowTmplTxtTrnsltn.
-- 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: IWRKFLWTMPLTXTTR

CREATE VIEW I_WorkflowTmplTxtTrnsltn AS
SELECT
  thead.wrkflwtmpluuid AS WrkflwTmplUUID,
  case when text_target.text is not null then cast(left(text_target.text,80) as swf_flex_template_name) when text_original.text is not null then cast(left(text_original.text,80) as swf_flex_template_name) when text_target_old.wrkflwtmplname is not null then text_target_old.wrkflwtmplname else text_original_old.wrkflwtmplname end as WrkflwTmplName AS wrkflwtmplnameendasWrkflwTmplName,
  case when text_target.text is not null or text_original.text is not null then 'X' else ' ' end as Translatable AS textisnotnullthenXelseendasTranslatable,
  text_target.text AS a,
  text_original.text AS b,
  text_target_old.wrkflwtmplname AS c,
  text_original_old.wrkflwtmplname AS d
FROM swf_flex_thead AS thead
LEFT OUTER JOIN swf_flex_text_hd AS header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swf_flex_text_wf AS workflow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swf_flex_text AS text_target 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 */
LEFT OUTER JOIN swf_flex_ttext AS text_target_old ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swf_flex_ttext AS text_original_old ON /* join condition not captured in parsed metadata */
;