Sales Employee Details Based on Invoice

[Former Member]

Hi,

Based on Invoices i need to bring the sales employee details.

sales employee is present in Sales Order as Partner Function.

can any one help me on this.

[Former Member · Accepted solution]

Hi,

if sales employee is present in the order i guess he is also available on the invoice. I think the sales employee details are found in PA0001 table. Try to see if a link can be established between the partner functions KNVP and VBRK with which you can pull a report of invoices based on sales empl(PERNR).

regards

sadhu kishore

[Former Member]

Hi

Presuming that u are looking at a report, I am suggesting this solution.

The billing document will have the sales order number, and based on that go to the partner functions and pull in the sales employee.

Hope this helps.

Kind Regards

Chakradhar