how to solve

[Former Member]

Hi experts

I used the following code in my program, but it leads to dump error says that time exeeds, how to change this query and what could be the reason for this.

pls advise me on this. thanks in advance.

Regards

Rajaram

if zdate-high is not initial.

select OBJECTCLAS

OBJECTID

CHANGENR

UDATE

UTIME

TCODE

from cdhdr

into corresponding fields of table it2

for all entries in it1

where

OBJECTCLAS = it1-OBJECTCLAS and

OBJECTID = it1-OBJECTID and

CHANGENR = it1-CHANGENR and

TCODE = 'VA02' and

( UDATE BETWEEN ZDATE-LOW AND ZDATE-HIGH ).

else.

select OBJECTCLAS

OBJECTID

CHANGENR

UDATE

UTIME

TCODE

from cdhdr

into corresponding fields of table it2

for all entries in it1

where

OBJECTCLAS = it1-OBJECTCLAS and

OBJECTID = it1-OBJECTID and

CHANGENR = it1-CHANGENR and

TCODE = 'VA02' and

( UDATE = ZDATE-LOW ).

endif.

[Former Member]

Hi experts

I used the following code in my program, but it leads to dump error says that time exeeds, how to change this query and what could be the reason for this.

pls advise me on this. thanks in advance.

Regards

Rajaram

if zdate-high is not initial.

select OBJECTCLAS

OBJECTID

CHANGENR

UDATE

UTIME

TCODE

from cdhdr

into corresponding fields of table it2

for all entries in it1

where

OBJECTCLAS = it1-OBJECTCLAS and

OBJECTID = it1-OBJECTID and

CHANGENR = it1-CHANGENR and

TCODE = 'VA02' and

( UDATE BETWEEN ZDATE-LOW AND ZDATE-HIGH ).

else.

select OBJECTCLAS

OBJECTID

CHANGENR

UDATE

UTIME

TCODE

from cdhdr

into corresponding fields of table it2

for all entries in it1

where

OBJECTCLAS = it1-OBJECTCLAS and

OBJECTID = it1-OBJECTID and

CHANGENR = it1-CHANGENR and

TCODE = 'VA02' and

( UDATE = ZDATE-LOW ).

endif.

[Former Member]

Hi Rajaram ,

Few observations

1. Do not use <b>into correspondin</b>g , change the sequence of the fields in the internal table and use into table .

2. I think ZDATE is a range/select-option so use IN operation instead of Between,

Reagrds

Arun

[Former Member]

hi,

use INTO TABLE KEYWORD which will take less time when compared with normal SELECT st and also check whether in where condition that any select options are used or not. if used then give appropriate conditional operator

for exx:

UDATE IN (ZDATE-LOW, ZDATE-HIGH ). instead of between as it is a select option parameter.

if helpful reward some points.

with regards,

Suresh Aluri.

[Former Member]

how to use INTO TABLE in select stmt , actually i have many fields in internal table.

[Former Member]

if zdate-high is not initial.

select OBJECTCLAS

OBJECTID

CHANGENR

UDATE

UTIME

TCODE

from cdhdr

into table it2

for all entries in it1

where

OBJECTCLAS = it1-OBJECTCLAS and

OBJECTID = it1-OBJECTID and

CHANGENR = it1-CHANGENR and

TCODE = 'VA02' and

( UDATE BETWEEN ZDATE-LOW AND ZDATE-HIGH ).

else.

select OBJECTCLAS

OBJECTID

CHANGENR

UDATE

UTIME

TCODE

from cdhdr

into table it2

for all entries in it1

where

OBJECTCLAS = it1-OBJECTCLAS and

OBJECTID = it1-OBJECTID and

CHANGENR = it1-CHANGENR and

TCODE = 'VA02' and

( UDATE = ZDATE-LOW ).

endif.

[Former Member]

hi,

hi ,

time exceeds because there is large data present in the cdhdr table, i think its cluster table. use function module to reset the runtime it helps u.

CALL FUNCTION 'PROGRESS_INDICATOR'

EXPORTING

I_TEXT = ' Fetching Info records'.

it resets the runtime to initial value.

try this it helps u.

regards

siva