Skip to Content
avatar image
Former Member

How Can we see Employee wise sales records

Dear all,

Following to our business process, an employee is responsible for a group of customers.

Our client want to see employee wise quotations, relevant sales order, sales order value and Invoices in one report.

is there any standard report in SAP to suffice their requirement.

If not can we develop a query. if so, from which table we need to pick the data.

Please help me to resolve the issue, your suggestions will be highly appreciated.

thank you

Raghu Ram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 22, 2008 at 06:28 AM

    Hi Venu,

    Is their any identification mentioned in customer master data regarding the Employee responsible. Did u maintain that data in the sales group field in the customer sales area data.If so u can use the standard report to see the employee wise sales records.

    Regards,

    Ranjith

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 22, 2008 at 06:34 AM

    Hi,

    while creating sales order- employee numbe is mandatory?

    if yes, then you can track the sales orders in Table VBPA-

    by entering partner function.

    if not, you will lose the track of records.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2008 at 06:42 AM

    Hi,

    Check Report: MCTI

    Regs,

    Amit K. Yadav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2008 at 09:15 AM

    Hi

    You can check these reports..

    MCTI -Sales Employee Analysis

    MC(Q -Sales Employee, Incoming Orders

    MC-M -Sales Employee Returns

    MC-Q -Sales Employee Sales Volume

    MC-U -Sales Employee Credit Memos

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2008 at 10:07 AM

    In the header details of quotations, sales orders and invoices, there is an input field where you can give the name of the person who has created the same.

    In your case, if you have maintained the above said field for all the documents, then there is a method to view all the sales orders, quotations etc related to one particular employee. Following method shows how you can see the list of all sales orders created by an employee:

    T.Code: va05 (for seeing a list of sales orders)

    In the new screen that appears, give all the input data. After this, click on the tab: "Further Selection Criteria". Check the option "Created by", and give the name/id of the employee. Click enter and the data will get saved. Now click enter on the main page in order to get the list of sales orders pertaining to that employee.

    Similarly, you can get a list of invoices, quotations etc.

    Hope this proves useful.

    Please reward points if it helps.

    Regards,

    Swapna

    Add comment
    10|10000 characters needed characters exceeded