06-25-2008 6:32 AM
Hi all,
could you tell me how to create the secondary index in a d.d table,
reward asure
with regards,
Thambee
06-25-2008 6:34 AM
06-25-2008 6:34 AM
06-25-2008 6:42 AM
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.
06-25-2008 6:48 AM
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
06-25-2008 6:56 AM
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
06-25-2008 7:06 AM
Hi ,
Check the following link for step by step creation .
http://saptechnical.com/Tutorials/ABAP/SecondaryIndex/Create.htm
Regards,
Jaya Vani
06-25-2008 9:18 AM
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
06-25-2008 12:24 PM
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 ....
06-25-2008 6:03 PM
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
06-26-2008 4:30 PM