Urgently needed

[Former Member]

Hi Everyone,

An urgent help needed...

What is secondary index and how to create a secondary index to a field in the table?

Plz Tell me in detail...

Thanx

Nitin

[Former Member]

Hi Everyone,

An urgent help needed...

What is secondary index and how to create a secondary index to a field in the table?

Plz Tell me in detail...

Thanx

Nitin

[Former Member]

An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.

Creating Secondary Indexes

Procedure

1.In the maintenance screen of the table, choose Indexes.

If indexes already exist on the table, a list of these indexes is displayed. Choose .

2.In the next dialog box, enter the index ID and choose

The maintenance screen for indexes appears.

3.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.

4.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.

5.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).

6.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.

7.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 .

8.Choose activate .

[Former Member]

Hi Nitin ,

A secondary index is an index created to make the access of data from system faster.

Process of creating is

1. SE11 --> Enter table name --> Display

2. In the resulting Screen , press the index button.

3. You will have a button to create an index for the table , press that button and in the resulting screen enter the index feilds.

Regards

Arun

[Former Member]

Hi Nitin,

Please see below links

http://help.sap.com/saphelp_470/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm

<u>

</u>

Regards, ABY

[Former Member]

Hi,

To create a secondary index:

1. Display the table. You should begin on the Dictionary: Table/Structure: Display Fields screen.

2. Press the Indexes. . . button on the Application toolbar (or choose the menu path Goto->Indexes. . .).

3. If secondary indexes already exist, a list of them will be displayed in a dialog box named Indexes for Table xxxxx. To create an index, press the Create button. The Create Index dialog box will be displayed.

4. If no secondary indexes exist, you will not see a list of indexes. Instead, you will see the Create Index dialog box immediately.

5. Enter an index id in the Index ID field. Customer indexes should begin with Y or Z, although the system does not enforce this.

6. Press the Continue button. The ABAP/4 Dictionary: Table: Maintain Index screen is displayed.

7. In the Short Text field, type a description of the index.

8. In the Fld Name column, type the fields that should comprise the index in the order that they should be sorted.

9. If the values in these fields when taken together must always be unique, tickmark the Unique Index check box.

10. Press the Save button on the Application toolbar. The values in the Status fields are now New and Saved, and directly below them the message Does not exist in the database appears. Also, the message Index xxx to table xxxxx was saved appears at the bottom of the window in the status bar.

11. Press the Activate button on the Application toolbar. The system generates SQL and sends it to the RDBMS, creating the index in the database. If successful, the Status fields read Active and Saved, and below the status fields the message Exists in the database appears. The DB Index Name field will contain the name of the index in the database. Also, in the status bar, the message Index xxxxx was successfully activated. is displayed.

12. Press Back. The Indexes for Table xxxxx screen is displayed.

13. Press Cancel to return to the Dictionary: Table/Structure: Display Fields screen.

An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.

<b>Reward points</b>

Regards