Hi Naween,
Three things need to be done: -
1. In the Query Designer, create a New Variable based on the InfoObject that has the same data type as the value in your infopackage field selection. For example, create a variable for InfoObject 0CALDAY if your selection field is a date. This can be done in any query that has the required InfoObject. The processing of this variable must be 'CUSTOMER EXIT'.
2. In CMOD, create code for this variable. Sample code for the derivation of first and last dates for year based on 0CALDAY is affixed below: -
DATA: f_date LIKE sy-datum,
f_date2 LIKE sy-datum,
f_date3 LIKE sy-datum.
WHEN 'Z1ST_LST'.
CLEAR f_date.
CLEAR f_date2.
CLEAR f_date3.
f_date = sy-datum.
CLEAR l_s_range.
concatenate f_date+0(4) '0101' into f_date2.
concatenate f_date+0(4) '1231' into f_date3.
l_s_range-low = f_date2.
l_s_range-high = f_date3.
l_s_range-opt = 'BT'.
l_s_range-sign = 'I'.
APPEND l_s_range TO e_t_range.
3. Select the InfoPackage 'Data Selection' tab, then 'OLAP Variable' and specify the newly created variable. The values are not prepopulated but only populated at runtime. To review the values that will be populated, select the 'Details for Type' button and the 'Check' (glasses) button in the subsequent screen. If the values are not populated with the 'Check' method, you may have to log off and on to the system.
Regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.