I_BankAccSentItems

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_BankAccSentItems.
-- 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: ISENTITEMS

CREATE VIEW I_BankAccSentItems AS
SELECT
  Request.request_id AS BankAccountChangeRequest,
  Request.title AS BankAcctChangeReqHeadingText,
  Request.account_action AS BankAccountAction,
  Request.request_status AS BankAccountChangeRequestStatus,
  _requestStatusText.BankAccountReqStatusText AS BankAccountReqStatusText,
  _actionText.BankAccountActionText AS BankAccountActionText,
  Request.created_by AS CreatedByUser,
  Request.created_on AS CreationDate,
  Request.created_tm AS CreationTime,
  Request.duedate AS BankAcctChangeRequestDueDate,
  Request.lastchged_by AS LastChangedByUser,
  Request.lastchged_on AS LastChangeDate,
  Request.lastchged_tm AS LastChangeTime,
  Request.request_step AS BankAccountChangeRequestStep,
  cast(' ' as name_text) AS Name,
  cast(' ' as boolean preserving type ) AS WorkflowStepsSecIsHidden
FROM fclm_bam_req AS Request
INNER JOIN sww_wi2obj AS WorkItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankAcctReqStatusText AS _requestStatusText ON BankAccountChangeRequestStatus = _requestStatusText.BankAccountChangeRequestStatus AND _requestStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ActionOnBankAcctText AS _actionText ON BankAccountAction = _actionText.BankAccountAction AND _actionText.Language = $session.system_language  -- association [0..1]
;