udmo_dc_attr_view

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 udmo_dc_attr_view.
-- 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: UDMO_V_DC_ATTR
-- Parameters: language : abap.lang

CREATE VIEW udmo_dc_attr_view AS
SELECT
  scmg.case_guid AS case_guid,
  scmg.case_type AS case_type,
  ext_key,
  ext_ref,
  created_by,
  cast( create_time as udmo_create_time ) AS create_time,
  changed_by,
  cast( change_time as udmo_change_time ) AS change_time,
  closed_by,
  cast( closing_time as udmo_closing_time ) AS closing_time,
  processor,
  responsible,
  case_title,
  scmg.escal_reason AS escal_reason,
  scmg.category AS category,
  scmg.priority AS priority,
  scmg.stat_orderno AS stat_orderno,
  scmg.stat_para AS stat_para,
  scmg.reason_code AS reason_code,
  fin_due_date,
  fin_paid_amt,
  fin_kunnr,
  fin_bukrs,
  fin_origin,
  scmgstatprofst.stat_ordno_descr AS status_descr
FROM scmg_t_case_attr AS scmg
INNER JOIN udmcaseattr00 AS udm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgcasetypet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgstatt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgstatprofst ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgattr_categot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgattr_reasont ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgattr_priot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scmgattr_sescalt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN udmattr_rccodet ON /* join condition not captured in parsed metadata */
;