Question Re: conditional statement to make comparision between tables in Technology Q&A

conditional statement to make comparision between tables

devboy — Thu, 18 Aug 2022 05:56:33 GMT

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

Re: conditional statement to make comparision between tables

venkateswaran_k — Thu, 18 Aug 2022 06:24:39 GMT

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

Do you want it in SQL or ABAP?

Which table ?

Re: conditional statement to make comparision between tables

yannmiquel — Thu, 18 Aug 2022 07:11:23 GMT

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

Re: conditional statement to make comparision between tables

devboy — Thu, 18 Aug 2022 08:02:46 GMT

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

Re: conditional statement to make comparision between tables

venkateswaran_k — Thu, 18 Aug 2022 08:17:17 GMT

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

Re: conditional statement to make comparision between tables

venkateswaran_k — Thu, 18 Aug 2022 08:17:47 GMT

I put some example code in answer.

Re: conditional statement to make comparision between tables

yannmiquel — Thu, 18 Aug 2022 08:57:31 GMT

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

Re: conditional statement to make comparision between tables

devboy — Thu, 18 Aug 2022 09:17:49 GMT

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

Re: conditional statement to make comparision between tables

venkateswaran_k — Thu, 18 Aug 2022 09:19:00 GMT

Yes it is Single Char 'E'