Replace hexidemical values in SAP BW with ABAP

Sometime it happens that users accidentally enters a horizontal tab into a text field when creating order. These are translated into BW as hexadecimal. BW displays these values as a hash tag (#). When activating a DSO, SIDs cannot be generated for these hashes. It is therefore necessary to replace these hashes with a normal characters like a space. The ABAP code below can be used for this purpose.

REPLACE ALL OCCURRENCES OF CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB in lv_string WITH space.

This code uses class CL_ABAP_CHAR_UTILITIES to get the hexadecimal representation for a horizontal tab. Also other hexadecimal representations are available in this class.

Class which can be used to replace hexadecimal value

Joury Jonkergouw

Joury Jonkergouw

Business Intelligence consultant a.k.a.a.k.a. Data Ninja, Blogger & Enthusiast. Experience in various SAP business processes. Believes strongly in a future where analytical EIM and Data Governance are the key to success.