v_coll_wl_item_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 v_coll_wl_item_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: V_COLL_WL_ITEM
-- Parameters: language : spras, P_DisplayCurrency : displaycurrency, P_ExchangeRateDate : vdm_v_exchange_rate_date

CREATE VIEW v_coll_wl_item_view AS
SELECT
  udm_wl_item.workitem_id AS workitem_id,
  udm_coll_prio_view.priority AS priority,
  udm_statust.Name AS StatusText,
  _AssignedText.Name AS IsSpecialistAssignedText,
  udm_wl_item.coll_group AS coll_group,
  udm_wl_item.coll_segment AS coll_segment,
  wl_item_date,
  run_id,
  udm_wl_item.status AS status,
  strategy,
  valuation,
  cast( udm_wl_item.percentage as abap.char(4)) AS percentage,
  partner_id,
  udm_wl_item.partner_desc AS partner_desc,
  _BusinessPartner.BusinessPartnerFullName AS partner_name,
  contact_name,
  udm_wl_item.cct_result AS cct_result,
  cast(calltimefrom as tzntstmps) AS calltimefrom,
  cast(calltimeto as tzntstmps) AS calltimeto,
  total_amt,
  debit_amt,
  credit_amt,
  due_amt,
  overdue_amt,
  promised_amt,
  disputed_amt,
  dunned_amt,
  arranged_amt,
  broken_amt,
  currency,
  due_amt_int1,
  due_amt_int2,
  due_amt_int3,
  due_amt_int4,
  due_amt_int5,
  cast(rsm_date as bdm_rsm_date) AS rsm_date,
  cast(rsm_time as tzntstmps) AS rsm_time,
  rsm_reason,
  credit_sgmnt,
  credit_limit,
  grade,
  grade_method,
  created_by,
  cast(create_time as tzntstmps) AS create_time,
  changed_by,
  cast(change_time as tzntstmps) AS change_time,
  cast( 1 as abap.int4 ) AS LineCount,
  coalesce( _UserContactCard.FullName , _AssignedText.Name ) AS CollSpecialistFullName,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  cast( '' as udmo_payment_trend_md ) AS PAYMENT_TREND
FROM udm_wl_item
LEFT OUTER JOIN udm_coll_sgmtt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN udm_coll_grpt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_prio4_view AS udm_coll_prio_view ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN udm_coll_priot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN udm_cct_resultt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN udm_rsm_reasont ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN V_Coll_wl_Status_Text AS udm_statust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN V_Coll_Wl_Specialist_Assign_T AS _AssignedText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON coll_specialist = _UserContactCard.ContactCardID  -- association [0..1]
;