topic Re: probs in database view in Application Development and Automation Discussions

probs in database view

Former Member — Wed, 20 Dec 2006 05:35:59 GMT

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 — Wed, 20 Dec 2006 06:59:28 GMT

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 — Wed, 20 Dec 2006 10:18:18 GMT

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.