topic Re: Case Statement in CDS Views in Application Development and Automation Discussions

Case Statement in CDS Views

Former Member — Fri, 27 May 2016 17:36:15 GMT

Hello,

In a CDS View how can I use the Case statement to validade a field that is not retrieved from an outer join?

Here follows the example:

How can I verigy if ekbe_mseg.belnr is empty?

Thank you.

simon_collet — Mon, 30 May 2016 05:20:52 GMT

Hi,

you're on the right path, the solution is

case when ekbe_mseg.belnr is null

then '@S_LEDR@'

else '@S_LEDG@'

end as icon

Best regards,

Simon

Former Member — Mon, 30 May 2016 08:04:39 GMT

Hi Simon,

It worked. Thank you. The CDS View was activated successfully, but the editor does not seem to recognize the sintax. Is it normal?

Best Regards,

Luís Martins