SAP ABAP Data Element ISH_OPTI (IS-H: Option for RANGE tables)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       NPAS (Package) Application development patient accounting system
Basic Data
Data Element ISH_OPTI
Short Description IS-H: Option for RANGE tables  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type RALDB_OPTI    
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    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Option 
Medium 14 Option 
Long 20 Option 
Heading Op 
Documentation

Definition

In this field, you can specify an operator to define the entered values as a single value, range or search pattern in order to restrict data selection. The operators work together with the fields lower limit (from) and upper limit (to) as well as the include/exclude criterion (I/E).

Subsequent operators can be entered:

EQ    Equal
BT    BeTween
LE    Less Equal
GE    Greater Equal
CP    Contains Pattern

EQ

Single value selection. Selects exactly the value you enter.

Example:

MILLER    __    EQ    _
returns exactly the value MILLER.
(Onderscores denote blank input fields)

BT

Interprets the lower and upper limit values entered as a range.

Example:

1000    2000    BT    _
returns all values between 1000 and 2000.

LE

Interprets the value entered in the lower limit field as the upper limit of a range with no specified lower limit. The limit itself is included in the range.

Example:

1000    _    LE    _
returns all values smaller than or equal to 1000.

GE

interprets the value entered in the lower limit field as the lower limit of a range with no specified upper limit. The limit itself is included in the range.

Example:

1000    _    _GE    _
returns all values greater than or equal to 1000.

CP

The value entered in the lower limit field is masked. Here
+    stands for one character
*    stands for any number of characters, even none.

Example:

M+++ER*    _    CP    _
returns all values that begin with M, contain the letters ER in the fifth and sixth positions and end with any string of characters.

If you use the characters * and + together with another operator they are not interpreted as placeholders, but stand for themselves.

Example:

a*c    _    EQ    I
returns a*c.

Note

For the first entry in the lower limit and upper limit fields, the system automatically sets the suitable operator, if none was entered.

Example

1000    _    _    _

3000    5000    _    _

MIL*    _    _    _

5000    _    GE    _

When you press Enter, this becomes:

1000    _    EQ    _

3000    5000    BT    _
MIL*    _    CP    _
5000    _    GE    _
If you change the lower limit value, the upper limit value, or the operator itself after pressing Enter, you must specify the operator yourself. The same applies if you are assigning values to these fields from a program.

History
Last changed by/on SAP  20050224 
SAP Release Created in