Skip to Content
0
May 17, 2016 at 05:40 AM

Reading texts based on logon language

309 Views

Hello All,

I have a requirement where I need to get short text based on the logon language.

If the text is not maintained in logon language, then I need fetch it from English language.

Example

Consider a join between MARA and MAKT.

In Table MAKT

MATNR SPRAS MAKTX 1 DE Test1-DE 1 EN Test1-EN 2 EN Test2-EN

Consider the logon language in DE,

For material 1 there is text in language DE, so the output should to be Test1-DE

For material 2 there is no text in language DE, so the output should be from EN language Test2-EN

I tried to use left outer join , but that gives few records with empty text or text in both languages, which we can later delete them.

And there are lot of other ways by which we can refine the internal table after the select is performed.

What I am looking for, is there any way we can do it in select query itself, considering new advancements in ABAP open SQL and CDS views.

With regards,

Sandeep Akella