Avoid using SELECT … ENDSELECT statement

Production RiskSoftware ResiliencyProgramming Best Practices

Avoid using SELECT … ENDSELECT statement


This code insight shows that The SELECT … ENDSELECT works as a loop fetching single record for every loop pause. Basically, it works like a client cursor which will generate too much traffic on the network and communications between the application server and the database server.

This report lists all ABAP Artifacts using SELECT … ENDSELECT statement on tables and views.
It provides the following information:
ABAP Artifacts full name, number of violations



Why you should care

Business Impacts

Production Risk

CAST recommendations




About CAST and Highlight’s Code Insights

Over the last 25 years, CAST has leveraged unique knowledge on software quality measurement by analyzing thousands of applications and billions of lines of code. Based on this experience and community standards on programming best practices, Highlight implements hundreds of code insights across 15+ technologies to calculate health factors of a software.

See featuresHow it works