Which tables does C_BusinessPartnerBank use?

C_BusinessPartnerBank reads from 1 data source(s): I_BusinessPartnerBankTP.

How many fields does C_BusinessPartnerBank have?

C_BusinessPartnerBank has 30 fields. Key fields: BankIdentification, BusinessPartner.

C_BusinessPartnerBank

DDL: C_BUSINESSPARTNERBANK SQL: CBUPABANK Type: view CONSUMPTION

BP Bank Consumption View

C_BusinessPartnerBank is a Consumption CDS View that provides data about "BP Bank Consumption View" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerBankTP) and exposes 30 fields with key fields BankIdentification, BusinessPartner. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BusinessPartnerBankTP	BusinessPartnerBank	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	C_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[1..1]	C_BusinessPartnerSupplier	_BusinessPartnerSupplier	`$projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner`
[1..1]	C_BusinessPartnerCustomer	_BusinessPartnerCustomer	`$projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner`
[0..*]	C_Countrytextvhtemp	_BankCountryText	`$projection.BankCountryKey = _BankCountryText.Country`
[1..1]	I_PaymentSystemValueHelp	_PaymentSystemVH	`$projection. PaymentSystem = _PaymentSystemVH. PaymentSystem`
[1..1]	I_PaytSystToAliasTypeValueHelp	_AliasTypeVH	`$projection.PaymentSystem = _AliasTypeVH.PaymentSystem and $projection.AliasType = _AliasTypeVH.AliasType`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	CBUPABANK	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	BP Bank Consumption View	view
Metadata.allowExtensions	true	view
ObjectModel.type	#CONSUMPTION	view
ObjectModel.writeEnabled	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
UI.headerInfo.typeName	Bank Account	view
UI.headerInfo.typeNamePlural	Bank Accounts	view
UI.headerInfo.title.label	Bank Details ID	view
UI.headerInfo.title.value	BankIdentificationForEdit	view
VDM.viewType	#CONSUMPTION	view

Fields (30)

Key	Field	Source Table	Source Field
KEY	BankIdentification	I_BusinessPartnerBankTP	BankIdentification
KEY	BusinessPartner	I_BusinessPartnerBankTP	BusinessPartner
	BusinessPartnerForEdit	I_BusinessPartnerBankTP	BusinessPartnerForEdit
	BankIdentificationForEdit	I_BusinessPartnerBankTP	BankIdentificationForEdit
	BankCountryKey	I_BusinessPartnerBankTP	BankCountryKey
	BankNumber	I_BusinessPartnerBankTP	BankNumber
	BankName	I_BusinessPartnerBankTP	BankName
	BankControlKey	I_BusinessPartnerBankTP	BankControlKey
	BankAccountHolderName	I_BusinessPartnerBankTP	BankAccountHolderName
	BankAccountName	I_BusinessPartnerBankTP	BankAccountName
	IBAN	I_BusinessPartnerBankTP	IBAN
	IBANValidityStartDate	I_BusinessPartnerBankTP	IBANValidityStartDate
	BankAccount	I_BusinessPartnerBankTP	BankAccount
	BankValidityStartDate	I_BusinessPartnerBankTP	BankValidityStartDate
	BankValidityEndDate	I_BusinessPartnerBankTP	BankValidityEndDate
	BankAccountReferenceText	I_BusinessPartnerBankTP	BankAccountReferenceText
	CollectionAuthInd	I_BusinessPartnerBankTP	CollectionAuthInd
	BPBankIsProtected	I_BusinessPartnerBankTP	BPBankIsProtected
	SWIFTCode	I_BusinessPartnerBankTP	SWIFTCode
	PaymentSystem	I_BusinessPartnerBankTP	PaymentSystem
	AliasType	I_BusinessPartnerBankTP	AliasType
	BPBankAccountAliasName	I_BusinessPartnerBankTP	BPBankAccountAliasName
	PaymentSystemText	_PaymentSystemVH	PaymentSystemText
	AliasTypeText	_AliasTypeVH	AliasTypeText
	_BusinessPartnerSupplier		_BusinessPartnerSupplier
	_BusinessPartnerCustomer		_BusinessPartnerCustomer
	_BusinessPartner		_BusinessPartner
	_BankCountryText		_BankCountryText
	_PaymentSystemVH		_PaymentSystemVH
	_AliasTypeVH		_AliasTypeVH

@AbapCatalog.sqlViewName: 'CBUPABANK'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Bank Consumption View'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: ['BusinessPartner','BankIdentificationForEdit' ],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@UI.headerInfo:{
  typeName: 'Bank Account',
  typeNamePlural: 'Bank Accounts',
  title:  { label:'Bank Details ID', value: 'BankIdentificationForEdit' }
  }

@VDM.viewType: #CONSUMPTION

define view C_BusinessPartnerBank
  as select from I_BusinessPartnerBankTP as BusinessPartnerBank
  
  association [1..1] to C_BusinessPartner         as _BusinessPartner         on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  
  association [1..1] to C_BusinessPartnerSupplier as _BusinessPartnerSupplier on $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
  
  association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
  
  association [0..*] to C_Countrytextvhtemp       as _BankCountryText         on $projection.BankCountryKey = _BankCountryText.Country
  
//  association [1..1] to I_Bank_Acct_VH            as _BankNumber              on $projection.BankNumber     = _BankNumber.BankInternalID

//                                                                            and $projection.BankCountryKey = _BankNumber.BankCountry


 association [1..1] to I_PaymentSystemValueHelp      as _PaymentSystemVH         on $projection. PaymentSystem = _PaymentSystemVH. PaymentSystem
 
 association [1..1] to I_PaytSystToAliasTypeValueHelp      as _AliasTypeVH    on $projection.PaymentSystem = _AliasTypeVH.PaymentSystem
                                                                              and $projection.AliasType = _AliasTypeVH.AliasType
{
  key BusinessPartnerBank.BankIdentification,
  key BusinessPartnerBank.BusinessPartner,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BusinessPartnerForEdit,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'         
      BusinessPartnerBank.BankIdentificationForEdit, //not in old app but mandatory field for cvi

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.text.association: '_BankCountryText'
      BusinessPartnerBank.BankCountryKey,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    //  @ObjectModel.foreignKey.association: '_BankNumber'

      BusinessPartnerBank.BankNumber,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankName,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankControlKey,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccountHolderName,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccountName,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.IBAN,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.IBANValidityStartDate,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccount,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankValidityStartDate,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankValidityEndDate,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccountReferenceText,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.CollectionAuthInd,
      BusinessPartnerBank.BPBankIsProtected,
      BusinessPartnerBank.SWIFTCode,
      @ObjectModel.text.element: ['PaymentSystemText']
      BusinessPartnerBank.PaymentSystem,
      @ObjectModel.text.element: ['AliasTypeText']
      BusinessPartnerBank.AliasType,
      BusinessPartnerBank.BPBankAccountAliasName,
      @ObjectModel.readOnly: true
      _PaymentSystemVH.PaymentSystemText,
      @ObjectModel.readOnly: true
      _AliasTypeVH.AliasTypeText,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerSupplier,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,
      _BankCountryText,
      _PaymentSystemVH,
      _AliasTypeVH
//      _BankNumber

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERBANKTP",
"I_PAYMENTSYSTEMVALUEHELP",
"I_PAYTSYSTTOALIASTYPEVALUEHELP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER",
"C_COUNTRYTEXTVHTEMP",
"I_PAYMENTSYSTEMVALUEHELP",
"I_PAYTSYSTTOALIASTYPEVALUEHELP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_BusinessPartnerBank view

I_BusinessPartnerBankTP view