C_NO_SAFTGenLedgerCustBankAcct

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_NO_SAFTGenLedgerCustBankAcct.
-- 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: CNOSAFTGLCBKACCT

CREATE VIEW C_NO_SAFTGenLedgerCustBankAcct AS
SELECT
  CustomerCompany.CompanyCode AS CompanyCode,
  BankDetails.Customer AS CustomerNum,
  BankDetails.BankCountry AS BankCountry,
  BankDetails.Bank AS Bank,
  BankAcct.BankAccountInternalID AS BankAccountInternalID,
  BankDetails.BankAccount AS BankAccount,
  Bank.SWIFTCode AS SWIFTCode,
  _IBAN.IBAN AS IBAN,
  BankAcct.BankAccountHolderName AS BankAccountHolderName,
  BankDetails._Customer AS _Customer,
  BankDetails._Country AS _Country,
  BankDetails._BankAccount AS _BankAccount
FROM I_CustomerBankDetails AS BankDetails
INNER JOIN I_Bank AS Bank ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerCompany AS CustomerCompany ON companycode = CustomerCompany.CompanyCode AND CustomerCompany.Customer = BankDetails.Customer  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS BankAcct ON BankDetails.BankCountry = BankAcct.BankCountry AND BankDetails.Bank = BankAcct.Bank AND BankDetails.BankAccount = BankAcct.BankAccountNumber  -- association [0..1]
LEFT OUTER JOIN I_Iban AS _IBAN ON BankDetails.BankAccount = _IBAN.BankAccount AND BankDetails.Bank = _IBAN.Bank AND BankDetails.BankCountry = _IBAN.BankCountry AND BankDetails.BankControlKey = _IBAN.BankControlKey  -- association [0..1]
;