I_WorkflowStage

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_WorkflowStage.
-- 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: IVWRKFLWSTAGE

CREATE VIEW I_WorkflowStage AS
SELECT
  Stage.wrkflwscen AS WrkflwScen,
  Stage.wrkflwstage AS WrkflwStage,
  _Translation.WrkflwStageName AS WrkflwStageName,
  Stage.wrkflwstagecrtedlang AS WrkflwStageCrtedLang,
  Stage.wrkflwstagecrtedusr AS WrkflwStageCrtedUsr,
  Stage.wrkflwstagecrtedutcdtetme AS WrkflwStageCrtedUTCDteTme,
  Stage.wrkflwstagelastchgdusr AS WrkflwStageLastChgdUsr,
  Stage.wrkflwstagelastchgdutcdtetme AS WrkflwStageLastChgdUTCDteTme,
  Stage.wrkflwstagetransported AS WrkflwStageTransported,
  Stage.isdeleted AS IsDeleted
FROM swf_flex_scstage AS Stage
LEFT OUTER JOIN I_WorkflowScenario AS _Scenario ON WrkflwScen = _Scenario.Wfd_Id  -- association [1..1]
LEFT OUTER JOIN I_WorkflowStageText AS _Text ON WrkflwScen = _Text.WrkflwScen AND WrkflwStage = _Text.WrkflwStage  -- association [0..*]
LEFT OUTER JOIN I_WorkflowStageTextTrnsltn AS _Translation ON WrkflwScen = _Translation.WrkflwScen AND WrkflwStage = _Translation.WrkflwStage AND WrkflwStageCrtedLang = _Translation.Language  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON WrkflwStageCrtedLang = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_WorkflowUser AS _CreatedBy ON WrkflwStageCrtedUsr = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_WorkflowUser AS _ChangedBy ON WrkflwStageLastChgdUsr = _ChangedBy.UserID  -- association [0..1]
;