C_WorkflowTemplate

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 C_WorkflowTemplate.
-- 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.

CREATE VIEW C_WorkflowTemplate AS
SELECT
  Template.WrkflwTmplUUID AS WrkflwTmplUUID,
  Template.WrkflwTmplId AS WrkflwTmplId,
  Template.WrkflwTmplName AS WrkflwTmplName,
  Template.WrkflwTmplNameSearchA AS WrkflwTmplNameSearchA,
  Template.WrkflwTmplNameSearchC AS WrkflwTmplNameSearchC,
  Template.WrkflwScen AS WrkflwScen,
  Template.WrkflwScenVers AS WrkflwScenVers,
  Template.SAPApplicationComponent AS SAPApplicationComponent,
  Template.WrkflwTmplType AS WrkflwTmplType,
  Template.WrkflwTmplStage AS WrkflwTmplStage,
  Template.WrkflwTmplCrtedLang AS WrkflwTmplCrtedLang,
  Template.WrkflwTmplCrtedUTCDteTme AS WrkflwTmplCrtedUTCDteTme,
  Template.WrkflwTmplCrtedUsr AS WrkflwTmplCrtedUsr,
  Template.WrkflwTmplLastChgdUTCDteTme AS WrkflwTmplLastChgdUTCDteTme,
  Template.WrkflwTmplLastChgdUsr AS WrkflwTmplLastChgdUsr,
  cast('' as xfeld preserving type ) AS ContentDevelopmentAllowed,
  Template._Language AS _Language,
  Template._CreatedBy AS _CreatedBy,
  Template._ChangedBy AS _ChangedBy,
  Template._Scenario AS _Scenario,
  Template._Type AS _Type,
  Template._Stage AS _Stage
FROM I_WorkflowTemplate AS Template
LEFT OUTER JOIN I_WorkflowTemplateValHelp AS _Template_VH ON WrkflwTmplId = _Template_VH.WrkflwTmplId  -- association [0..1]
;