ABAP Table Index in SAP

by | Apr 16, 2018 | ABAP Beginner

Home » SAP » ABAP » ABAP Beginner » ABAP Table Index in SAP

Preface – This post is part of the ABAP Beginner series.

ABAP Table Index

Suppose you have a million unsorted records and you want to perform search on the basis of non primary key. Then it will take a lot of time to process all the records. In this case you will make something called Secondary Indexes or ABAP Table Index.

Definition

An Index is a sorted copy of Database which contains pointer pointing to non-key fields which is used to increase the search speed of a table.

Types of Indexes

Primary Index:

The Primary Index is an Index created by system itself just after the creation of table. It contains only key fields. It has ID 0.

Secondary Index:

When your search criteria are not fulfilled by Primary Index, then in this case we can create our own Indexes called Secondary Indexes. Its ID can be of max 3 digit alphanumeric value. The total length of Index Name can be of 13 digit which includes table name and Index ID.

The naming convention of Secondary Indexes:

<TABLE_NAME> ~ <INDEX_ID>

e.g.  ZBARRY_ALLEN ~ A.

 

Unique Index:

If we define an Index as Unique Index if we want only unique records or unique combination of field in the table.

e.g. If you have defined two field combination as Unique. Then only unique values will be inserted. For more visit ABAP Documentation.

Extension Index:

A secondary Index is temporary index and needs recreation after every upgrade. If we create Extension Index it is upgrade protected. We don’t have to do anything new, just choose Extension Index in step 02 below.

How to Create a Secondary ABAP Table Index:

Step 01: Create a table and in the maintenance screen click on Indexes. [How to Create a table: Click here]

Step 02: Choose New Icon  and click Create.

Step 03: Choose Index from Drop Down box. Enter Index ID and click CONTINUE.

Step 04: Enter an explanatory Short Description.

Step 05: Choose Table Fields, choose desired fields and choose COPY.

*NOTE: The order of the field is important.

Step 06: If the values in the index are always unique then choose Unique radio button else leave it.

Step 07: According to the use of Index choose one of the radio button:

Radio ButtonDescription
For all database systemsIf it will be used across all database systems
For selected database systemsIf only for selected database systems. You can select at max 4.
Not at all in the databaseIf it is an exclusive Index

 

Step 08: Save it, Check for Errors and Activate it.

Disadvantages of Index

More the number of ABAP Table Index, the more load on the system, as it needs to adjust Indexes every time you Insert, Update or Delete a record. Due to which Table which is written frequently must have less indexes.

Author

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Author