Skip to Content

Customer Master data cleansing

Apr 28, 2017 at 06:05 AM


avatar image

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?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jelena Perfiljeva
Apr 28, 2017 at 04:40 PM

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.

10 |10000 characters needed characters left characters exceeded
Hidayathulla Hasan Apr 29, 2017 at 05:26 AM


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.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

G Lakshmipathi
Apr 29, 2017 at 11:32 AM

Try with S_ALR_87012186 where you have one check box "Accounts w/o sales"

10 |10000 characters needed characters left characters exceeded