Skip to Content

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

           

To report this post you need to login first.

25 Comments

You must be Logged on to comment or reply to a post.

    1. joan mas 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

      (0) 
    1. joan mas 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

      (0) 
      1. ' 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$

        (0) 

Leave a Reply