perfromance tuning..

me using these three select

this taking hell lot of time.. any ways to improve these..

for all entries taking more then tht.. so please dont suggest tht.

its critial issue help me out..

SELECT B_{WERKS A}VBELN B~MATNR

A_{FKDAT A}SPART A_{VTWEG A}ERDAT A~ERZET

B_{VGBEL B}AUBEL

A~FKART "Added by Arun pandey 08/05/2007

B_{NETWR B}FKIMG B~MWSBP

FROM VBRP AS B

JOIN VBRK AS A ON A_{VBELN = B}VBELN INTO TABLE IT_INV

WHERE A~FKART IN S_FKART

AND ( A_{SPART IN S_SPART AND A}SPART 'ST' )

AND A~FKDAT IN S_FKDAT

AND ( A_{VTWEG IN S_VTWEG AND A}VTWEG 'ST' )

AND A~FKSTO 'X'

AND A~KUNAG IN S_CUST

AND B~WERKS = S_WERKS.

SELECT A_{VBELN B}POSNR B_{MATNR B}VGBEL A_{KUNNR A}ERDAT A~ERZET

A_{LFDAT B}LFIMG

FROM LIKP AS A JOIN LIPS AS B ON A_{VBELN = B}VBELN

INTO TABLE IT_DELV

FOR ALL ENTRIES IN IT_INV

WHERE A~VBELN = IT_INV-VGBEL

AND B~MATNR = IT_INV-MATNR.

SELECT A_{VBELN A}BSTNK A_{AUART A}KUNNR

A_{VKBUR A}VKGRP B_{NAME1 B}ORT01

FROM VBAK AS A JOIN KNA1 AS B ON A_{KUNNR = B}KUNNR

INTO TABLE IT_ORDER

FOR ALL ENTRIES IN IT_DELVHEAD

WHERE A~VBELN = IT_DELVHEAD-VGBEL.