probs in database view

[Former Member]

hi,

i have problem in my select query where i am trying to fetch datas from database view.

it takes huge time to process and finally results in run time errors.

help me.

ganesh.

[andreas_mann3]

hi,

post your coding and look at Wiki-ABAP Performance and Tuning

e.g.:

https://wiki.sdn.sap.com/wiki/display/HOME/ABAPPerformanceand+Tuning#ABAPPerformanceandTuning-Whattoolscanbeusedtohelpwithperformancetuning%3F

pls reward usefufl answers

thx.

Andreas

[Former Member]

For ex: assume that u r creating DB view (say zdbview) for VBAP and MARA.

Select only required fields from two tables when creating the view.

SE38 code:

Data: itab like zdbview occurs 1 with header line.

select * from zdbview into table itab.

loop at itab.

write: / itab-vbeln, itab-matnr, itab-zmwng, itab-mbrsh, itab-mtart.

endloop.

Hope it helps.