A_MKT_SpendHeader

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 A_MKT_SpendHeader.
-- 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: AMKT_SPENDHEADER

CREATE VIEW A_MKT_SpendHeader AS
SELECT
  spend_header.MarketingSpendHeaderUUID AS MarketingSpendHeaderUUID,
  spend_header.MarketingSpendStatus AS MarketingSpendStatus,
  cast(spend_header.Campaign as cuan_api_campaign_uuid preserving type ) AS CampaignUUID,
  spend_header.PlannedMktgSpendIsDetailed AS PlannedMktgSpendIsDetailed,
  spend_header.MarketingSpendPeriodStartYear AS MarketingSpendPeriodStartYear,
  spend_header.MarketingSpendPeriodStartMonth AS MarketingSpendPeriodStartMonth,
  cast(_MKT_CalendarMonthStart._Text[1: Language=$session.system_language].CalendarMonthName as cuan_calendarmonthname preserving type ) AS MktgSpendPeriodStartMonthName,
  spend_header.MarketingSpendPeriodEndYear AS MarketingSpendPeriodEndYear,
  spend_header.MarketingSpendPeriodEndMonth AS MarketingSpendPeriodEndMonth,
  cast(_MKT_CalendarMonthEnd._Text[1: Language=$session.system_language].CalendarMonthName as cuan_calendarmonthname preserving type ) AS MktgSpendPeriodEndMonthName,
  spend_header.PlannedMktgSpendHeaderAmt AS PlannedMktgSpendHeaderAmt,
  spend_header.PlannedMktgSpendHeaderCrcy AS PlannedMktgSpendHeaderCrcy,
  _MKT_Initiative.MarketingArea AS MarketingArea
FROM I_MKT_SpendHeader AS spend_header
LEFT OUTER JOIN A_MKT_SpendItem AS _MKT_SpendItem ON MarketingSpendHeaderUUID = _MKT_SpendItem.MarketingSpendHeaderUUID  -- association [0..*]
LEFT OUTER JOIN I_MKT_CalendarMonth AS _MKT_CalendarMonthStart ON MarketingSpendPeriodStartMonth = _MKT_CalendarMonthStart.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_MKT_CalendarMonth AS _MKT_CalendarMonthEnd ON MarketingSpendPeriodEndMonth = _MKT_CalendarMonthEnd.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN A_MKT_SpendHeaderTimeSplit AS _MKT_SpendHeaderTimeSplit ON MarketingSpendHeaderUUID = _MKT_SpendHeaderTimeSplit.MarketingSpendHeaderUUID  -- association [0..*]
LEFT OUTER JOIN I_Mkt_Initiative AS _MKT_Initiative ON CampaignUUID = _MKT_Initiative.Campaign  -- association [1..1]
;