How to identify active vendors and customers in a company code?

[Former Member]

Hello everybody,

I have to identify the vendors and customers who have been active since the last two fiscal years in a certain company code for data migration purpose. I have tried looking into LFB1 and KNB1 tables, I tried classifying based on "Company Code Post Block" or "Company Code Deletion Flag" fields but I am not sure about it. Any thoughts on this one? Thanks.

[bxiv · Accepted solution]

I think this would be a unique scenario for every company, as it is part of your Master Data; personally I would verify the active vendors with the Vendor Master team and have them remove/update the data so its no longer a problem to solve during a TDMS run.