Skip to Content
Author's profile photo Former Member

Add partner function to standard report

Hi Friends,

Here i am trying to show you, how we add partner function to the standard report selection criteria.

Requirement : i want to run report to  generate  list of Quotations  with ship to party instead of Sold to party, but standard report VA25 have only partner function sold to party as selection field, now we want to enhance the VA25 report to include SH(Ship to party) as a selection criterion.

Now the system output:

  • Go to Tcode VA25 , Only sold to party selection field available.

1.JPG

   

  • Click on Partner function tab, a popup appear with select partner function.

2.JPG  

  • If you want to change the partner function(SP to SH) system will not allow and give warning massage.

3.JPG    

 

Configuration steps for retired output:

  • SPRO –> Sales& distribution –> Sales –> List –.> Set updating of partner index.
  • Go to new entry and select required transaction group ( in our we select 2- quotation) and save the record.

4.JPG

  • Go to Tcode VA25 and select partner function tab, now you should able to see partner function SH(Ship to party)

5.JPG

  • Now you should able to execute VA25 report with partner function SH.

6.JPG

  • But system will give the following massage, this is standard behaviour now we have to updating the historical data.

7.JPG

Updating the historical data:

 

Go to Tcode SE38 and enter program name “RVV05IVB”

  • Execute the programme .

9.JPG

  • Select the” partner index” filed in sales document and execute.

10.JPG

  • Now go to Tcode VA25 and enter ship to part name and execute, we will get the total historical report .

13.JPG

Hope you like my detailed explanation

If you still have any doubts or further clarification reuired , plz let me know.

Regards,

Patchala.

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Dear Patchala sir,, Thank you so much sharing This information ...It is very clear

      And Hats of To You for Detailed explanation Everybody will understand very very easily

      Keep it up sir .... 🙂   

      Author's profile photo Former Member
      Former Member

      Superb

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you venu .. 🙂 🙂

      Author's profile photo Typewriter TW
      Typewriter TW

      Patchala,

      Thank you!

      Below are few comments, questions; could you please reply to these?

      1. At quotation stage, why would an organization (Selling company) be interested in extracting a report based on ShipTo party?

      First, let the sale happen (i.e. creation of sales order), then this kind of analysis might be needed.

      2.

      program name “RVV05IVB”

      What is the this program?

      Does this only impact the t-code VA25?

      Or does it impact across (many) areas?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Tw,

      1) It`s not real business requirement which i faced , i just take one example standard table to explain better, so i used VA25 t code.

      2) please fine following link for program RVV05IVB

      http://scn.sap.com/message/8641302#8641302

      Regards,

      Rao.

      Author's profile photo Former Member
      Former Member

      very usefull doc

      Author's profile photo Lakshmipathi Ganesan
      Lakshmipathi Ganesan

      The logic has already been discussed in the forum for sale orders (VA05) and Billing (VF05).  Please try to provide some new information when you post as a blog.

      G. Lakshmipathi

      Author's profile photo Former Member
      Former Member

      Hi Patchala,

      Fantastic document it is. I liked it and bookmarked it.

      Regards,

      Venkat

      Author's profile photo Michael Turner
      Michael Turner

      Thank you!

      Author's profile photo Former Member
      Former Member

      gud one

      Author's profile photo Hidayathulla Hasan
      Hidayathulla Hasan

      Congrats for your efforts!!!!! But this has been discussed earlier in forum. My wishes with you. Keep sharing.

      Thank$

      Hidayath

      A Day Unlearnt is A Day Burnt.