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