I_BUSINESSPARTNERBANK_2

CDS View

Core View: Business Partner Bank

I_BUSINESSPARTNERBANK_2 is a CDS View in S/4HANA. Core View: Business Partner Bank. It contains 11 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 11 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BusinessPartnerBankGov view union_all COMPOSITE Business Partner Bank (Governance)
I_BusinessPartnerBankTP_2 view_entity from TRANSACTIONAL Transactional View for BP bank details with RAP
R_WorkAssgmtPaymentTP view_entity from TRANSACTIONAL TP View for Payment for Workforce Person

Fields (11)

KeyField CDS FieldsUsed in Views
KEY BankIdentification BankIdentification 1
BankAccount BankAccount 1
BankAccountHolderName BankAccountHolderName 1
BankAccountName BankAccountName 1
BankControlKey BankControlKey 1
BankCountryKey BankCountryKey 1
BankName BankName 1
BankNumber Bank 1
BusinessPartner BusinessPartner 1
IBAN IBAN 1
SWIFTCode SWIFTCode 1 
@AbapCatalog.sqlViewName: 'IBUPABANK2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Core View: Business Partner Bank'
define view I_BusinessPartnerBank_2
  as select from but0bk as BusinessPartnerBank

  association [1..1] to I_BusinessPartner        as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [1..1] to I_BankForBusinessPartner as _Bank            on  $projection.BankNumber     = _Bank.BankInternalID
                                                                     and $projection.BankCountryKey = _Bank.BankCountry

  association [1..1] to I_BusinessPartnerIBAN    as _IBAN            on  $projection.BankAccount    = _IBAN.BankAccount
                                                                     and $projection.BankNumber     = _IBAN.Bank
                                                                     and $projection.BankCountryKey = _IBAN.BankCountry
                                                                     and $projection.BankControlKey = _IBAN.BankControlKey                                                 
{
  key BusinessPartnerBank.partner       as BusinessPartner,
  key BusinessPartnerBank.bkvid         as BankIdentification,
      BusinessPartnerBank.banks         as BankCountryKey,
      _Bank.BankName                    as BankName,
      BusinessPartnerBank.bankl         as BankNumber,
      _Bank.SWIFTCode                   as SWIFTCode,
      BusinessPartnerBank.bkont         as BankControlKey,
      BusinessPartnerBank.koinh         as BankAccountHolderName,
      BusinessPartnerBank.accname       as BankAccountName,
      BusinessPartnerBank.bk_valid_from as ValidityStartDate,
      BusinessPartnerBank.bk_valid_to   as ValidityEndDate,
      case BusinessPartnerBank.bankn
        when ''
          then BusinessPartnerBank.iban
        else
          _IBAN.IBAN
      end                               as IBAN,
      _IBAN.IBANValidityStartDate       as IBANValidityStartDate,
      BusinessPartnerBank.bankn         as BankAccount,
      BusinessPartnerBank.bkref         as BankAccountReferenceText,
      BusinessPartnerBank.xezer         as CollectionAuthInd,
      BusinessPartnerBank.bkext         as BusinessPartnerExternalBankID,
      BusinessPartnerBank.bk_move_date  as BPBankDetailsChangeDate,
      BusinessPartnerBank.move_bkvid    as BPBankDetailsChangeTargetID,
      BusinessPartnerBank.protect       as BPBankIsProtected,
      _Bank.CityName                    as CityName,
      _Bank,
      _IBAN,
      _BusinessPartner,
      _BusinessPartner.AuthorizationGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKFORBUSINESSPARTNER",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERIBAN",
"BUT0BK"
],
"ASSOCIATED":
[
"I_BANKFORBUSINESSPARTNER",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERIBAN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More