selection from database tables

[Former Member]

Hi Experts,

In one program I'm selecting data from tables <b>VBAK, VBAP,VBRK,VBRP,LIKP,LIPS</b>. As the tables have huge data, it's taking forever to get the data into internal tables.

Could you please suggest me to better the performance.

Thnx much.

[RichHeilman]

Make sure that you are selecting data from the tables using the key fields, this will help in performance.

Regards,

Rich Heilman

[Former Member]

hi dev,

do not use select .. endselect statement and include all the key fields in your select statement.

instead of select .. endselect statement use

select * from <table> into table itab where < conditions)

.

Regards,

Santosh

Message was edited by: Santosh Kumar P

[Former Member]

Hi

Fetching data is not a problem from this tables.

The only care to be taken is that will using select use index in the where clause & fetch those columns which are required.

Also while joining tables join on the primary keys.

this process will sharply reduce performance issues.

Regards

kapil

[Former Member]

in the where clause of the select try to give all the key fields ,

do not use select in loop ..... endloop.

[Former Member]

Hard to say without actually seeing your code. Could you please post it?

Rob

[Former Member]

Thnx all.

[Former Member]

hi Dev,

If any of the above answers were helpful mark those answers and close the thread if your problem is solved..

Regards,

santosh