Abap query

[Former Member]

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

[Former Member]

hi

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.

[Former Member]

hi

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.

[Former Member]

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