I_BankAccountWithBP

DDL: I_BANKACCOUNTWITHBP SQL: IBANKACCBP Type: view COMPOSITE Package: FCLM_BAM
14 Fields 1 Data Sources

Bank Account Data with BP

I_BankAccountWithBP is a Composite CDS View that provides data about "Bank Account Data with BP" in SAP S/4HANA. It reads from 1 data source (I_BankAccount) and exposes 14 fields. Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
I_BankAccount BankAccount from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBANKACCBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Data with BP view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
BankAccountInternalID I_BankAccount BankAccountInternalID Technical ID
CompanyCode I_BankAccount CompanyCode Receiver Company Code
BankCountry I_BankAccount BankCountry Bank Ctry/Rgn. Key
Bank I_BankAccount Bank Bank Number
BankAccountNumber I_BankAccount BankAccountNumber Bank Account
BankAccountType I_BankAccount BankAccountType Account Type
BankAccountContractType I_BankAccount BankAccountContractType
BusinessPartner BPBankLinkage BusinessPartnerNumber
BankAccountCurrency I_BankAccount BankAccountCurrency Currency
ValidityStartDate I_BankAccount ValidityStartDate Validity Start Date
ValidityEndDate I_BankAccount ValidityEndDate ValidTo
_CompanyCode _CompanyCode
_BankCountry _BankCountry
_Bank _Bank

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_BankAccountWithBP.
-- 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: IBANKACCBP

CREATE VIEW I_BankAccountWithBP AS
SELECT
  BankAccount.BankAccountInternalID AS BankAccountInternalID,
  BankAccount.CompanyCode AS CompanyCode,
  BankAccount.BankCountry AS BankCountry,
  BankAccount.Bank AS Bank,
  BankAccount.BankAccountNumber AS BankAccountNumber,
  BankAccount.BankAccountType AS BankAccountType,
  BankAccount.BankAccountContractType AS BankAccountContractType,
  BPBankLinkage.BusinessPartnerNumber AS BusinessPartner,
  BankAccount.BankAccountCurrency AS BankAccountCurrency,
  BankAccount.ValidityStartDate AS ValidityStartDate,
  BankAccount.ValidityEndDate AS ValidityEndDate
FROM I_BankAccount AS BankAccount
;

Learn More