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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Creating Index on Standard Table

Former Member

‎04-20-2009 5:53 AM

0 Kudos

Hi All,

I have created some new fields in BUT000 and some of these fields will be used for wil card search in the application. Could you please let me know how to create index on these fields. Any help will be very much appreciated.

4 REPLIES 4

Former Member

‎04-20-2009 5:58 AM

0 Kudos

Hi,

Se11-->table Name->display>& Click on indexes. Click Create give index ID say Z01 & Give your keys.

Regards

Raju chitale

Edited by: Raju Chitale on Apr 20, 2009 6:58 AM

Edited by: Raju Chitale on Apr 20, 2009 7:39 AM

former_member222860
Active Contributor

‎04-20-2009 5:59 AM

0 Kudos

From SE11.. Click on Indexes , then create, and select the fieldnames that u want to create index on..

Former Member

‎04-20-2009 6:05 AM

0 Kudos

Hi,

It is so simple.

First in SE11, enter the table name and choose in Change/Display mode. Click the Index button in toolbar. Then, it will display the indexes. Press the Create button (or Press F5). Then, it will ask for a unique index name. Give any 3 digit code. Ex: TES.

Enter the short description. Then, choose the required index type. (Unique or Non-unique).

If you need further explanations on this, just choose a radio button and Press F1. You will get the help documentation for it.

Then choose the fields for the index. After entering the values, Save, Check and Activate it.

Please Revert back for further clarifications.

Thanks and Best Regards,

Suresh