I_BankAcctChangeRequest

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_BankAcctChangeRequest.
-- 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: IBAMREQ

CREATE VIEW I_BankAcctChangeRequest AS
SELECT
  cr.request_id AS BankAccountChangeRequest,
  cr.title AS BankAcctChangeReqHeadingText,
  cr.account_action AS BankAccountAction,
  _actionText.BankAccountActionText AS BankAccountActionText,
  cr.request_status AS BankAccountChangeRequestStatus,
  _requestStatusText.BankAccountReqStatusText AS BankAccountReqStatusText,
  cr.created_by AS CreatedByUser,
  cr.created_on AS CreationDate,
  cr.duedate AS BankAcctChangeRequestDueDate,
  cr.lastchged_by AS LastChangedByUser,
  cr.request_process AS BankAcctRequestProcess,
  cr.request_step AS BankAccountChangeRequestStep,
  cr.lastchged_on AS LastChangeDate,
  cr.lastchged_tm AS LastChangeTime,
  cr.created_tm AS CreationTime,
  cr.bypass_check_mass AS ChangeRequestIsBypassCheck,
  cast ( case when bypass_check_mass = 'X' then '' else 'X' end as boolean preserving type ) AS ChgReqBypassChkIsHidn
FROM fclm_bam_req AS cr
LEFT OUTER JOIN I_RequestWithBankAccount AS _Bankaccount ON BankAccountChangeRequest = _Bankaccount.BankAccountChangeRequest  -- association [1..*]
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]
;