CUAN_ME_QR_ENG_WITH_NAMES

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 CUAN_ME_QR_ENG_WITH_NAMES.
-- 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 CUAN_ME_QR_ENG_WITH_NAMES AS
SELECT
  qr_eng_with_name_base.db_key AS db_key,
  qr_eng_with_name_base.id AS id,
  qr_eng_with_name_base.name AS name,
  qr_eng_with_name_base.description AS description,
  qr_eng_with_name_base.CREATED_AT AS CREATED_AT,
  qr_eng_with_name_base.CREATED_BY AS CREATED_BY,
  qr_eng_with_name_base.CREATED_BY_NAME AS CREATED_BY_NAME,
  qr_eng_with_name_base.CHANGED_AT AS CHANGED_AT,
  qr_eng_with_name_base.CHANGED_BY AS CHANGED_BY,
  qr_eng_with_name_base.CHANGED_BY_NAME AS CHANGED_BY_NAME,
  qr_eng_with_name_base.EXPORT_DEFINITION_NAME AS EXPORT_DEFINITION_NAME,
  qr_eng_with_name_base.initiative AS initiative,
  qr_eng_with_name_base.INITIATIVE_NAME AS INITIATIVE_NAME,
  qr_eng_with_name_base.SENDING_PROFILE_NAME AS SENDING_PROFILE_NAME,
  qr_eng_with_name_base.language AS language,
  qr_eng_with_name_base.LANGUAGE_NAME AS LANGUAGE_NAME,
  qr_eng_with_name_base.sender_name AS sender_name,
  qr_eng_with_name_base.sender_email AS sender_email,
  qr_eng_with_name_base.STATUS AS STATUS,
  qr_eng_with_name_base.TECHNICAL_STATUS AS TECHNICAL_STATUS,
  qr_eng_with_name_base.STATUS_INT_TEXT AS STATUS_INT_TEXT,
  qr_eng_with_name_base.STATUS_TEXT_60 AS STATUS_TEXT_60,
  qr_eng_with_name_base.comm_area_id AS comm_area_id,
  qr_eng_with_name_base.COMM_AREA_DESC AS COMM_AREA_DESC,
  qr_eng_with_name_base.comm_medium AS comm_medium,
  qr_eng_with_name_base.OVERWRITE_SEND_INFO AS OVERWRITE_SEND_INFO,
  qr_eng_with_name_base.category AS category,
  qr_eng_with_name_base.SEGMENTATION_OBJECT_NAME AS SEGMENTATION_OBJECT_NAME,
  qr_eng_with_name_base.SEGMENTATION_PROFILE_NAME AS SEGMENTATION_PROFILE_NAME,
  qr_eng_with_name_base.is_template AS is_template,
  case when category = 'REUSEBLOCK' and qr_eng_with_name_base.TYPE = 'EMD' then 'EMD-RUB' when category = 'REUSEBLOCK' and qr_eng_with_name_base.TYPE = 'EM' then '-RUB' when category = 'EMAIL' and qr_eng_with_name_base.TYPE = ' ' then 'EM' else qr_eng_with_name_base.TYPE_EXT end as TYPE_EXT AS TYPE_EXTendasTYPE_EXT,
  case when category = 'EMAIL' and qr_eng_with_name_base.TYPE = ' ' then 'EM' else qr_eng_with_name_base.TYPE end as TYPE AS TYPEendasTYPE,
  qr_eng_with_name_base.TYPE_EXT_DESC AS TYPE_EXT_DESC,
  qr_eng_with_name_base.CONF_MSG_TYPE AS CONF_MSG_TYPE,
  qr_eng_with_name_base.CONF_MSG_TYPE_DESC AS CONF_MSG_TYPE_DESC,
  qr_eng_with_name_base.CREA_UNAME_TECH AS CREA_UNAME_TECH,
  qr_eng_with_name_base.LCHG_UNAME_TECH AS LCHG_UNAME_TECH
FROM CUAN_ME_QR_ENG_WITH_NAMES_BASE AS qr_eng_with_name_base
LEFT OUTER JOIN I_IBCMessageContentCommArea AS _MessageContentCommArea ON db_key = _MessageContentCommArea.CampaignContentUUID  -- association [0..*]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _MessageContentRootCommArea ON comm_area_id = _MessageContentRootCommArea.CommunicationArea AND ref_org_struc = _MessageContentRootCommArea.ReferencedOrgStructure  -- association [0..*]
;