A_MKT_Campaign

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_Campaign.
-- 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: AMKTCAMP

CREATE VIEW A_MKT_Campaign AS
SELECT
  Campaign AS CampaignUUID,
  CampaignID,
  CampaignName,
  CampaignDescription,
  CampaignCategory,
  MarketingArea,
  _MKT_MarketingAreaText.MarketingAreaName AS MarketingAreaName,
  MarketingProgram AS MarketingProgramUUID,
  _MKT_PROGRAMTEXT.MarketingProgramName AS MarketingProgramName,
  CommunicationCategoryUUID,
  _CommunicationCategory.CommunicationCategoryName AS CommunicationCategoryName,
  _CAMP_CAT_Text.CampaignCategoryName AS CampaignCategoryName,
  CampaignCreatedByUser AS CreatedByUser,
  case when _camp_crea_usr.FullName is null then CampaignCreatedByUser else _camp_crea_usr.FullName end as CreatedByUserName AS FullNameendasCreatedByUserName,
  CampaignLastChgdByUser AS LastChangeByUser,
  case when _camp_lc_usr.FullName is null then CampaignLastChgdByUser else _camp_lc_usr.FullName end as LastChangeByUserName AS FullNameendasLastChangeByUserName,
  CampaignCreationDateTime AS CreationDateTime,
  CampaignLastChgdDateTime AS LastChangeDateTime,
  CampaignScheduleDateTime,
  CampaignExecutionFrqcyInterval,
  CampaignExecutionFrqcyUnitName AS CampaignExecutionFrequencyUnit,
  CampaignProcessType,
  CampaignOwner,
  case when _camp_owner.FullName is null then CampaignOwner else _camp_owner.FullName end as CampaignOwnerName AS FullNameendasCampaignOwnerName,
  CampaignLifecycleStatus,
  _Life_cycleText.CampaignLifecycleStatusName AS CampaignLifecycleStatusName,
  CampaignStartDate,
  CampaignEndDate,
  MediaType,
  _MediaTypeText.MediaTypeName AS MediaTypeName,
  CampaignPriority,
  _PriorityText.CampaignPriorityName AS CampaignPriorityName
FROM I_Mkt_Initiative AS _MKT_camp
LEFT OUTER JOIN E_MKT_INITIATIVE AS _Extension ON CampaignUUID = _Extension.Campaign  -- association [1..1]
LEFT OUTER JOIN A_MKT_CampaignInterest AS _MKT_IOI ON CampaignUUID = _MKT_IOI.CampaignUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_CampaignTeamMember AS _MKT_CampTM ON CampaignUUID = _MKT_CampTM.CampaignUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_CampaignTargetGroup AS _MKT_CampTG ON CampaignUUID = _MKT_CampTG.CampaignUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_CmpgnCmtmtActlSpend AS _MKT_CampSpend ON CampaignUUID = _MKT_CampSpend.CampaignUUID  -- association [0..1]
LEFT OUTER JOIN A_MKT_SpendHeader AS _MKT_CampSpend_hdr ON CampaignUUID = _MKT_CampSpend_hdr.CampaignUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_CampaignMktgAgency AS _MKT_agncy ON CampaignUUID = _MKT_agncy.CampaignUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_ExtCampaignReference AS _MKT_CampEXT ON CampaignUUID = _MKT_CampEXT.CampaignUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_CampaignCategoryText AS _CAMP_CAT_Text ON _MKT_camp.CampaignCategory = _CAMP_CAT_Text.CampaignCategory AND _CAMP_CAT_Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN A_MKT_CmpgnLifeCycleStsTxt AS _Life_cycleText ON _MKT_camp.CampaignLifecycleStatus = _Life_cycleText.CampaignLifecycleStatus AND _Life_cycleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN A_MKT_MediaTypeText AS _MediaTypeText ON _MKT_camp.MediaType = _MediaTypeText.MediaType AND _MediaTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN A_MKT_MarketingAreaText AS _MKT_MarketingAreaText ON MarketingArea = _MKT_MarketingAreaText.MarketingArea AND _MKT_MarketingAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN A_MKT_CampaignPriorityText AS _PriorityText ON _MKT_camp.CampaignPriority = _PriorityText.CampaignPriority AND _PriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN A_MKT_CommunicationCat AS _CommunicationCategory ON _MKT_camp.CommunicationCategoryUUID = _CommunicationCategory.CommunicationCategoryUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_CampaignOwnerUser AS _camp_owner ON _MKT_camp.CampaignOwner = _camp_owner.UserID  -- association [0..1]
LEFT OUTER JOIN A_MKT_CampaignUser AS _camp_crea_usr ON _MKT_camp.CampaignCreatedByUser = _camp_crea_usr.UserID  -- association [0..1]
LEFT OUTER JOIN A_MKT_CampaignUser AS _camp_lc_usr ON _MKT_camp.CampaignLastChgdByUser = _camp_lc_usr.UserID  -- association [0..1]
LEFT OUTER JOIN A_MKT_Program AS _MKT_PROGRAMTEXT ON _MKT_camp.MarketingProgram = _MKT_PROGRAMTEXT.MarketingProgramUUID  -- association [0..1]
;