topic Creating a range table type in Application Development and Automation Discussions

Creating a range table type

Former Member — Thu, 23 Nov 2006 08:56:12 GMT

Hello Gurus,

How do you create Range Table Type?

Thanks!

Jeffrey

Re: Creating a range table type

anversha_s — Thu, 23 Nov 2006 08:57:31 GMT

hi,

Define a range:

Ranges: r_field for <table>.

if not field1 is initial.
r_field-sign = 'I'.
r_field-option = 'EQ'.
r_field-option-low = field1.
append r_field.
endif.

if not field2 is initial.
r_field-sign = 'I'.
r_field-option = 'EQ'.
r_field-option-low = field2.
append r_field.
endif.

if field1 is initial and field2 is initial.
r_field-sign = 'I'.
r_field-option = 'EQ'.
append r_field.
endif.

select * from <table> where field1 in r_field.

rgds

anver

Re: Creating a range table type

Former Member — Thu, 23 Nov 2006 08:58:56 GMT

data: zip(6) type n.

data: year(4) type c.

ranges: r_zip for zip.

ranges: r_year for year.

clear r_zip.

r_zip-sign = 'I'.

r_zip-option = 'EQ'.

r_zip-low = '301526'.

append r_zip.

clear r_zip.

r_zip-sign = 'I'.

r_zip-option = 'BT'.

r_zip-low = '30111'.

r_zip-high = '301136'.

append r_zip.

clear r_year.

r_year-sign = 'E'.

r_year-option = 'LT'.

r_year-low = '2005'.

append r_year.

if p_zip in r_sip

and p_year in r_year.

endif.

Re: Creating a range table type

Former Member — Thu, 23 Nov 2006 08:59:02 GMT

Hi

Range is nothing but like SELECT_OPTIONS in Reporting

Ranges: sdate for sy-datum occurs 1.

sdate-sign = 'I'.

sdate-option = 'EQ'.

sdate-low = sy-datum - 1.

sdate-high = sy-datum.

append sdate.

Then

in SELECT use IN operator.

Regs

Manas Ranjan Panda

Message was edited by:

MANAS PANDA

Re: Creating a range table type

Former Member — Thu, 23 Nov 2006 08:59:09 GMT

hi,

Check

Regards,

Santosh

Re: Creating a range table type

Former Member — Thu, 23 Nov 2006 08:59:26 GMT

Hi Jeffrey

Please check CURTO_MATNR_RANGE_T via SE11.

Kind Regards

Eswar

Re: Creating a range table type

former_member404244 — Thu, 23 Nov 2006 09:01:19 GMT

Hi,

for example.

Ranges: R_field for Vbak-vkorg.

r_field-sign = 'I'.

r_field-option = 'EQ'.

r_field-option-low = '1000'.

append r_field.

r_field-option-low = '2000'.

append r_field.

r_field-option-low = '3000'.

append r_field.

In this way u can do it.

regards,

nagaraj

Re: Creating a range table type

michael-john_turner — Thu, 23 Nov 2006 09:13:33 GMT

Hi,

You can also do:


data:
itab type range of field.

Where field could be a data element, etc.

Re: Creating a range table type

Former Member — Thu, 23 Nov 2006 09:23:18 GMT

Hello Guys!

I'm so sorry I forgot to mention how to create it in the data dictionary.

Thanks!

Jeffrey

Re: Creating a range table type

anversha_s — Thu, 23 Nov 2006 09:25:41 GMT

hi,

create a domain for ur data elemnt of ur fiedl.

in the domain give value range.

Rgds

anver

Re: Creating a range table type

Former Member — Thu, 23 Nov 2006 09:25:46 GMT

Have you checked my reply.

Check the table type that i have provided, which can help you..

Kind Regards

Eswar