I_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 I_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.
-- SQL view name: IWFLWTEMPLATE

CREATE VIEW I_WorkflowTemplate AS
SELECT
  Template.wrkflwtmpluuid AS WrkflwTmplUUID,
  Template.wrkflwtmplid AS WrkflwTmplId,
  _Translation.WrkflwTmplName AS WrkflwTmplName,
  upper(_Translation.WrkflwTmplName) AS WrkflwTmplNameSearch,
  _Translation.a AS WrkflwTmplNameSearchA,
  _Translation.c AS WrkflwTmplNameSearchC,
  Template.wrkflwscen AS WrkflwScen,
  _Scenario.SAPApplicationComponent AS SAPApplicationComponent,
  Template.wrkflwscenvers AS WrkflwScenVers,
  Template.wrkflwtmpltype AS WrkflwTmplType,
  Template.wrkflwtmplstage AS WrkflwTmplStage,
  Template.wrkflwtmplgenericprpty1 AS WrkflwTmplGenericPrpty1,
  Template.wrkflwtmplgenericprpty2 AS WrkflwTmplGenericPrpty2,
  Template.wrkflwtmplgenericprpty3 AS WrkflwTmplGenericPrpty3,
  Template.wrkflwtmplgenericprpty4 AS WrkflwTmplGenericPrpty4,
  Template.wrkflwtmplgenericprpty5 AS WrkflwTmplGenericPrpty5,
  Template.wrkflwtmplgenericprpty6 AS WrkflwTmplGenericPrpty6,
  Template.wrkflwtmplgenericprpty7 AS WrkflwTmplGenericPrpty7,
  Template.wrkflwtmplgenericprpty8 AS WrkflwTmplGenericPrpty8,
  Template.wrkflwtmplgenericprpty9 AS WrkflwTmplGenericPrpty9,
  Template.wrkflwtmplgenericprpty10 AS WrkflwTmplGenericPrpty10,
  Template.wrkflwtmplcrtedlang AS WrkflwTmplCrtedLang,
  Template.wrkflwtmplcrtedusr AS WrkflwTmplCrtedUsr,
  Template.wrkflwtmplcrtedutcdtetme AS WrkflwTmplCrtedUTCDteTme,
  Template.wrkflwtmpllastchgdusr AS WrkflwTmplLastChgdUsr,
  Template.wrkflwtmpllastchgdutcdtetme AS WrkflwTmplLastChgdUTCDteTme,
  Template.wrkflwtmpltransported AS WrkflwTmplTransported,
  Template.isdeleted AS IsDeleted
FROM swf_flex_thead AS Template
LEFT OUTER JOIN I_WorkflowTemplateText AS _Text ON WrkflwTmplUUID = _Text.WrkflwTmplUUID  -- association [0..*]
LEFT OUTER JOIN I_Language AS _Language ON WrkflwTmplCrtedLang = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_WorkflowTmplTxtTrnsltn AS _Translation ON WrkflwTmplUUID = _Translation.WrkflwTmplUUID  -- association [0..1]
LEFT OUTER JOIN I_WFTMPL_SCENARIOVALHELP AS _Scenario ON WrkflwScen = _Scenario.WrkflwScen  -- association [0..1]
LEFT OUTER JOIN I_WorkflowTemplateType AS _Type ON WrkflwTmplType = _Type.WrkflwTmplType  -- association [0..1]
LEFT OUTER JOIN I_WorkflowStageValHelp AS _Stage ON WrkflwScen = _Stage.WrkflwScen AND WrkflwTmplStage = _Stage.WrkflwStage  -- association [0..1]
LEFT OUTER JOIN I_WorkflowUser AS _CreatedBy ON WrkflwTmplCrtedUsr = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_WorkflowUser AS _ChangedBy ON WrkflwTmplLastChgdUsr = _ChangedBy.UserID  -- association [0..1]
;