Skip to Content
avatar image
-1
Hidayathulla Hasan

Customer Master data cleansing

Apr 28, 2017 at 06:05 AM | 224 Views | Last edit Oct 01, 2018 at 12:51 PM 2 rev.

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

Goods and Services Tax (GST India)
SD (Sales and Distribution) | lakshmipathi g
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Hidayathulla Hasan
    Apr 29, 2017 at 05:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Veselina Peykova
      Apr 29, 2017 at 06:43 AM

      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.

  • avatar image
    G Lakshmipathi
    Apr 29, 2017 at 11:32 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Hidayathulla Hasan
    Oct 01, 2018 at 11:04 AM

    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
    10|10000 characters needed characters exceeded