Problem solve Get help with specific problems with your technologies, process and projects.

How to test queries before transport

This tip offers a quick way to test your queries before running in either QA or production environments.

There is a way to detect possible performance issues in the quality assurance or production environments before transport (authorization maybe required for production.) To test the impact of select queries, especially impact of joins on the database, write a query using transaction SQ01 with a required test condition in the target system (like QA). This should be done while writing big joins on large database tables like MARA, before the piece of code is transported to testing environment.

Dig Deeper on SAP ABAP

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close