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.
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
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
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
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:
In this case, I’ve select price requirement routine 2
User exits
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):
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
Nice document JM !!
Thanks Jay,
Regards,
JM
Hi Joan,
Excellent document, thanks.
Regards
Deep
Thanks Deep,
Regards,
JM
Dear But i am not able to open by T.code and report wise also plz let me know
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
Dear haaa it is working in Real time servers but in ides i have checked and i got it now
ok thanks a lot
Interesting, thanks for sharing!
Thanks Hussain
Interesting document Joan. Never new of this facility.
Thank you for the enlightenment.
Regards,
Jignesh Mehta
Thanks Jignesh
Everything new for me.
New learning.
Thank you very much Joan Mas.
Thanks Keyur
Hi joan,
iam completly new to this contribution.
Thanks for sharing
Thanks Siva
Thanks..
Thanks Naresh
Thanks for sharing!
Good job.
Thanks Raul for your comment,
JM
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$
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
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$
Hi MoazzaM,
yes, it´s the same for me.
Regards,
JM
Interesting ............ keep posting
Thanks Neeraj for your comments