Index in sales order

[Former Member]

hi all......

i wanna 2 know abt the index,what are index and how they are made,in my co. doc.date in sales order in index.....but y index is set and where it is selected and plz tell me the path in spro.and what is the necessity of index.

Plz tell

thnx

shailesh Lodha

[Former Member]

Hi Shailesh,

Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field of the tables. In order that other fields are also read, a pointer to the associated record of the actual table are included in the index. Yhe indexes are activated along with the table and are created automatically with it in the database.

Reward points if u helpful

Thanks & Regards

Govind.

[Former Member]

Hello Sailesh,

<b>Reminder:- **Do reward if this helps you**</b>

You can speed up a table search for data records that satisfy certain search criteria by using an index. You can create more than one index for a table. An index is created for the characteristic, to provide faster access to its values.

You can search a table for data records that satisfy certain search criteria faster using an index.

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.

The primary index is distinguished from the secondary indexes of a table. The primary index contains the key fields of the table and a pointer to the non-key fields of the table. The primary index is created automatically when the table is created in the database.

http://help.sap.com/saphelp_46c/helpdata/en/9b/c743f5b40711d194f900a0c929b3c3/frameset.htm

Classification of index series by determining the most important characteristics

• Age-dependent/year-dependent

• Historical indexing

Index entries permit you to find keywords by info object. Index entries are Descriptor for info objects in the SAP Knowledge Engineer.

In FICO, indexes are Mathematical series for representing price rate increases.

Example: You can use an index series to show the evolution of values of an asset having annual price rate increases.

Regards

AK