I_BUSINESSPARTNERBANKPROC

CDS View

Core View: Bus Part Bank (Process)

I_BUSINESSPARTNERBANKPROC is a CDS View in S/4HANA. Core View: Bus Part Bank (Process). It contains 6 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 6 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPBankProcessChanges view from TRANSACTIONAL BP Bank Process Changes
I_BPBankProcessChanges view union_all TRANSACTIONAL BP Bank Process Changes
I_BusinessPartnerBankGov view from COMPOSITE Business Partner Bank (Governance)
I_BusinessPartnerBankProcTP view_entity from TRANSACTIONAL Business Partner Bank (Process Data)

Fields (6)

KeyField CDS FieldsUsed in Views
KEY BankIdentification BankIdentification 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.sqlViewName: 'IBPBANKPROC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@EndUserText.label: 'Core View: Bus Part Bank (Process)'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BusinessPartnerBankProc
  as select from but0bk_prc

  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on  but0bk_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                     and but0bk_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                     and but0bk_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                     and but0bk_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
  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 process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key bkvid                    as BankIdentification,
      partner                  as BusinessPartner,
      banks                    as BankCountryKey,
      bankl                    as BankNumber,
      bankn                    as BankAccount,
      bkont                    as BankControlKey,
      bkref                    as BankAccountReferenceText,
      koinh                    as BankAccountHolderName,
      bkext                    as BusinessPartnerExternalBankID,
      xezer                    as CollectionAuthInd,
      accname                  as BankAccountName,
      move_bkvid               as BPBankDetailsChangeTargetID,
      protect                  as BPBankIsProtected,
      bk_valid_from            as ValidityStartDateTime,
      bk_valid_to              as ValidityEndDateTime,
      bk_move_date             as BPBankDetailsChangeDate,
      iban                     as IBAN,
      //      bank_guid,

      //      account_id,

      //      check_digit,

      //      account_type,

      //      bp_eew_but0bk,

      //      source_recency,

      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      //      source_index


      _BusinessPartner,
      _Bank,
      _IBAN
}

Learn More