cancel
Showing results for 
Search instead for 
Did you mean: 

Special Chars

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

Isn't the problem due to lower case letter ?

You should convert it to caps in transformation.

Former Member
0 Kudos

In RSKC put ALL_CAPITAL_PLUS_HEX at the end of permitted characters.

Our in your transformation convert the data to upper case as Praveen said.

Thansks,

Nick.

Answers (3)

Answers (3)

dennis_scoville4
Active Contributor
0 Kudos

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).

neelesh_jain3
Contributor
0 Kudos

Check the link below:

[Allowed Chars|http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417600)ID0858249250DB00410294685402968860End?blog=/pub/wlg/4059]

Cheers,

Neel.

Former Member
0 Kudos

Hi,

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

Thanks