fetching data from a big database view

[Former Member]

I have a database view of four tables viz.,EKKO ,EKPO, EKBE, LFA1.So, when I retrieve the data from this view the application hangs or stops responding means this particular query which is fetching the data from this big view gets stuck somewhere.How to get around this problem?

Thanks and regards

Mr.Sonal Sharma

[ritesh_dugad2]

Pls. check your Join conditions in the view, hope they are correct. Other way is to write select statements using Joins/for all entries/into table etc.

[Former Member]

hi

yes it will take time if data retrived for selection will be high in volume.

insted of that u can start ur selection from EKKO , and can use SELECT FOR ALL ENTRIES to select data form other tables .

INNER JOIN or VIEW's for big selection condition (WHERE condition decrease performance of report)

reward if helpful.

[Former Member]

hai,

send the piece of code you are using for data access.

check out for performance in sap hel also.

regards

jase

[Former Member]

Hi,

Try to use criteria with key field,

If program return a huge data, Try to run in background!

More info about performance tuning http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Cheers

Wiparat