on 12-30-2014 3:36 PM
Dear All,
I have a requirement to calculate the Prior month.
I have a Manual Input Varialbe (Example 07.2014 - 09-2014) we have written the below logic in customer exit.
The logic is working fine but output is not coming correctly..
for the month 07.2014 it is giving same value which is there in current sales.
CalMonth Current sales Prior Sales
1234
07.2014 2345 2345
08.2014 3456 3456
09.2014 4567
But I need output as below.
CalMonth Current sales Prior Sales
07.2014 2345 1234
08.2014 3456 2345
09.2014 4567 3456.
I can try for offset but problem is if my selection is January. So please suggest if any one come accorss the sme situation.
FORM *****_002
TABLES I_T_VAR_RANGE TYPE rrs0_t_var_range
e_t_range TYPE rsr_t_rangesid
USING i_vnam LIKE rszglobv-vnam i_step TYPE i.
DATA : l_s_range TYPE rsr_s_rangesid,
loc_var_range TYPE rrrangeexit
data: p1(4) TYPE n,
p2(2) TYPEn,
p3(6) TYPE n,
p4(4) type n,
p5(2)TYPE n,
p6(6) TYPEn.
READ TABLE i_t_var_range INTO loc_var_range WITH KEY vnam = '******_001'.
p1 = loc_var_range-low+0(4).
p2 = loc_var_range-low+4(2).
p4 = loc_var_range-high+0(4).
p5 = loc_var_range-high+4(2).
if p2 = '01'.
p2 = '12'.
p1 = p1 - 1.
ELSEIF p2 ne '01'.
p2 = p2 - 1.
ENDIF.
CONCATENATE p1 p2 INTO p3.
if p5 = '01'.
p4 = p4 - 1.
p5 = '12'.
ELSEIF p5 ne '01'.
p5 = p5 - 1.
ENDIF.
CONCATENATE p4 p5 INTO p6.
if sy-subrc = 0 .
l_s_range-low = p3.
l_s_range-high = p6.
l_s_range-sign = 'I'.
l_s_range-opt = 'EQ'.
APPEND l_s_range TO e_t_range.
ENDIF.
ENDFORM.
Let me know if you need more details.....
Thanks,
Areef
Hi Areef,
Have you tried changing:
l_s_range-opt = 'EQ'.
to
l_s_range-opt = 'BT'.
I think it could work. Other than that I don't see any issue with your code.
Thanks
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Areef,
The easiest way is to try out Off Setting...Variable-ZCALMONTH..-1,-2,-3....
Its flexible also..and can be changed easily as per needs.
rgds
SVU
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you all for the Inputs,
There are 2 problems,
1. We are usng Camonth Range Variable for which the offset will not work correctly and also with offset the problem will be during the CALMONTH="01" so we caqn not use this.
User want Range of Variable.
2. If we want Prior Calculated and to be populated at the same line then query designer should be static not dinamic for each month we need to have conditional keyfigure which will work according to the Month,
Work Around: We have requested client to execute the report for only one month and not to put Camonth in Rows which will show all the data in single line.
Hi Areef,
Make sure all your variables used are correct, like "vnam = '******_001'", are you sure is this your manual entry variable?
Other than that your code look good.
Also, as Amit suggested try 2 use Offset.
Thanks,
Shreya J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.