on 02-17-2009 3:33 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to all, VC/2 information helped us
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.