I_MKT_CampaignContentAll

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 I_MKT_CampaignContentAll.
-- 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.

CREATE VIEW I_MKT_CampaignContentAll AS
SELECT
  I_MKT_Content_Root.id AS CampaignContent,
  I_MKT_Content_Root.type AS CampaignContentType,
  cast(I_MKT_Content_Root.id as sstring) AS CampaignAssetConverted,
  I_MKT_Content_Root.category AS MarketingContentCategory,
  I_MKT_Content_Root.name AS CampaignContentName,
  I_MKT_Content_Root.description AS CampaignAssetDescription,
  I_MKT_Content_Root.crea_uname AS CreatedByUser,
  I_MKT_Content_Root.crea_date_time AS CreationDateTime,
  I_MKT_Content_Root.lchg_date_time AS LastChangeDateTime,
  I_MKT_Content_Root.lchg_uname AS LastChangedByUser,
  I_MKT_Content_Root.comm_area_id AS CommunicationArea,
  I_MKT_Content_Root.ref_org_struc AS ReferencedOrgStructure,
  I_MKT_Content_Root.status AS CampaignContentStatus,
  I_MKT_Content_Root.sender_name AS SenderName,
  I_MKT_Content_Root.is_template AS MktgAstIsCmpgnCntntTmpl,
  campaignContent(P_client: $session.client).SUBJECT AS EmailSubjectText,
  I_MKT_Content_Root.db_key AS CampaignContentUUID,
  I_MKT_Content_Root.language AS CampaignContentDefaultLanguage
FROM cuand_me_me_root AS I_MKT_Content_Root
LEFT OUTER JOIN P_MKT_CAMPAIGNCONTENT AS campaignContent ON campaignContent.PARENT_KEY = I_MKT_Content_Root.db_key AND campaignContent.LANGUAGE = I_MKT_Content_Root.language  -- association [0..*]
LEFT OUTER JOIN I_IBCMessageContentCommArea AS _MessageContentCommArea ON CampaignContentUUID = _MessageContentCommArea.CampaignContentUUID  -- association [0..*]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _MessageContentRootCommArea ON CommunicationArea = _MessageContentRootCommArea.CommunicationArea AND ReferencedOrgStructure = _MessageContentRootCommArea.ReferencedOrgStructure  -- association [0..*]
;