Ansicht
Dokumentation

ABENCDS_F1_COALESCE_EXPRESSION - CDS F1 COALESCE EXPRESSION

ABENCDS_F1_COALESCE_EXPRESSION - CDS F1 COALESCE EXPRESSION

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

- coalesce

... COALESCE( arg1, arg2 ) ...

Effect

Coalesce function in a SELECT statement of a CDS view. The coalesce function returns the value of the argument arg1 (if this is not the null value), else it returns the value of the argument arg2. The arguments can be literals, fields of a data source, input parameters, built-in functions, or expressions of data types CHAR, SSTRING, CLNT, LANG, NUMC, CUKY, UNIT, DATS, TIMS, DATN, TIMN, UTCL, DECFLOAT16, DECFLOAT34, FLTP, DEC, CURR, QUAN, INT1, INT2, INT4, or INT8.

The data types of both arguments must either match of the data type of one argument must represent the full value of the other data type. The result has the dictionary type of the argument with the greater value range.






TXBHW - Original Tax Base Amount in Local Currency   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 2872 Date: 20240329 Time: 093345     sap01-206 ( 40 ms )