What is Index.
The Index is copy of database having few number of fields, this copy is always in sorted form. as you know the sorted data would always have speed read access, and the index also contain pointer to actual database table.
There are two types of indexes in SAP i.e Primary Index and Secondary Index. Primary index automatically created using primary keys and secondary index could be created by user as per user requirement.
To create secondary index you can use SE11 Transaction code in your SAP System, and open your table that you want to create secondary index. For example we will to create secondary index in BSAD table.
Click INDEXES toolbar button, and the new popup screen will show.
Click icon Create. and choose Create Index. the new popup screen will show, in this screen you need to entered your Index Name, this index name only 3 characters.
In the new screen you need to entered what fields in your secondary index, don’t forget to including MANDT field to make index performance good.
Incoming search terms:
- how to create secondary index in sap abap
- sap create index
- how to create index in sap abap using code
- sap create table index
- how to create secondary index in sap
- create secondary index in sap abap
- abap create index
- what is secondary index and its use in sap
- how to create index in sap abap and how to use
- create secondary index for db table in sap