Skip to Content
0
Former Member
Oct 26, 2007 at 12:50 PM

query debugging

11 Views

Hi all,

I faced one problem in query level. see below 10/2006 two times repeated.

04/2006 1

05/2006

06/2006 1 2

07/2006 1 2

08/2006

09/2006

10/2006 3 6

10/2006 3 6

11/2006 2

12/2006 1 1

01/2007 2 1

02/2007 3

yesterday same report 08/2006.. before yesterday 07/2006. same query

i checked customer exit program...

Cube level mention 730 sample code

WHEN 'ZCreatedondate'. "To Populate the 24 Months for xyz Cube

IF i_step = 1.

CLEAR l_s_range.

l_s_range-sign = 'I'.

l_s_range-opt = 'BT'.

l_s_range-high = sy-datum.

CLEAR: tmp_date.

CLEAR: zcal_date.

zcal_date = sy-datum - 730.

tmp_date = zcal_date.

tmp_date+6(2) = '01'.

zcal_date = tmp_date.

l_s_range-low = zcal_date.

APPEND l_s_range TO e_t_range.

ENDIF.

WHEN 'ZFixedDate'. "To Populate the 24 Months for xyz Cube

IF i_step = 1.

CLEAR l_s_range.

l_s_range-sign = 'I'.

l_s_range-opt = 'BT'.

CLEAR: tmp_date.

tmp_date = sy-datum.

l_s_range-high = tmp_date.

CLEAR: zcal_date.

zcal_date = sy-datum - 730.

CLEAR: tmp_date.

tmp_date = zcal_date.

tmp_date+6(2) = '01'.

l_s_range-low = tmp_date.

APPEND l_s_range TO e_t_range.

WHEN 'Zxxx'. " 24 cal month

  • if i_step = 1.

CLEAR l_s_range.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

lv_date2 = sy-datum - 720.

MOVE lv_date2+0(6) TO l_s_range-low.

APPEND l_s_range TO e_t_range.

HEN 'Zyyy'. " 24 cal month

  • if i_step = 1.

CLEAR l_s_range.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

lv_date2 = sy-datum - 720.

MOVE lv_date2+0(6) TO l_s_range-low.

APPEND l_s_range TO e_t_range.

  • endif.

WHEN 'Zzzz'. " 24 cal month

  • if i_step = 1.

CLEAR l_s_range.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

lv_date2 = sy-datum - 690.

MOVE lv_date2+0(6) TO l_s_range-low.

APPEND l_s_range TO e_t_range.

  • endif.

to decrease value up 24 months..

can any body helpme this issue... this is include program

how to debug querys i know RSRT after when i select execut+debug .. one pop up screen showing.. so many options.. what are select options?. plz tell me?..

urgent

but i'm not taken cube level varible in query level. only taken zxxx to zzzz var

raj

Message was edited by:

gangaraju mullapudi