Skip to Content
0
Jan 03, 2010 at 10:21 AM

Production order report on Daily

26 Views

Hi gurus,

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.

Thank you.

Edited by: Rob Burbank on Jan 3, 2010 2:09 PM