Skip to Content
0
Former Member
Sep 07, 2007 at 05:09 AM

Problem with Inner Join

42 Views

Hi All,

I am new to SAP and have been told by all abapers that using joins is a major performance issue but in below select i am using inner join with key fields on the tables because if i don't use joins then i have to use loops which will again a performace issue so please suggest me that how in my case joins is a performance issue and if it is then what's best way to do.

select

vk~vbeln

vk~erdat

vk~vkgrp

vk~kunnr

vk~lifsk " lifsk

k1a~name1 as sotonm

pa~kunnr as kunnr_pa

k1b~name1 as shtonm

vk~gwldt

vk~vdatu

vk~bstnk

tv~bezei

from vbak as vk

inner join

kna1 as k1a on vkkunnr = k1akunnr

inner join

vbpa as pa on vkvbeln = pavbeln and

pa~parvw = 'WE' and

pa~posnr = ''

inner join

kna1 as k1b on pakunnr = k1bkunnr

inner join

tvgrt as tv on vkvkgrp = tvvkgrp

into corresponding fields of table ord_hdr

where vk~lifsk in dblock.

Thanks in advance,

Navdeep singh