CUAN_CONT_LIB_CM_SEARCH

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_CONT_LIB_CM_SEARCH.
-- 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_CONT_LIB_CM_SEARCH AS
SELECT
  libcmbase.DB_Key AS DB_KEY,
  libcmbase.ID_INT AS ID,
  libcmbase.name AS NAME,
  libcmbase.TYPE_EXT AS TYPE_EXT,
  libcmbase.STATUS AS STATUS,
  libcmbase.STATUS_EXT AS STATUS_EXT,
  libcmbase.crea_date_time AS CREA_DATE_TIME,
  libcmbase.crea_uname AS CREA_UNAME,
  libcmbase.lchg_date_time AS LCHG_DATE_TIME,
  libcmbase.lchg_uname AS LCHG_UNAME,
  libcmbase.comm_area_id AS COMM_AREA_ID,
  libcmbase.ref_org_struc AS REF_ORG_STRUC,
  libcmbase.comm_medium AS COMM_MEDIUM,
  libcmbase.is_template AS IS_TEMPLATE,
  libcmbase.type AS type,
  libcmbase.CREA_UNAME_TEXT AS CREA_UNAME_TEXT,
  libcmbase.LCHG_UNAME_TEXT AS LCHG_UNAME_TEXT,
  libcmbase.COMM_AREA_DESC AS COMM_AREA_DESC,
  libcmbase.REF_ORG_STRUC_DESC AS REF_ORG_STRUC_DESC,
  case when TYPE_EXT = 'CON' then libcmbase.STATUS_CON_TEXT when TYPE_EXT = 'SMS' then libcmbase.STATUS_SMS_TEXT when TYPE_EXT = 'MPN' then libcmbase.STATUS_MPN_TEXT when TYPE_EXT = 'EM' then libcmbase.STATUS_EM_TEXT when TYPE_EXT = 'RUB' then libcmbase.STATUS_RUB_TEXT when TYPE_EXT = 'TMP' then libcmbase.STATUS_TMP_TEXT else '' end as TYPE_EXT_DESC AS STATUS_TMP_TEXTelseendasTYPE_EXT_DESC,
  libcmbase.CONF_MSG_TYPE AS CONF_MSG_TYPE,
  libcmbase.CONF_MSG_TYPE_DESC AS CONF_MSG_TYPE_DESC
FROM Cuan_Cont_Lib_Cm_Base AS libcmbase
;