C_BusinessPartnerBank

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_BusinessPartnerBank.
-- 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: CBUPABANK

CREATE VIEW C_BusinessPartnerBank AS
SELECT
  BusinessPartnerBank.BankIdentification AS BankIdentification,
  BusinessPartnerBank.BusinessPartner AS BusinessPartner,
  BusinessPartnerBank.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerBank.BankIdentificationForEdit AS BankIdentificationForEdit,
  BusinessPartnerBank.BankCountryKey AS BankCountryKey,
  BusinessPartnerBank.BankNumber AS BankNumber,
  BusinessPartnerBank.BankName AS BankName,
  BusinessPartnerBank.BankControlKey AS BankControlKey,
  BusinessPartnerBank.BankAccountHolderName AS BankAccountHolderName,
  BusinessPartnerBank.BankAccountName AS BankAccountName,
  BusinessPartnerBank.IBAN AS IBAN,
  BusinessPartnerBank.IBANValidityStartDate AS IBANValidityStartDate,
  BusinessPartnerBank.BankAccount AS BankAccount,
  BusinessPartnerBank.BankValidityStartDate AS BankValidityStartDate,
  BusinessPartnerBank.BankValidityEndDate AS BankValidityEndDate,
  BusinessPartnerBank.BankAccountReferenceText AS BankAccountReferenceText,
  BusinessPartnerBank.CollectionAuthInd AS CollectionAuthInd,
  BusinessPartnerBank.BPBankIsProtected AS BPBankIsProtected,
  BusinessPartnerBank.SWIFTCode AS SWIFTCode,
  BusinessPartnerBank.PaymentSystem AS PaymentSystem,
  BusinessPartnerBank.AliasType AS AliasType,
  BusinessPartnerBank.BPBankAccountAliasName AS BPBankAccountAliasName,
  _PaymentSystemVH.PaymentSystemText AS PaymentSystemText,
  _AliasTypeVH.AliasTypeText AS AliasTypeText
FROM I_BusinessPartnerBankTP AS BusinessPartnerBank
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_Countrytextvhtemp AS _BankCountryText ON BankCountryKey = _BankCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_PaymentSystemValueHelp AS _PaymentSystemVH ON PaymentSystem = _PaymentSystemVH. PaymentSystem  -- association [1..1]
LEFT OUTER JOIN I_PaytSystToAliasTypeValueHelp AS _AliasTypeVH ON PaymentSystem = _AliasTypeVH.PaymentSystem AND AliasType = _AliasTypeVH.AliasType  -- association [1..1]
;