Skip to Content
0
Former Member
May 08, 2008 at 07:09 AM

Inner join performance

375 Views

Hello,

Could the following program be improved?

types:
  begin of ty_konten,
    bukrs type bukrs,
    saknr type saknr,
  end of ty_konten.
data: it_konten type table of ty_konten.
data: wa_konten type ty_konten.

 
  select skb1~bukrs skb1~saknr
    appending corresponding fields of table it_konten
    from ska1 inner join skb1
      on ska1~saknr = skb1~saknr
    where ska1~ktopl = 'BSV'
      and ska1~xloev = ' '
      and skb1~xloeb = ' '.
  sort it_konten.

Thanks and Regards,

Tommaso