Time Out

[Former Member]

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.

[Former Member]

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

[Former Member]

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