Step by Step Tutorial on Creating Secondary Index in SAP ABAP

Step by Step Tutorial on Creating Secondary Index in SAP ABAP

Indexes are used in SAP ABAP to search the data fast.

There are two types of search indexes :

1 Primary Index

2 Secondary Index

You can also create further indexes on a table in the ABAP Dictionary. These are called secondary indexes. This is necessary if the table is frequently accessed in a way that does not take advantage of the sorting of the primary index for the access. Different indexes on the same table are distinguished with a three-place index identifier.

We use indexes to speed up searching a table for data records that satisfy certain search criteria.

An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.

Steps to create secondary index

1) go to se11

we need to clear a table initially  we can find secondary index for an already existing table

 to check the presence of secondary indexes we have to go through the following steps

if this below screen appears it indicates no secondary index is present

go through following steps to create secondary index

give the index name and continue

now a session appears where we have to give a short description and give any field as secondary index

save and then activate

we finally created secondary index

we can create till 9 secondary indexes

   Creating Structure Tutorial in SAP ABAP
   Creating Domain Tutorial in SAP ABAP
   Creating Type Group Tutorial in SAP ABAP
   Help View Tutorial in SAP ABAP
   Secondary Index Tutorial in SAP ABAP
   Copy fields from one table to another Table in SAP ABAP
   Creating Transparent Table Tutorial in SAP ABAP   ABAP Basic tutorials for freshers