Skip to Content
0
Jun 01, 2015 at 11:43 AM

How do improve SELECT in BKPF/BSEG table.

972 Views

Hi everyone.

I'm using this SELECT in a report program but processing this taking about 10 minutes in these two commands:

select belnr

awkey

from bkpf

into table t_bkpf

for all entries in t_cobk

where awkey eq t_cobk-awkey.

select belnr

vbeln

vbel2

kstar

kostl

buzei

kunnr

vorgn

from bseg

into table t_bseg

for all entries in t_bkpf

where kstar eq '0000464001'

and belnr eq t_bkpf-belnr

and shkzg eq 'S'.


There is another way of improving these SELECT, or another table to use instead of BSEG ?

Tks!