Restrict Query Output

[Former Member]

Hi All,

I need to restrict the output of my Bex Query,only with the Material Numbers starting with "20" followed by any other digits therafter.How can I filter those required data?

How can it be done in Query level?

Thanks,

Brinto.

[Former Member]

Try to apply a range filter to material number

200000000000000000 - 209999999999999999 if the material numbers are only numerical

200000000000000000 - 20ZZZZZZZZZZZZZZZZ if the material numbers contain alphabets.

Remember that material numbers are internally 18 characters.

[Former Member]

Thanks Rajendra. I'll try that.

Edited by: Brinto Roy on Aug 23, 2009 8:35 AM