I_IBCMessageContentCommArea

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_IBCMessageContentCommArea.
-- 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_IBCMessageContentCommArea AS
SELECT
  persistency.db_key AS MessageContentCommAreaUUID,
  persistency.parent_key AS CampaignContentUUID,
  persistency.comm_area_id AS CommunicationArea,
  persistency.ref_org_struc AS ReferencedOrgStructure,
  _CommArea._Text[1: Language = $session.system_language].CommunicationAreaName AS CommunicationAreaName,
  _AuthCommArea[1: CommunicationArea = CommunicationArea and ReferencedOrgStructure = ReferencedOrgStructure].AuthorizedCommunicationArea AS AuthorizedCommunicationArea
FROM cuand_me_ad_coma AS persistency
LEFT OUTER JOIN I_CommunicationArea AS _CommArea ON CommunicationArea = _CommArea.CommunicationArea AND ReferencedOrgStructure = _CommArea.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON CommunicationArea = _AuthCommArea.CommunicationArea AND ReferencedOrgStructure = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;