Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Abap query

Former Member
0 Kudos
47

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

2 REPLIES 2

Former Member
0 Kudos
26

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.

0 Kudos
26

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