Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Offset for variable not working !


I have to show sales for last 5 months ( in 5 diff. Columns )

So, i have written CMOD code, where i am converting System date in to Fiscal Year / Period using FM DATE_TO_PERIOD_CONVERT.

every thing works good, i do get result. but the problem is the Offset for Variable function doesnt support that.

I was hoping that, Now i can do Offset -1, -2 , -3...till -5 and i will have all 5 Periods.

But looks like its not working out.

What other logic i can use.

!!!!!!!!!!My Variable is Not ready for Input !!!!!!!!!!! So the only way i found is to convert system date to current Period and then off setting it till last 5 months. And i do need to so last 5 months starting current Period -1, -2, -3, -4 and -5

is there any other way to get current Period ( i guess only from system date ).

I think in my logic, when i do offset, its not offsetting the Period, but its off setting system date.

Please help

Not what you were looking for? View more on this topic or Ask a question