I need your suggestion to implement the TMVL function

[Former Member]

Hi All,

         Earlier the values hard coded in the Lookup logics and need to change it and it will be work for ever. For this I have implemented TMVL functionality by following the below syntax. It validated successfully but when I have observe the log the values are not passed to the variable. Could you suggest me in this if any syntatical chages if required. And one more thing i.e variable decleration is possible for the datasrc, the categoey dimensions ?

LOGIC:

*LOOKUP TEST

*DIM CATEGORY = "BUDGET"

*DIM SALARY = SALARY_MI

*DIM DATASRC = INTEX

*RPTCURRENCY = LC

*ACCOUNT =  87647

*TIME = "%TIME_SET%"

*ENDLOOKUP

*WHEN CATEGORY.ID

*IS = "BUDGET"

*WHEN RPTCURRENCY

*IS = USD

*WHEN SALARY.ID

*IS SALARY_MI

*WHEN TIME

*IS %TIME_SET%

*REC(EXPRESSION =ROUND(0* LOOKUP(TEST),0),TIME=TMVL(0,%TIME_SET%),SALARY="SALARY_RATE",ACCOUNT= "475782")

*IS TMVL(+1,%TIME_SET%)

*REC(EXPRESSION=ROUND(0* LOOKUP(TEST),0),TIME=TMVL(+1,%TIME_SET%),SALARY="SALARY_RATE",ACCOUNT="475782")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

Thanks and Regards,

Krishan.

[former_member186498 · Accepted solution]

Hi Krishan

TMVL function didn't exists in MS, it's supported only on NW.

In MS version you must use the time-shift instructions, please see http://help.sap.com/saphelp_bpc75/helpdata/en/ce/89abe348e842c8a9e914b869effe24/content.htm

Kind regards

     Roberto

[Former Member · Accepted solution]

Hi Roberto,

                Let me know How to use the time-shift instructions because I am not aware of MS syntaxes much. In my logics how to capture the run time time value by placing %time_set% ?

How to increase or decrease the time period value with out using TMVL in MS verion ?

Could you share any logic similar to the above logic......

Thanks and regards,

Krishna.

[Former Member · Accepted solution]

Hi Krishna,

Please check the link shared by Roberto. That has all the information.

[former_member186498 · Accepted solution]

Hi Krishna,

with the %TIME_SET% you recive the value passed from a PROMPT function, instead of TMVL you must use the functions described in the link I've send you before, f.e. PRIOR and NEXT functions, in the link help there are some examples.

Kind regards

     Roberto