Fdm_Coll_Disp

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 Fdm_Coll_Disp.
-- 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: FDM_COLL_PR_DISP
-- Parameters: language : abap.lang

CREATE VIEW Fdm_Coll_Disp AS
SELECT
  case_guid,
  case_type,
  ext_key,
  ext_ref,
  created_by,
  create_time,
  changed_by,
  change_time,
  closed_by,
  closing_time,
  processor,
  responsible,
  case_title,
  escal_reason,
  category,
  priority,
  stat_orderno,
  stat_para,
  reason_code,
  fin_due_date,
  fin_paid_amt,
  fin_kunnr,
  fin_bukrs,
  fin_origin,
  status_descr,
  _ProcessorContactCard.FullName AS ProcessorName,
  _ResponsibleContactCard.FullName AS ResponsibleName,
  _CoordinatorContactCard.FullName AS CoordinatorName,
  _dcobj_kunnr.obj_type AS obj_type,
  _dcobj_kunnr.obj_key AS obj_key,
  substring( _dcobj_item.obj_key, 1, 4) AS dcobj_bukrs,
  _dcobj_kunnr.relation AS relation
LEFT OUTER JOIN udmo_dc_attr_view ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _ProcessorContactCard ON processor = _ProcessorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsibleContactCard ON responsible = _ResponsibleContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CoordinatorContactCard ON fin_coordinator = _CoordinatorContactCard.ContactCardID  -- association [0..1]
;