Would like to ask if anyone have done the following before in the Bex Analyzer.
Currently, my R3 system maintains the GL Account text master data in 2 languages, Malay and English. I manage to extract both Malay (MS) and English (EN) text master data into my BW system.
However, I need to create a query which can allow the users to select the text language for the 0GL_ACCOUNT that they would like to see (since both language version of the report needs to be generated). 0LANGU is not available for me to create a variable on it, and the users cannot log into the BW system with the language MS (since there's no such language pack). Currently, the report defaults to the English text only, and I could not find a way to display the Malay text. Any ideas on how to create a variable to allow my users to select the language for my G/L Account?
Thanks a lot guys..