Case Statement in CDS Views

[Former Member]

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.

[Former Member]

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]

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]

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