bank ledger accounts

[Former Member]

hi to experts !

we r paying cheques through 2 banks to our vendors .

now i want to know details of accounts . based on vendor .

whether the bank ledger accounts (like twobanks e.g ICICI and Citi bank) can be generated from SAP for the period sep 06 till date. inpuut data by end-user should be vendor name and fields required at output are date, vendor name, vendor code, amount, cheque no., narration.

1. Is some standard transaction available.

2. can it be done through sap query .

can u tell me in details like tables names and respective fields .

in SD we r using VAV during query . what be for FI .

[Former Member]

On a house bank master data, you should assign a GL account.

I would recommend that the different accounts have differnt GL accounts, so therefore you can report on them in standard finance through FS10N or FBL3N and so on.

Please award points if this is useful.