C_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 C_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: CMKTPREDSCEN

CREATE VIEW C_MKT_PredictiveScenario AS
SELECT
  PredictiveScenario.PredictiveScenario AS PredictiveScenario,
  PredictiveScenario.PredictiveScenarioVersion AS PredictiveScenarioVersion,
  PredictiveScenario._PredictiveScenarioText.PredictiveScenarioName AS PredictiveScenarioName,
  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._PredictiveScenStatusText.PredictiveScenarioStatusName AS PredictiveScenarioStatusName,
  PredictiveScenario.PrdtvScenDataSrceInterfaceVers AS PrdtvScenDataSrceInterfaceVers,
  PredictiveScenario.PrdtvDataSrceWrkgSetTableAlias AS PrdtvDataSrceWrkgSetTableAlias,
  PredictiveScenario.PredictiveScenarioIcon AS PredictiveScenarioIcon,
  PredictiveScenario._PredictiveScenSegmtnObject.SegmentationObject AS SegmentationObject,
  PredictiveScenario._PredictiveScenSegmtnObject._SegmentationObjectText.SegmentationObjectName AS SegmentationObjectName,
  PredictiveScenario.CreationDateTime AS CreationDateTime,
  PredictiveScenario.CreatedByUser AS CreatedByUser,
  cast(PredictiveScenario._CreatedByUser.FullName as cuan_created_by preserving type) AS CreatedByUserName,
  PredictiveScenario.LastChangeDateTime AS LastChangeDateTime,
  cast(PredictiveScenario._LastChangedByUser.FullName as cuan_changed_by preserving type) AS LastChangedByUserName
FROM I_MKT_PredictiveScenario AS PredictiveScenario
LEFT OUTER JOIN C_MKT_PrdtvScenImplmtn AS _PredictiveScenImplementation ON PredictiveScenario = _PredictiveScenImplementation.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenImplementation.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PrdtvScenAttribute AS _PredictiveScenAttribute ON PredictiveScenario = _PredictiveScenAttribute.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenAttribute.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PrdtvScenParameter AS _PredictiveScenParameter ON PredictiveScenario = _PredictiveScenParameter.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenParameter.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PrdtvScenClntAppl AS _PredictiveScenClntApplication ON PredictiveScenario = _PredictiveScenClntApplication.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenClntApplication.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PrdtvScenValRank AS _PredictiveScenValueRank ON PredictiveScenario = _PredictiveScenValueRank.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenValueRank.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PrdtvScenTargetAttrib AS _PredictiveScenTargetAttribute ON PredictiveScenario = _PredictiveScenTargetAttribute.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenTargetAttribute.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PredictiveScenName AS _PredictiveScenName ON PredictiveScenario = _PredictiveScenName.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenName.PredictiveScenarioVersion  -- association [0..*]
LEFT OUTER JOIN C_MKT_PrdtvScenSegmtnObject AS _PredictiveScenSegmtnObject ON PredictiveScenario = _PredictiveScenSegmtnObject.PredictiveScenario AND PredictiveScenarioVersion = _PredictiveScenSegmtnObject.PredictiveScenarioVersion  -- association [0..*]
;