get data from aufm

[Former Member]

is there any proper way to selecting data from aufm

because below query taking long time.

SELECT  * FROM  aufm     into table i_aufm          " collecting input material document numbers
         WHERE mblnr GE '4900000000'
           AND mjahr GE '2008'
           AND zeile GT '0'
           AND matnr EQ matnr_101-matnr
           AND werks IN p_werks
           AND charg EQ matnr_101-charg
           AND bwart = '101'.

Cross post locked

Edited by: Rob Burbank on May 30, 2009 8:28 PM

[Former Member]

is there any proper way to selecting data from aufm

because below query taking long time.

SELECT  * FROM  aufm     into table i_aufm          " collecting input material document numbers
         WHERE mblnr GE '4900000000'
           AND mjahr GE '2008'
           AND zeile GT '0'
           AND matnr EQ matnr_101-matnr
           AND werks IN p_werks
           AND charg EQ matnr_101-charg
           AND bwart = '101'.

Cross post locked

Edited by: Rob Burbank on May 30, 2009 8:28 PM

[muhammad_sohail]

Dear,

You can use BAPI.

Regards,

Sohail

[Former Member]

u can also compare with budat

SELECT * FROM aufm into table i_aufm " collecting input material document numbers

WHERE mblnr GE '4900000000'

AND mjahr GE '2008'

AND zeile GT '0'

AND matnr EQ matnr_101-matnr

AND werks IN p_werks

AND charg EQ matnr_101-charg

AND bwart in ( '101' , '102' )

and budat in s_budat.

or

select sum( menge ) as menge sum( dmbtr ) as dmbtr

aufnr aufm_{matnr aufm}meins bwtar bwart

APPENDING corresponding fields of table itab

from aufm

where aufm~matnr in t_matnr1

and bwtar in bwtar

and budat >= first

and budat <= last

group by aufnr aufm_{matnr aufm}meins bwtar bwart .