topic Re: Time Out in Application Development and Automation Discussions

Time Out

Former Member — Thu, 14 Feb 2008 14:49:59 GMT

I am running a query as follows:

SELECT bukrs day_a racct prctr per_day average_m accumulate average

FROM zavg_bal_table

INTO CORRESPONDING FIELDS OF TABLE it_zavg

WHERE bukrs IN app_ref->company_code_range

AND day_a BETWEEN start_month AND param_date

AND prctr IN p_prctr.

When I only specify bukrs, the query runs fine. But when I specify both

a company code (bukrs) and profit center (prctr), the application

times out.

Company code (bukrs) and profit center (prctr) are key fields in the

zavg_bal_table.

Re: Time Out

Former Member — Thu, 14 Feb 2008 15:47:07 GMT

is that select statement the exact point of the coding where you get the time-out? please check the dump ...

Re: Time Out

Former Member — Thu, 14 Feb 2008 15:54:02 GMT

Hi,

By using ST05 run the report and get where exactly , it would have taken more time(dump out) , If suppose you cant define primary key in select query, define it .

Otherwise go for creating INDEXES for respective database table.

Thanks,

Krishna Rao