Hierarchy
⤷ 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 | 2 | 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 |