CUAN_RECO_SCENARIOS_LIST

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 CUAN_RECO_SCENARIOS_LIST.
-- 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: CUAN_SCENARIOS

CREATE VIEW CUAN_RECO_SCENARIOS_LIST AS
SELECT
  scenario.db_key AS DB_KEY,
  scenario.scenario_id AS SCENARIO_ID,
  USER_TYPE,
  scenario.comm_medium AS COMM_MEDIUM,
  comm_t.comm_medium_desc AS COMM_MEDIUM_DESC,
  SOURCE_OBJECT_TYPE,
  SOURCE_SYSTEM_ID,
  SOURCE_SYSTEM_TYPE,
  PRECO_SYSTEM,
  engine_t.description AS PRECO_MODEL_TYPE_DESC,
  PRECO_MODEL_TYPE,
  case when model.sum_a > 0 then 'A' when model.sum_d > 0 then 'D' when model.sum_p > 0 then 'P' when model.sum_e > 0 then 'E' else '' end as PRECO_MODEL_STATUS AS sum_e0thenEelseendasPRECO_MODEL_STATUS,
  dsType.object_type_calculated AS OBJECT_TYPE_ID,
  dsType.result_type AS RESULT_TYPE,
  scenario_t.langu AS LANGUAGE,
  scenario_t.scenario_name AS SCENARIO_NAME,
  scenario_t.scenario_description AS SCENARIO_DESCRIPTION,
  scenario.ia_type AS IA_TYPE,
  iatype_t.ia_type_desc AS IA_TYPE_DESC,
  dsType.cacheable AS CACHEABLE,
  IS_USER_SECURE
FROM preco_a_scenario AS scenario
LEFT OUTER JOIN preco_d_engine_t AS engine_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuanc_ce_iatyp_t AS iatype_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuanc_ce_cmm_m_t AS comm_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN preco_a_scenar_t AS scenario_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CUAN_ENGINE_DATASOURCETYPE AS dsType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CUAN_MODEL_AGGRE_STATUS AS model ON /* join condition not captured in parsed metadata */
;