Hierarchy
⤷
⤷
Basic Data
| Data Element | RALDB_SIGN |
| Short Description | SIGN field in creation of SELECT-OPTIONS tables |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | RALDB_SIGN | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| 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 | SIGN |
| Medium | 15 | SIGN |
| Long | 20 | SIGN |
| Heading | 55 | SIGN |
Documentation
Definition
This field allows you to enter either "I" or "E".
- "I" (Inclusive) means that the single value or range you specified is selected itself.
- "E" (Exclusive) means that the single value or range you specified is excluded from the selection. The default is "I".
Example
1000 5000 BT I
returns everything between 1000 and 5000.
D _ EQ I
returns D (selects, for example, all domestic customers).
1000 5000 BT E
returns everything apart from the values between 1000 and 5000.
D _ EQ E
returns everything apart from D (selects, for example, all foreign customers).
Combining "I" and "E"
If you enter several values for a selection criterion and use both "I" and "E", the system always combines all the selections with "I" first and then removes those selections specified with "E".
Example
Suppose you want a list of addresses for the zip code areas 3000 and 6000, but want to exclude large cities. You could make your selection as follows:
3000 3999 BT I
6000 6999 BT I
3+00 _ CP E
6+00 _ CP E
The system first selects the entire ranges and then removes those values that end with '00' (i.e. the round hundred values).
History
| Last changed by/on | SAP | 20010130 |
| SAP Release Created in |