topic Reading table S026 in Application Development and Automation Discussions

Reading table S026

Former Member — Tue, 22 Aug 2006 14:07:41 GMT

Hello;

Is there a faster way to read table S026(material consumptions table)? My select statement is as follows but it takes too much time to read.

select s026_{matnr s026}werks s026~mcomp

into (s026-matnr, s026-werks, s026-mcomp)

from s026 client specified

where vrsio = '000' and

ssour = space and

mandt = sy-mandt and

werks in werks and

mcomp in mcomp and

sptag in dates.

........

endselect.

Thanks in advance.

Ali abbasgil

Re: Reading table S026

Former Member — Tue, 22 Aug 2006 14:13:21 GMT

hi,

As we are not specifying all the key fields, it is taking much time. Check if there are secondary indexes on that table. Specify that index while selecting data using HINT statement.

Regards,

Sailaja.

Re: Reading table S026

Former Member — Tue, 22 Aug 2006 14:19:54 GMT

Try this:

data: begin of t_s026 occurs 0,

matnr like s026-matnr,

werks like s026-werks,

mcomp like s026-mcomp,

end of t_s026.

select matnr werks mcomp

into table t_s026

from s026 client specified

where mandt = sy-mandt and

ssour = space and

vrsio = '000' and

sptag in dates and

werks in werks and

mcomp in mcomp.

Regards,

ravi

Re: Reading table S026

Former Member — Tue, 22 Aug 2006 14:22:31 GMT

try not to use select-endselect....it'l affect performance.instead use the following.

data : s026 like table of s026 with header line.

select s026_{matnr s026}werks s026~mcomp

into corresponding fields of table s026

from s026 client specified

where vrsio = '000' and

ssour = space and

mandt = sy-mandt and

werks in werks and

mcomp in mcomp and

sptag in dates.

........

u need not use append.this will put the data directly into the table n not the work area

Re: Reading table S026

former_member312315 — Thu, 09 Nov 2006 00:48:58 GMT

Instead of using ABAP, try using the Report Painter. Once the table has been installed for report painter, it should be good to go for any flexible reporting by the user.

Good luck.