Customers without sales in last 6 months by sales group

[Former Member]

How would you get the customers that had not placed an order in the last six months by sales group?

I was looking if in MCSI I could find something but no luck, I guess I will have to make a query on SQVI

Regards,

Carlos

[Former Member · Accepted solution]

You need to create a Z-Report or manually download data into excel and compare.

You need to sort out all customers based on sales group from table KNVV. Then check against orders created against those sales groups in last 6 months - the difference is te result.

There are two points to be taken care of -

1. All customers which was created in last 6 months but have not done any business - should be excluded from result

2. If sales group is put/changed manually in transaction (i.e. customer and sales order sales groupd are different) then the logic will not work properly - Sales group wise.

I had faced these problems in a similiar report, so just informing.

Thanks

[Former Member]

Thank you, the tables had the right values.

Regards,

Carlos

[Shiva_Ram]

Try t.code MC+E, which gives customer sales for a particular time period. If the sales show 0.00, then there is no sales was done for the customer in that period.

Regards,

[former_member693548]

Yes, you can query tables VBAK and VBPA to get the desired report.

Thanks,

Charan