cancel
Showing results for 
Search instead for 
Did you mean: 

SEM BCS - Validation Rule

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

I am sorry, but I am German and I don't use the english frontend. What is RE?

revenue?

Former Member
0 Kudos

RE = retained earnings. It's the cumulative value of net (non-distributed) profit in balance sheet.

Message was edited by:

Eugene Khusainov

Answers (1)

Answers (1)

dan_sullivan
Active Contributor
0 Kudos

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.