Multi lang. rec in DB and conversion into login lang. and disply/ print

[satish_talikota]

I just gathered a point that, in Unicode system, for example in a single instance and single client, when 2 different language logins happen by 2 users, they can maintain their data in their respective languages eg: in CMR, KNA1 table you can have one record in chinese and one in German. So when the data is retrieved in a list/ report, the data is converted in the login language Eg: if the chinese has logged in, he will see the German language stored in the database due to 1st users login and data maintenance converted into Chinese language. However in the database, it is always the login language which is stored. Conversion happens only in the list.

Based on this funda, the program assigned to the output type when it reads the data from the database of different languages, it converts into the login language and prints it out.

Can you please validate this point and also send some good document which is simple to understand the Unicode funda understanding of language conversion of reports and invoices etc.

Also the Unicode Infrastructure pre-requisites from Basis point of view.

Lastly, I want to know how BI interprets multi languages data from SAP and other sources and have the ability to convert into any login language while taking a report.

Eg: 10 users enter data in 10 different langugages in 10 different source systems creating say 10 records. Now, when 1 user logs in this language, he should be able to get the 9 other records data converted into his login language. Same should be for other 9 users.

Please let me know if this is possible in BI system.

[markus_doehr2]

I just gathered a point that, in Unicode system, for example in a single instance and single client, when 2 different language logins happen by 2 users, they can maintain their data in their respective languages eg: in CMR, KNA1 table you can have one record in chinese and one in German. So when the data is retrieved in a list/ report, the data is converted in the login language Eg: if the chinese has logged in, he will see the German language stored in the database due to 1st users login and data maintenance converted into Chinese language. However in the database, it is always the login language which is stored. Conversion happens only in the list.

>

> Based on this funda, the program assigned to the output type when it reads the data from the database of different languages, it converts into the login language and prints it out.

Especially with KNA1 and addresses the situation is a bit different, here is the language filed filled with the language the addresse was created.

> Can you please validate this point and also send some good document which is simple to understand the Unicode funda understanding of language conversion of reports and invoices etc.

Well, this whole thing is not really "simple" You can be logged on in German, create a English order confirmation and write a chinese invoice - depending on the configuration of your message processing.

> Also the Unicode Infrastructure pre-requisites from Basis point of view.

With Unicode you can enter and read any character (that your SAPGUI fonts supports) at any time without changing logon language.

> Lastly, I want to know how BI interprets multi languages data from SAP and other sources and have the ability to convert into any login language while taking a report.

If it's Unicode you will see all characters.

Markus

[nils_buerckel]

Hi,

you are asking several questions here ...

However please note that most of it is independent of Unicode .... Unicode simply means that all characters can be stored on the DB - the language key does not matter ...

The question of language dependency is more complicated, as it is application dependent ...

In general for language dependent data, the system tends to display the data stored in the logon language.

Please note that address data is rather an exception (not language dependent, but customers can maintain address versions - see also SAP note 1375438 > point 6).

For BW, you might need to check SAP note 173255 in order to upload all existing languages.

Best regards,

Nils Buerckel