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

Which table stores the programs created?

619


What is the table buffer? Which type of tables used this buffer?

563


How can we determine a vendor is Bloc/Unblock from the table LFA1?

1660


How can we send data to external programs?

621


What are roles and authorization objects?

1197






Is it possible to pass data to and from include programs explicitly?

585


What are pooled tables? : abap data dictionary

665


What is a badi?

554


how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran

2046


How can we declare a table control in the abap/4 program?

642


What are the requirements a dialog program must fulfill?

639


A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization

561


I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/

1815


What data is contained in data dictionary? : abap data dictionary

644


What is the use of lock objects?

575