on 08-14-2007 10:50 AM
Dear Gurus,
In validation rule, there are function like : "P_LC_YTD Cumulative Value in LC, Prior Yr/Period" , etc. Does anyone have some documentation about how to use those functions?I tried find it in the SAP.HELP, but no documentation about the functions.
Thanks in advance.
Hi u1u1,
check out this page and the following part of text on it:
<a href="http://help.sap.com/saphelp_sem60/helpdata/en/e5/f979e9c554a2489a659b06e696742f/frameset.htm">help.sap.com/...</a>
"If you use generic functions, such as VAL_YTD, VAL_PER, or P_VAL_YTD, the system uses you customizing settings for the currencies in the task to select values in either the local or group currency. That is, if necessary the system translates the values it finds into group currency."
The only thing I can tell you is the syntax:
AFAIK, P_LC_YTD is also an generic function. It says " P_LC_YTD( X1 , X2 , X3 )".
I put in those X for better understanding. So you have to put in your selection condition at X1, the amount of periods at X2 and the amount of accounting years at X3.
What it really does: no clue : ) Didn't use it yet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Benjamin,
Thank you for replying and for your link.
Regarding to P_LC_YTD(x1,x2,x3),
x1 = Selection
x2 = Periods
x3 = Year
Actually, I want to make a validation like this :
RE beginning current Year = (Net Income + RE beginning - RE transfer to reverse) from the last year.
But the x2 and x3 cannot maintain in selection/variable. They are maintained by constant value.
According to your experience, do you have any idea how to make a validation like above without using P_LC_YTD?
Thanks in advance.
With the VAL... you may choose the currency to be validated in the task configuration. This is the most flexible way to go.
With the LC... or GC... you are only validating that specific currency.
For your example I see no need for the P_VAL... to be used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.