I_IBCMessageContent

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_IBCMessageContent.
-- 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_IBCMessageContent AS
SELECT
  db_key AS CommunicationMessageUUID,
  id AS CommunicationMessage,
  status AS CommunicationMessageStatus,
  name AS CommunicationMessageName,
  type AS CommMessageContentType,
  category AS CommunicationMessageCategory,
  is_template AS CommMessageIsMessageTemplate,
  comm_medium AS CommunicationMedium,
  segmentation_object AS SegmentationObject,
  segmentation_profile AS SegmentationProfile,
  ref_org_struc AS ReferencedOrgStructure,
  comm_area_id AS CommunicationArea,
  email_for_send_version AS CommMessageJSONVersionString,
  email_for_send AS CommunicationMessageJSONString,
  language AS CommunicationMessageLanguage,
  lchg_date_time AS CommMsgLastChangedDateTime,
  comm_pattern_id AS CommunicationPattern
FROM cuand_me_me_root
LEFT OUTER JOIN I_IBCMessageContentStatus AS _Status ON CommunicationMessageStatus = _Status.CommunicationMessageStatus  -- association [0..1]
LEFT OUTER JOIN I_IBCMessageContentType AS _ContentType ON CommMessageContentType = _ContentType.CommMessageContentType  -- association [0..1]
LEFT OUTER JOIN I_IBCMsgSegmentationProfile AS _SegmentationProfile ON SegmentationProfile = _SegmentationProfile.SegmentationProfile  -- association [0..1]
;