topic COALESCE in Application Development and Automation Discussions

COALESCE

sabarna17 — Mon, 14 Dec 2015 13:15:16 GMT

Hi,

SELECT EBELN, INFNR,

MATKL,

COALESCE( s~INFNR, s~MATKL ) AS ABCD

FROM EKPO AS s

UP TO 20 ROWS

INTO TABLE @DATA(lt_result).

I am Using the previous code to test.

But if s~INFNR is null and s~MATKL consists value, then also blank is displaying in ABCD column.

Need clarification.

-Sabarna

former_member183045 — Thu, 17 Dec 2015 08:19:55 GMT

In the field INFNR there is never a null value but an empty value. So you can not use coalesce here because infnr is always set

SELECT * FROM EKPO WHERE INFNR = '' ... returns a lot of results

SELECT * FROM EKPO WHERE INFNR is null ... returns no results

So in your case you should use matkl if infnr = ''

Best regards, Andreas