03-13-2008 7:05 AM
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,
03-13-2008 7:15 AM
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.
03-13-2008 7:15 AM
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.
03-19-2008 5:52 AM
Hi,
Thanks for your reply.
but I did not found bwkey in BKPF.
Any suggestions...
Thanks
03-19-2008 7:07 AM
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
03-13-2008 7:55 AM
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
03-19-2008 6:07 AM
Hi ,
awkey is defined as an Object Key in BKPF.
Pls reward if helpful...!!!
03-19-2008 7:15 AM
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
05-27-2008 9:10 AM