Skip to Content
0
Sep 15, 2014 at 09:55 AM

Select statement using mathematical operator on property

64 Views

Hi,

In EHP7 FOR SAP ERP 6.0, JavaScript engine, I have this select statement to retrieve current year:

*SELECT(%ACT_YEAR%, "YEAR","CATEGORY", "[ID] = 'ACTUAL'")


Now I'd like to create a select statement that uses the Year property for Category Actual to find next year, i.e. something like this (not working):

*SELECT(%ACT_YEAR_1%, "YEAR","CATEGORY", "([ID] = 'ACTUAL') +1 ")

What would be the syntax?

Thanks,

Cecilia