I_BUSINESSPARTNERISBANK

CDS View

Business Partner Identification as bank

I_BUSINESSPARTNERISBANK is a CDS View in S/4HANA. Business Partner Identification as bank. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_BusinessPartnerIsBank view from BASIC Partner is Bank
I_BusinessPartnerIsBankTP view_entity from TRANSACTIONAL Business Partner is Bank - TP
@AbapCatalog: { sqlViewName: 'IBPFINSRVCISBANK',
                compiler.compareFilter: true,
                buffering.status: #NOT_ALLOWED
              }
@AccessControl: {authorizationCheck: #MANDATORY,
                 personalData.blocking: #REQUIRED
                }
@ObjectModel: { representativeKey: 'BusinessPartner',
                sapObjectNodeType.name: 'BusinessPartnerIsBank',
                usageType: { dataClass: #MASTER,
                             serviceQuality: #A,
                             sizeCategory: #M
                           },
                supportedCapabilities: [  #ANALYTICAL_DIMENSION,
                                          #CDS_MODELING_DATA_SOURCE,
                                          #CDS_MODELING_ASSOCIATION_TARGET,
                                          #SQL_DATA_SOURCE,
                                          #EXTRACTION_DATA_SOURCE ],
                modelingPattern: #ANALYTICAL_DIMENSION            
              }
@Analytics: { dataExtraction.enabled: true,
              dataCategory: #DIMENSION,
              internalName: #LOCAL
            }
@Metadata: { ignorePropagatedAnnotations: true, 
             allowExtensions:true
           }
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]                       
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Business Partner Identification as bank'

define view I_BusinessPartnerIsBank
  as select from but0bank
  association [1]    to I_BusinessPartner         as _BusinessPartner         on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_BPFinancialServicesExtn as _BPFinancialServicesExtn on $projection.BusinessPartner = _BPFinancialServicesExtn.BusinessPartner
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */ 
  association [0..1] to I_BPMinimumReserve        as _BPMinimumReserve        on $projection.BPMinimumReserve = _BPMinimumReserve.BPMinimumReserve
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */ 
  association [0..*] to I_BPMinimumReserveText    as _BPMinimumReserveText    on $projection.BPMinimumReserve = _BPMinimumReserveText.BPMinimumReserve
{
  key but0bank.partner    as BusinessPartner,
      but0bank.bankl      as BankKey,
      but0bank.banks      as BankCountry,
      but0bank.min_reserv as BPMinimumReserve,

      _BusinessPartner,
      _BPFinancialServicesExtn,
      _BPMinimumReserve,
      _BPMinimumReserveText
}