topic Re: table index in Application Development and Automation Discussions

table index

former_member192432 — Tue, 08 Apr 2008 12:59:59 GMT

hi all,

how to create table index in program.

regards...

Re: table index

Former Member — Tue, 08 Apr 2008 13:04:52 GMT

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

Re: table index

Former Member — Tue, 08 Apr 2008 13:07:33 GMT

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

Re: table index

prasanth_kasturi — Tue, 08 Apr 2008 13:08:32 GMT

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

Re: table index

Former Member — Tue, 08 Apr 2008 13:10:21 GMT

Hi,

Check this out.

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

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

Re: table index

Former Member — Tue, 08 Apr 2008 13:13:32 GMT

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.

Re: table index

Former Member — Tue, 08 Apr 2008 13:17:50 GMT

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.

Re: table index

former_member192432 — Thu, 10 Dec 2009 12:20:26 GMT

thanks for reply