I_CustomerBankDetails

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_CustomerBankDetails.
-- 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: ICUSTOMERBANK

CREATE VIEW I_CustomerBankDetails AS
SELECT
  kunnr AS Customer,
  banks AS BankCountry,
  bankl AS Bank,
  bankn AS BankAccount,
  koinh AS BankAccountHolderName,
  bkont AS BankControlKey,
  bvtyp AS BPBankAccountInternalID,
  bkref AS BankDetailReference,
  xezer AS CollectionAuthInd,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  bank_guid AS BPBankUUID,
  _Customer.AuthorizationGroup AS AuthorizationGroup
FROM knbk
LEFT OUTER JOIN I_Bank AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerBank AS _BusinessPartnerBank ON BusinessPartner = _BusinessPartnerBank.BusinessPartner AND BankCountry = _BusinessPartnerBank.BankCountryKey AND Bank = _BusinessPartnerBank.BankNumber AND BankAccount = _BusinessPartnerBank.BankAccount  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON BankCountry = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccount = _BankAccount.BankAccountInternalID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerBankAlias AS _BusinessPartnerBankAlias ON BPBankUUID = _BusinessPartnerBankAlias.BPBankUUID  -- association [1..1]
;