BW Related ABAP - SELECT-OPTIONS and RANGES

 Both Ranges and Select-Options are used for maintaining Ranges.

  • Select-Options are used for taking input from user on selection screen
  • In case of Select-Options system itself creates an internal table
  • In case of Ranges, the internal table should be defines explicitly
  • The internal table contains four fields- Sign, Option, Low and High.
  • Special operator IN is used in comparisons.
SIGN

The data type of SIGN is C with Lengh 1. Possible values are I and E.

  • I stands for "inclusive" (operators are not inverted)
  • E stands for "exclusive" (operators are inverted)
OPTION

The data type of OPTION is C with length 2. OPTION contains the selection operator.

The following operators are available:

  • if HIGH is empty, you can use EQ, NE, GT, LE, LT, CP and NP.
  • if HIGH is filled, you can use BT (Between) and NB (Not Between)
LOW

To maintain lower limit of range.

HIGH

To maintain higher limit of range.

Ex:

SELECT-OPTIONS range_ex FOR sy-index.

SELECT-OPTIONS matno FOR mara-matnr.

RANGES docu_num FOR likp-vbeln.

Example Program:

REPORT.

TABLES SCARR.

RANGES EX FOR SCARR-CARRID.

*--filling RANGES with a single value

EX-SIGN = 'I'.

EX-OPTION = 'EQ'.

EX-LOW = 'UA'.

APPEND EX.

SELECT * FROM SCARR WHERE CARRID IN EX.

WRITE:/ SCARR-CARRID, SCARR-CARRNAME.

 

 

Comments

Post a Comment

Popular posts from this blog

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more

OPEN SQL EXAMPLES IN ABAP – PART 2

 ******************************************* **displaying Raw Materials and Finished products **only from MARA table. DATA WA TYPE MARA. * **--WHERE clause is for filtering the records SELECT * FROM MARA INTO WA WHERE MTART = 'ROH' OR MTART = 'FERT'. WRITE: / WA-MATNR, WA-MBRSH, WA-MTART, WA-MEINS. ENDSELECT. * **************************************************
Read more

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more