06-28-2007 3:48 PM
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.
07-04-2007 11:27 AM
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.
07-04-2007 11:32 AM
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
07-04-2007 11:36 AM
Hi
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
07-04-2007 11:40 AM
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.