P_Cfd_Selected_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_Selected_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_SEL_SCN_SP

CREATE VIEW P_Cfd_Selected_Scenario_Step AS
SELECT
  CurrentVersion.externalName AS ExternalFieldName,
  SelectedScenarioStep.scenario_name AS ScenarioName,
  SelectedScenarioStep.sequence_number AS SequenceNumber,
  SelectedScenarioStep.data_transfer_name AS Name,
  SelectedScenarioStep.name AS FieldName,
  CurrentVersion.version AS Version,
  AvailableScenarioStep.Availability AS Availability,
  AvailableScenarioStep.StepReleaseStatus AS ReleaseStatus,
  _ReleaseStatus._Text[1: Language=$session.system_language].Description AS ReleaseStatusDescription
FROM cfd_w_rep_scn_sp AS SelectedScenarioStep
INNER JOIN P_Cfd_Rep_Current_Version AS CurrentVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Cfd_Available_Scenario_Step AS AvailableScenarioStep ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cfd_w_rep_scn AS ScenarioRepository ON ScenarioRepository.name = FieldName AND ScenarioRepository.scenario_name = ScenarioName AND ScenarioRepository.version = CurrentVersion.version  -- association [1]
LEFT OUTER JOIN I_CFD_Release_Status AS _ReleaseStatus ON _ReleaseStatus.Code = ReleaseStatus  -- association [1]
;