Ansicht
Dokumentation

ABENSQL_FUNCTIONS_STRING - SQL FUNCTIONS STRING

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.
SAP E-Book

- 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 .

SQL Function UPPER






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 )