Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to create secondary index

Former Member
0 Kudos

Hi all,

could you tell me how to create the secondary index in a d.d table,

reward asure

with regards,

Thambee

1 ACCEPTED SOLUTION
9 REPLIES 9

Former Member
0 Kudos

Hi ,

Step 1: goto se11 tcode.

step 2: give ur table name <ztab> and Change mode.

step 3:Goto ---> Indexex(Ctrl+F5).

Step 4: select the create buttong and give the field name(on what field you want to create secondary indexes).

Regards,

KV.

Former Member
0 Kudos

Hi Thambi Durai,

Goto indexes tab in the table screen

and then click on create.

and give the index name

and the field details

Thanks,

Chandrasekhar

Former Member
0 Kudos

hi,

check the link for step-by-step process

http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21eb47446011d189700000e8322d00/frameset.htm

Reward if found helpful.

Anirban Bhattacharjee

Former Member
0 Kudos

Hi ,

Check the following link for step by step creation .

http://saptechnical.com/Tutorials/ABAP/SecondaryIndex/Create.htm

Regards,

Jaya Vani

Former Member
0 Kudos

Hello,

Secondary indexes are 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.

To see how to create seconary indexes in a database table check this link for step by step procedure.

[http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm]

Hope this will solve your query..

Good luck,

Bhumika

Former Member
0 Kudos

Step 1: goto se11 tcode.

step 2: give ur table name

step 3:push button named index in application tool bar..click that

Step 4: select the create buttong and give the field name..

index is used to increase the performs ....

Former Member
0 Kudos

Hi,

Select the field in the table and click on INDEX button or ctrl+F5..

and carry on with the screen.. and finally save it...

If you want to check your no of secondary indexes goto DATABASE UTILITY there you can see the default primary index and also the secondary index..

Hope this would help you

Regards

Narin Nandivada

Former Member
0 Kudos

thanks