-
Book Overview & Buying
-
Table Of Contents
SAP ABAP Advanced Cookbook
By :
Very often, the cause of a long running report is full-scan of a database table specified within the code, mainly because no suitable index exists. In this recipe, we will see the steps required in creating a new secondary index in database table for performance improvement. Creating indexes lets you optimize standard reports as well as your own reports. In this recipe, we will create a secondary index on a test table ZST9_VBAK (that is simply a copy of VBAK).
For creating a secondary index, proceed as follows:
Call transaction SE11. Enter the name of the table in the field provided, in our case, ZST9_VBAK. Then click the Display button. This will take you to the Display Table screen.
Next, choose the menu path Goto | Indexes. This will display all indexes that currently exist for the table.


The dialog box appears. Enter a three-digit name for the index...
Change the font size
Change margin width
Change background colour