P_Cfd_Available_Scenario_Step

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 P_Cfd_Available_Scenario_Step.
-- 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: P_CFD_AVL_SCN_SP

CREATE VIEW P_Cfd_Available_Scenario_Step AS
SELECT
  AvailableScenarioStep.scenario_name AS ScenarioName,
  AvailableScenarioStep.sequence_number AS SequenceNumber,
  AvailableScenarioStep.data_transfer_name AS Name,
  AvailableScenario.availability AS Availability,
  AvailableScenario.release_status AS ReleaseStatus,
  DataTransfer.source_business_context AS SourceBusinessContext,
  DataTransfer.target_business_context AS TargetBusinessContext,
  _ReleaseStatus._Text[1: Language=$session.system_language].Description AS ReleaseStatusDescription,
  case when _SourceBusinessContext.release_status = #CFD_RELEASE_STATUS.'DEPRC' or _TargetBusinessContext.release_status = #CFD_RELEASE_STATUS.'DEPRC' then 'DEPRC' else AvailableScenarioStep.release_status end as StepReleaseStatus AS release_statusendasStepReleaseStatus
FROM cfd_w_scen_step AS AvailableScenarioStep
INNER JOIN cfd_w_scen AS AvailableScenario ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cfd_w_trans AS DataTransfer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cfd_w_bus_ctxt AS _SourceBusinessContext ON _SourceBusinessContext.business_context = DataTransfer.source_business_context  -- association [1]
LEFT OUTER JOIN cfd_w_bus_ctxt AS _TargetBusinessContext ON _TargetBusinessContext.business_context = DataTransfer.target_business_context  -- association [1]
LEFT OUTER JOIN I_CFD_Release_Status AS _ReleaseStatus ON _ReleaseStatus.Code = ReleaseStatus  -- association [1]
;