Page 1 of 1

2 languages in one Bex-Report

PostPosted: Mon Oct 07, 2013 5:11 am
by xmchx
Dear all,
I have a master data query for 0GL_ACCOUNT. We have loaded the Texts in several languages. Now I would like to create one query which shows the Text in language "DE" and in language "EN". How can I manage to bring both languages in one query result?

Example:

GL Account No. Text DE Text EN
0815 Anlage Asset

Thanks!
xmchx

Re: 2 languages in one Bex-Report

PostPosted: Thu Dec 19, 2013 9:02 am
by RavekiD
There are several options.

I'd create a copy of Char and name it say XXX_DE, original would stay as is.
During data loads, all English texts would go into original Char, but German into XXX_DE (but with language key 'EN').
Both Chars should be present in Cube, MP and Query.

Of course if your users are running different languages, then there has to be a bit more combinations, but similar approach can be used.