I_MKT_AggrdCmpgnSpndSuccCube

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_AggrdCmpgnSpndSuccCube.
-- 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: IMKT_SPNDSUCCC
-- Parameters: P_DisplayCurrency : cuan_displaycurrency, P_ExchangeRateType : kurst_curr, P_StartDate : cuan_start_date

CREATE VIEW I_MKT_AggrdCmpgnSpndSuccCube AS
SELECT
  I_Mkt_Initiative.Campaign AS Campaign,
  I_Mkt_Initiative.MarketingProgram AS MarketingProgram,
  I_Mkt_Initiative._MKT_Program.MarketingProgramID AS MarketingProgramID,
  I_Mkt_Initiative._MKT_Program.MarketingProgramName AS MarketingProgramName,
  I_Mkt_Initiative._MKT_Program.MarketingPlanUUID AS MarketingPlanUUID,
  I_Mkt_Initiative._MKT_Program._MKT_MarketingPlan.MarketingPlan AS MarketingPlan,
  I_Mkt_Initiative._MKT_Program._MKT_MarketingPlan.MarketingPlanName AS MarketingPlanName,
  I_Mkt_Initiative.MarketingProgramPhaseUUID AS MarketingProgramPhaseUUID,
  cast(_ProgramPhase.MarketingProgramPhaseName as cuan_programphasename preserving type) AS MarketingProgramPhaseName,
  _ProgramPhase.MarketingProgramPhaseStartDate AS MarketingProgramPhaseStartDate,
  _ProgramPhase.MarketingProgramPhaseEndDate AS MarketingProgramPhaseEndDate,
  I_Mkt_Initiative._MKT_Program.MarketingArea AS MarketingProgramMarketingArea,
  I_Mkt_Initiative.CampaignID AS CampaignID,
  I_Mkt_Initiative.CampaignName AS CampaignName,
  I_Mkt_Initiative._MKT_CampaignAgency.MarketingAgency AS MarketingAgency,
  I_Mkt_Initiative._MKT_CampaignAgency.MarketingAgencyName AS MarketingAgencyName,
  I_Mkt_Initiative.MediaType AS MediaType,
  I_Mkt_Initiative.MarketingArea AS CampaignMktgArea,
  I_Mkt_Initiative.CampaignPriority AS CampaignPriority,
  I_Mkt_Initiative.CampaignCategory AS CampaignCategory,
  I_Mkt_Initiative.CampaignProcessType AS CampaignProcessType,
  I_Mkt_Initiative.CampaignLifecycleStatus AS CampaignLifecycleStatus,
  I_Mkt_Initiative.CampaignOwner AS CampaignOwner,
  I_Mkt_Initiative.CampaignStartDate AS CampaignStartDate,
  I_Mkt_Initiative.CampaignEndDate AS CampaignEndDate,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.CalendarYear AS CalendarYear,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.Brand AS Brand,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingAudience AS MarketingAudience,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.Market AS Market,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.Country AS Country,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.Region AS Region,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension01 AS MarketingCustomDimension01,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension02 AS MarketingCustomDimension02,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension03 AS MarketingCustomDimension03,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension04 AS MarketingCustomDimension04,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension05 AS MarketingCustomDimension05,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension06 AS MarketingCustomDimension06,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension07 AS MarketingCustomDimension07,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension08 AS MarketingCustomDimension08,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension09 AS MarketingCustomDimension09,
  _MKT_CampaignPlanCoordinate._MKT_PlanCoordinate.MarketingCustomDimension10 AS MarketingCustomDimension10,
  cube.ActualMktgSpendAmtInDC AS ActualMktgSpendAmtInDC,
  cube.MktgCommitmentAmtInDC AS MktgCommitmentAmtInDC,
  cube.ApprovedPlndMktgSpendAmtInDC AS ApprovedPlndMktgSpendAmtInDC,
  cube.PlannedMktgSpendAmtInDC AS PlannedMktgSpendAmtInDC,
  cube.LatestEstimateMktgSpendAmtInDC AS LatestEstimateMktgSpendAmtInDC,
  cube.AdServingSpendAmountInDC AS AdServingSpendAmountInDC,
  cube.SuggestedAdServingSpendAmtInDC AS SuggestedAdServingSpendAmtInDC,
  cube.OrderAmountInDC AS OrderAmountInDC,
  cube.MultiTouchAttributedOrdAmtInDC AS MultiTouchAttributedOrdAmtInDC,
  cube.ProjectedOrderAmountInDC AS ProjectedOrderAmountInDC,
  cube.OpportunityAmountInDC AS OpportunityAmountInDC,
  cast($parameters.P_DisplayCurrency as cuan_displaycurrency preserving type) AS DisplayCurrency,
  cube.AssgdCmpgnSuccessDataUUID AS AssgdCmpgnSuccessDataUUID,
  cube.CampaignReach AS CampaignReach,
  cube.NumberOfImpressions AS NumberOfImpressions,
  cube.NumberOfUniqueClicks AS NumberOfUniqueClicks,
  cube.NumberOfClicks AS NumberOfClicks,
  cube.NumberOfPageLikes AS NumberOfPageLikes,
  cube.NumberOfPostEngagements AS NumberOfPostEngagements,
  cube.NumberOfVideoViews AS NumberOfVideoViews,
  cube.NumberOfWebsiteConversions AS NumberOfWebsiteConversions,
  cube.NumberOfAppInstalls AS NumberOfAppInstalls,
  cube.NumberOfAppEngagements AS NumberOfAppEngagements,
  cube.NumberOfEventResponses AS NumberOfEventResponses,
  cube.NumberOfDeliveredMessages AS NumberOfDeliveredMessages,
  cube.NumberOfDownloads AS NumberOfDownloads,
  cube.NumberOfHardBounces AS NumberOfHardBounces,
  cube.NumberOfSoftBounces AS NumberOfSoftBounces,
  cube.NumberOfMktgOfferClaims AS NumberOfMktgOfferClaims,
  cube.NumberOfOpenedMessages AS NumberOfOpenedMessages,
  cube.NumberOfOrders AS NumberOfOrders,
  cube.NumberOfSentMessages AS NumberOfSentMessages,
  cube.NumberOfRegistrations AS NumberOfRegistrations,
  cube.VideoViewedAverageInPercent AS VideoViewedAverageInPercent,
  cube.ElmntOfWgtdAvgOfVidViews AS ElmntOfWgtdAvgOfVidViews,
  cube.NumberOfRejectedMessages AS NumberOfRejectedMessages,
  cube.GrossRatingPointBase AS GrossRatingPointBase,
  cube.GrossRatingPoints AS GrossRatingPoints,
  cube.NumberOfLeads AS NumberOfLeads,
  cube.NumberOfConvertedLeads AS NumberOfConvertedLeads,
  cube.NumberOfOpportunities AS NumberOfOpportunities,
  cube.NumberOfPhoneCalls AS NumberOfPhoneCalls,
  cube.NumberOfAppointments AS NumberOfAppointments,
  cube.NumberOfFailedInteractions AS NumberOfFailedInteractions,
  cube.NumberOfMarketingOfferViews AS NumberOfMarketingOfferViews,
  cube.NumberOfEmailComplaints AS NumberOfEmailComplaints,
  cube.NmbrOfOpenChannelInteractions AS NmbrOfOpenChannelInteractions,
  cube.NumberOfExecutedInteractions AS NumberOfExecutedInteractions,
  cube.NumberOfTasks AS NumberOfTasks,
  cube.NrOfMultiTchAttrCnvrsns AS NrOfMultiTchAttrCnvrsns,
  cube.ProjectedNumberOfConversions AS ProjectedNumberOfConversions,
  I_Mkt_Initiative._MKT_Program AS _MKT_Program,
  I_Mkt_Initiative._MKT_Program._MKT_MarketingPlan AS _MKT_MarketingPlan
