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: 

need tables for bank details of an invoice

Former Member
0 Kudos

Hi All,

We have generated and invoice for our project payments to the customer.

then once the money received from customer we have done the financial posting in the FI.

Now we haev an report for invoice. but agaist the invoice number I have to show the bank details of that invoice payment . i mean which bank account G/L account.

Pls suggest the tables abd relation how do I use it

I have some idea about BSAD, BSED, BSIS, but I am not able to link it.

Points will be rewarded.

thanks,

1 ACCEPTED SOLUTION

Former Member
0 Kudos

For Details like Bank Account no Bank Name etc you hav to take the details from Customer Bank Details which is in XD03. the tables are KNBK and BNKA. try it

For GL Account datails U have to go to FI.

Pass the Invoice No to bwkey of table BKPF and take the document No from BKPF.

Pass the Document No to BSEG table u ll get the GL account from field HKONT.

For taking the details From BSIS and BSAS u can pass the Document No to the table same as BSEG.

7 REPLIES 7

Former Member
0 Kudos

For Details like Bank Account no Bank Name etc you hav to take the details from Customer Bank Details which is in XD03. the tables are KNBK and BNKA. try it

For GL Account datails U have to go to FI.

Pass the Invoice No to bwkey of table BKPF and take the document No from BKPF.

Pass the Document No to BSEG table u ll get the GL account from field HKONT.

For taking the details From BSIS and BSAS u can pass the Document No to the table same as BSEG.

0 Kudos

Hi,

Thanks for your reply.

but I did not found bwkey in BKPF.

Any suggestions...

Thanks

0 Kudos

Hi,

I have check the way you have told.

But still it is not giving the bank details.

G/L account which I got is for Sundry debtors account. and for all it is same.

I am not getting the G/L account for which bank.

Pls suggest

Points has and will be rewarded

Thanks

raymond_giuseppi
Active Contributor
0 Kudos

First find the invoice in accounting

Direct if invoice was directlly posted in FI, if posted through SD, look BKPF for records with AWTYP = 'VBRK' and AWKEY = invoice number.

(You could also use SD document flow)

In this document; look for the customer line

Look in BSEG or BSAD (BSAD as we suppose the item is cleared when paid) (same BUKRS, GHJAR and BELNR and account type is Customer KOART = 'D' debitor)

Look for clearing document

From this item, we look for the clearing document (BELNR = BSEG-AUGBL)

Look for bank account item

Look in BSEG with account type KOART ne 'D'

Look for bank detail

Look at SKB1 for the account, the fields HKBID defines the bank and HKTID the account, look then in table T012, T012K for informations

Regards

Former Member
0 Kudos

Hi ,

awkey is defined as an Object Key in BKPF.

Pls reward if helpful...!!!

Former Member
0 Kudos

you need to know that GL is related to bank or not..right..

check FS00 -> third tab -> Create/bank/interest

There are some assignment field for GL if it is related to bank.

Once you come to know that GL is related with bank then filter that Line item and display in your report..

Raj

Former Member
0 Kudos

.