Monday, September 3, 2012

Dealing the Special Characters In BW

TCode: RSKC or table: RSALLOWEDCHAR

As per the requirement, if characters like „#? or „!? has to be present as the 1st character then we can use ALL_CAPTIAL or ALL_CAPITAL_PLUS_HEX or ALL_CAPTIAL* in RSKC or if this is required only in one particular IOBJ, then a field routine can be written in the transformation.

The Function Module 'SCP_REPLACE_STRANGE_CHARS', can be used in the field routine or in the start routine, which will remove the unwanted characters from the specified field or in whole.

The Function Module ' RSKC_CHAVL_CHECK? can be used to check the Non-Allowed characters in BW, then we can use the ABAP Replace statement to replace it with a valid statement.

REPLACE ALL OCCURRENCES OF „X? IN i_string WITH 'Y'

To deal with special characters, invisible, like TAB, CR BACKSPACE etc. you need to write ABAP routines in transfer rules to eliminate them.

Check the below link for more information:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0cdc928-5e2d-2e10-e1bb-ec77bcb5cbfd?QuickLink=index&overridelayout=true

No comments:

Post a Comment