Abap query with constante value

[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

[RaymondGiuseppi]

Have you thought to query variant?

Regards

[RaymondGiuseppi]

I explain a little more

- create a variant with MSEG-BWART filled with the desired constant

- In variant attribute you protect/hide the select-options

- Put your variant as executed at startup in the query

Regards

[Former Member]

Hi,

Variant is a good option. Here is one more stable option.

Other option is to use following Code.

RANGES : ran1 FOR MSEG-BWART.

ran1-sign = 'I'.

ran1-option = 'EQ'.

ran1-low = 101.

APPEND ran1.

ran1-sign = 'I'.

ran1-option = 'EQ'.

ran1-low = 501.

APPEND ran1.

Then use ran1 similar to select option.

Hope this will help you.

Darshan

[Former Member]

Hi,

I addition to above reply. Please feel free to contact me for further info.

• Lastly don't forget to give points to correct answer