Hi All,
As a part of GST Implementation, customer has requested the customer master cleansing.
* There is no customer master data duplication. so we don't need to bother about this.
* We have around 1.75 lacs customers and now customer is saying that, there are some customers, which are not in used.
I have done so far,
1. downloaded the dump from VBAK-KUNNR
2. Downloaded the dump from KNA1
3. data compare between these two dumps.
As the data is very huge, I'm not sure i will get the desired result.
Can anyone throw some light, how to achieve?
Thanks
Hidayath
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
I hope, that you consider, that customers could be ship-tos or bill-tos for example (Jelena tried to hint this in her answer already). In both of your reports these will not be shown, but it does not mean, that they are not needed.
Try with S_ALR_87012186 where you have one check box "Accounts w/o sales"