I_MKT_MarketingScoreModel

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_MarketingScoreModel.
-- 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: IMKTSCOREMDL

CREATE VIEW I_MKT_MarketingScoreModel AS
SELECT
  cast(cuand_pm_root.db_key as cuan_pm_predictive_model preserving type) AS PredictiveModelUUID,
  cast(cuand_pm_root.model_id as cuan_model_ruleset_id preserving type) AS PredictiveModel,
  cast(cuand_pm_root.model_name as cuan_model_ruleset_name preserving type) AS MarketingScoreModelName,
  cast(cuand_pm_root.predictive_kpi as cuan_pm_score preserving type) AS PredictiveScenario,
  cuand_pm_root.lchg_date_time AS LastChangeDateTime
FROM cuand_pm_root
LEFT OUTER JOIN I_MKT_MarketingScore AS _MKT_MarketingScore ON PredictiveScenario = _MKT_MarketingScore.PredictiveScenario  -- association [0..1]
LEFT OUTER JOIN I_MKT_IntactnCntctScoreVal AS _MKT_IntactnCntctScoreVal ON PredictiveModelUUID = _MKT_IntactnCntctScoreVal.PredictiveModelUUID  -- association [0..*]
LEFT OUTER JOIN I_MKT_MktgScorePersistence AS _MKT_MktgScorePersistence ON PredictiveModelUUID = _MKT_MktgScorePersistence.PredictiveModelUUID  -- association [0..1]
;