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