Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

cds view join text table, if first langu not found, get second langu

lcs00
Explorer

‎2021 Sep 30 6:22 AM

0 Kudos
382

hi guys,

i want to LEFT OUTER JOIN these two tables for example,

mara and makt

and if there is no makt line exists when WHERE makt.spras = 'S', then i would like to use second option WHERE makt.spras = 'E'

is this possible and how should the CDS view code be written?

thanks.

0 REPLIES 0