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).

[Former Member]

Hi,

You can use SQVI tool for above report.

YOu can join two tables VBRK and VBPA and fetch required fields.

From tabel VBRK you can get Sold to party , using sold to party field in table VBPA you can get details about Employee.

Rajesh

[Former Member]

A 'Z' report requires to be developed in Abap, to meet the requirement. Nothing availble for same in Standard.

Regards,

Rajesh Banka