I_MKT_ProgramSpendByMktgPlan

DDL: I_MKT_PROGRAMSPENDBYMKTGPLAN SQL: IMKT_PGMSPDMKTPL Type: view COMPOSITE Package: CUAN_CDS_MRM
31 Fields 2 Data Sources 2 Associations

Marketing Proposed Spend By Mktg Plan

I_MKT_ProgramSpendByMktgPlan is a Composite CDS View (Fact) that provides data about "Marketing Proposed Spend By Mktg Plan" in SAP S/4HANA. It reads from 2 data sources (I_MKT_MarketingPlan, I_MKT_ProgramSpend) and exposes 31 fields. It has 2 associations to related views. Part of development package CUAN_CDS_MRM.

Data Sources (2)

SourceAliasJoin Type
I_MKT_MarketingPlan I_MKT_MarketingPlan from
I_MKT_ProgramSpend I_MKT_ProgramSpend left_outer

Parameters (2)

NameTypeDefault
P_DisplayCurrency cuan_displaycurrency
P_ExchangeRateType kurst_curr

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Currency _MarketingProgramCurrency $projection.MarketingProgramCurrency = _MarketingProgramCurrency.Currency
[0..1] I_Currency _DisplayCurrency $projection.DisplayCurrency = _DisplayCurrency.Currency

Annotations (10)

NameValueLevelField
EndUserText.label Marketing Proposed Spend By Mktg Plan view
Analytics.dataCategory #FACT view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IMKT_PGMSPDMKTPL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
MarketingPlanUUID I_MKT_MarketingPlan MarketingPlanUUID
MktgObjVersHdrUUID I_MKT_MarketingPlan MktgObjVersHdrUUID
MarketingProgram I_MKT_ProgramSpend MarketingProgram
MarketingProgramPhaseUUID I_MKT_ProgramSpend MarketingProgramPhaseUUID
MarketingProgramMediaType I_MKT_ProgramSpend MarketingProgramMediaType
MarketingSpendCalendarQuarter
MarketingSpendCalendarMonth
MarketingBudgetPlanUUID
MktgBudgetPlanCalendarYear
Brand
MarketingAudience
Market
Country
Region
MarketingCustomDimension01
MarketingCustomDimension02
MarketingCustomDimension03
MarketingCustomDimension04
MarketingCustomDimension05
MarketingCustomDimension06
MarketingCustomDimension07
MarketingCustomDimension08
MarketingCustomDimension09
MarketingCustomDimension10
MarketingPlanningModel
MarketingProgramCurrency I_MKT_ProgramSpend MarketingProgramCurrency
ProposedMktgSpendAmt I_MKT_ProgramSpend ProposedMktgSpendAmt
DisplayCurrency
ProposedMktgSpendAmtInDC I_MKT_ProgramSpend ProposedMktgSpendAmtInDC
_MarketingProgramCurrency _MarketingProgramCurrency
_DisplayCurrency _DisplayCurrency

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_ProgramSpendByMktgPlan.
-- 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_PGMSPDMKTPL
-- Parameters: P_DisplayCurrency : cuan_displaycurrency, P_ExchangeRateType : kurst_curr

CREATE VIEW I_MKT_ProgramSpendByMktgPlan AS
SELECT
  I_MKT_MarketingPlan.MarketingPlanUUID AS MarketingPlanUUID,
  I_MKT_MarketingPlan.MktgObjVersHdrUUID AS MktgObjVersHdrUUID,
  I_MKT_ProgramSpend.MarketingProgram AS MarketingProgram,
  I_MKT_ProgramSpend.MarketingProgramPhaseUUID AS MarketingProgramPhaseUUID,
  I_MKT_ProgramSpend.MarketingProgramMediaType AS MarketingProgramMediaType,
  cast(coalesce(I_MKT_ProgramSpend.CalendarQuarter, '0') as cuan_calendarquarter preserving type) AS MarketingSpendCalendarQuarter,
  cast(coalesce(I_MKT_ProgramSpend.CalendarMonth, '00') as cuan_calendarmonth preserving type) AS MarketingSpendCalendarMonth,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingBudgetPlanUUID AS MarketingBudgetPlanUUID,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.CalendarYear AS MktgBudgetPlanCalendarYear,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.Brand AS Brand,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingAudience AS MarketingAudience,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.Market AS Market,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.Country AS Country,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.Region AS Region,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension01 AS MarketingCustomDimension01,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension02 AS MarketingCustomDimension02,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension03 AS MarketingCustomDimension03,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension04 AS MarketingCustomDimension04,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension05 AS MarketingCustomDimension05,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension06 AS MarketingCustomDimension06,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension07 AS MarketingCustomDimension07,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension08 AS MarketingCustomDimension08,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension09 AS MarketingCustomDimension09,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingCustomDimension10 AS MarketingCustomDimension10,
  I_MKT_ProgramSpend._MKT_BudgetSource._MKT_PlanCoordinate.MarketingPlanningModel AS MarketingPlanningModel,
  I_MKT_ProgramSpend.MarketingProgramCurrency AS MarketingProgramCurrency,
  I_MKT_ProgramSpend.ProposedMktgSpendAmt AS ProposedMktgSpendAmt,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  I_MKT_ProgramSpend.ProposedMktgSpendAmtInDC AS ProposedMktgSpendAmtInDC
FROM I_MKT_MarketingPlan
LEFT OUTER JOIN I_MKT_ProgramSpend ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _MarketingProgramCurrency ON MarketingProgramCurrency = _MarketingProgramCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
;

Learn More