sales employee target vs actual

[Former Member]

Hi

We have a requirement wherein we have to develop a report of sales employee target vs actual. That means in that report we will enter the sales target for each sales employee based on various criteria like product/customer/distribution channel wise and system should show the actual revenue generated against the target given to each sales employee.

[Former Member]

Dear Rohan

As said by members, you can achieve this via various ways. First you need to understand that is your customers comes under certain employee, if yes then you have to take a filed in your customer master and assign employee to their customers.

Now tell your ABAPER make a Z Table with fields Employee, Month, Target, etc etc whatever your requirement and save data here  and fallow this as a process.

Now on main thing Develop a Z Report and tell your ABAPER to loop at VBRP with material and  move to VBRK  with the help of VBELN and Select the customer and bring the Employee name from customer master, now you will have everything except for the target and achieved, for this tell ABAPER now bring the values from Z Table with compering Employee Name and hence all is done now, you have everything you required and make your report.

Thanking you!

Ashish Mishra

[Former Member]

Dear Ashish

Thanks a ton for your valuable solution

[suman_sardar2]

Hi Rohan,

Please avoid such query.It is like some is doing your work.Post such query where you got stuck and not clear to joining,data finding,SAP tables name or any standard customization.

This is not so difficult report you want to build.Therefore,I request you to talk to your ABAPer and give him such logic like fetching Sales data from SAP SD tables and some Ztable to store the Target sale for an employee.

Hope you got my view.

If you have any issue then definitely post it but search it before posting any query.

Thanks,

Suman

[Former Member]

Hi Rohan ,

I agree with suman. When you have such requirement, always propose your solution too as you know your clients requirement better. Then it will be easy for the forum members to give suggestions or guidance to meet your requirement in a efficient way.

For your above query, there are n numbers of way to acheive it and but only you know the limitations of the your client.

Regards

Vinu