I_MKT_CorpAcctMktgScoreCube

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_CorpAcctMktgScoreCube.
-- 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: IACCMKTSCRC
-- Parameters: P_StartDate : cuan_start_date, P_EndDate : cuan_end_date

CREATE VIEW I_MKT_CorpAcctMktgScoreCube AS
SELECT
  I_MKT_IntactnCntctScoreVal.MarketingScoreUUID AS MarketingScoreUUID,
  I_MKT_IntactnCntctScoreVal.MktgScoreVersion AS MktgScoreVersion,
  cast(I_MKT_IntactnCntctScoreVal.InteractionContact as cuan_cds_account preserving type) AS CorporateAccountUUID,
  I_MKT_IntactnCntctScoreVal.MarketingScoreValue AS SumMarketingScoreValue,
  cast (1 as abap.int8(19)) AS NumberOfScores,
  I_MKT_IntactnCntctScoreVal.MktgScoreValueCategory AS MktgScoreValueCategory,
  I_MKT_IntactnCntctScoreVal.MktgScoreVersionDate AS MktgScoreVersionDate,
  cast ( I_MKT_IntactnCntctScoreVal._MKT_CalendarDate.CalendarYear as cuan_year_cds ) AS CalendarYear,
  I_MKT_IntactnCntctScoreVal._MKT_CalendarDate.YearQuarter AS YearQuarter,
  I_MKT_IntactnCntctScoreVal._MKT_CalendarDate.YearMonth AS YearMonth,
  I_MKT_IntactnCntctScoreVal._MKT_CalendarDate.YearWeek AS YearWeek,
  I_MKT_IntactnCntctScoreVal.MktgScoreIsCurrentVersion AS MktgScoreIsCurrentVersion,
  I_MKT_IntactnCntctScoreVal.PredictiveScenario AS PredictiveScenario,
  I_MKT_IntactnCntctScoreVal.PredictiveModelUUID AS PredictiveModelUUID,
  I_MKT_IntactnCntctScoreVal._MKT_MarketingScoreModel.PredictiveModel AS PredictiveModel,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact.Country AS Country,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact.AddressRegion AS AddressRegion,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact._MKT_CountryMarket.Market AS Market,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact.Industry AS Industry,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact.ValidationStatus AS ValidationStatus,
  I_MKT_IntactnCntctScoreVal.InteractionContactOrigin AS InteractionContactOrigin,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact.CorpAcctIsRlvtForAcctBasedMktg AS CorpAcctIsRlvtForAcctBasedMktg,
  I_MKT_IntactnCntctScoreVal._MKT_CalendarDate AS _MKT_CalendarDate,
  I_MKT_IntactnCntctScoreVal._MKT_MarketingScore AS _MKT_MarketingScore,
  I_MKT_IntactnCntctScoreVal._MKT_MarketingScore.MarketingArea AS MarketingArea,
  I_MKT_IntactnCntctScoreVal._MKT_MarketingScore.PredictiveScenarioType AS PredictiveScenarioType,
  I_MKT_IntactnCntctScoreVal._MKT_MarketingScoreModel AS _MKT_MarketingScoreModel,
  I_MKT_IntactnCntctScoreVal._MKT_IntactnCntctMktgArea AS _MKT_IntactnCntctMktgArea,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact AS _Mkt_Contact,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact._MKT_Country AS _MKT_Country,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact._MKT_Region AS _MKT_Region,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact._MKT_Industry AS _MKT_Industry,
  I_MKT_IntactnCntctScoreVal._Mkt_Contact._MKT_ValidationStatus AS _MKT_ValidationStatus
FROM I_MKT_IntactnCntctScoreVal
LEFT OUTER JOIN I_MKT_CorpAcctMktgScoreModelVH AS _MKT_CorpAcctMktgScoreModelVH ON PredictiveModelUUID = _MKT_CorpAcctMktgScoreModelVH.PredictiveModelUUID AND predictivemodel = _MKT_CorpAcctMktgScoreModelVH.PredictiveModel  -- association [0..1]
LEFT OUTER JOIN I_MKT_CorpAcctMktgScoreValCat AS _MKT_CorpAcctMktgScoreValCat ON PredictiveScenario = _MKT_CorpAcctMktgScoreValCat.PredictiveScenario AND MktgScoreValueCategory = _MKT_CorpAcctMktgScoreValCat.MktgScoreValueCategory  -- association [1..1]
LEFT OUTER JOIN I_MKT_Company AS _MKT_Company ON CorporateAccountUUID = _MKT_Company.Company  -- association [0..1]
LEFT OUTER JOIN I_MKT_Market AS _MKT_Market ON market = _MKT_Market.Market  -- association [0..1]
LEFT OUTER JOIN I_MKT_CorpAccountMktgScoreVH AS _MKT_CorpAccountMktgScoreVH ON PredictiveScenario = _MKT_CorpAccountMktgScoreVH.PredictiveScenario  -- association [0..1]
LEFT OUTER JOIN E_MKT_CONTACT AS _ExtensionInteractionContact ON CorporateAccountUUID = _ExtensionInteractionContact.InteractionContact  -- association [1..1]
LEFT OUTER JOIN E_MKT_COMPANY AS _ExtensionCompany ON CorporateAccountUUID = _ExtensionCompany.Company  -- association [1..1]
;