I_CAWorklistItem

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 I_CAWorklistItem.
-- 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: ICAWORKLISTITEM

CREATE VIEW I_CAWorklistItem AS
SELECT
  iguid AS CAWorklistItemUUID,
  higuid AS CAWorklistUUID,
  wlhid AS CAWorklistNumber,
  cast(gpart as bu_partner) AS BusinessPartner,
  cast(waers as fis_rwcur) AS TransactionCurrency,
  betrw AS CAWorklistItemAmtInTransCrcy,
  prioy AS CAWorklistPriority,
  duedt AS CAWorklistDueDate,
  acton AS CAClarificationActionCode,
  xref1 AS CAWorklistItemReference1,
  xref2 AS CAWorklistItemReference2,
  xref3 AS CAWorklistItemReference3,
  state AS CAClrfctnStatus,
  lock_user AS CAClrfctnLastProcessedByUser,
  lock_limit AS CAClrfctnLockedToDate,
  workstate AS CAClrfctnProcgStatus,
  resubmit_date AS CAClrfctnResubmsnDate,
  wf_count AS CAClrfctnNmbrOfWorkflows,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  ertim AS CreationTime,
  concat(erdat, ertim) AS CreationDateTime,
  tile_id AS CAInternalAppCode
FROM dfkkcfkwl
LEFT OUTER JOIN I_CAWorklistHeader AS _Header ON CAWorklistUUID = _Header.CAWorklistUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CAClrfctnStatus AS _Status ON CAClrfctnStatus = _Status.CAClrfctnStatus AND _Status.CAClrfctnApplicationObject = 'KWL'  -- association [0..1]
LEFT OUTER JOIN I_CAClrfctnStatus AS _WorklistItemStatus ON CAClrfctnStatus = _WorklistItemStatus.CAClrfctnStatus AND _WorklistItemStatus.CAClrfctnApplicationObject = 'KWL'  -- association [0..1]
LEFT OUTER JOIN I_CAClrfctnProcgStatus AS _ProcgStatus ON CAClrfctnProcgStatus = _ProcgStatus.CAClrfctnProcgStatus AND _ProcgStatus.CAClrfctnApplicationObject = 'KWL'  -- association [0..1]
;