1. Get a clear definition of what "not used" means.
2. Let SAP do the work - instead of "downloading" the data you can just create a query with LEFT JOIN from KNA1 that will show where no matching records exist in the other table(s). Criteria should be based on p.1 above.
VBAK-KUNNR only covers Sold-to partners, there are many more places where customer account is used. Get a qualified SD consultant to assist with this.
Hi,
Not used means- they just created a customer and stop doing business since one year with them or never done any transaction(business) with them.
We have got list of customers through FI report which shows that zero receivables and payables. so we came to an understanding that, this customers didn't had any transaction from past one year.
Thanks
Hidayath
Try with S_ALR_87012186 where you have one check box "Accounts w/o sales"
Hey Veselina Peykova,
Though it is a old thread, wish to give the complete scenario and want to close the thread.
our client was into diary business and As per GOI(Govt of India) new taxation rules. they need to file the tax on monthly basis.
They were few middle ware companies(GST suvida) which will connect SAP system to GOI GST system.
The middle ware companies were quoting based on number of customers. client requested to cleanse the master data so that they can give exact number of customers.
Thanks
Hidayath
Add comment