C_BankAccReviewLog

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_BankAccReviewLog.
-- 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: CREVIEWLOG

CREATE VIEW C_BankAccReviewLog AS
SELECT
  log.BankAccountChangeRequest AS BankAccountChangeRequest,
  log.BankAccountInternalID AS BankAccountInternalID,
  log.InWorkflowProcess AS InWorkflowProcess,
  log.BankAccountNumber AS BankAccountNumber,
  log.BankAccountDescription AS BankAccountDescription,
  log.Bank AS Bank,
  _Bank.BankName AS BankName,
  log.BankCountry AS BankCountry,
  _BankCountryText.CountryName AS CountryName,
  log.BankAccountCurrency AS BankAccountCurrency,
  _CurrencyText.CurrencyName AS CurrencyName,
  log.BankAccountChangeRequestStatus AS BankAccountChangeRequestStatus,
  log.BankAccountReqStatusText AS BankAccountReqStatusText,
  log.Name AS Name,
  _Reviewer.FullName AS FullName,
  log.BkAcctReqLastChgdDteTme AS BkAcctReqLastChgdDteTme,
  log.LastChangedByUser AS LastChangedByUser,
  _LastChangedBy.FullName AS LastChangedByUserFullName,
  log.IsBankAcctRevAuthzdUser AS IsBankAcctRevAuthzdUser,
  log.CompanyCode AS CompanyCode,
  log.CompanyCodeName AS CompanyCodeName,
  log.BusinessArea AS BusinessArea,
  log.ProfitCenter AS ProfitCenter,
  log.Segment AS Segment,
  log.BankAccountType AS BankAccountType
FROM I_BankAcctReviewLg AS log
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country AND _BankCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _Reviewer ON Name = _Reviewer.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON BankAccountCurrency = _CurrencyText.Currency AND _CurrencyText.Language = $session.system_language  -- association [0..1]
;