Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create secondary index. Do you have access to
create secondary index?
- 2 Answers
- 7472 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / parthasarathi
Creating Secondary Indexes
Procedure
In the maintenance screen of the table, choose Indexes.
If indexes already exist on the table, a list of these indexes is displayed. Choose .
In the next dialog box, enter the index ID and choose
The maintenance screen for indexes appears.
Enter an explanatory text in the field Short text.
You can then use the short text to find the index at a later time, for example with the R/3 Repository Information System.
Select the table fields to be included in the index using the input help for the Field name column.
The order of the fields in the index is very important. See What to Keep in Mind for Secondary Indexes.
If the values in the index fields already uniquely identify each record of the table, select Unique index.
A unique index is always created in the database at activation because it also has a functional meaning (prevents double entries of the index fields).
If it is not a unique index, leave Non-unique index selected.
In this case you can use the radio buttons to define whether the index should be created for all database systems, for selected database systems or not at all in the database.
Select for selected database systems if the index should only be created for selected database systems.
Click on the arrow behind the radio buttons. A dialog box appears in which you can define up to 4 database systems with the input help. Select Selection list if the index should only be created on the given database systems. Select Exclusion list if the index should not be created on the given database systems. Choose .
Choose .
Result
The secondary index is automatically created in the database during activation if the corresponding table was already created there and index creation was not excluded for the database system.
You can find information about the activation flow in the activation log, which you can call with Utilities ® Activation log. If errors occurred when activating the index, the activation log is automatically displayed.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different functions used in sap script?
What is an on”*-input filed” statement?
Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?
What are th control break events in abap?
What are matchcodes?
Explain the systems fields used for interactive lists and lists?
Work most on which module: name a few tables?
What is the significance of technical settings (specified while creating a table in the data dictionary) ?
Explain some essential objects in abap dictionary?
hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
What function does data dictionary perform?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
How does the system handle roll areas for external program components?
How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures?
