cancel
Showing results for 
Search instead for 
Did you mean: 

I need your suggestion to implement the TMVL function

Former Member
0 Kudos
101

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.

View Entire Topic
former_member186498
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

Hi Krishna,

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

former_member186498
Active Contributor
0 Kudos

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