FROM I_Mkt_Initiative
LEFT OUTER JOIN P_MKT_AggrdCmpgnSpndSuccCube ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Mkt_Initiative AS _Mkt_Initiative ON Campaign = _Mkt_Initiative.Campaign  -- association [1..1]
LEFT OUTER JOIN E_MKT_INITIATIVE AS _CampaignExtension ON Campaign = _CampaignExtension.Campaign  -- association [1..1]
LEFT OUTER JOIN E_MKT_AssgdCmpgnSuccessData AS _SuccessExtension ON AssgdCmpgnSuccessDataUUID = _SuccessExtension.AssgdCmpgnSuccessDataUUID  -- association [1..1]
LEFT OUTER JOIN E_MKT_PROGRAM AS _ProgramExtension ON MarketingProgram = _ProgramExtension.MarketingProgram  -- association [1..1]
LEFT OUTER JOIN I_MKT_MediaType AS _MKT_MediaType ON MediaType = _MKT_MediaType.MediaType  -- association [0..1]
LEFT OUTER JOIN I_MKT_MarketingArea AS _CampaignMktgArea ON CampaignMktgArea = _CampaignMktgArea.MarketingArea  -- association [0..1]
LEFT OUTER JOIN I_MKT_MarketingArea AS _ProgramMktgArea ON MarketingProgramMarketingArea = _ProgramMktgArea.MarketingArea  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProgramPhase AS _ProgramPhase ON MarketingProgramPhaseUUID = _ProgramPhase.MarketingProgramPhaseUUID  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignCategory AS _CampaignCategory ON CampaignCategory = _CampaignCategory.CampaignCategory  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignPriority AS _CampaignPriority ON CampaignPriority = _CampaignPriority.CampaignPriority  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignProcessType AS _CampaignProcessType ON CampaignProcessType = _CampaignProcessType.CampaignProcessType  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignLifeCycleStatus AS _CampaignLifeCycleStatus ON CampaignLifecycleStatus = _CampaignLifeCycleStatus.CampaignLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_MKT_User AS _CampaignOwner ON CampaignOwner = _CampaignOwner.UserID  -- association [0..1]
LEFT OUTER JOIN I_MKT_Brand AS _MKT_Brand ON Brand = _MKT_Brand.Brand  -- association [0..1]
LEFT OUTER JOIN I_MKT_Audience AS _MKT_Audience ON MarketingAudience = _MKT_Audience.MarketingAudience  -- 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_Country AS _MKT_Country ON Country = _MKT_Country.Country  -- association [0..1]
LEFT OUTER JOIN I_MKT_Region AS _MKT_Region ON Country = _MKT_Region.Country AND Region = _MKT_Region.Region  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension01 AS _MKT_CustomDimension01 ON MarketingCustomDimension01 = _MKT_CustomDimension01.MarketingCustomDimension01  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension02 AS _MKT_CustomDimension02 ON MarketingCustomDimension02 = _MKT_CustomDimension02.MarketingCustomDimension02  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension03 AS _MKT_CustomDimension03 ON MarketingCustomDimension03 = _MKT_CustomDimension03.MarketingCustomDimension03  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension04 AS _MKT_CustomDimension04 ON MarketingCustomDimension04 = _MKT_CustomDimension04.MarketingCustomDimension04  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension05 AS _MKT_CustomDimension05 ON MarketingCustomDimension05 = _MKT_CustomDimension05.MarketingCustomDimension05  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension06 AS _MKT_CustomDimension06 ON MarketingCustomDimension06 = _MKT_CustomDimension06.MarketingCustomDimension06  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension07 AS _MKT_CustomDimension07 ON MarketingCustomDimension07 = _MKT_CustomDimension07.MarketingCustomDimension07  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension08 AS _MKT_CustomDimension08 ON MarketingCustomDimension08 = _MKT_CustomDimension08.MarketingCustomDimension08  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension09 AS _MKT_CustomDimension09 ON MarketingCustomDimension09 = _MKT_CustomDimension09.MarketingCustomDimension09  -- association [0..1]
LEFT OUTER JOIN I_MKT_CustomDimension10 AS _MKT_CustomDimension10 ON MarketingCustomDimension10 = _MKT_CustomDimension10.MarketingCustomDimension10  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
;