topic Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE in Application Development and Automation Discussions

Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

Former Member — Wed, 03 Jan 2007 09:39:08 GMT

Hello,

we changed from 4.6 to ECC 700.

Most of our problems were easy to solve but this one is difficult because nobody here has experience with this special issue 'code pages'.

We have one report which has to move data to a host.

The data consists of customer information like names, addresses etc..

Unfortunately this is germany and lots of addresses contain umlauts (you know: Ü,Ä,Ö). The host cannot work with them so the report has to convert them.

The currently used code is:(example)

TRANSLATE S-KUNDE FROM CODE PAGE '1100' TO CODE PAGE '9103'.

Code page 9103 is a customer specific one.

And both pages are available in table TCP00.

Everything was fine in 4.6, ( so all attributes to be used when converting are available from the code pages.)

But in ECC700 we have an error when running this report.

'converting from code page 1100 to code page 9103 is not possible'.

Our ECC 700 is NOT a unicode system!

And if I understand this right from some of the few threats about this issue here the used command is not obsolete.

But how can we make it work again?

Any ideas are welcome!

Regards

Dirk

null

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

andreas_mann3 — Wed, 03 Jan 2007 11:12:32 GMT

Hi Dirk,

look int abap-help with F1 to:

Varianten:

1. TRANSLATE dobj [FROM CODE PAGE cp1] [TO CODE PAGE cp2].

2. TRANSLATE dobj [FROM NUMBER FORMAT nf1] [TO NUMBER FORMAT nf2].

-> your command is obsollete

(my rel. is SAP ERP 5.0)

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

athavanraja — Wed, 03 Jan 2007 11:33:04 GMT

may be you could try this FM

SCP_TRANSLATE_CHARS

where you can specify source codepage and target codepage

Regards

Raja

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

Former Member — Wed, 03 Jan 2007 12:02:17 GMT

Thank you, Raja!

With this function module we could find out that our code page is possibly incorrect now.

It is the code page for our target!

The result when using the FM is: Codepage is empty!

So my next question is: where to maintain code pages?

Can you give me a hint or more?

Regards

Dirk

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

athavanraja — Wed, 03 Jan 2007 12:06:58 GMT

check this online help.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/74/57453c3ff4110ee10000000a11405a/frameset.htm">Creating a Code Page</a>

Regards

Raja

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

Former Member — Wed, 03 Jan 2007 12:20:16 GMT

Hi Raja,

looks like I have some work for this afternoon learning something new!

Some more questions are open but they will be easier to solve when we are not running through total darkness!

Thank you for your help!

Regards

Dirk

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

Former Member — Wed, 03 Jan 2007 12:21:17 GMT

Re: Changing from 4.6 to ECC700 - error with command TRANSLATE CODE PAGE

athavanraja — Wed, 03 Jan 2007 12:22:45 GMT

Hi Dirk,

Glad i could help. do get back if you still have problems.

Regards

Raja