Skip to Content
author's profile photo Former Member
Former Member

Special Chars

Hi Experts,

Data is load is failed because of Hexidecimal value.

From R/3 XREF field value is coming as TCode-P1/Rec.Type-CO.

But in BW system RSKC T.Code All these chars -,/,. are included.

So please advice me how to load data into my cube.

Thanks in Advance,

Raghav.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Sep 04, 2009 at 09:19 AM

    Isn't the problem due to lower case letter ?

    You should convert it to caps in transformation.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2009 at 06:19 AM

    Hi,

    Please check mapping the R3 field with formula TOUPPER(Character_String) function in the tranformation.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2009 at 06:50 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2009 at 05:30 PM

    Remove all entries from RSKC and enter only ALL_CAPITAL_PLUS_HEX. This has to be the only entry in that field, anything else included with it (e.g. special characters you've already defined) will invalidate the code for determining if the character is allowed.

    This will not take care of some other potential bad characters, however:

    1) You can never have '!' as the first character in a field. This is an exit character, when in the first position, used by SAP processing. There is no workaround for this but to remove the '!' and replace it with an acceptable character.

    2) You can never have '#' as a character anywhere in a field. This is the SAP representation for not assigned or null values. There is no workaround for this except to replace all '#' with an acceptable character.

    3) Space or spaces at the beginning or end of a value. To resolve this, you must either right or left trim the value through a Characteristic Rules formula (only one formula can be used) or via the ABAP statement CONDENSE in a routine (caveat: this will remove all spaces).

    4) Lowercase characters where the InfoObject hasn't been identified to accept lowercase. The two ways around this is to use a Characteristic Rules formula or ABAP routine to change the value to uppercase, or to set the InfoObject to accept lowercase characters (this needs to be done carefully however).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.