C_MKT_CustJrnyCampaignVH

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 C_MKT_CustJrnyCampaignVH.
-- 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: CMKTCUSJRNCAMPVH

CREATE VIEW C_MKT_CustJrnyCampaignVH AS
SELECT
  campaign.Campaign AS Campaign,
  campaign.CampaignID AS CampaignID,
  campaign.CampaignName AS CampaignName,
  campaign.MarketingArea AS MarketingArea,
  campaign.CampaignLifecycleStatus AS CampaignLifecycleStatus,
  campaign.CampaignCategory AS CampaignCategory,
  campaign.CampaignOwner AS CampaignOwner,
  campaign._MKT_CampaignCategory._Text[1: Language = $session.system_language ].CampaignCategoryName AS CampaignCategoryName,
  cast(_CampaignOwner.FullName as cuan_created_by preserving type) AS CampaignOwnerName,
  campaign.CampaignProcessType AS CampaignProcessType,
  cast(' ' as abap.sstring( 512 )) AS CustJourneyCampaignIconName,
  cast(' ' as abap.sstring( 512 )) AS CustJourneyCampaignIconURL,
  campaign.CampaignLastChgdDateTime AS CampaignLastChgdDateTime,
  campaign.TargetGroupUUID AS TargetGroupUUID
FROM I_Mkt_Initiative AS campaign
LEFT OUTER JOIN I_MKT_User AS _CampaignOwner ON CampaignOwner = _CampaignOwner.UserID  -- association [0..1]
;