SAP query

[Former Member]

Hi,

I want to make a SAP query with Agent (partner function )as one of the selection criteria, and in the output to give Sales value in each Sales order where the Agent is attached.

A report which will give Sales Value/Qty by agent.

Was thinking of using

VBPA to get the partner - KNA1 to get the customer name and VBAK to get the net value.

But i cannot find a way to get the total qty in the SO.

1- Please let me know the ideal way to get this query done.

2- Please let me know how i can get the total SO net value.

thanks in advance,

[Former Member · Accepted solution]

Hi,

sales order net value will come from VBAK table. You can have join between VBPA and VBAK and then can have query as per your requirement.

Thanks,

Raja

[Former Member]

Hello,

Get the Customer Number from the VBAK-KUNNR with the Partner function PARVW of your agent.

Get the ADRNR number from the VBAK and then from VBPA you can get the Name and customer address.

For Sales quantity you have to get it from VBAP-KWEMG

Net order value is from VBAK-NETWR

Hope it is clear,

santosh

[Former Member]

try using VBAK and VBAP