topic indexes in Application Development and Automation Discussions

indexes

Former Member — Fri, 29 Feb 2008 05:24:02 GMT

How to create a secondary index?

Re: indexes

Former Member — Fri, 29 Feb 2008 05:25:17 GMT

hi,,

Use Foreign Keys.. That Might be a useful Secondary index..

Edited by: Karthik Thiruvenkadam on Feb 29, 2008 10:55 AM

Re: indexes

Former Member — Fri, 29 Feb 2008 05:25:50 GMT

http://www.saptechnical.com/Tutorials/ABAP/SecondaryIndex/Create.htm

Re: indexes

Former Member — Fri, 29 Feb 2008 05:29:21 GMT

hi,

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.

,check this link,

Regards,

Arunsri

Re: indexes

Former Member — Fri, 29 Feb 2008 05:32:42 GMT

Hi Girish ,

This will be helpful to you.

Proceed as follows to create a secondary index on a table:

In the field maintenance screen for the table, choose Goto ® Indexes.

1. If you went to the field maintenance screen of the table in display mode, only correct the index (and not the table).

If indexes already exist on the table, a list of these indexes is displayed. Choose Create. A dialog box appears in which you must enter the three-place index identifier. If there are no indexes, go directly to the dialog box.

2. Enter the index identifier and choose Continue.

You will go to the maintenance screen for indexes.

3. Enter an explanatory short text in the field Short text.

Choose TabFields.

4. A list of all the fields of the table is displayed.

5. Select the fields which you want to copy to the index.

6. Choose Copy.

The selected fields are copied to the index.

7. If the values in the index fields already uniquely identify each record of the table, select Unique index.

A unique index is automatically created on the database during activation because a unique index also has a functional meaning (prevents double entries of the index fields).

8. If it is not a unique index, leave Non-unique index selected. In this case you can use the corresponding radio buttons to define whether the index should be created automatically on the database for all database systems, for selected database systems or for no database system.

9. If you chose For selected database systems, you must specify these systems.

You have two possibilities here:

List of inclusions: The index is only created automatically during activation for the database systems specified in the list. The index is not created on the database for the other database systems.

List of exclusions: The index is not created automatically on the database during activation for the specified database systems. The index is automatically created on the database for the other database systems.

Click on the arrow symbol behind the radio buttons. A dialog box appears in which you can define up to 4 database systems. Use the corresponding radio buttons to decide whether this list should be treated as a list of inclusions or exclusions.

10. Activate the index with Index ® Activate. The activation log tells you about the flow of the activation. Call it with Utilities ® Act.log. If an error occurred when activating the secondary index, you will automatically go to this log.

The secondary index is automatically created on the database during activation if the corresponding table has already been created there and index creation was not excluded for the database system.

Reward if helpful ,

Regards,

SreekarKadiri