CDS_WDY_CONF_USER

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_WDY_CONF_USER.
-- 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: WDY_CONF_USER_V

CREATE VIEW CDS_WDY_CONF_USER AS
SELECT
  wdy_conf_user.wduser AS Wduser,
  wdy_conf_user.user_id AS User_Id,
  wdy_conf_user.config_id AS Config_Id,
  wdy_conf_user.config_type AS Config_Type,
  wdy_conf_user.config_var AS Config_Var,
  wdy_conf_user.config_view AS Config_View,
  cast( ' ' as abap.char(96) ) AS app_key,
  cast( ' ' as abap.char(32) ) AS search_id,
  wdy_conf_user.component_name AS Component_Name,
  wdy_conf_user.content_type AS Content_Type,
  wdy_conf_user.author AS Author,
  wdy_conf_user.createdon AS Createdon,
  wdy_conf_user.changedby AS Changed_by,
  wdy_conf_user.changedon AS Changed_on,
  wdy_conf_usert.description AS descr_text,
  case when wdy_conf_user.user_id = 'U' then 'PERS' when wdy_conf_user.user_id = 'F' then 'FLAVOR' when wdy_conf_user.user_id = 'A' and wdy_conf_user.config_type <> '04' then 'CUST' when wdy_conf_user.user_id = 'G' and wdy_conf_user.wduser <> 'A' then 'GROUPED' when wdy_conf_user.user_id = 'A' and wdy_conf_user.config_type = '04' then 'SHARED' when wdy_conf_user.user_id = 'G' and wdy_conf_user.wduser = 'A' then 'SHARED' else 'UNKNOWN' end as tabname AS wduserAthenSHAREDelseUNKNOWNendastabname,
  case when fpm_saved_search.user_id = '*' then 'GSEARCH' else 'SEARCH' end as tabname AS user_idthenGSEARCHelseSEARCHendastabname
FROM wdy_conf_user
LEFT OUTER JOIN wdy_conf_usert ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fpm_search_descr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fpm_ssearch_user ON /* join condition not captured in parsed metadata */
;