Regarding range tables

[Former Member]

Hello,

I have a range table which gets populated with the following data.

S.....O.......Low................High

-

---

I......BT......<lower id>.......<higher id>

I need to do some processing for each of the values in the range table, ie, all ids in the 'between' range. How do i get the individual ids in that range?

Regards,

Suraj

[Former Member]

in that case u have to get all the values which falls in this ranges.

like

select * from t001w into table i_t001w where werks in r_werks.

so here i_t001 will contains all the records which falls for given range.

Regards

prabhu

[Former Member]

Hi,

The question is not clear , please mention waht kind of processin u want

and how is the range filled ( through some user input or something else ) ...based on waht ?

Thanks

Soumyadip Pal

[RaymondGiuseppi]

If you range refer to a transparent table/databse view use you range in a select instruction to get individual values :

SELECT field FROM table WHERE field IN range.

Regards

[Former Member]

Hello Suraj,

Its not a good practice to validations on range tables, try to avoid it. If it has to been done, then check the entries from where your taking the values to populate the table depending on range.

Regards

[Former Member]

Hello,

Thank you all for your inputs.

In my case, the user would enter either one or a range of ids ( this is master data).

I need to get the details for each of these ids. The selection criteria entered by the user would be filled in a range table.

My range table can have EQ or BT in that case.

I now need to hit the DB to get the values of these ids.

Can i still do a select * from table where id IN <range table name>.... even though it has both EQ and BT entries? Will it work?

Regards,

Suraj