topic index in Application Development and Automation Discussions

index

Former Member — Tue, 15 Apr 2008 17:15:54 GMT

ABAP GURU'S

I want to create indexes in a program. How i can create indexes.plz reply immedeitly with an example.

thanks

Re: index

Former Member — Tue, 15 Apr 2008 17:24:23 GMT

Hi,

-> First decide the order in which you need the index to be created,

-> goto to se11 & enter table name & display(f7),

->then press indexes.. button on the application toolbar,

->if secondary indexes already exist, a list of them will

be displayed in a dialog box named indexes for table

xxxxx.to create an index,press the create(f5) button.the

create index dialog box will be displayed.

->if no secondary indexes exist,you will not see a list of

indexes.Instead, you will see the create index dialog box

immediately.

->enter an index id in the index id field.customer indexes

should begin with y or z,although the system does not

enforce this.

->press the continue button.the abap/4 dictionary:table

maintain index screen is displayed.

->in the short text field,type a description of the index.

->in the fld name column,type the fields that should

comprise the index in the order that they should be sorted.

->if the values in these fields when taken together must

always be unique be unique,tickmark the unique index check

box.if you tickmark the Unique Index checkbox, the

combination of fields in the index is guaranteed to be

unique; An insert or modify

statement will fail if the combination of values in index

fields is already present in the table.

->press the save button on the application toolbar.the

values in the status fields are now NEW & SAVED & directly

below them the message Does not exist in the database

appears.Also, the message Index xxx to table xxxxx was

SAVED appears at the bottom of the window in the status bar.

->press the Activate button on the Application toolbar

-> in the status bar, the message INDEX xxxxx was successfully

activated , is displayed.

->press Back. The Indexes for Table xxxxx screen is

displayed.

For demo with screen shots,pls check the link below

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

<REMOVED BY MODERATOR>

Regards

Byju

Edited by: Alvaro Tejada Galindo on Apr 15, 2008 4:29 PM

Re: index

Former Member — Tue, 15 Apr 2008 17:30:18 GMT

Hi,

Please refer the below link which has step by step process with screenshots.

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

Thanks,

Sriram Ponna.

Re: index

Sm1tje — Tue, 15 Apr 2008 20:55:12 GMT

You are saying that you want to create indexes in a PROGRAM? Are you sure that you want to do it in a program. Suggestions above all relate to creating indexes for database tables, which makes sense to me. However creating them in a program doesn't.

Or are you referring to creating 'indexes' for internal tables in a program? This is also 'possible', however, these are not really indexes, but more key definitions.

Decide yourself what it is you want to do.

Re: index

Former Member — Tue, 15 Apr 2008 21:22:21 GMT

Hi Sachin,

Please refer to these links because it is very clearly given what is an index and how to create indexes. So it might be very useful for you.

http://help.sap.com/saphelp_erp2005/helpdata/en/6a/c943401a306f13e10000000a1550b0/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/ad/99008eeaf111d4aa2800a0c9430730/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/c4/3a7271505211d189550000e829fbbd/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/c4/3a71e2505211d189550000e829fbbd/frameset.htm

Regards,

AMK.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 15, 2008 6:01 PM

Re: index

Former Member — Wed, 16 Apr 2008 00:29:01 GMT

Hi Sachin,

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.

You can create secondary index for the table ,by clicking on the index button on the toolbar.and give your name and save the changes

Reward Points if useful,

Thanks,

Surya Pydikondala