CUAN_EXP_DEF_SEARCH_UI

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_EXP_DEF_SEARCH_UI.
-- 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_EXP_DEF_SEARCH_UI AS
SELECT
  ed.definition_id AS DEFINITION_ID,
  ed.db_key AS DB_KEY,
  ed.name AS NAME,
  ed.application_id AS APPLICATION_ID,
  ed.profile_id AS PROFILE_ID,
  pr_t.pr_text AS PROFILE_TEXT,
  ed.comm_area_id AS COMM_AREA_ID,
  _commareatxt.CommunicationAreaName AS COMM_AREA_DESC,
  ed.ref_org_struc AS REF_ORG_STRUC,
  ed.usage AS USAGE_FOR,
  dd07t.ddtext AS USAGE_T,
  ed.export_obj_header AS EXPORT_OBJ_HEADER,
  ed.field_separator AS FIELD_SEPARATOR,
  ed.multi_val_separator AS MULTI_VAL_SEPARATOR,
  ed.crea_uname AS crea_uname,
  ed.lchg_uname AS lchg_uname,
  count( distinct ed_at.db_key ) AS ed_at_count
FROM hpa_d_ed_root AS ed
LEFT OUTER JOIN cuan_d_tg_root AS tg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_mktorc_ap AS ap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_mktorc_rt AS rt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_ini_root AS ini ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_profile_t AS pr_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hpa_d_attribute AS ed_at ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CommunicationAreaText AS _commareatxt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = ed.crea_uname  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = ed.lchg_uname  -- association [0..1]
;