I_CUSTOMERBANKDETAILS

CDS View

Customer Bank Details Core

I_CUSTOMERBANKDETAILS is a CDS View in S/4HANA. Customer Bank Details Core. It contains 13 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 13 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_CustomerBankDetailsOP view from CONSUMPTION
C_NO_SAFTGenLedgerCustBankAcct view from CONSUMPTION SAF-T Norway GL Customer Bank Accounts
C_PaymentRequestCustomerVH view_entity inner CONSUMPTION Customer Value Help for Payment Request
C_PaytReqCustomerBankDetailVH view_entity from CONSUMPTION Customer Bnk Details for Payt Request VH
C_RO_SAFTCustomerBankAccount view from CONSUMPTION RO SAFT Customer Bank Account Details
FAC_Audit_Z3_Customer_Bank view left_outer Customer Bank Data
FI_F4_BVTYP_KNBK view from Only for usage in function module FI_F4_BVTYP
I_CustomerBankDetailsVH view from COMPOSITE Customer bank details
I_RO_SAFTBankAccountDetails view from COMPOSITE RO SAFT Bank Account Details
I_SAFTBankAccountDetails view from COMPOSITE SAFT Bank Account Details
P_CN_GoldenTaxCustomerBank view from COMPOSITE
P_CN_GoldenTaxCustomerBankAgg view from COMPOSITE
P_CustomerSupplierBankDetail view_entity from COMPOSITE Bank Detail for Customer and Supplier

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Bank Bank 9
KEY BankAccount BankAccount 9
KEY BankCountry BankCountry 8
KEY BPBankAccountInternalID BPBankAccountInternalID 2
KEY BusinessPartner BusinessPartner 2
KEY Customer BusinessPartnerNumber,Customer,CustomerNum 6
_BankAccount _BankAccount 1
_Country _Country 1
_Customer _Customer 2
BankAccountHolderName BankAccountHolderName 6
BankControlKey BankControlKey 5
BankDetailReference BankDetailReference 4
BPBankUUID BPBankUUID 1 
@AbapCatalog.sqlViewName: 'ICUSTOMERBANK'
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customer Bank Details Core'
@ObjectModel.representativeKey: 'Bank'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: '_Customer.IsBusinessPurposeCompleted'
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
define view I_CustomerBankDetails
  as select from knbk

  association [1..1] to I_Bank                     as _Bank                     on  $projection.BankCountry = _Bank.BankCountry
                                                                                and $projection.Bank        = _Bank.BankInternalID

  association [1..1] to I_BusinessPartnerBank      as _BusinessPartnerBank      on  $projection.BusinessPartner = _BusinessPartnerBank.BusinessPartner
                                                                                and $projection.BankCountry     = _BusinessPartnerBank.BankCountryKey
                                                                                and $projection.Bank            = _BusinessPartnerBank.BankNumber
                                                                                and $projection.BankAccount     = _BusinessPartnerBank.BankAccount

  association [1..1] to I_Customer                 as _Customer                 on  $projection.Customer = _Customer.Customer

  association [1..1] to I_Country                  as _Country                  on  $projection.BankCountry = _Country.Country

  association [1..1] to I_BankAccount              as _BankAccount              on  $projection.BankAccount = _BankAccount.BankAccountInternalID //Added to remove representative key ATC, DO NOT USE

  association [1..1] to I_BusinessPartnerBankAlias as _BusinessPartnerBankAlias on  $projection.BPBankUUID = _BusinessPartnerBankAlias.BPBankUUID
{
      @ObjectModel.foreignKey.association: '_Customer'
  key kunnr                                                                        as Customer,
      @ObjectModel.foreignKey.association: '_Country'
  key banks                                                                        as BankCountry,
      //@ObjectModel.text.element: 'BankName'

  key bankl                                                                        as Bank,
      @ObjectModel.foreignKey.association: '_BankAccount'
  key bankn                                                                        as BankAccount,
      koinh                                                                        as BankAccountHolderName,
      bkont                                                                        as BankControlKey,
      bvtyp                                                                        as BPBankAccountInternalID,
      bkref                                                                        as BankDetailReference,
      xezer                                                                        as CollectionAuthInd,
      _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner        as BusinessPartner,
      // Commented As a part of Whitelisting Kindly Use _Bank Association and the corresponding fields

      //   _Bank.CityName  as CityName,

      //   _Bank.BankName  as BankName,

      //   _Bank.SWIFTCode as SWIFTCode,

      bank_guid                                                                    as BPBankUUID,
      _Bank,
      _Country,
      _Customer.AuthorizationGroup,
      _Customer,
      @API.element.releaseState: #DEPRECATED
      _BankAccount,
      _BusinessPartnerBank,
      _BusinessPartnerBankAlias
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"KNBK"
],
"ASSOCIATED":
[
"I_BANK",
"I_BANKACCOUNT",
"I_BUSINESSPARTNERBANK",
"I_BUSINESSPARTNERBANKALIAS",
"I_COUNTRY",
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More