Ansicht
Dokumentation

ABENSQL_STRING - SQL STRING

rdisp/max_wprun_time - Maximum work process run time   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

- sql_string

... sql_elem1 && sql_elem2  $[&& sql_elem3 ... $] ...

Effect

String expression in . The operator && concatenates the character strings in two adjacent operand into a single character string. Elementary SQL expressions can be specified as the operands sql_elem1, sql_elem2 with the following restrictions:

• A literal must be a non-empty text field literal of type c.

• Host variables and host expressions must be of ABAP type c.

• Columns of data sources must have one of the dictionary types CHAR, CLNT, CUKY, LANG, or UNIT.

The result of the concatenation must be no longer than 255 characters. Trailing blanks are handled as follows:

• Precisely one blank is respected in host variables declared using CONSTANTS and in text field literals consisting only of blanks.

• In all other cases, trailing blanks are cut off on the right.

The result has the type CHAR in the resulting length and can be assigned to the ABAP types c and string in accordance with the associated assignment rule.

If the operand of a string expression has the null value, the result of the full string expression is the null value.

Notes

• Specifying a string expression always means specifying an SQL expression. String expressions can only be specified for operand positions for which SQL expressions are possible.

• Strings can also be concatenated using the SQL function CONCAT. The function CONCAT is restricted to concatenating two operands but has the following benefits when compared to the operator &&:

• It allows any SQL expressions as operands.

• It allows more data types.

• It does not apply any special handling to constants and text field literals that contain only blanks.

• It allows results to be longer than 255 characters.

• A string expression cannot be evaluated in the table buffer and always causes table buffering to be bypassed.

Example

The two columns in a result set are created using a concatenation of character-like columns of the data source and of literals.

SQL expressions, concatenations

BAL_S_LOG - Application Log: Log header data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 4006 Date: 20240423 Time: 135102     sap01-206 ( 48 ms )