FAQ’s, intros and memorable discussions in the ABAP Testing and Troubleshooting Space

Welcome to the SCN ABAP Testing and Troubleshooting Space!

In addition to release dependent information available by:

– pressing the F1 key on an ABAP statement,

– searching for them in transaction ABAPDOCU,

– using the SCN “Search the Community” functionality,

– the information accessible via the SCN ABAP Main Wiki at https://wiki.sdn.sap.com/wiki/display/ABAP,

– the SAP Service Marketplace at http://service.sap.com/ (see SAP Note 192194 at https://service.sap.com/sap/support/notes/192194 for search tips).

This document lists some discussions and documents from the ABAP spaces as:

– An introduction for new members / visitors on topics discussed,

– An introduction to how the forums are used and the quality expected,

– A collection of some discussions which provided usefull answers to questions which are frequently asked, and,

– A collection of some memorable discussions if you feel like reading some ABAP related material.

The listed discussions and documents will be enhanced from time to time.

Note: When asking a question in the forum, please also provide sufficient information such that the question can be answered usefully, do not repeat interview-type questions, and once closed please indicate which solution was usefull – to help others who search for it.

Read Performance => Gurus take over the discussion from Guests caught cheating the points-system.

SELECT INTO TABLE => Initial questions often result in interesting follow-up discussions.
Inner Joins vs For all Entries. => Including infos about system parameters for performance optimization.
Inner Join Vs Database view Vs for all entries => Usefull literature recommended by performance guru YukonKid.
Inner Joins vs For All Entries – performance query => Performance legends unplugged… read the blogs as well.

JOINS vs. FOR ALL ENTRIES – Which Performs Better? => More thoughts on this eternal rivalry
The ABAP Runtime Trace (SE30) –  Quick and Easy => New tricks in old tools. See other blogs by the same author as well.
Skip scan used instead of (better?) range scan => Insider information on how index access works.
DELETE WHERE sample case that i would like to share with you => Experts discussing the deletion of data from internal tables.
Impact of Order of fields in Secondary  index => Also discussing order of fields in WHERE-clause
“SELECT SINGLE” vs. “SELECT UP TO 1 ROWS” => Better for performance or semantics?
into corresponding fields of table VERSUS into table => detailed discussion incl. runtime measurements
Indexes making program run slower… => Everything you ever wanted to know about Oracle indexes.
Mass reading standard texts (STXH, STXL) => avoiding single calls to READ_TEXT for time-critical processes
Next Generation ABAP Runtime  Analysis (SAT) – Introduction => detailed introduction to the successor of SE30
SAP Support case “FOR ALL ENTRIES disaster” => detailed blog on the pitfall(s) a developer might face when using FAE
Performance: What is the best way to check if a record exist on a table ? => Hermann’s tips on checking existence of a record in a table

( original “ABAP Performance and Tuning” forum sticky thread created by Julius von dem Bussche )