CUAN_MKT_MARKETING_PLAN_SEARCH

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 CUAN_MKT_MARKETING_PLAN_SEARCH.
-- 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: CUAN_MKTGPLAN

CREATE VIEW CUAN_MKT_MARKETING_PLAN_SEARCH AS
SELECT
  I_MKT_MarketingPlan.MarketingPlanUUID AS DB_KEY,
  I_MKT_MarketingPlan.MktgObjVersHdrUUID AS OBJECT_VERSION_HEADER_GUID,
  I_MKT_MarketingPlan.MarketingPlan AS ID,
  I_MKT_MarketingPlan.MarketingPlanName AS NAME,
  _MKT_ObjectVersionHeader.MktgObjVersHdrName AS MKTGOBJVERSHDRNAME,
  I_MKT_MarketingPlan.MarketingPlanStartDate AS VALID_FROM,
  I_MKT_MarketingPlan.MarketingPlanEndDate AS VALID_TO,
  I_MKT_MarketingPlan.MarketingPlanStatus AS STATUS,
  case when I_MKT_MarketingPlan._MKT_StatusForBusObj._Text[1: Language = $session.system_language ].ObjectStatusName is null or I_MKT_MarketingPlan._MKT_StatusForBusObj._Text[1: Language = $session.system_language ].ObjectStatusName = ' ' then case when I_MKT_MarketingPlan._MKT_StatusForBusObj._Text[1: Language = 'E' ].ObjectStatusName is null or I_MKT_MarketingPlan._MKT_StatusForBusObj._Text[1: Language = 'E' ].ObjectStatusName = ' ' then cast( I_MKT_MarketingPlan.MarketingPlanStatus as hpa_status_description ) else I_MKT_MarketingPlan._MKT_StatusForBusObj._Text[1: Language = 'E' ].ObjectStatusName end else I_MKT_MarketingPlan._MKT_StatusForBusObj._Text[1: Language = $session.system_language ].ObjectStatusName end as STATUS_DESC AS ObjectStatusNameendasSTATUS_DESC,
  cast(left( I_MKT_MarketingPlan.MarketingPlanStartDate, 4 ) as cuan_year preserving type) AS CALENDAR_YEAR,
  I_MKT_MarketingPlan._MKT_MarketingPlanBudgetPlan.MarketingBudgetPlanUUID AS BUDGET_PLAN_KEY,
  I_MKT_MarketingPlan.MarketingArea AS MKT_AREA,
  I_MKT_MarketingPlan._MarketingPlanMktgArea._Text[1: Language = $session.system_language ].MarketingAreaName AS MKT_AREA_DESC,
  I_MKT_MarketingPlan.MarketingPlanCreatedByUser AS CREATED_BY,
  I_MKT_MarketingPlan.MarketingPlanLastChangedByUser AS CHANGED_BY,
  I_MKT_MarketingPlan.MktgPlanCreationDateTime AS CREATED_ON,
  I_MKT_MarketingPlan.MktgPlanLastChangedDateTime AS CHANGED_ON
FROM I_MKT_MarketingPlan
;