Skip to Content
0
Former Member
Mar 05, 2009 at 01:10 PM

performance issue for select statement

23 Views

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.