SAP ABAP Data Element BAPIOPTION (Selection operator OPTION for range tables)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-MID-API (Application Component) BAPI Tools (for BAPIs see Note 813411)
     SBF_BAPI (Package) Business Framework BAPI, Central Modules, Tools
Basic Data
Data Element BAPIOPTION
Short Description Selection operator OPTION for range tables  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type BAPIOPTION    
Data Type CHAR   Character String 
Length 2    
Decimal Places 0    
Output Length 2    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name OPTION   
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Option 
Medium 20 Selection op. OPTION 
Long 25 Selection operator OPTION 
Heading 55 Selection operator OPTION for range tables 
Documentation

Definition

These operators are used to specify whether the values entered in this field are to be used as single values, area or search strings to limit the data selected. The operators are used together with the fields LOW (lower limit) and HIGH (upper limit) as well as the inclusion/ exclusion criteria SIGN.

The operators provided are:
EQ - Equal
NE - Not Equal
BT - Between
NB - Not Between
LT - Less Than
LE - Less Equal
GT - Greater Than
GE - Greater Equal
CP - Contains Pattern
NP - Not contain Pattern

The examples below are based on the line structure of RANGE tables:

SIGN        OPTION      LOW         HIGH

Underscores represent empty input fields.
X stands for "I" or "E".

1. EQ

Selects a single value. The value selected is the value that you have entered in the field LOW.

Example:

X           EQ          MEIER       __

Returns the value MEIER.

2. NE

Excludes a single value. All values are selected that are not equal to the value in the field LOW.

Example:

X           NE          MEIER       __

Returns all the values that are not equal to MEIER.

3. BT

The two values entered as the lower and upper limits represent the area between which the selected values must lie.

Example:

X           BT          1000        2000

Returns all values between 1000 and 2000.

4. NB

Both the values entered as the lower and upper limits represent the range between which the values selected must NOT lie.

Example:

X           NB          1000        2000

Returns all values that are NOT between 1000 and 2000.

5. LT

The value in the field LOW is the upper limit of a range. The limit itself is not selected.

Example:

X           LT          1000        __

Returns all values that are less than 1000.

6. LE

The value entered in the field LOW is the upper limit of a range. The limit itself is selected.

Example:

X           LE          1000        __

Returns all the values that are less than or equal to 1000.

7. GT

The value in the field LOW is the lower limit of a range. The limit itself is not selected.

Example:

X           GT          1000        __

Returns all values that are greater than 1000.

8. GE

The value in the field LOW is the upper limit of a range. The limit itself is selected.

Example:

X           GE          1000        __

Returns all values greater or equal to 1000.

9. CP

The value in the field LOW is masked.
- "+" stands for precisely one character
- "*" stands for any number of characters, including no characters

All values are selected that match the character pattern in the field LOW.

Example:

X           CP          M++ER*      __

Returns all values that begin with "M", contain the letters "ER" after any two other characters and end with with a character string of any length.

10. NP

The value entered in the field LOW is masked.
- "+" stands for precisely one character
- "*" stands for any number of characters, including no characters.

All values are selected that are not equal to the character pattern in the field LOW.

Example:

X           NP          M++ER*      __

Returns all values that are not equal to the character strings that begin with "M", contain the letters "ER" after any two other characters and end with with a character string of any length.

Note

With the options CP and NP the fields LOW and HIGH must be of type C (character). The field LOW must contain at least one masking character (otherwise the operator EQ is used).

If you use the characters "*" and "+" together with another operator, they are not interpreted as place holders - they stand for themselvs.

Example:

I           EQ          a*c         __ returns precisely a*c.
History
Last changed by/on SAP  20010130 
SAP Release Created in