I tried to create a report for production orders. it contain four selection parameters. Here i am using four tables 1) crhd 2) caufv 3) aufk 4) afru 5) zbreak ( this is a ztable created by me ) . i need the fields like date,work centre, porder,startdate,enddate,order quantity,processed quantity,yield,scrap, (down time ,from time ,reason these all from ztable). i want to make one report on this.
i did it in two ways. I used a join statement but it is taking more time to execute. i know this is a performance issue. please give me a good idea how to finish this report.
<< Please repect the 2,500 character limit on posts. Post only the relevant portion of your code. And please use code tags.>>
form get_data. select a~arbpl b~plnbez c~aufnr d~rueck d~isdd d~iedd b~gamng d~lmnga d~xmnga d~rmnga e~from_time e~to_time e~total_time e~workcentre e~reason into table itab * (itab-arbpl, itab-plnbez, itab-aufnr, * itab-rueckb itab-isdd itab-iedd, * itab-gamng, itab-lmnga, itab-xmnga, * itab-rmnga ,itab-from_time, itab-to_time, * itab-total_time, itab-workcenter, itab-reason) from ( ( crhd as a inner join caufv as b on a~werks = b~werks inner join aufk as c on c~werks = b~werks inner join afru as d on d~werks = c~WERKS ) inner join ZBREAK_DOWN_TIME as e on e~werks = d~werks ) WHERE PLNBEZ IN S_MATNR. append itab. endform.
Edited by: Rob Burbank on Jan 3, 2010 2:09 PM