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.
vk~lifsk " lifsk
k1a~name1 as sotonm
pa~kunnr as kunnr_pa
k1b~name1 as shtonm
from vbak as vk
kna1 as k1a on vkkunnr = k1akunnr
vbpa as pa on vkvbeln = pavbeln and
pa~parvw = 'WE' and
pa~posnr = ''
kna1 as k1b on pakunnr = k1bkunnr
tvgrt as tv on vkvkgrp = tvvkgrp
into corresponding fields of table ord_hdr
where vk~lifsk in dblock.
Thanks in advance,