cancel
Showing results for 
Search instead for 
Did you mean: 

Extraction from a unicode ERP to a non unicode BW

Former Member
0 Kudos

Hi Friends,

We did an unicode conversion in our ERP (ECC6.0).

When we are now loading attributes from our chinese clients into our non unicode BW (3.5), we have to face an alignment issue in PSA, i.e. (a part of) content of a field is moved into the next field. Therefore load fails e.g. because of conversion exit or not permitted characters. Upload of texts works properly.

Can somebody help me out?

Thanks in advance

Joe

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Joe,

I guess you are trying to load 0CUSTOMER or 0VENDOR data. If so there is an OSS Note on this from SAP. I am not sure about the number.

Bye

Dinesh

Former Member
0 Kudos

Hi Dinesh,

Thanks for reply.

Exactly, I try to load 0CUSTOMER or 0VENDOR.

I already searched OSS for hours and hours. There is a note

715247 related to 0CUSTOMER and 0VENDOR, but it contents the solution for loading into an unicode BW (my problem is vice versa). And process doesn't end with a dump as decribed It's terminated with a red traffic light in monitor.

Any other idea?

Best Regards

Joe

Answers (2)

Answers (2)

Former Member
0 Kudos

Problem solved. Thanks to SAP Notification Service.

As I understood, system tries to "translate" characters from Unicode ERP due to field SPRAS to local codepage in BW.

This fails e.g. when 'CN' meets an european codepage.

Solution (workaround):

Initialzation of SPRAS in INCLUDE ZXRSAU02.

If SPRAS is used in BW, you aditionally have to append datasource by a "Z" field, assign content of SPRAS in ZXRSAU02 and later map this to info object in BW.

Edited by: J.F.B. on Oct 10, 2008 2:14 PM

Former Member
0 Kudos

Hi,

We are facing a similar issue. could you give more details as how you did the initialization in r/3 for SPRAS.

Thanks,

Joseph M

desgallagher
Contributor
0 Kudos

Hi Joe,

Please check if the note 673533 can help with the problem you have. If not can you let me know the exact error text and the error code that you

get in the monitor when the load fails?

Best Regards,

Des.

Former Member
0 Kudos

Hi Des,

Many thanks. I already checked this note, but I think it isn't

useful in my case , because we run ECC60 with PI 2006_1_700. Or is required API not implemented autmatically?

How can I check this?

However, please let me give an example (0Vendor_Attr):

Fields in PSA (BW)

House number and street

ÉϺ£ÊĐÇàÆÖ¹¤̉µÔ°Çøäî

Telephone 1

ӯ·3775ºÅ

Fax Number

021-59227679 021

Trading pa

-59227

Fields in RSA3(ERP)

House number and street

上海市青浦工业园区漕盈路3775号

Telephone 1

021-59227679

Fax Number

021-59227699

Trading pa

700205

Error msg

InfoObject 0PCOMPANY contains non-alpha compliant value

-59227

after activating conersion exit alpha for 0PCOMPANY:

Value ӯ·3775ºÅ' for characteristic 0PHONE contains invalid characters

That's clear when you consider the alignment.

Edited by: J.F.B. on Oct 9, 2008 1:48 PM