Invalid characters in SAP BW 3.x: Myths and Reality. Part 1.
There are no invalid characters in texts of infoobjects!
There are several wide-spread delusions (I call them myths) in SAP BW world that even some experienced BWers share. I’d like to list these myths and make some comments.
Myth 1: Everything said (in documentation, help, notes etc.) about valid and invalid characters in SAP BW 3.x is equally applied to both, infoobjects texts and their characteristic values.
It is very well known that the most of errors occurring during data load in SAP BW is related to invalid characters in data inflow. All these errors happen with infoobjects characteristic values. There are some settings need to be made in order to load data with lowercase letters or foreign language symbols. By default, all these precautions spread on infoobjects texts also. It produces the other myth.
Myth 2: Infoobjects texts accept limited number of characters and special settings should be made in order to load texts with lowercase letters.
I’ll show that these two myths are simply delusions. I made a special experiment. First, with Visual Basic I created a txt file with all available characters with ASCII codes from 0 to 255 (non-Unicode system). It doesn’t matter that characters with hexadecimal code 00 – 1F are replaced in the file by ESC symbol, the same happens during file saving as CSV or TXT. Here is created file.
- the first row represents invisible characters (hex 00-1F);
- there are “!” and “#” signs alone in separate rows;
- there are both, uppercase and lowercase letters;
- there are cyrillic letters (foreign language).
- Lowercase Letters flag for infoobject where I’m going to load data, WAS NOT checked.
- There is NOTHING set in RSKC.
Here is a result of data load (master data maintenance screen):
As one can see, all data have been loaded without any problems. It proves that infoobjects texts accept ANY CHARACTERS regardless of any settings. Hence, use literal data in infoobjects texts (instead of characteristic values) whenever possible and acceptable. It’ll relieve you from many problems with data loading. The list of myths related to invalid characters in characteristic values is here: Invalid characters in SAP BW 3.x: Myths and Reality. Part 2.