I_IBCMessageReuseBlockUsedIn

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_IBCMessageReuseBlockUsedIn.
-- 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_IBCMessageReuseBlockUsedIn AS
SELECT
  rub_root.id AS CommunicationMessageReuseBlock,
  using_root.id AS CommunicationMessage,
  using_block.langu AS CommunicationMessageLanguage,
  case when using_root.status = '15' and block_valid.valid_from < 99991231000000 then '20' else using_root.status end as CommunicationMessageStatus AS statusendasCommunicationMessageStatus,
  case when using_root.status = '15' and block_valid.valid_from = 99991231000000 then header.name else using_root.name end as CommunicationMessageName AS nameendasCommunicationMessageName,
  case when using_root.is_template = 'X' then concat(using_root.type, '-TMP') else using_root.type end as CommMsgExternalContentType AS typeendasCommMsgExternalContentType,
  using_root.is_template AS CommMessageIsMessageTemplate,
  using_root.type AS CommMessageContentType,
  using_root.category AS CommunicationMessageCategory,
  case when using_root.is_template = 'X' then ContentTypeText.template_text else ContentTypeText.text end as CommMsgCntntTypeName AS textendasCommMsgCntntTypeName,
  using_root.comm_area_id AS CommunicationArea,
  using_root.ref_org_struc AS ReferencedOrgStructure,
  using_root.segmentation_profile AS SegmentationProfile,
  using_root.lchg_date_time AS CommMsgLastChangedDateTime,
  using_root.language AS CommMessageDefaultLanguage,
  reusable.is_language_dependent AS CommMessageIsLanguageDependent,
  using_root.comm_medium AS CommunicationMedium,
  CommMediumText.CommunicationMediumName AS CommunicationMediumName,
  using_root.db_key AS CommunicationMessageUUID,
  rub_root.db_key AS CommMessageReuseBlockUUID,
  using_root.email_for_send AS CommunicationMessageJSONString,
  using_root.email_for_send_version AS CommMessageJSONVersionString,
  header.email_for_send AS CommMessageRevisionJSONString,
  header.email_for_send_version AS CommMsgRevsnJSONVersionString
FROM cuand_me_me_root AS rub_root
LEFT OUTER JOIN cuand_me_header AS header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuand_me_valid AS header_valid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuand_me_valid AS block_valid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS status_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS status_20_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IBCCommunicationMediumText AS CommMediumText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IBCMessageContentCommArea AS _MessageContentCommArea ON CommunicationMessageUUID = _MessageContentCommArea.CampaignContentUUID  -- association [0..*]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _MessageContentRootCommArea ON CommunicationArea = _MessageContentRootCommArea.CommunicationArea AND ReferencedOrgStructure = _MessageContentRootCommArea.ReferencedOrgStructure  -- association [0..*]
;