How to list customers per Employee responsible??

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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

Regards

[Former Member]

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.

[Former Member]

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

[Former Member]

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