A_MKT_SpendHeaderTimeSplit

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_SpendHeaderTimeSplit.
-- 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_SPENDHDRTS

CREATE VIEW A_MKT_SpendHeaderTimeSplit AS
SELECT
  spend_header_timesplit.MarketingSpendHdrTimeSplitUUID AS MarketingSpendHdrTimeSplitUUID,
  spend_header_timesplit.MarketingSpendHeaderUUID AS MarketingSpendHeaderUUID,
  spend_header_timesplit.MarketingSpendCalendarYear AS MarketingSpendCalendarYear,
  spend_header_timesplit.MarketingSpendCalendarQuarter AS MarketingSpendCalendarQuarter,
  spend_header_timesplit.MarketingSpendCalendarMonth AS MarketingSpendCalendarMonth,
  cast(_MKT_CalendarMontht._Text[1: Language=$session.system_language].CalendarMonthName as cuan_calendarmonthname preserving type ) AS MktgSpendCalendarMonthName,
  spend_header_timesplit.PlannedMktgSpendHeaderAmt AS PlannedMktgSpendHeaderAmt,
  spend_header_timesplit.PlannedMktgSpendHeaderCrcy AS PlannedMktgSpendHeaderCrcy
FROM I_MKT_SpendHeaderTimeSplit AS spend_header_timesplit
LEFT OUTER JOIN I_MKT_CalendarMonth AS _MKT_CalendarMontht ON MarketingSpendCalendarMonth = _MKT_CalendarMontht.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN A_MKT_SpendHeader AS _MKT_SpendHeader ON MarketingSpendHeaderUUID = _MKT_SpendHeader.MarketingSpendHeaderUUID  -- association [1..1]
;