How to find out Inactive customers

[Former Member]

Hi,

I have a report which shows the customers detail. But I have to filter out the customers who are inactive that having no orders for the last 2 years.

How to find those customers and filter out in the report?

Thanks,

Ezhil.

[former_member224404]

Hi,

Can you please clarify in more detail. And I think a Functional Consultant in your team will be the best person to tell you what exactly you have to do. Besides, are you talking about sales orders when you are saying orders. If that's true then is it your requirement that filter out those customers who is not sold-to-party for all the sales order created in last 2 years?

In that case, you can simply implement this by querying on corresponding DB table.

Thanks,

Mainak

[former_member196079]

Hi Ezhilhrh

Select orders from vbak with the kunnr = customer number...

if the orders selected are all older than 2 years you delete the customer number...

Regards

Marco

[Former Member]

Thank you...

i used VBAK table and deleted the customers who dont have order for past two years.

[Former Member]

HI Ezhilhrh,

you should check customer balances in table KNC1, too.

Regards

REA

[Former Member]

Look at table VAKPA. You could read this with the partner, partner type and AUDAT > your 2 year limit....