Skip to Content
Author's profile photo joan mas

A Pricing Analysis Tool

Hi,

There’s a standard pricing analysis tool, report RV61A_ANALYSEREPORTS_PRICING or transaction code PRCAT, hidden… but available to be used.

Let’s have an overview to the most interesting options, last three ones.

1.JPG

RV61A GETFORMULAS is useful to get conditions and formulas a sales document used. We can use restrictions (customized formulas / all formulas,
used conditions / all in pricing procedure, with / without subtotals).

Document number entry must be filled with leading zeroes. Once run we have similar info as when checking document’s pricing procedure

2.JPG

Selecting all conditions we’ll get actual conditions defined in the pricing procedure the document is using.

Columns KOBED, KOFRM and KOFRA show routines from VOFM. As a reminder,

In KOBED we have pricing requirements routines LV61Annn and RV61Annn

In KOFRM we have condition value formulas FV64Annn and RV64Annn

In KOFRA we have condition base value routines FV63Annn and RV63Annn

Once we know what routines our document used, we can move to next option…

RV61A USEREXITS and Formulas / conditions defined in VOFM

In this option we can see, in 2 different tabs, active / inactive user exits, with their coding, and formulas / conditions defined in VOFM.

 

Formulas/Condition

3.JPG

We can select copy requirements, data transfer, requirements and formulas.

In GETFORMULAS previous screenshot example we saw following info:

– in column KOBED (pricing requirements)  routines 2, 9 and 10.

In column KOFRM (condition value formulas) routines 14, 18 and 48

In column KOFRA (condition base value) routine 16

Then in order to see what coding was used we would select

4.JPG

And then chose evaluate all conditions and formulas in next screen (there’s a problem with input format and this option seems the only one working) and execute to display source code:

5.JPG

In this case, I’ve select price requirement routine 2

6.JPG

User exits

7.JPG

Select the ones you want to check, and in next screen you’ll see which ones are active / inactive. Select and execute to see the source code. For example user exit RV61AFZA form userexit_pricing_rule which is inactive (0 lines active):

8.JPG

Last option is also interesting…

RV61A compare KONV, T683S and T685A.

This is a comparison among tables KONV (conditions), T683S (pricing procedure data) and T685A (additional price elements).

When running this option, SAP will display differences found between the document price procedure used when creating the document and actual pricing procedure,  showing the differences found.

The following fields are checked:

KSTAT statistical condition, KVSL1 Account key, KVSL2 Accrual account key, KDUPL Struct. Condition,

KFKIV Intercompany billing, KGRPE Group condition, KNTYP Condition category, KOAID Condition class,

KOUPD Condition update, KRECH Calculation type, KRELI Invoice type condition, KRUEK Accruals,

KTREL Rel. for acct assigt, KVARC Variant condition, KZBZG Scale basis, MDLFG Matrix maintenance

Unfortunately it is not checked if a condition existing in the sales document is not anymore in the actual pricing procedure (fortunately it is easy to find out).

Enjoy.

Regards,

JM

           

Assigned Tags

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

      Nice document JM !!

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Jay,

      Regards,

      JM

      Author's profile photo Dipranjan Khanra
      Dipranjan Khanra

      Hi Joan,

      Excellent document, thanks.

      Regards

      Deep

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Deep,

      Regards,

      JM

      Author's profile photo venu gopal
      venu gopal

      Dear But i am not able to open by T.code and report wise also plz let me know

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Hi Venu,

      please check if standard report RV61A_ANALYSEREPORTS_PRICING is available (t.code SE38). I don't know which SAP version you're using but this report seems to exists already in ECC5 SAP version. Also check if there's not restrictions by authorizations.

      Regards,

      JM

      Author's profile photo venu gopal
      venu gopal

      Dear haaa it is working in Real time servers but in ides i have checked  and i got it now

      ok thanks a lot

      Author's profile photo Former Member
      Former Member

      Interesting, thanks for sharing!

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Hussain

      Author's profile photo Jignesh Mehta
      Jignesh Mehta

      Interesting document Joan. Never new of this facility.

      Thank you for the enlightenment.

      Regards,

      Jignesh Mehta

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Jignesh

      Author's profile photo Keyur Mistry
      Keyur Mistry

      Everything new for me.

      New learning.

      Thank you very much Joan Mas.

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Keyur

      Author's profile photo Siva Prasad V
      Siva Prasad V

      Hi joan,

      iam completly new to this contribution.

      Thanks for sharing

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Siva

      Author's profile photo Former Member
      Former Member

      Thanks..

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Naresh

      Author's profile photo Former Member
      Former Member

      Thanks for sharing!

      Good job.

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Raul for your comment,

      JM

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      This is new thing for me as well but I dont see it that useful for me at least. What usage do you guys have from this report?

      Thank$

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Hi MoazzaM,

      usefulness will depend on your expertise... I found it worthy, specially points 3 to 5, when you have several customers each with their own pricing and you need a tool that shows pricing information in a single place for a quick view or starting point.

      Regards,

      JM

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi Jaons

      Yes you are right. It depends on our own need. I have noticed that we can't give multiple document numbers in it. Is it same with you?

      Thank$

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Hi MoazzaM,

      yes, it´s the same for me.

      Regards,

      JM

      Author's profile photo Neeraj Lal
      Neeraj Lal

      Interesting ............ keep posting

      Author's profile photo joan mas
      joan mas
      Blog Post Author

      Thanks Neeraj for your comments