Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-WHM-DST (Application Component) Data Staging⤷
RSDS_ACCESS (Package) Access methods Apollo DataSource
Basic Data
| Data Element | RSDS_DATASEP |
| Short Description | Data Separator |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR4 | |
| Data Type | CHAR | Character String |
| Length | 4 | |
| Decimal Places | 0 | |
| Output Length | 4 | |
| 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 | Data Sep. |
| Medium | 15 | Data Separator |
| Long | 20 | Data Separator |
| Heading | 14 | Data Separator |
Documentation
Definition
Use
If the values in your file (CSV file, for example) are separated using a particular character, you enter this separator in the Data Separator field.
Note the following when entering escape characters:
- Always enter one character for the field - either a letter, a number or a special character !"§$%&/()=,;.:-_#'+*{[]} .
You have to enter the character at the beginning of the input field. If you have two characters in the input field, the system tries to interpret these as a hexadecimal number.
- The letters, numbers or special characters that you enter are converted to a hexadecimal number.
- If you want to enter special characters such as tab or linefeed, or if you are not sure whether, for example, a semicolon also needs to be interpreted as a semicolon in your file, enter the special character in hexadecimal code. These are not filtered before they are used during loading.
Dependencies
If you select the Hex indicator, the entry in the Data Separator field is always displayed as a hexadecimal number. If you enter a character for the data separator, this is displayed as hexadecimal code after the entries have been checked. A 2 character entry for a data separator is always interpreted as a hexadecimal entry if the Hex indicator is set.
If the data separator character is a part of the value, this is indicated in the file as the value is enclosed in particular start and end characters. You specify these start and end characters in the Escape Characters field.
Example
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 700 |
