topic Re: Select query giving Time out dump in Application Development and Automation Discussions

Select query giving Time out dump

Former Member — Mon, 22 Jun 2009 10:17:01 GMT

Hi All,

I have written a select query on a table in BW system.The code for the same is attached below.The table contains some 6,00,000 records.This query is giving a time out error.Kindly look into the query and advice ways to make it work.Thanks.

IF NOT lt_temp[] IS INITIAL.

SELECT /bic/zprrmatnr objvers /bic/zprclwynr /bic/zprrmdlr

FROM /bic/pzprrmatnr

INTO CORRESPONDING FIELDS OF TABLE lt_zprrmatnr

FOR ALL ENTRIES IN lt_temp

WHERE /bic/zprclwynr = lt_temp-temp

AND objvers = 'A'.

ENDIF.

Thanks and Regards,

Faisal

Re: Select query giving Time out dump

Former Member — Mon, 22 Jun 2009 10:25:51 GMT

Hi,

Please see if you can pass the fields of the primary index or some secondary index in your where clause.

This is just a recommendation. Since i do not have access to BW tables and do not know you exact requirement; I can just suggest the above at the moment.

Regards,

Ankur Parab

Re: Select query giving Time out dump

ThomasZloch — Mon, 22 Jun 2009 10:32:29 GMT

Not only is it BW, it is also a customer table. Have a look here on how to research yourself:

Thomas