How to create secondary index ?
Answers were Sorted based on User's Feedback
Answer / leo
GO TO SE11
Take any table- You can see button "Secondary Index"
Locate it and Go forth....
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
when u prefer lsmw?
How to pass data from list to report?
Explain the uses of the simple maintenance interface? : sap abap hr
Table ztest has a secondary index on the following fields: tnum, tcode. Select * from ztest where tnum ne '123' and tcode = '456'. Why is the index not used in the above case? Choices: a) Indexes are not allowed on Z tables b) Variables must be used, NOT literals c) Select individual fields, not select * d) Client is not in the where clause e) NE invalidates the use of an index Info: Can someone explain in detail why this happened? It will be really helpful to handle to case in Secondary index:
Can we execute the script individually? If yes How? Else what we need to do so?
What are differences between at selection-screen and at selection-screen output?
What is view? Explain the different types of view?
What are different data types in ABAP?
Hi Everyone, Can one any explain the situation where we can exactly use the events and also explain the diff. between LIKE AND TYPE. Am new one of sap-abap. Thanks in advance Jaya DS
How to create any functions?
What is the difference between At first and On change control command.
what is the difference between Blocked ALV and interactive ALV?