Master Data storage BW

Hello experts,

How can i store ranges in master data?

I have a flatfile as following:

Field 1

Field 2

Field 3

A

1 -- >5

ABC

B

6 --> 9

DEF

Field 2 is a range, 1 -- >5 means from 1 to 5.

I thought about this solution, but may be there are other better solution that I am missing.

Field 1

Field 2 (from)

Field 2’ (to)

Field 3

A

1

5

ABC

B

6

9

DEF

The idea is to use this master data in an infocube and after in a bex Query.

Thanks for your advices.

Amine