How to create secondary index ?

Answer Posted / ravikanth @ abm

Creating Secondary Indexes
Procedure
1. On the maintenance screen of the table, choose Indexes.
If indexes already exist on the table, a list of these indexes is displayed.
2. Choose This graphic is explained in the accompanying text with the quick info text Create.
3. From the dropdown menu, choose Create Index.
4. In the next dialog box, enter the index ID and choose This graphic is explained in the accompanying text with the quick info text Continue.
The maintenance screen for indexes appears.
5. Enter an explanatory text in the Short description field.
You can use the short description to find the index at a later time, for example using the Information System.
6. To select the table fields to be inserted in the index, choose Table Fields.
A list of all the available table fields appears.
7. Select the desired fields using the indicator in the first column and then choose This graphic is explained in the accompanying text

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the definition of modification in an sap system and how do they impact an upgrade?

701


What are the dynapro keywords?

829


where do we store all custom programs in SD module?

5179


What is the use of message command in a report? What are the different message types?

689


Explain the difference between a dialog program and a report?

705






Did you create any joins?

705


What is table attribute? : abap data dictionary

749


What are domains and data element? : abap hr

764


Differentiate between static and dynamic step loops?

727


Have you set up a back ground job ? How to create a background job without a variant ?

796


how to use the xk01 in realtime.can it apply the others. how it it will goes to first page and next page.

1898


Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?

2169


Is main window mandatory in smartforms?

874


Mention what is alv programming in abap?

769


What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?

762