Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Adding Values in Ranges.

Go to solution
karthik_rajaspic
Participant

‎2007 Nov 22 10:37 AM

24,238

Hi,

I have 4 values. eg: 100, 200, 300 and 400.

I need to take all these values into a range R_VALUES.

How I can do this. Please help me.

Thanks in advance.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2007 Nov 22 10:42 AM

10,765

DATA: spfli_wa TYPE spfli,

r_carrid TYPE RANGE OF spfli-carrid,

r_carrid_line LIKE LINE OF r_carrid.

r_carrid_line-sign = 'I'.

r_carrid_line-option = 'BT'.

r_carrid_line-low = 'AA'.

r_carrid_line-high = 'LH'.

APPEND r_carrid_line TO r_carrid.

SELECT *

FROM spfli

INTO spfli_wa

WHERE carrid IN r_carrid.

...

ENDSELECT.

8 REPLIES 8
Read only

Go to solution
former_member386202
Active Contributor

‎2007 Nov 22 10:39 AM

0 Likes
10,765

Hi,

Just pass that values to range

R_VALUES-LOW = '100'.

append R_VALUES.

R_VALUES-LOW = '200'.

append R_VALUES.

R_VALUES-LOW = '300'.

append R_VALUES.

R_VALUES-LOW = '400'.

append R_VALUES.

Regards,

Prashant

Read only

Go to solution
karthik_rajaspic
Participant
In response to former_member386202

‎2007 Nov 22 10:42 AM

0 Likes
10,765

Thanks Prashant.

Read only

Go to solution
karthik_rajaspic
Participant

‎2007 Nov 22 10:41 AM

0 Likes
10,765

R_VALUE-SIGN = 'I'.

R_VALUE-OPTION = 'EQ'.

R_VALUE-LOW = '100'.

APPEND R_VALUE.

CLEAR R_VALUE.

R_VALUE-SIGN = 'I'.

R_VALUE-OPTION = 'EQ'.

R_VALUE-LOW = '200'.

APPEND R_VALUE.

CLEAR R_VALUE.

R_VALUE-SIGN = 'I'.

R_VALUE-OPTION = 'EQ'.

R_VALUE-LOW = '300'.

APPEND R_VALUE.

CLEAR R_VALUE.

R_VALUE-SIGN = 'I'.

R_VALUE-OPTION = 'EQ'.

R_VALUE-LOW = '400'.

APPEND R_VALUE.

CLEAR R_VALUE.

This will solve the probelm.

Thanks.

Read only

Go to solution
Former Member

‎2007 Nov 22 10:42 AM

10,766

DATA: spfli_wa TYPE spfli,

r_carrid TYPE RANGE OF spfli-carrid,

r_carrid_line LIKE LINE OF r_carrid.

r_carrid_line-sign = 'I'.

r_carrid_line-option = 'BT'.

r_carrid_line-low = 'AA'.

r_carrid_line-high = 'LH'.

APPEND r_carrid_line TO r_carrid.

SELECT *

FROM spfli

INTO spfli_wa

WHERE carrid IN r_carrid.

...

ENDSELECT.

Read only

Go to solution
Former Member

‎2007 Nov 22 10:42 AM

0 Likes
10,765

Hi .

Try this code..

R_values-Sign = 'I'

R_values-Option = 'EQ'

R_values-Low = '100'.

Append R_values.

R_values-Sign = 'I'

R_values-Option = 'EQ'

R_values-Low = '200'.

Append R_values.

R_values-Sign = 'I'

R_values-Option = 'EQ'

R_values-Low = '300'.

Append R_values.

R_values-Sign = 'I'

R_values-Option = 'EQ'

R_values-Low = '400'.

Append R_values.

Regards

Bala..

Read only

Go to solution
Former Member

‎2007 Nov 22 10:42 AM

0 Likes
10,765

R_VALUES-SIGN = 'I'.

R_VALUES-OPTION = 'EQ'.

R_VALUES-LOW = '100'.

append R_VALUES.

CLEAR R_VALUES-LOW.

R_VALUES-LOW = '200'.

append R_VALUES.

CLEAR R_VALUES-LOW.

DO IN SIMILAR WAY...

Read only

Go to solution
karthik_rajaspic
Participant
In response to Former Member

‎2007 Nov 22 10:44 AM

0 Likes
10,765

Hi All,

Thanks for the answers.

I too got the answer from my side. Myself also posted a reply for this question.

Thanks for everyone.

Read only

Go to solution
Former Member

‎2007 Nov 22 10:44 AM

10,765

Hi Karthik,

Do like this

DATA: r_values  TYPE RANGE OF <reference field>.

r_values-sign = 'I'.
r_values-option = 'EQ'.
r_values-low = '100'.
Append r_values.

r_values-sign = 'I'.
r_values-option = 'EQ'.
r_values-low = '200'.
Append r_values.

r_values-sign = 'I'.
r_values-option = 'EQ'.
r_values-low = '300'.
Append r_values.

r_values-sign = 'I'.
r_values-option = 'EQ'.
r_values-low = '400'.
Append r_values.

<b>Reward Points if this helps,</b>

Satish