table index

[former_member192432]

hi all,

how to create table index in program.

regards...

[Former Member]

Hi Dear,

You cannot create table index in program. Table index is created for database tables in using tcode se11.

Follow the below link to know more about it.

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 5:56 PM

[Former Member]

HI,

Indexes are created in the table level only.

we cannot create indexes in programs.

<REMOVED BY MODERATOR>

Jagadish.

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 5:57 PM

[prasanth_kasturi]

hi

you cannot create indexes in the programs.

its created in se11

we can create through

after you enter the table name and click change

goto----> indexes

regards

prasanth

[Former Member]

Hi,

Check this out.

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/how-to-create-index-in-abap-dictionar...

and for creating secondary index, Check out

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

<REMOVED BY MODERATOR>

Regards,

Ramya

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 5:57 PM

[Former Member]

Since you didn't state it.. I'll assume you are talking about an internal table.

This link give some very good information about internal tables and keys.

http://help.sap.com/saphelp_46c/helpdata/EN/fc/eb35de358411d1829f0000e829fbfe/frameset.htm

Take note of the discussion of the UNIQUE and NON-UNIQUE verbs.

[Former Member]

hi check this...

report ztest.

tables:mara .

data: begin of itab occurs 0,

matnr like mara-matnr,

end of itab.

select-options:s_matnr for mara-matnr .

select matnr from mara into table itab where matnr in s_matnr.

loop at itab.

write:/ sy-tabix, itab-matnr.

endloop.

here sy-tabix shows the table index .

regards,

venkat.

[former_member192432]

thanks for reply