glpca

[Former Member]

hi,

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

thanks

[Former Member]

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

[Former Member]

hi,

i did that in the where clause.

what do you mean by secondary index.

thanks

[Former Member]

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