conditional statement to make comparision between tables

[venkateswaran_k]

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.

[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