Skip to Content
0
Former Member
Nov 28, 2006 at 09:17 AM

Inner Join How performance can be improved

1027 Views

Hi All,

There is a inner join for fetching data from mkpf and mseg. Now the query is like shown below.what all things can be done to improve the performance.

SELECT

b~mblnr

b~mjahr

b~zeile

b~bwart

b~matnr

b~werks

b~lgort

b~charg

b~sobkz

b~lifnr

b~shkzg

b~waers

b~dmbtr

b~menge

b~meins

b~ebeln

b~ebelp

b~kostl

b~aufnr

b~bukrs

a~budat

INTO TABLE imseg

FROM mkpf AS a INNER JOIN mseg AS b

ON amblnr = bmblnr AND amjahr = bmjahr

CLIENT SPECIFIED

WHERE a~mandt EQ sy-mandt

AND a~budat IN s_budat

AND a~vgart IN s_vgart

AND a~blart IN s_blart.

DELETE imseg WHERE NOT ( sobkz EQ 'K' ) .

DELETE imseg WHERE NOT ( bwart = '411' OR bwart = '412' ) .

IF NOT ( s_matnr IS INITIAL ) .

DELETE imseg WHERE NOT ( matnr IN s_matnr ) .

ENDIF.

IF NOT ( s_werks IS INITIAL ) .

DELETE imseg WHERE NOT ( werks IN s_werks ) .

ENDIF.

IF NOT ( s_lifnr IS INITIAL ) .

DELETE imseg WHERE NOT ( lifnr IN s_lifnr ) .

ENDIF.

IF NOT ( p_bukrs IS INITIAL ) .

DELETE imseg WHERE NOT ( bukrs EQ p_bukrs ) .

ENDIF.

Key fields are not available in the selection screen.

Thanks in advance,

Shyam