Ansicht
Dokumentation
ABENCDS_F1_SQL_FUNCTIONS_CHARACTER - CDS F1 SQL FUNCTIONS CHARACTER
BAL_S_LOG - Application Log: Log header data TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
- String Functions
The following table shows the possible SQL functions for character strings in a CDS view, plus the requirements made on the arguments. The meaning of the functions can be found under SQL Functions for Strings.
| Function | Valid Argument Types | Result Type |
| CONCAT(arg1, arg2) | See below | SSTRING if an argument has the type SSTRING, else CHAR with the length of the result. |
| CONCAT_WITH_SPACE(arg1, arg2, spaces ) | arg1, arg2: see below \lbr\lbr spaces: positive numeric literal greater than 0 and less than or equal to 1331 | SSTRING if an argument has the type SSTRING, else CHAR with the length of the result. |
| INSTR(arg, sub) | arg: see below \lbr\lbr sub: non-empty character literal | INT4 |
| LEFT(arg, len) | arg: see below \lbr\lbr len: positive numeric literal greater than 0 and less than or equal to 1333 | SSTRING if arg has the type SSTRING, else CHAR with length len |
| LENGTH(arg) | See below | INT4 |
| LOWER( arg ) | See below, with the exception of NUMC, DATS, and TIMS | Data type of arg in the length of arg |
| LPAD(arg, len, src) | arg: see below \lbr\lbr len: positive numeric literal greater than 0 and less than or equal to 1333 \lbr\lbr src: Character literal | SSTRING if arg has the type SSTRING, else CHAR with length len |
| LTRIM(arg, char) | arg: see below \lbr\lbr char: Character literal with length 1 | SSTRING if arg has the type SSTRING, else CHAR with the length of arg. |
| REPLACE(arg1, arg2, arg3) | See below | SSTRING if arg1 or arg3 has the type SSTRING, else CHAR with the maximum possible length of the result. |
| RIGHT(arg,len) | arg: see below \lbr\lbr len: positive numeric literal greater than 0 and less than or equal to 1333 | SSTRING if arg has the type SSTRING, else CHAR with length len |
| RPAD(arg, len, src) | arg: see below \lbr\lbr len: positive numeric literal greater than 0 and less than or equal to 1333 \lbr\lbr src: Character literal | SSTRING if arg has the type SSTRING, else CHAR with length len |
| RTRIM(arg, char) | arg: see below \lbr\lbr char: Character literal with length 1 | SSTRING if arg has the type SSTRING, else CHAR with the length of arg. |
| SUBSTRING(arg, pos, len) | arg: see below \lbr\lbr pos and len: positive numeric literals not equal to zero | SSTRING if arg has the type SSTRING, else CHAR or NUMC with length of at lest len |
| UPPER( arg ) | See below, with the exception of NUMC, DATS, and TIMS | Data type of arg in the length of arg |
The valid argument types for arg, arg1, arg2, and arg3 are CHAR, CLNT, LANG, NUMC, CUKY, UNIT, DATS, TIMS, and SSTRING.
In functions where an explicit length len is specified, the actual length of the result is defined when the CDS view is activated and is at least as long as len.
In all functions with the exception of LPAD and RPAD, the trailing blanks of all arguments are removed before the actual processing and the trailing blanks of the result are removed before the return operation. In LPAD and RPAD, the trailing blanks of the argument src are preserved. In the case of UPPER and LOWER, the handling of trailing blanks makes no difference, as the length of the argument is retained.
Notes
- The characters in the surrogate area of the system code page UTF-16 are handled as two characters by the CDS string functions. This must be respected when the length is determined and these characters must not be split by mistake. Functions UPPER and LOWER do not change the character of the surrogate area.
- In the case of the function REPLACE, it should be noted that the maximum possible length of the result can be slightly greater than the permitted length of 1333. This produces a syntax error. In general, the maximum possible length is calculated by dividing the length of arg1 by the length of arg2, multiplied by the length of arg3.
Example
The following CDS view applies built-in SQL functions for strings in the SELECT list to columns of the DDIC database table DEMO_EXPRESSIONS. The program DEMO_CDS_SQL_FUNCTIONS_STRING uses SELECT to access the view.
TXBHW - Original Tax Base Amount in Local Currency RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 16766 Date: 20240425 Time: 061522 sap01-206 ( 223 ms )
