on 07-13-2017 1:13 PM
Hello Experts,
I have one doubt-
I am trying to use COALESCE function but it does not work
it always returns first value even in table value is blank.
When i checked the table i found "NOT NULL" is "X" in DB, so value is never NULL
to check this i created a table in SE11 , even though i am selecting "initial" flag X or not, DB automatically sets "NOT NULL"
Now i am little bit confused how to deal with this, how to use 'coalesce' function.
If anyone has any idea please clear my doubt.
Thanks in advance
Ashish T.
The NOT_NULL flag is only relevant for inserting new fields into existing database tables.
It does not say, that there can't be null values in that field. But normally you simply don't have null values in database tables defined in the dictionary and accessed by ABAP.
Null values can arise as described here:
See also the example for COALESCE in Open SQL:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.