Report for a partner function

[Former Member]

Hi all

I am looking for a report to show how much sales has happened because of a referal party.

In our sales order, we capture the details of the referal party. I have created a new partner funtion (say ZD and assigned partner type KU, i.e. customer) and the system is capturing all the details. Now I want a report where if I enter the refering party, the entire sales that has happened because of the refering party must come. I created a separate info-structure with "partner type" as one of the selecting options, but the sale was not reflected under the Referal party. I tried all my ways to check if the updating rules are not working but could not get it.

Please let me know if there are any standard reports or let me know if there are any better ways to capture this sales value

regards

[Former Member · Accepted solution]

Hi,

For geting the data as u desired ,U can make query by using and joining table VBPA and VBAK.

Use SQVI t-code for creating Query,.

Thanks,

Raja