Skip to Content
author's profile photo
Former Member

How to list customers per Employee responsible??

Dear all,

I want to create a report (Query) which has to list employee wise customers.

I have taken KNA1 and KNVP tables.

Query has been prepared, but when I try using employee responsible number in selection field system showing 'No data available'.

But in our data base we are maintaining ER to all of our customers.

Please help me to resolve this issue. Your suggestions will be highly appreciated.

Best regards

Raghu ram

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • author's profile photo
    Former Member
    Sep 03, 2008 at 09:08 AM

    Hi,

    you could have opened this in

    I guess the problem is due to online translation of the partner function.

    Whatever you see in transaction XD03 for the partner function is not necessarly what is stored on the database.

    Maybe you could have a look to table TPAUM which handle the online translation of the partner functions.

    Employee responsible is displayed in english as ER inthe transactions but on the database it seems to be ZM !

    Alternatively you may have made a mistake in the selection itself. The customer number that owns your partner function is stored in KNVP-KUNNR.

    But the link to the employee responsible is in KNVP-PERNR.

    Hope this helps

    Alain

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 03, 2008 at 09:13 AM

    Hi,

    If you create a query with KNA1 & KNVP, SAP assign these 2 tables with the bad field :

    KNA1-KUNNR <--> KNVP-KUNN2.

    Then, you can change the default link and use the right link :

    KNA1-KUNNR <--> KNVP-KUNNR.

    Regards,

    Lionel

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 03, 2008 at 10:05 AM

    Hi,

    For you requirement KNVP table is enough.You can give the name of the customer in the field KNVP-KUNNR and partner function is ER then you will get the employee responsible in the field KNVP-PERNR.

    Thanks,

    radha.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 03, 2008 at 10:30 AM

    hi

    TRY with report RVKUSTA1 and u will get all the PARTNERS assgined to customer

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 05, 2008 at 11:18 AM

    Hi,

    Use T.code VC/1.

    Enter sales area, go to Information Block segment uncheck the all blocks except partner functions and press execute.

    Regards,

    Chandra

    Add comment
    10|10000 characters needed characters exceeded