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.
-- SQL view name: CUAN_MEQRENGNAME

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.changed_at AS changed_at,
  qr_eng_with_name_base.changed_by AS changed_by,
  qr_eng_with_name_base.initiative AS initiative,
  qr_eng_with_name_base.language AS language,
  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.mkt_area_id AS mkt_area_id,
  qr_eng_with_name_base.comm_medium AS comm_medium,
  qr_eng_with_name_base.category AS category,
  qr_eng_with_name_base.comm_cat_key AS comm_cat_key,
  qr_eng_with_name_base.comm_cat_id AS comm_cat_id,
  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.agency_uuid AS agency_uuid,
  qr_eng_with_name_base.agency_name AS agency_name,
  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_meqrengbase AS qr_eng_with_name_base
;