Hi Experts,
I want to improve performance for one report select statement.
SELECT amatnr ameins amtart amstav
cwerks ceisbe
dlgort dlabst
vprodh vmvgr2 vvmsta vprodh vvkorg vvtweg
m~maktx
b~stprs
INTO CORRESPONDING FIELDS OF TABLE it_data
FROM ( mara AS a INNER JOIN mvke AS v ON
vmatnr = amatnr
INNER JOIN marc AS c
ON amatnr = cmatnr
INNER JOIN mard AS d
ON cmatnr = dmatnr AND
cwerks = dwerks
INNER JOIN mbew AS b
ON bmatnr = cmatnr AND
bbwkey = cwerks
INNER JOIN makt AS m
ON amatnr = mmatnr AND
m~spras = sy-langu )
WHERE
a~matnr IN so_matnr
AND c~werks IN so_werks
AND d~lgort IN so_lgort
AND v~vkorg IN so_vkorg
AND v~vtweg IN so_vtweg
AND v~prodh IN so_prodh.
Pls suggest me in this.
Thanks in advance.
Thanks,
Madhu.