conditional statement to make comparision between tables

[devboy]

a table has two columns one for English language and one for french language if user is English then it should show English description if user is french then it should show french description then for that what i have to do if i use Conditional Statement then how can I make comparison In every table. If this two field i.e. English & French column so I need to Make logic for that.

Anyone can help me then most welcome.

Regards

Saurabh

[venkateswaran_k]

Hi

Can you please explain with some examples. Not able to get it fully.

Do you want it in SQL or ABAP?

Which table ?

[devboy]

I want a sql code which is used in a cat-service.cds file actually we have problem statement like when we get a response from user means if they select a english language then we need to compare the table and according to show the table fields inside a table and if user select french then for that we need to show a some different table field for that which operation we need to perform please share your response If you knows something related to this issueRegards,Saurabh

[venkateswaran_k]

I put some example code in answer.

[venkateswaran_k]

Hi

You may use the union based on the session variable as below:

Provided, the COL1 , COL2, COL3 of same type.

SELECT COL1, COL2, COL3 
FROM TABLE
WHERE SESSION_CONTEXT('LOCALE_SAP') = 'EN'
UNION
SELECT COL1, COL2, COL3 
FROM TABLE
WHERE SESSION_CONTEXT('LOCALE_SAP') <> 'EN'

Regards,

Venkat

[yannmiquel]

the 'LOCALE_SAP' is a one letter convention ('E'), isn't it ?

[devboy]

Thank You for your response but what I required I have a 5-6 table in which there are multiple field and in that table there is English description column and French description column also so we need to convert those column i.e. English to french. So, the challenge is How can we get that type of user either English or French user then we need to make comparison of that table and need to make change.

Regards,

Saurabh

[venkateswaran_k]

Yes it is Single Char 'E'

[yannmiquel]

Hi,

If you can use the LOCALE of the users, then a calculation view with "Text join" can be a good option. Since you have one column for each language, you should do an union of these 2 in 1 column with a fixed input for the language (E or F) in a 2nd column.

Regards,

Yann