topic Re: Time out Problem in Application Development and Automation Discussions

Time out Problem

Former Member — Thu, 28 Jun 2007 14:48:18 GMT

Hi,

I have written a code as above but it is giving timeout error, what I can do to resolve this problem.

SELECT bukrs belnr gjahr j_1ibuzei witht wt_withcd

FROM with_item INTO corresponding fields of TABLE

data_tab FOR ALL ENTRIES IN

bkpftab WHERE bukrs = bkpftab-bukrs AND

belnr = bkpftab-belnr AND

gjahr = bkpftab-gjahr AND

wt_qbshh NE 0 AND

koart = 'K' AND

wt_acco IN zvendor AND

qsrec IN zrec AND

wt_stat = ' ' AND

j_1ibuzei <> '000'.

Thanks.

Re: Time out Problem

Former Member — Wed, 04 Jul 2007 10:27:28 GMT

Before giving query using select all entries check whether the internal table is initial or not.otherwise it will fetch all the values in the table.that may lead to time out error.

Re: Time out Problem

former_member404244 — Wed, 04 Jul 2007 10:32:06 GMT

Hi,

Write like this

If not bkpftab[] is not initial.

SELECT bukrs belnr gjahr j_1ibuzei witht wt_withcd

FROM with_item INTO corresponding fields of TABLE

data_tab FOR ALL ENTRIES IN

bkpftab WHERE bukrs = bkpftab-bukrs AND

belnr = bkpftab-belnr AND

gjahr = bkpftab-gjahr AND

wt_qbshh NE 0 AND

koart = 'K' AND

wt_acco IN zvendor AND

qsrec IN zrec AND

wt_stat = ' ' AND

j_1ibuzei <> '000'.

endif.

regards,

Nagaraj

Re: Time out Problem

Former Member — Wed, 04 Jul 2007 10:36:34 GMT

Instead of corresponding fields better use INTO TABLE

by writing the fileds in internal table in the correct sequence

and also in where condition follow the sequence of fields similar to the table field sequence.

If not bkpftab[] is not initial.

SELECT bukrs belnr gjahr j_1ibuzei witht wt_withcd

FROM with_item INTO TABLE

data_tab FOR ALL ENTRIES IN

bkpftab WHERE bukrs = bkpftab-bukrs AND

belnr = bkpftab-belnr AND

gjahr = bkpftab-gjahr AND

wt_qbshh NE 0 AND

koart = 'K' AND

wt_acco IN zvendor AND

qsrec IN zrec AND

wt_stat = ' ' AND

j_1ibuzei <> '000'.

endif.

<b>

Reward points for useful Answers</b>

Regards

Anji

Re: Time out Problem

Former Member — Wed, 04 Jul 2007 10:40:11 GMT

SELECT bukrs belnr gjahr j_1ibuzei witht wt_withcd

FROM with_item

APPENDING corresponding fields of TABLE data_tab

PACKAGE SIZE 1000

FOR ALL ENTRIES IN

bkpftab WHERE bukrs = bkpftab-bukrs AND

belnr = bkpftab-belnr AND

gjahr = bkpftab-gjahr AND

wt_qbshh NE 0 AND

koart = 'K' AND

wt_acco IN zvendor AND

qsrec IN zrec AND

wt_stat = ' ' AND

j_1ibuzei <> '000'.

ENDSELECT.

Use Package size and Appending into table

This helps you.

Regards,

Pavan P.