I_BankAcctReviewLg

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_BankAcctReviewLg.
-- 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: IREVIEWLOG

CREATE VIEW I_BankAcctReviewLg AS
SELECT
  log.request_id AS BankAccountChangeRequest,
  log.acc_id AS BankAccountInternalID,
  _amd.BankAccountNumber AS BankAccountNumber,
  _amd.BankAccountDescription AS BankAccountDescription,
  _amd.Bank AS Bank,
  _amd.BankCountry AS BankCountry,
  _amd.BankAccountCurrency AS BankAccountCurrency,
  log.review_status AS BankAccountChangeRequestStatus,
  _requestStatusText.BankAccountReqStatusText AS BankAccountReqStatusText,
  reviewer.reviewer AS Name,
  log.reviewed_on AS LastChangeDate,
  log.reviewed_at AS LastChangeTime,
  log.reviewed_by AS LastChangedByUser,
  cast(' ' as fclm_bam_in_workflow) AS InWorkflowProcess,
  cast(' ' as fclm_bam_is_rev_authorized) AS IsBankAcctRevAuthzdUser,
  _amd.CompanyCode AS CompanyCode,
  _amd.BusinessArea AS BusinessArea,
  _amd.ProfitCenter AS ProfitCenter,
  _amd.Segment AS Segment,
  _amd.BankAccountType AS BankAccountType,
  _amd.CompanyCodeName AS CompanyCodeName
FROM fclm_bam_revwlog AS log
LEFT OUTER JOIN fclm_bam_reviwer AS reviewer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankAcctWithDesc AS _amd ON BankAccountInternalID = _amd.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAcctRevStatusText AS _requestStatusText ON BankAccountChangeRequestStatus = _requestStatusText.BankAccountChangeRequestStatus AND _requestStatusText.Language = $session.system_language  -- association [0..1]
;