topic Abap query in Application Development and Automation Discussions

Abap query

Former Member — Sun, 25 Mar 2007 12:22:54 GMT

hello,

I wish to create several abap query since tables MKPF and MSEG for the inventory mouvements. each query for a type of inventory turnover (101, 501,…), but I should not put the code movement in criteria of selection. it is necessary that the code movement should be fixed in the query. should-I declare the MSEG-BWART as a constante? where I can do it?

thank you for your assistance.

cordialy Said

Re: Abap query

Former Member — Sun, 25 Mar 2007 12:37:58 GMT

yes you can ristrict that in select quary by declaring like this,

select field1

field2

from mseg

into table gt_mseg

where bwart in ('101' ,'105').

Thanks,

Sarala.

Re: Abap query

Former Member — Sun, 25 Mar 2007 15:15:23 GMT

hello,

thank u for your answer, baut can do thise in the t-code SQ01 for may abap query?

if yes, where can i do it?

many thank's.

cdt