CDS_SUI_TM_MM_APP_A

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 CDS_SUI_TM_MM_APP_A.
-- 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: SUI_TM_MM_APP_VA

CREATE VIEW CDS_SUI_TM_MM_APP_A AS
SELECT
  sui_tm_mm_app.app_id AS app_id,
  sui_tm_mm_app.cat_id AS cat_id,
  sui_tm_mm_app.sem_obj AS sem_obj,
  sui_tm_mm_app.sem_act AS sem_act,
  sui_tm_mm_app.app_type AS app_type,
  sui_tm_mm_app.app_subtype AS app_subtype,
  sui_tm_mm_app.tcode AS tcode,
  sui_tm_mm_app.wd_appl_id AS wd_appl_id,
  sui_tm_mm_app.wd_conf_id AS wd_conf_id,
  sui_tm_mm_app.ui5_app_id AS ui5_app_id,
  sui_tm_mm_app.fiori_id AS fiori_id,
  sui_tm_mm_app.system_alias AS system_alias,
  tstmp_to_dats( sui_tm_mm_app.changed_at, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) AS changed_at,
  sui_tm_mm_app.changed_by AS changed_by,
  sui_tm_mm_app.masterlang AS masterlang,
  sui_tm_mm_app.tile_type AS tile_type,
  sui_tm_mm_app.target_url AS target_url,
  sui_tm_mm_appt.tile_title AS app_title,
  sui_tm_mm_appt.tile_subtitle AS app_subtitle,
  sui_tm_mm_appt.tile_keywords AS app_keywords,
  sui_tm_mm_appt.description AS description,
  tadir.srcsystem AS srcsystem,
  tadir.author AS author,
  tadir.devclass AS devclass,
  tadir.component AS component,
  tadir.crelease AS crelease,
  tadir.created_on AS created_on
FROM sui_tm_mm_app
LEFT OUTER JOIN sui_tm_mm_appt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sui_uiaa ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sui_uiaat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sui_uiaa_tile ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sui_uiaa_tilet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS dd07t_sy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS dd07t_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sui_tm_mm_appdep ON /* join condition not captured in parsed metadata */
;