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 )