CUAN_PRED_INITIATIVES

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_PRED_INITIATIVES.
-- 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_PRED_INI

CREATE VIEW CUAN_PRED_INITIATIVES AS
SELECT
  cuan_d_ini_root.mandt AS MANDT,
  cuan_d_ini_root.db_key AS INI_DB_KEY,
  cuan_d_ini_root.id AS INI_ID,
  cuan_d_ini_root.name AS INI_NAME,
  cuan_d_ini_root.description AS INI_DESCRIPTION,
  cuan_d_ini_root.start_date AS INI_START_DATE,
  cuan_d_ini_root.end_date AS INI_END_DATE,
  cuan_d_ini_root.crea_uname AS INI_CREA_UNAME,
  ADRP_2.name_text AS INI_CREA_PERSON_NAME,
  cuan_d_ini_root.type AS INI_TYPE,
  cuan_d_tg_root.db_key AS TG_DB_KEY,
  cuan_d_tg_root.id AS TG_ID,
  cuan_d_tg_root.target_group_name AS TG_NAME,
  cuan_d_tg_root.responsible AS TG_RESP_UNAME,
  cuan_d_tg_root.member_type AS TG_MEMBER_TYPE,
  adrp.name_text AS TG_RESP_PERSON_NAME,
  gseg_d_sm_root.db_key AS GSEG_DB_KEY,
  gseg_d_sm_root.application_id AS GSEG_APPL_ID,
  gseg_d_sm_root.segmentation_model_id AS GSEG_ID,
  gseg_d_sm_root.name AS GSEG_NAME,
  gseg_d_sm_root.crea_uname AS GSEG_CREA_UNAME,
  ADRP_3.name_text AS GSEG_CREA_PERSON_NAME,
  gseg_d_sm_root.crea_date_time AS GSEG_CREA_DATE_TIME,
  gseg_d_segment.name AS GSEG_SEGMENT_NAME,
  cuan_d_tg_root.control_group AS CG_DB_KEY,
  CUAN_D_TG_ROOT_1.id AS CG_ID,
  CUAN_D_TG_ROOT_1.target_group_name AS CG_NAME,
  CUAN_D_TG_ROOT_1.responsible AS CG_RESP_UNAME,
  CUAN_D_TG_ROOT_1.member_type AS CG_MEMBER_TYPE,
  ADRP_1.name_text AS CG_RESP_PERSON_NAME,
  cuan_d_ini_root.repo_start_offset AS INI_REPO_START_OFFSET,
  cuan_d_ini_root.repo_start_date AS INI_REPO_START_DATE,
  cuan_d_ini_root.repo_end_offset AS INI_REPO_END_OFFSET,
  cuan_d_ini_root.repo_end_date AS INI_REPO_END_DATE,
  usr21.mandt AS MANDT_1,
  dd07t.ddtext AS TG_MEMBER_TYPE_T,
  DD07T_1.ddtext AS CG_MEMBER_TYPE_T,
  cuan_d_ini_root.id AS INI_ID_EXT,
  cuan_d_tg_root.id AS TG_ID_EXT,
  case when CUAN_D_TG_ROOT_1.id is null or CUAN_D_TG_ROOT_1.id= '' then '' else 'X' end AS TG_WITH_CONTROL_GROUP
FROM cuan_d_ini_root
LEFT OUTER JOIN cuan_d_ini_tg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 AS USR21_3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_tg_root ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS ADRP_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_d_sm_root ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 AS USR21_1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_tg_root AS CUAN_D_TG_ROOT_1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_d_segment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 AS USR21_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS DD07T_1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS ADRP_3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS ADRP_1 ON /* join condition not captured in parsed metadata */
;