I would like to find a report refers to vendors those are not having bank a/c details on their master records. I don't think there is a direct transaction code to achieve this. Do you guys any idea??
This is an interesting question! I tried several tcodes but fail to achieve. However if you have time, I suggest you to give a try with one material, you may find something useful in it: http://goo.gl/AW8AP.
There may not be a report for the requirement specified. One thing you can do is to get the vendors who have bank details from table LFBK and create a list from LFA1 using the LFBK list.
You can download the list of Vendors in your company code from table LFB1. Goto Transaction SE16. In the company code field give your company code. Remove the maximum number of hits(by default 200) & execute.
Similarly you will have to extract the data for the Bank Accounts from the table LFBK.
Down these two tables data in Excel & with the help of VLOOKUP Function you can find out for which endors you have not maintained the Bank Accounts.
I tried with LFBK with one vendor who does not have bank details and executed.
But does not work.
Can anyone suggest how to get the report.
I have a scenario to get the report to see the vendors who does not have bank details.
I tried with LFA1,LFB1 to find the vendors who does not have bank details in that list.But the list is showing only the vendors who are having bank details only.It is not showing the vendors who does not have bank details(which I want this).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.