I_SupplierBankDetailsVH

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_SupplierBankDetailsVH.
-- 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: ISUPPLIERBANKVH

CREATE VIEW I_SupplierBankDetailsVH AS
SELECT
  I_SupplierBankDetails.BusinessPartner AS BusinessPartner,
  I_SupplierBankDetails.Supplier AS Supplier,
  I_SupplierBankDetails.BPBankAccountInternalID AS BPBankAccountInternalID,
  I_SupplierBankDetails.BankCountry AS BankCountry,
  I_SupplierBankDetails.Bank AS Bank,
  case when _BusinessPartnerBankAlias.PaymentSystem is not initial then cast (' ' as bankn ) else I_SupplierBankDetails.BankAccount end as BankAccount AS BankAccountendasBankAccount,
  I_SupplierBankDetails._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  I_SupplierBankDetails._Supplier.AuthorizationGroup AS AuthorizationGroup,
  I_SupplierBankDetails._Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_SupplierBankDetails._BusinessPartnerBank.BPBankIsProtected AS BPBankIsProtected,
  I_SupplierBankDetails._BusinessPartnerBank.IBAN AS IBAN,
  I_SupplierBankDetails.BankDetailReference AS BankDetailReference,
  I_SupplierBankDetails._BusinessPartnerBankAlias.PaymentSystem AS PaymentSystem,
  I_SupplierBankDetails._BusinessPartnerBankAlias.AliasType AS AliasType,
  I_SupplierBankDetails._BusinessPartnerBankAlias.BPBankAccountAliasName AS BPBankAccountAliasName,
  I_SupplierBankDetails._Supplier AS _Supplier
FROM I_SupplierBankDetails
;