topic Re: RANGES : in Application Development and Automation Discussions

RANGES :

Former Member — Mon, 18 May 2009 11:36:29 GMT

Hi ABAP Expert.

Please see the code below.

RANGES: COMPANY_CODE FOR VBAK-BUKRS_VF.

COMPANY_CODE-LOW = 2500
COMPANY_CODE-HIGH = 2500

SELECT * FROM VBAK
WHERE VBAK~BUKRS_VF IN COMPANY_CODE

Compare the above code with below code

SELECT * FROM VBAK
WHERE VBAK~BUKRS_VF = 2500

I am getting different results.

Looking for ur reply

thanks

Re: RANGES :

faisalatsap — Mon, 18 May 2009 11:41:47 GMT

Hi,

Do the following Way,

TYPES: BEGIN OF ty_vbak,
  bukrs_vf like vbak-bukrs_vf,
  END OF ty_vbak.

RANGES: company_code FOR vbak-bukrs_vf.
DATA: it_vbak type STANDARD TABLE OF ty_vbak WITH HEADER LINE .

company_code-option = 'EQ'. " EQ when only one Value like you are using this time only 2500 if like this Low = 2000 to High = 2500 thna use BT
company_code-sign = 'I'.
company_code-low = '2500'.
company_code-high = '2500'.
APPEND company_code.

SELECT * FROM vbak INTO CORRESPONDING FIELDS OF TABLE it_vbak
WHERE vbak~bukrs_vf IN company_code.

and Please always use Meaningful Subject Line

Regards,

Faisal

Re: RANGES :

former_member242255 — Mon, 18 May 2009 11:42:24 GMT

Example for Ranges:

*Ranges declaration for PO Number

DATA : r_ebeln TYPE RANGE OF ebeln,
       w_ebeln LIKE LINE  OF r_ebeln.
   MOVE :'I'                     TO w_ebeln-sign,
          'EQ'                    TO w_ebeln-option,
          wa_cdpos-objectid+0(10) TO w_ebeln-low.
    APPEND w_ebeln TO r_ebeln.
    CLEAR: w_ebeln.

Re: RANGES :

Former Member — Mon, 18 May 2009 11:42:32 GMT

there is an error in first example...

it should be:


COMPANY_CODE-LOW = 2500.
COMPANY_CODE-HIGH = 2500.
COMPANY_CODE-OPTION = 'EQ'
COMPANY_CODE-SIGN = 'I'.
APPEND COMPANY_CODE.

regards, darek

Re: RANGES :

Former Member — Mon, 18 May 2009 11:42:45 GMT

Point 1: the RANGES statement is obsolete and should not be used anymore. try using following:

Data: company_code type range of bukrs_vf.

Point 2: iu cant see any append when building your range. i guess the first statement gives you ALL records.

Re: RANGES :

Former Member — Mon, 18 May 2009 11:55:34 GMT

thanks everyone i awarded u two the points.

Re: RANGES :

Former Member — Mon, 18 May 2009 11:57:22 GMT

use this code.... it will give you complete result....

RANGES: COMPANY_CODE FOR VBAK-BUKRS_VF.
 
COMPANY_CODE-SIGN = 'I'.
COMPANY_CODE-OPTION = 'EQ'.
COMPANY_CODE-LOW = 2500.
APPEND COMPANY_CODE.
 
SELECT * FROM VBAK
WHERE VBAK~BUKRS_VF IN COMPANY_CODE

Regards,

Siddarth

Re: RANGES :

Former Member — Mon, 18 May 2009 12:07:59 GMT

HI Ajay,

RANGES: r_company_code FOR VBAK-BUKRS_VF.
 
r_company_code-sign   = 'I'.   
r_company_code-option = 'EQ'.  
r_company_code-LOW = 2500
append r_company_code.

SELECT * 
FROM VBAK
WHERE VBAK~BUKRS_VF IN r_company_code

Regards,

Sravanthi

Re: RANGES :

Former Member — Mon, 18 May 2009 12:13:42 GMT

Hi,

RANGES: COMPANY_CODE FOR VBAK-BUKRS_VF.

COMPANY_CODE-LOW = 2500

COMPANY_CODE-HIGH = 2500

SELECT * FROM VBAK

WHERE VBAK~BUKRS_VF IN COMPANY_CODE

Compare the above code with below code

SELECT * FROM VBAK

WHERE VBAK~BUKRS_VF = 2500

There was a difference in both statments.

For the first select query it will retrieve the data from company code 0000 to 2500. Ranges will creates a Sign, Options, Low and High.

Sign = I

Options = BT

Low = 2500

High = 2500

So your condition is retrieving the data as a company code input BT 0001 to 2500. So you gill get the result from 0000 to 2500.

The second select query it will fetches the record only the company code 2500. So you will get the record for only 2500.

Let me know if you have anything.

Regards

Thiru