Skip to Content
author's profile photo Former Member
Former Member

wrting customer exit in variables

Posted on Aug 03, 2006 at 02:56 PM 10 Views

Hi Guys,

I have to change the code in customer exit for variables in reporting.i have to give inputrange in 0calmonth(01/06-07/06)and i have to get the output as 0calday(multiplevalues),can any body help me out.

Thanks

Kiran

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 03:08 PM

    Kiran,

    can you please tell your requiremetn with some more details... rigth now what is the existing functionality. what is required? what dates needs come...

    suppose )CALMONTH variable values are 200606 to 200608.

    datt variable values...20060601 to 20060831 is this the one you are looking for?

    All the best.

    regards,

    Nagesh Ganisetti.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 03:17 PM

    Hi Ganesh,

    Now it is taking input as 0calmonth(singlevalue) and

    Output as singlevalue,now the current requirement is

    to give input as range(selectoptions) and ouput as multiple values.Please help in sorting it out.

    Thanks

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 03, 2006 at 03:33 PM

      Kiran,

      check this... i wrote the code as mentioed in my last post...

      data:w_date(8).

      CASE I_VNAM.

      WHEN '0CALDAY Variable Name'

      if i_step = 1. clear l_s_range.

      read table I_T_VAR_RANGE where vnam = '0CALMONTH Varibale'.

      l_s_range-low = concatenate i_t_var_range-low+'01'.

      l_s_range-sign = 'I'.

      l_s_range-opt = 'EQ'.

      w_date = concatenate i_t_var_range-high '01' into w_date.

      call function 'SLS_MISC_GET_LAST_DAY_OF_MONTH'

      exporting

      DAY_IN = w_date

      importing

      LAST_DAY_OF_MONTH = l_s_range-high.

      append l_s_range to e_t_range.

      endif.

      endcase.

      check this code and let me know...change the Variable Names and keep capital letters.

      i'm telling you again... if the 0CALMONTH variable range 200605 to 200608. code will populate the values for 0CALDAY like this...20060501 to 20060831.

      all thes best.

      Regards,

      Nagesh Ganisetti.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 03:18 PM

    Hi Ganesh,

    Now it is taking input as 0calmonth(singlevalue) and

    Output as singlevalue,now the current requirement is

    to give input as range(selectoptions) and ouput as multiple values.Please help in sorting it out.

    Thanks

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 03:43 PM

    Hi Ganesh,

    It seems to be helpful a lot,i want to assign points to you,how should i assign?I am new to sdn.

    Thanks

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 06:36 PM

    Hi Ganesh,

    Actually they dont want to change the entire code,I am

    sending the code where i have to change.

    *When 'zclmonth'.

    when ZZClmonth(here i have to change to multiplevalue instead of single value and also i have to replace with 0calday instead of month)

    If I_Step = 2.

    Loop At I_T_VAR_RANGE INTO VAR_RANGE.

    Where vnam = '0calmonth'(here i have to give the range)

    Where VNAM = 'ZCL_RQDM'

    This all i have to put in loop.

    please send some suggestions about this one.

    Thanks

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 03, 2006 at 06:47 PM

      Kiran,

      try this code...Everything is clear for me except that WHERE VNAM = 'ZCL_RQDM'.

      WHEN 'ZZCALMONTH'.

      if i_step = 2. " in my last post i gave 1 that is wrong.

      clear l_s_range.

      read table I_T_VAR_RANGE where vnam = '0CALMONTH' BINARY SEARCH.

      concatenate i_t_var_range-low '01' INTO l_s_range-low.

      l_s_range-sign = 'I'.

      l_s_range-opt = 'EQ'.

      w_date = concatenate i_t_var_range-high '01' into w_date.

      call function 'SLS_MISC_GET_LAST_DAY_OF_MONTH'

      exporting

      DAY_IN = w_date

      importing

      LAST_DAY_OF_MONTH = l_s_range-high.

      append l_s_range to e_t_range.

      endif.

      all the best.

      Regards,

      Nagesh Ganisetti.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 07:03 PM

    Hi Ganesh,

    This is good,but they want me to put in a loop and also there is no need of changing the total code.They want me to put ranges in the input to get multiple values in the output,Please help me out.

    Thanks

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 03, 2006 at 07:23 PM

      Kiran,

      first of My name is Nagesh not Ganesh

      check the code...

      WHEN 'ZZCALMONTH'.

      if i_step = 2. " in my last post i gave 1 that is wrong.

      clear l_s_range.

      loop at I_T_VAR_RANGE where vnam = '0CALMONTH' .

      concatenate i_t_var_range-low '01' INTO l_s_range-low.

      w_date = concatenate i_t_var_range-high '01' into w_date.

      call function 'SLS_MISC_GET_LAST_DAY_OF_MONTH'

      exporting

      DAY_IN = w_date

      importing

      LAST_DAY_OF_MONTH = l_s_range-high.

      l_s_range-sign = 'I'.

      l_s_range-opt = 'EQ'.

      append l_s_range to e_t_range.

      endloop.

      endif.

      Read statement with Binary Search is good compared Loop wihh Where class.

      all the best.

      Regards,

      Nagesh Ganisetti.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 07:27 PM

    Hi Nagesh,

    I will try this one.

    Thanks

    Kiran

    Add comment
    10|10000 characters needed characters exceeded