Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Procedure for creating an Index on SAP standard table

sharadendu_agrawal
Active Participant

‎10-08-2008 8:47 PM

0 Kudos

Hi,

I need to create an Index on a SAP standard table. Please help me out with the process of doing so.

Regards,

Sharadendu

4 REPLIES 4

Former Member

‎10-08-2008 8:51 PM

0 Kudos

Hi,

Open the table, In the menu Goto -> Indexes.

If no index exist for the table, you will get a pop-up to create a index. Give yes and proceed. Give name ( say Z1) and the field you want to create as index.

Thanks,

Senthil

Former Member

‎10-08-2008 8:54 PM

0 Kudos

Please search the forum. You will find lots of related threads:

sharadendu_agrawal
Active Participant

‎10-08-2008 9:20 PM

0 Kudos

Hi,

What i want to know is the fields we should give in the index to get the correct selection.

Regards,

Sharadendu

valter_oliveira
Active Contributor
In response to sharadendu_agrawal

‎10-08-2008 11:05 PM

0 Kudos

For that you have to post the select statement you are using ...

I can give you an example:

Supose you want to select data from vbrk and you only have fkdat field. So you should create an index like: MANDT-FKDAT (if you have no other options of course).

Regards,

Valter Oliveira.