How do you create secondary index. Do you have access to
create secondary index?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / parthasarathi
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 ? | 0 Yes | 5 No |
How to insert row in an Internal table?
How can we set the tablespaces and extent sizes ?
what is the difference between message type and basic type
What are the FM's you used in ALV?
why you are creating tables ? Already so many Predefined tables are there?
Hi i am surya, i have faced this questions plz give me the answer. I have requirement like this, i have two internal tbale like itab and itab1 in itab i have 50 records, in itab1 100 records are there. When execute this question what will be the output a]50 b]100 c]150? And how to join two internal tables what is the syntax for that?
12 Answers Satyam, TCS, Wipro,
How to reterive data from the data base using scripts with out touching the print program
HOW TO TRANSFER MATERIAL MASTER DATA FROM LEGACY SYSTEM (ORACLE) TO SAP USING A FUNCTION MODULE BAPI_MATERIAL_SAVE_DATA. IF ANYBODY KNOW THE ANSWER PLZ MAIL TO MY ID SHAIKZIA@GMAIL.COM
can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?
Performance techniques?
wht is the diff. b/n initialization and lotus of event
What is the difference between open sql & native sql ?
3 Answers Accenture, SAP Labs,