Skip to Content
avatar image
Former Member

Procedure for creating an Index on SAP standard table

Hi,

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

Regards,

Sharadendu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 08, 2008 at 07:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 07:54 PM

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

    how-to-create-an-index

    how-to-create-secondary-index

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 08:20 PM

    Hi,

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

    Regards,

    Sharadendu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.