2 languages in one Bex-Report

[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

[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.