I have these tables VBUK, VBAP, VBUP, LIPS, LIKP that I used to retrieve data from tables in a report program.
I have to avoid join condition in order to improve performance.
The join condition in select statement is below.
select LIKP~VBELN LIKP~LFART LIKP~ERDAT LIKP~ERZET LIKP~ERNAM LIKP~VKORG LIKP~KUNAG LIKP~KUNNR LIKP~VSTEL LIKP~WADAT_IST
LIKP~WADAT LIPS~VTWEG LIPS~SPART LIPS~POSNR LIPS~PSTYV LIPS~MATNR LIPS~MATWA LIPS~WERKS LIPS~LFIMG LIPS~VRKME LIPS~LGORT
LIPS~CHARG LIPS~SHKZG LIPS~VGBEL LIPS~VGPOS LIPS~VBELN VBUP~WBSTA VBUP~KOSTA VBUP~VBELN VBUP~POSNR VBAP~ERDAT VBAP~VBELN
VBAP~POSNR VBAP~NETPR VBAP~WAERK VBAP~KZWI1 VBAP~VRKME VBAP~KMEIN VBAP~KWMENG VBAP~KZWI3 VBUK~CMGST VBUK~VBELN
into CORRESPONDING FIELDS OF TABLE itab3
from ( LIKP
inner join LIPS
on LIPS~VBELN = LIKP~VBELN
inner join VBUP
on VBUP~VBELN = LIPS~VBELN
and VBUP~POSNR = LIPS~POSNR
inner join VBAP
on VBAP~VBELN = LIPS~VGBEL
and VBAP~POSNR = LIPS~VGPOS
inner join VBUK
on VBUK~VBELN = LIKP~VBELN )
where LIKP~ERDAT in StDate
and LIKP~VKORG = SaleOrg
AND LIPS~WERKS = Plant1 .
How I can effectively split this code to retrieve same data.
Thank You.