topic Re: Range declaration in Application Development and Automation Discussions

Range declaration

Former Member — Fri, 04 Apr 2008 09:20:17 GMT

Hi i have to declare the vendor number,idoc date and invoice date in a range how should i do?as of now i have declared in select-options.

Re: Range declaration

UmaArjunan — Fri, 04 Apr 2008 09:25:21 GMT

Check this link

for range declaration.

http://help.sap.com/saphelp_webas620/helpdata/en/9f/dba71f35c111d1829f0000e829fbfe/content.htm

thanks

Re: Range declaration

Former Member — Fri, 04 Apr 2008 09:32:42 GMT

Hi,

Ranges: s_itab1 for vendor number,

S_itab2 for idoc date,

S_itab3 for invoice date.

s_itab1-sign = 'I'.

s_itab1-options = 'EQ'.

s_itab1-low = '00000000000000106'.

s_itab1 -high = '00000000000000109'.

append s_itab1.

s_itab2-sign = 'I'.

s_itab2-options = 'EQ'.

s_itab2-low = date.

s_itab2 -high = date.

append s_itab2.

S_itab3-sign = 'I'.

s_itab3-options = 'EQ'.

s_itab3-low = date.

s_itab3 -high = date.

append s_itab3.

Re: Range declaration

Former Member — Fri, 04 Apr 2008 09:32:56 GMT

Hi,

find the below example.

RANGES :  r_rr FOR p0000-massg.
*      (or)
data :r_rr1 type range of p0000-massg INITIAL SIZE 0,
        w_rr1  LIKE LINE OF r_rr1. 
INITIALIZATION.
  
* Ranges table for matching the Reasons for Resign
  r_rr-option  = 'EQ'.
  r_rr-sign    = 'I'.
  r_rr-low     = '01'.          " Cessation of Contract
  APPEND r_rr.

  r_rr-option  = 'EQ'.
  r_rr-sign    = 'I'.
  r_rr-low     = '05'.          " Medical Boarded out
  APPEND r_rr.
  
* Ranges table for matching the Reasons for Resign
  w_rr1-option  = 'EQ'.
  w_rr1-sign    = 'I'.
  w_rr1-low     = '01'.          " Cessation of Contract
  APPEND w_rr1 to r_rr1.

  w_rr1-option  = 'EQ'.
  w_rr1-sign    = 'I'.
  w_rr1-low     = '05'.          " Medical Boarded out
  APPEND w_rr1 to r_rr1.
.

Regards,

Sreenivasa Sarma K.

Re: Range declaration

UmaArjunan — Fri, 04 Apr 2008 09:40:42 GMT

Eg. to RANGES:

REPORT YARRANGE.

TABLES YTXLFA1.

RANGES: VENDOR FOR YTXFLA1-LIFNR.

- - - -

- - - --

- - - -

SELECT LIFNR LAND1 NAME1 FROM LFA1 INTO TABLE ITAB

WHERE LIFNR IN VENDOR.

Here with RANGES user has to design an internal table with fields -

SIGN,OPTION,LOW and HIGH EXPLICITLY.

Example:

select-options: bukrs for zstock-bukrs.

Should the user fill in 'ABFI' in BUKRS on the selection screen, BUKRS will look like this:

IEQABFI

This is because BUKRS is set as a table as follows:

begin of bukrs occurs 0,

SIGN(1) type c,

OPTION(2) type c,

LOW like bukrs,

HIGH like bukrs,

end of bukrs.

Now, when you create the following range, it will have the exact same fields set inside its table:

Ranges: bukrs for zstock-bukrs.

The difference is, because ranges doesn't show on the selection screen, you will have to fill it yourself, meaning you will have to fill bukrs-sign, bukrs-option, bukrs-low & bukrs-high all manually.

Some tips:

Sign is always I (for Include) or E (for Exclude)

Option can be a whole range, which includes:

EQ (Equal)

BT (Between))

CP (Contain Pattern)

So let's say you want to have the range check for all company codes not starting with AB, you will set your code as follow:

ranges: bukrs for zstock-bukrs.

bukrs-sign = 'E'. "Exclude

bukrs-option = 'CP'. "Pattern

bukrs-low = 'AB*'. "Low Value

bukrs-high = ''. "High Value

append bukrs.

Always remember to APPEND your range when you fill it, as the WHERE clause checks against the lines of the range table, not against the header line.

Hope this explains it well enough.

Re: Range declaration

Former Member — Fri, 04 Apr 2008 10:01:37 GMT

Hi what values should i declare in the high n low values

Re: Range declaration

Former Member — Fri, 04 Apr 2008 11:38:39 GMT

Hi its showing an error to declare as an internal table.

Re: Range declaration

former_member187109 — Mon, 17 Mar 2014 05:00:17 GMT

Hi,

This Logic may be helpful for you.

* DATA DECLARATION

RANGES : r_itab_1 for comm_product-product_id .

Data : wa_retreq like line of lt_retreq ,

lt_retreq_1 like lt_retreq ,

wa_retreq_1 like line of lt_retreq .

loop at lt_retreq into wa_retreq . * LT_RETREQ HOLDS THE VEHICLE ID

shift wa_retreq-vehicle_id left deleting leading '0' .

r_itab_1-sign = 'I' .

r_itab_1-option = 'EQ'.

r_itab_1-low = wa_retreq-VEHICLE_ID .

APPEND r_itab_1 .

endloop .

*-- Get Vehicle Guid

IF r_itab_1 IS NOT INITIAL.

Select product_guid

product_id

from comm_product

into table lt_commpr

where product_id in r_itab_1 .

Regards ,

Joyjit B

Re: Range declaration

Former Member — Mon, 17 Mar 2014 08:12:56 GMT

do not use RANGES: as it is obsolete. Use DATA: lr_test type range of blabla.

Re: Range declaration

mayur_priyan — Mon, 17 Mar 2014 09:14:54 GMT

Hi,

Try using the structure SELOPT as RANGES statement is obsolete.

Eg:

DATA:

*" Table for Valuation area

i_bwkey TYPE STANDARD TABLE OF selopt ,

*" Valuation area

e_bwkey TYPE selopt .

e_bwkey-sign = 'I'.

e_bwkey-option = 'BT'.

e_bwkey-low = '100'.

e_bwkey-low = '200'.

APPEND e_bwkey TO i_bwkey.