Skip to content

Format SQL UPDATE statements #505

Description

@luis-rod-git

Should ABAP Cleaner process SQL UPDATE statements?

If I write :

UPDATE my_table SET
a   = @X,
  b = @y,
 d = @Z
WHERE Z1 = @Z2.

This does results in:

UPDATE my_table SET
a   = @x,
  b = @y,
 d = @z
WHERE z1 = @z2.

So it changes the columns names to lower case (OK), but does not align the assignments or the WHERE clause..

Regards,
Luis

(Added on May 05th, 2026)
And it seems it is not with UPDATE only. SELECT seems to have some issues as well.

This:

OPEN CURSOR @cursor FOR
SELECT
  FROM tab1
       INNER JOIN
       tab2 ON tab2~col_j = tab1~col_j
  FIELDS tab1~col_z
         tab1~col_j,
         tab2~colx
  WHERE tab1~col1 >= @val_1
    AND tab1~col2  = @val_2
    AND tab1~col3  = @val_3
  ORDER BY tab1~val_x.


Gets changed to this:

OPEN CURSOR @cursor FOR
SELECT
  FROM tab1
       INNER JOIN
       tab2 ON tab2~col_j = tab1~col_j
  FIELDS tab1~col_z
         tab1~col_j,
         tab2~colx
  WHERE tab1~col1 >= @val_1
    AND tab1~col2  =     @val_2
                     AND tab1~col3  = @val_3
  ORDER BY tab1~val_x.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions