on 2012 Dec 06 9:27 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
9 | |
5 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.