Frequently Asked Questions of SQL/Performance

This document contains frequently asked questions about SQL in SAP.Following questions are answered

What are the different SQL statements used in abap/4?
How to take care for performance in ABAP development?
What is Runtime analysis and its benefits?
What is SQL trace tool?
What is Explain SQL function?

Read more

Function Modules:Definition

All ABAP programs are modular in structure and made up of processing blocks you can modularize source code by placing ABAP statements either global include programs or function modules. The processing blocks that you call from ABAP programs are called procedures.

Read more

The New ABAP Editor

The Code Editor is an ActiveX control that can be used to replace the standard source code editor (based on an SAP TextEditor) for any SAP system that supports ActiveX embedding. The reason for the replacement is that the standard RTF control, which the SAP TextEditor is based on, is not optimized for working with line-based text (as source code) and does not support modern code-editing functionality.

  • Powerful, Fully-Customizable Highlighting for Predefined Keywords, Comments, and Strings
  • Language Schemes
  • Fully-Customizable Display Functionality
  • Different Types of Word Wrap
  • Different Cursor and Caret Styles
  • Active Status Bar
  • Edit Functionality
  • Drag & Drop Editing
  • Clipboard Ring
  • Block Selection of Text in Addition to Normal Selection
  • Multiple Clipboard Formats
  • Extended “Pretty Print” Functionality
  • Automatic Brace and Structures Matching, Current Scope Displaying
  • Powerful Find/Replace Functionality
  • Incremental Search (Forward/Backward)
  • Code Outlining/Structuring
  • Code Hints
  • Quick Info
  • User-Defined Code Templates
  • Bookmarks
  • Scroll navigation
  • Printing with Previewing of documents in color
  • Window Splitter
  • Go to Line
  • Different Keyboard Schemes
  • External Files Handling
  • Export Functionality
  • XML Settings

Read more

Interfacing with SAP

Overview:

SAP AG has been coming up with new tools and techniques to support emerging industry standard EAI technologies from time to time.
The following are the techniques currently supported by SAP (as in SAP Version 4.6c) for both
batch and real-time interfacing.

Read more

Transport Guide Tips for SAP Objects

Here are tips for different objects:

LSMW: There are 2 ways for transporting LSMW data from a system to another.
Export/import this method gives you the opportunity to select the subprojects or objects you want to transfer. LSMW -> Extras -> Export project
Transport request with this method, you can transport a LSMW project in full (you can not select the objects you want). With this method, the project will be transported as any other SAP object in a transport order. LSMW -> Extras -> Create change request

Read more

ABAP/4 Optimization

ABAP/4 programs can take a very long time to execute, and can make other processes have to wait before executing. Here are some tips to speed up your programs and reduce the load your programs put on the system:

  • Use the GET RUN TIME command to help evaluate performance. It’s hard to know whether that optimization technique REALLY helps unless you test it out. Using this tool can help you know what is effective, under what kinds of conditions. The GET RUN TIME has problems under multiple CPUs, so you should use it to test small pieces of your program, rather than the whole program.

    Read more