ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Operands and Expressions →  ABAP SQL - SQL Expressions sql_exp →  sql_exp - sql_func →  ABAP SQL - Built-In Functions sql_func →  ABAP SQL - SQL Functions 

sql_exp - sql_uuid

Other versions: 7.31 | 7.40 | 7.54

Syntax

... UUID(  ) ...

Effect

Calls the UUID function as an SQL expression or operand of an expression in ABAP SQL. The function UUID does not have any parameters and creates a new unique UUID of the type RAW with the length 16 for each row read from the results set.

Note

When used, the function UUID applies the strict syntax check mode from Release 7.54.

Example

Creates a UUID for each row read from the database table SCARR. These UUIDs are unique for each row and for each execution of the statement.

SELECT carrid, carrname, uuid( ) AS uuid 
       FROM scarr 
       INTO TABLE @DATA(result). 

cl_demo_output=>display( result ).