Report for a group of customers

[Former Member]

Hi gurus,

we have categorised our customers as x, y and z in customer classification.

We have some customers who fall under x category and y category and z category, no we want a report which shows their order values and invoiced values for a period of time. in mcta we are not able to add customer classification as selection field. in report we want customer classification to be shown so that we can change their categories according to their invoiced values.

if there is an option in standard report or if i have to write a query what tables are best to get information for a particular customer. please advise gurus and thanks in advance.

Cheers,

Nathan.

[former_member204513 · Accepted solution]

Dear Nathan,

Try with this option

Go to VC/2 transaction then click on Dynamic selection Icon or press Shift+F4 now system will take you to the additional selection data.

-->General data in customer master

-->Customer contact person

-->Customer master partner functions

-->Customer master sales data

Here you go in to the Customer master sales data you double click on ABC Classification now field come to the right side under Dynamic selections tab here you can input customer classification related data then execute now system will give sales report with customer classification details.

I hope this will help you,

Regards,

Murali.

[Former Member]

Thanks to all, VC/2 information helped us

[Former Member]

Hi murali,

I am not able to see the field customer classification in sales documents, is there anything that we can maintain in configuration or any enhancement further to be needed.

Thank you,

Cheers.

Nathan

[reazuddin_md]

Follow the procedure as suggested by AMIT.

You can view Customer Sales analysis.

But , it wont serve your purpose,

as per your req- you need to maintian Customer group -1 field in all CMR's who falls into same group.

N you can retrieve records from SE16-KNVV,

to provide the same to the customer , u need to write a query with this table.

[Former Member]

Hi murali,

Thank you, but when i execute i am getting an error msg saying '' no view can be determined for RVCUSTA1 for user---''

Can you advise me how to proceed further, thank you.

Edited by: nathan jones on Feb 17, 2009 7:07 AM

[former_member204513]

Dear Nathan,

This may due authorisation take help of BASIS people.

Make sure you have maintained customer classification in your customer master and same data come to your sales documents.

I hope this will help you,

Regards,

Murali.

[Former Member]

Dear Nathan,

Path: SPRO --> IMG ---> Sales and Distribution --> Sales Support --> Sales Summary --> Assign default view to user

Assign a reporting view (say, 001 - Complete Information) for that user name.

I hope, your isue will get resolved.

Best Regards,

Amit