I_MKT_PredictiveScenario

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_MKT_PredictiveScenario.
-- 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: IMKTPREDSCEN

CREATE VIEW I_MKT_PredictiveScenario AS
SELECT
  $session.client AS mandt,
  PredictiveScenario.predictivescenario AS PredictiveScenario,
  PredictiveScenario.predictivescenarioversion AS PredictiveScenarioVersion,
  PredictiveScenario.predictivescenariotype AS PredictiveScenarioType,
  PredictiveScenario.persistencealias AS PersistenceAlias,
  PredictiveScenario.predictivescenarioview AS PredictiveScenarioView,
  PredictiveScenario.predictivescenarioscorecolumn AS PredictiveScenarioScoreColumn,
  PredictiveScenario.predictivedatasourceview AS PredictiveDataSourceView,
  PredictiveScenario.prdtvdatasourceviewpackage AS PrdtvDataSourceViewPackage,
  PredictiveScenario.prdtvdatasourceviewid AS PrdtvDataSourceViewID,
  PredictiveScenario.predictivedatasourcekeycolumn AS PredictiveDataSourceKeyColumn,
  PredictiveScenario.predictivescenariostatus AS PredictiveScenarioStatus,
  PredictiveScenario.prdtvscendatasrceinterfacevers AS PrdtvScenDataSrceInterfaceVers,
  PredictiveScenario.prdtvdatasrcewrkgsettablealias AS PrdtvDataSrceWrkgSetTableAlias,
  PredictiveScenario.predictivescenarioicon AS PredictiveScenarioIcon,
  PredictiveScenario.creationdatetime AS CreationDateTime,
  PredictiveScenario.createdbyuser AS CreatedByUser,
  PredictiveScenario.lastchangedatetime AS LastChangeDateTime,
  PredictiveScenario.lastchangedbyuser AS LastChangedByUser
FROM cuanw_ps AS PredictiveScenario
LEFT OUTER JOIN I_MKT_PrdtvScenImplmtn AS _PredictiveScenImplementation ON PredictiveScenario = _PredictiveScenImplementation.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenImplementation.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PrdtvScenAttribute AS _PredictiveScenAttribute ON PredictiveScenario = _PredictiveScenAttribute.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenAttribute.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PrdtvScenParameter AS _PredictiveScenParameter ON PredictiveScenario = _PredictiveScenParameter.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenParameter.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PrdtvScenClntAppl AS _PredictiveScenClntApplication ON PredictiveScenario = _PredictiveScenClntApplication.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenClntApplication.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PrdtvScenTargetAttrib AS _PredictiveScenTargetAttribute ON PredictiveScenario = _PredictiveScenTargetAttribute.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenTargetAttribute.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PredictiveScenName AS _PredictiveScenName ON PredictiveScenario = _PredictiveScenName.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenName.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PrdtvScenSegmtnObject AS _PredictiveScenSegmtnObject ON PredictiveScenario = _PredictiveScenSegmtnObject.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenSegmtnObject.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PrdtvScenValRank AS _PredictiveScenValueRank ON PredictiveScenario = _PredictiveScenValueRank.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenValueRank.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN I_MKT_PredictiveScenarioText AS _PredictiveScenarioText ON PredictiveScenario = _PredictiveScenarioText.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenarioText.PredictiveScenarioVersion AND _PredictiveScenarioText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MKT_PrdtvScenStatusText AS _PredictiveScenStatusText ON PredictiveScenarioStatus = _PredictiveScenStatusText.PredictiveScenarioStatus AND _PredictiveScenStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MKT_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MKT_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;