FI_F4_BVTYP_LFBK

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 FI_F4_BVTYP_LFBK.
-- 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: FIF4BVTYPK

CREATE VIEW FI_F4_BVTYP_LFBK AS
SELECT
  cast ( Supplier as lifnr preserving type ) AS lifnr,
  cast ( BankCountry as banks preserving type ) AS banks,
  cast ( Bank as bankk preserving type ) AS bankl,
  cast ( BankAccount as bankn preserving type ) AS bankn,
  cast ( BPBankAccountInternalID as bvtyp preserving type ) AS bvtyp,
  cast ( BankControlKey as bkont preserving type ) AS bkont,
  cast ( BankDetailReference as bkref preserving type ) AS bkref,
  Supplier,
  AuthorizationGroup,
  BankCountry,
  BusinessPartner,
  I_SupplierBankDetails.Bank AS Bank,
  I_SupplierBankDetails.BankAccount AS BankAccount,
  _BusinessPartnerBankAlias.PaymentSystem AS PaymentSystem,
  _BusinessPartnerBankAlias.AliasType AS AliasType,
  _BusinessPartnerBankAlias.BPBankAccountAliasName AS BPBankAccountAliasName,
  I_SupplierBankDetails.BPBankUUID AS BPBankUUID,
  I_SupplierBankDetails.IBAN AS IBAN
FROM I_SupplierBankDetails
;