2 languages in one Bex-Report

Business Warehouse

Moderators: Snowy, thx4allthefish

Post Reply
Posts: 73
Joined: Sun Apr 05, 2009 11:10 pm

2 languages in one Bex-Report

Post by xmchx » Mon Oct 07, 2013 5:11 am

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?


GL Account No. Text DE Text EN
0815 Anlage Asset


Posts: 323
Joined: Thu Aug 18, 2005 5:29 am
Location: Planet Earth

Re: 2 languages in one Bex-Report

Post by RavekiD » Thu Dec 19, 2013 9:02 am

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.
think 1 minute longer

Post Reply