I_BankAccountWithBP

DDL: I_BANKACCOUNTWITHBP SQL: IBANKACCBP Type: view COMPOSITE

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.

1 data source(s) 14 fields

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
CompanyCode I_BankAccount CompanyCode
BankCountry I_BankAccount BankCountry
Bank I_BankAccount Bank
BankAccountNumber I_BankAccount BankAccountNumber
BankAccountType I_BankAccount BankAccountType
BankAccountContractType I_BankAccount BankAccountContractType
BusinessPartner BPBankLinkage BusinessPartnerNumber
BankAccountCurrency I_BankAccount BankAccountCurrency
ValidityStartDate I_BankAccount ValidityStartDate
ValidityEndDate I_BankAccount ValidityEndDate
_CompanyCode _CompanyCode
_BankCountry _BankCountry
_Bank _Bank 
@AbapCatalog.sqlViewName: 'IBANKACCBP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Account Data with BP'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking:#REQUIRED
define view I_BankAccountWithBP as select from I_BankAccount as BankAccount 
    left outer to one join I_BPBankLinkage as BPBankLinkage on  BankAccount.BankCountry = BPBankLinkage.BankCountry
                                                            and BankAccount.Bank = BPBankLinkage.Bank
{
    BankAccount.BankAccountInternalID,
    BankAccount.CompanyCode,
    BankAccount.BankCountry,
    BankAccount.Bank,
    BankAccount.BankAccountNumber,
    BankAccount.BankAccountType,
    BankAccount.BankAccountContractType,
    BPBankLinkage.BusinessPartnerNumber as BusinessPartner,
    BankAccount.BankAccountCurrency,
    BankAccount.ValidityStartDate,
    BankAccount.ValidityEndDate,
    _CompanyCode,
    _BankCountry,
    _Bank    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNT",
"I_BPBANKLINKAGE"
],
"ASSOCIATED":
[
"I_BANK_2",
"I_COMPANYCODE",
"I_COUNTRY"
],
"BASE":
[
"I_BANKACCOUNT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More