Bank details of invoice

[Former Member]

hi Experts ,

How can i get the bank details for a particullar invoice ,can u plese help me out with the neccasary tables, i know that bnka is the table for bank details ,how can i relate this with the invoice i have created

Thanks in Advance

[Former Member]

HI,

Once the invoice is processed for the payment, the bank details are get stored in PAYR table with ref to the payment document number. You can also get the check no. from this table.

Logic is like this:

From PAYR table get BUKRS (Company Code) and HBKID (House Bank Code) with input as VBLNR (Payment document no.)

Pass these values as inputs to Table T012 and get BANKS (country Key) and BANKL (Account ID)

Pass these values to BNKA table to get the bank details.

Thanks

VK