Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Bank Details from Accounting Document

0 Kudos

How to Get bank details(BNKA) and customer bank details(KNBK) table from accounting document number of bkpf-belnr field.

2 REPLIES 2

mmcisme1
Active Contributor
0 Kudos

How I would normally go about this is go into the table itself - click on the data element and do a where-used. It will come up with a list of the tables that it is used in. Now you can search for what type of table you want.

You'll be a able to use BSID or BSAD and belnr. That will get you the customer to use with KNBK (Kunnr). The banking information is in those tables as well.

raymond_giuseppi
Active Contributor
0 Kudos

What is your exact requirement, which bank account: house bank, partner bank, it depends on your actual requirement and your Customizing of Bank Accounting, check with functionals.

e.g. from an account GL number related to bank accounting :

  • Look at the account number in the document (BSEG-HKONT) if related to a bank you should be able to link it to a house bank and accounts, look at tables T012K and BNKA. In some case, look at Customizing of Electronic Bank Statement, you could have to reverse the coding rule which generated the GL account number, look at table T033G.
  • If you are looking for bank account of a partner (vendor/customer) you may be required to navigate from FI document to bank statement, join with table FEBE and available documents linked depending on you Bank solution.

But AFAIK you may require (one of) the bank(s) of the customer or the bank written on an invoice, etc.