topic Re: glpca in Application Development and Automation Discussions

glpca

Former Member — Wed, 07 Mar 2007 08:39:11 GMT

hi,

as glpca table is a large file, how can i make the data retrieval by kostl faster in my program.

thanks

Re: glpca

Former Member — Wed, 07 Mar 2007 08:42:32 GMT

There is a secondary Index for that table on that field. So, you can normally write your select statement. It will be fast enough(Atleast faster when compared to a table which doesnt have a secondary index for that field KOSTL).

Pass the following fields in the where clause:

KOKRS Controlling Area

RYEAR Fiscal Year

RPRCTR Profit Center

RVERS Version

RACCT Account number

Regards,

Ravi

Message was edited by:

Ravi Kanth Talagana

Re: glpca

Former Member — Wed, 07 Mar 2007 08:59:21 GMT

hi,

i did that in the where clause.

what do you mean by secondary index.

thanks

Re: glpca

Former Member — Wed, 07 Mar 2007 09:07:08 GMT

An index is something which makes the selection from a database faster, when you search using certain fields.

The best analogy would be the Index of a BOOK which will have the page numbers for Chapters. In this case we can think that the database called BOOK has a secondary Index on CHAPTER number as an analogy.

Simlarly to make the search faster for the table GLPCA, there are a few secondary indexes created each for a different set of fields.

Regards,

Ravi