2006 Dec 20 5:35 AM
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.
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
2006 Dec 20 6:59 AM
2006 Dec 20 10:18 AM
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.
Bluesky
