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.

What are the differences between session method and call transaction method? : abap bdc

1009

---

What are the differences between interactive and drill down reports?

1036

---

What are the merits of its?-

1027

---

Define the various contents of technical specifications ?

1056

---

What is the function of the correction system?

930

---

What are the value tables?

1031

---

What is exception class and test class. How to use it?

1327

---

What is your current client number?

1017

---

What is an abap data dictionary? : abap data dictionary

974

---

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

2413

---

Program for Prime numbers and Matrix plz explain me the procedural method with steps

2705

---

How will you read from internal table records in a given value range (without using loop)

1427

---

There is 1 person but it’s displaying that this person cannot be booked. He is not available for the business event. Can you tell me where is it going wrong? What can be the reasons? : sap abap hr

1011

---

How is time management and payroll is integrated? : sap abap hr

957

---

How is collect statement different from append?

984

---