This plugin adds a quick fix to your ADT environment for formatting your ABAP SQL statement. You can customize it in the preferences:
- Align operators
- Standardize operators (e.g., convert all 'EQ' to '=')
- Add spaces to each line
- Additional spaces in condition lines
- Order of keywords (please use it wisely)
- Combine SELECT with FROM/INTO until a certain character limit
- Combine FROM with JOINs until a certain character limit
Don't forget to install the plugin's backend to your SAP system: https://github.com/lukas-mb/ABAP-SQL-Beautifier-Backend
Without the backend, formatting will still work, but the entire statement will be in uppercase.
Please note that it's disabled in some cases. These will be implemented in the future. If you encounter any bugs, please report them.
Planned for V1:
- Convert SQL statement to new syntax
- Add escaping to host variables
- Add commas between fields
- WHEN syntax
- SELECT in WHERE
Categories: Application Development Frameworks, Code Management, Database, Editor
Additional Details
Eclipse Versions: 2023-12 (4.30), 2023-09 (4.29), 2023-06 (4.28), 2023-03 (4.27), 2022-12 (4.26), 2022-09 (4.25), 2022-06 (4.24), 2022-03 (4.23)
Platform Support: Windows
Development Status: Beta
Date Created: Tuesday, October 10, 2023 - 15:05
License: Apache 2.0
Date Updated: Wednesday, November 15, 2023 - 13:53
Submitted by: Lukas Bachmann
Date | Ranking | Installs | Clickthroughs |
---|---|---|---|
December 2023 | 260/579 | 17 | 4 |
November 2023 | 295/686 | 55 | 16 |
October 2023 | 376/673 | 25 | 28 |
September 2023 | 0/0 | 0 | 0 |
August 2023 | 0/0 | 0 | 0 |
July 2023 | 0/0 | 0 | 0 |
June 2023 | 0/0 | 0 | 0 |
May 2023 | 0/0 | 0 | 0 |
April 2023 | 0/0 | 0 | 0 |
March 2023 | 0/0 | 0 | 0 |
February 2023 | 0/0 | 0 | 0 |
January 2023 | 0/0 | 0 | 0 |
Unsuccessful Installs
Unsuccessful Installs in the last 7 Days: 3
Count | Error Message |
---|---|
2 | Cannot complete the install because one or more required items could not be… |
1 | Cannot continue the operation. There is another install operation in progress. |
Reviews Add new review
the left jion format
Submitted by Jia Pengsan on Fri, 11/10/2023 - 01:41
when use left join, the left join is incorrect
and could you add a choice don't store comments,
I thought it is necessary to use comments in SQL statements.
thanks
Hi, I know this bug. I fixed…
Submitted by Lukas Bachmann on Fri, 11/10/2023 - 13:38
In reply to the left jion format by Jia Pengsan
Hi, I know this bug. I fixed it already yesterday, so please update the plugin. And there is the option to delete the comments... but be careful with that setting :)