Ansicht
Dokumentation
ABENSQL_FUNCTIONS_STRING - SQL FUNCTIONS STRING
BAL_S_LOG - Application Log: Log header data Vendor Master (General Section)This documentation is copyright by SAP AG.
- SQL Functions for Strings
The following table shows the SQL functions for strings that can be used by ABAP CDS and . The columns ABAP CDS, DDIC-Based Views / View Entities and SQL indicate where a function can be used. The Table Buffer column indicates whether the function can be executed in the table buffer.
SQL Function | Result | CDS DDIC-Based Views | CDS View Entities | Table Buffer | |
CONCAT | Concatenates strings | x | x | x | x |
CONCAT_WITH_SPACE | Concatenates strings with a specified number of blanks in between | x | x | x | x |
INITCAP | Transforms the first letter of a word to uppercase and all remaining letters to lowercase | x | - | ||
INSTR | Returns the position of the first occurrence of a string in another string | x | x | x | - |
LEFT | Returns the leftmost characters of a string with a specified length | x | x | x | - |
LENGTH | Returns the length of a string | x | x | x | x |
LIKE_REGEXPR | Checks whether a string contains any occurrence of a Perl Compatible Regular Expression (PCRE) | x | - | ||
LOCATE | Returns the position of a string in another string. The function enables the specification of further parameters like the starting position of the search and the number of the occurrence. | x | - | ||
LOCATE_REGEXPR | Searches a string for a PCRE pattern and returns the offset of the match | x | - | ||
LOCATE_REGEXPR_AFTER | Searches a string for a PCRE pattern and returns the offset of the match plus 1 | x | - | ||
LOWER | Transforms all uppercase letters to lowercase letters | x | x | x | - |
LPAD | Creates a string with a specified length while adding a specified string to the end of another one. | x | x | x | - |
LTRIM | Removes all trailing blanks and leading characters that match specified characters | x | x | x | - |
OCCURRENCES_REGEXPR | Counts and returns all occurrences of a Perl Compatible Regular Expression (PCRE) pcre in a string | x | - | ||
REPLACE | Searches a string for all occurrences of a specified string and replaces them with another specified string | x | x | x | - |
REPLACE_REGEXPR | A Perl Compatible Regular Expression (PCRE) is replaced in a string with another specified character string | x | x | - | |
RIGHT | Returns the rightmost characters of a string with a specified length | x | x | x | - |
RPAD | Creates a string with a specified length while adding a specified string at the beginning of another one | x | x | x | - |
RTRIM | Removes all trailing blanks and trailing characters that match specified characters | x | x | x | - |
SUBSTRING | Returns a substring of a specified string starting from a specified position within the string | x | x | x | x |
SUBSTRING_REGEXPR | Searches a substring for a Perl Compatible Regular Expression (PCRE) pattern and returns the offset of the match. | x | - | ||
UPPER | Transforms all lowercase letters in a string to uppercase letters. | x | x | x | - |
Descriptions of the possible operands and data types can be found in the corresponding documentation for ABAP CDS, DDIC-Based Views, ABAP CDS, View Entities and .
Fill RESBD Structure from EBP Component Structure ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 16042 Date: 20240328 Time: 193952 sap01-206 ( 114 ms )