topic Re: Table access time in Application Development and Automation Discussions

Table access time

Former Member — Tue, 06 Nov 2007 08:57:33 GMT

Hi.

One of my company's past developer has created an additional transparent table. Here are some of the fields of the table in SE11:

RCLNT X X MANDT CLNT 3 0 Client

GL_SIRID X X GU_RECID CHAR 18 0 Record number

...

DOCNR BELNR_D CHAR 10 0 Accounting Document Number

BELNR BELNR_D CHAR 10 0 Accounting Document Number

When I select values using DOCNR in SE11 it outputs data almost instantly but when I use BELNR alone, it takes about 3 minutes or more just to select a single data.

How could I treat BELNR the same as DOCNR so that I could select data almost instantly using BELNR and not DOCNR?

Regards,

Vince

Re: Table access time

Former Member — Tue, 06 Nov 2007 09:03:09 GMT

Hi,

Use the index on the key fileds.

Indices on the key fileds makes tha data access much faster.

Even if you have slow access,Then try to create secondary index on the primary index.

I Hope this definitely helps you.

Regards,

Rama.Pammi

Re: Table access time

Former Member — Tue, 06 Nov 2007 09:10:25 GMT

Thank you for the quick reply.

In the program i have created, I need to use BELNR in the parameters.