Coll_Wl_Cct

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 Coll_Wl_Cct.
-- 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: V_COLL_WL_CCT
-- Parameters: language : abap.lang

CREATE VIEW Coll_Wl_Cct AS
SELECT
  cct.cct_guid AS guid,
  customer,
  coll_segment,
  cct_id,
  contact_key,
  cct_name AS name,
  cct_email AS email,
  cct.cct_phone AS phone,
  cct.cct_fax AS fax,
  cct.cct_faxc AS faxcountry,
  cct.cct_type AS type,
  typet.cct_type_txt AS type_text,
  cct.cct_result AS cct_result,
  rest.cct_result_txt AS result_text,
  xreached,
  cast(cct_time as tzntstmps) AS time,
  cct_duration AS duration,
  created_by,
  cast(created_at as tzntstmps) AS created_at,
  changed_by,
  cast(changed_at as tzntstmps) AS changed_at,
  cct.cct_attch_count AS attachments,
  cnts.countquali AS no_of_nts,
  cdis.countquali AS no_of_dis,
  crsm.countquali AS no_of_rsm,
  cp2p.countquali AS no_of_p2p
FROM udm_cct_attr AS cct
LEFT OUTER JOIN udm_cct_typet AS typet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN udm_cct_resultt AS rest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Coll_Wl_Rel AS cdis ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Coll_Wl_Rel AS cp2p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Coll_Wl_Rel AS crsm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Coll_Wl_Rel AS cnts ON /* join condition not captured in parsed metadata */
;