on 2007 Mar 13 5:08 AM
Material Price on 0calday priceas Qty Difference
31stMarch on
1 5.00 1/2/07 5.50 2 5.00-5.50=-0.50
2/2/07 3.50 3
8/2/07 8.50 5
I have a requirement where if the user enters in the selection screen 02.2007 then the price of the material ahouls be compared with 31st march of previous year , in th e above example the price of the material changes 3 times & even it should show me the qty of material ordered for this material in the month 02.2007
For this I have created 1 custometexit variable for 0calday ( for 31st March data)
& created restricted keyfigure & in this I kept the keyfigure Netprice & 0calday restricted with customerexit variable
& I have created variable for 0calmonth/year if processing type manual entry/default value & created restricted keyfigure & in this I kept the keyfigure Netprice & 0calmonth/year restricted with variable manual entry/default value
& written the following code
If the user does not enter any value then it should compare 31st march data with all the months data
I have placed material, 0calday in rows . restricted keyfigures in cols
When I enter some value in selection screen then it is not at all showing the coumn which I have created for 31st March netprice (even though I dont have the dat in my systeme for 31 March of previos year , it should show me blank).if I am not entering the value in the selection screen then it is showing me the same values which I have
Material Price on31stMarch 0calday priceas Qty
on
1 5.50 1/2/07 5.50 2
3.50 2/2/07 3.50 3
8.50 8/2/07 8.50 5
10.00 1/3/07 10.50 6
Even when it show the data for qty also it should show me the data only of that month which the user enters but not the entire qty of all months
DATA: l_s_range TYPE rsr_s_rangesid,
i_s_range TYPE rrs0_s_var_range,
v_ysdate LIKE sy-datum,
v_year(4).
CASE i_vnam .
WHEN 'VAR_CMY'. -- customerexit variable
CLEAR:l_s_range,v_year,v_ysdate.
READ TABLE i_t_var_range INTO i_s_range
WITH KEY vnam = 'VAR_SCALMONTH'.----
Manual entry default variable
IF sy-subrc = 0.
v_year = i_s_range-low(4) - 1 .
CONCATENATE v_year '03' '31' INTO v_ysdate.
l_s_range-low = v_ysdate.
l_s_range-sign = 'I'.
l_s_range-opt = 'EQ'.
APPEND l_s_range TO e_t_range.
ENDIF.
ENDCASE.
Why my code is not working ,pls give anu inputs
Hello,
Check this code,
WHEN ''VAR_CMY'.
IF i_step = 2. "after the popup
LOOP AT i_t_var_range INTO loc_var_range
WHERE vnam = 'VAR_SCALMONTH'.
v_year = loc_var_range-low+0(4).
v_year = v_year - 1.
CONCATENATE v_year '03''31' INTO v_ysdate.
l_s_range-low = v_ysdate.
l_s_range-sign = 'I'.
l_s_range-opt = 'EQ'.
APPEND l_s_range TO e_t_range.
EXIT.
ENDLOOP.
ENDIF.
ENDCASE.
hope it helps ,
assign points if helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for ur reply
when i write the code provided by you and executing the query
giving me the error after entering the value in the variable VAR_SCALMONTH = 02.2007
value "200603'3" for user exit variable var_cmyis invalid
Diagnosis
The value for the variable VAR_CMY is determined in the user exit (RSR00001). In this case, the value 200603'3 was allowed. This value is not valid.
System Response
Procedure
Procedure for System Administration
Check the user exit for variable VAR_CMY. Make sure that variables for characteristic values are in internal format and are not compounded. This means, for example, that a date variable must have the value 20000914 and not the value 14.09.2000.
if i am not entering any value in the selection screen then it should show me in 31st march column with no data as there is no data of 31st March in my system, but its showing th values present in the netprice
Any other inputs pls
Where have you created the variable VAR_CMY.
It should be on the CALDAY or the date field on which you are restricting the data with.
And one more thing is you cannot hardcode the values just for the month of feb.2007.
Try to use Function Module in your code to get last day of the month
LAST_DAY_IN_PERIOD_GET.
Regards, Siva
Message was edited by:
Siva Bonam
User | Count |
---|---|
74 | |
10 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.