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

How can we access the correction and transport system? : abap data dictionary

741


What is the difference between semi-monthly and Bi-weekly payroll area

3172


Explain what are standard layouts sets in the sap script?

1079


What are the dis-advantages of logical databases? : abap hr

790


How is collect statement different from append?

724






What are the uses of interactive reporting?

771


If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?

1103


Explain the differences between se01, se09 and se10?

723


What are the techniques involved in using SAP supplied programs? Do you prefer to write your own programs to load master data? Why?

854


Did you create any joins?

695


In BDC, data transfer is done success in foreground mode but if we done the same in background mode it shows errors. What is the reason?

1133


Can we display a list in a pop-up screen other than full-size stacked list?

833


What are the different abap editors? What is the used of different editors in abap?

730


In SAP Script,How to display a single field(like matnr)at the right end of the form.

2133


What is the difference between free and refresh?

737