I_OpeningBalanceTransCrcy

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_OpeningBalanceTransCrcy.
-- 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: IBALTRANSCRCY

CREATE VIEW I_OpeningBalanceTransCrcy AS
SELECT
  balance.BankAccountInternalID AS BankAccountInternalID,
  balance.CompanyCode AS CompanyCode,
  balance.TransactionDate AS TransactionDate,
  coalesce(TransactionCurrency, BankAccountCurrency ) AS Currency,
  balance.GLAccount AS GLAccount,
  balance.ValidFrom AS ValidFrom,
  balance.ValidTo AS ValidTo,
  balance.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  balance.CompanyCodeCurrency AS CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  cast( coalesce( link.HouseBank, '' ) as hbkid ) AS HouseBank,
  cast( coalesce( link.HouseBankAccount, '' ) as hktid ) AS HouseBankAccount,
  cast( coalesce( balance.BankAccount, '' ) as fclm_bam_acc_num ) AS BankAccount,
  cast( coalesce( balance.Bank, '' ) as fclm_bam_bank_key ) AS Bank,
  cast( coalesce( balance.BankCountry, '' ) as fclm_bam_bank_country_key ) AS BankCountry
FROM P_Openingbalancetf
LEFT OUTER JOIN I_BankAccountMainLinkage AS link ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInCompanyCode AS glaccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON BankAccountCurrency = _Currency.Currency left outer join I_GLAccountInCompanyCode as glaccount on balance.CompanyCode = glaccount.CompanyCode AND balance.GLAccount = glaccount.GLAccount  -- association [0..1]
;