C_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 C_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.

CREATE VIEW C_BankAccSentItems AS
SELECT
  Req.BankAccountChangeRequest AS BankAccountChangeRequest,
  Req.BankAccountActionText AS BankAccountActionText,
  Req.BankAccountAction AS BankAccountAction,
  Req.BankAccountReqStatusText AS BankAccountReqStatusText,
  Req.BankAccountChangeRequestStatus AS BankAccountChangeRequestStatus,
  Req.BankAccountChangeRequestStep AS BankAccountChangeRequestStep,
  Req.BankAcctChangeReqHeadingText AS BankAcctChangeReqHeadingText,
  Req.BankAcctChangeRequestDueDate AS BankAcctChangeRequestDueDate,
  Req.BankAccountReqCreatedDateTime AS BankAccountReqCreatedDateTime,
  Req.BkAcctReqLastChgdDteTme AS BkAcctReqLastChgdDteTme,
  _LastChangedByUser.FullName AS LastChangedByUserFullName,
  Req.LastChangedByUser AS LastChangedByUser,
  Req.Name AS Name,
  Req.WorkflowStepsSecIsHidden AS WorkflowStepsSecIsHidden,
  case when BankAccountChangeRequestStatus = '05' then cast( 'X' as boolean ) else cast( '' as boolean ) end AS CancelRequestIsApplicable
FROM I_BankAccSentItems AS Req
LEFT OUTER JOIN C_RequestWithBankAccount AS _Bankaccount ON BankAccountChangeRequest = _Bankaccount.BankAccountChangeRequest  -- association [1..*]
LEFT OUTER JOIN C_BankAccountChangeRequestLog AS _reqLog ON BankAccountChangeRequest = _reqLog.BankAccountChangeRequest  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
;