on 09-04-2009 10:01 AM
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.
Isn't the problem due to lower case letter ?
You should convert it to caps in transformation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check the link below:
[Allowed Chars|http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417600)ID0858249250DB00410294685402968860End?blog=/pub/wlg/4059]
Cheers,
Neel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check mapping the R3 field with formula TOUPPER(Character_String) function in the tranformation.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.