SAP ABAP Data Element RALDB_SIGN (SIGN field in creation of SELECT-OPTIONS tables)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-ABA-TO (Application Component) Logical DB, Selection Screens, Selection Variants
     SLDBV (Package) Selection Screens, Variants, Logical Databases
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