Skip to Content
Author's profile photo Former Member

Enhancement Framework – Extension Index

Extension Index

Most known practice to speed up searches on the standard tables is to create secondary indexes. SAP has introduced a new enhancement technique called Extension index as part of Enhancement Framework. It is same as creating secondary index for the standard table.


SAP has already delivered secondary indexes for most of the standard table.  It is not necessary that the existing secondary index fulfill all scenarios. In such cases, creating a secondary index on a standard table comes under modification. During upgrade, they will be deleted and need to be re-created in a system. This involves efforts and cost. Extension indexes are automatically copied over during upgrades and no modification adjustment takes place.

How to create

1. Go to SE11-> Enter table name-> click on Indexes-> Create Extension Index


2. System will display screen same as ‘Creating Secondary Index’.  Enter the required data.


3. Save and activate it. Assign a package and transport request for the extension index.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very Nice to know this.. Thanks for sharing 🙂

      Author's profile photo Kiran K
      Kiran K

      Thanks for sharing this new feature in SAP.

      But,in what cases we should choose "Create Extension Index" over the normal Index creation.

      Extension Index getting carried through even during Upgrade is the only advantage ?


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Kiran,

      It is same as creation of secondary index. During upgrade, it will be deleted and need to be re-created in a system. If big list of customer secondary indexes deleted during upgrade, you can imagine the efforts to create them again. If you will not create them, it affects the performance of programs for which they created. Therefore, it is always good to create extension index.