I still have doubt in using FM status_read and tables jest and tj02t.
My requirement is to select work orders( auart), planned hrs( arbei), actual hrs( ismnw ) based on 'date range', 'work order type', func location ( tplnr ), 'abc indicator ( abckz).
i have to list all work orders:
for a particular planning plant say '1000' , systm status including CNF, TECO, CLSD, excluding PCNF , CRTD , DLFL and REL, I have to include all work orders except SM02 and CP01 and also exclude work orders scheduled outside query period .
When the above is done, i need to sum planned work work hours scheduled for that week , divided by sum of planned work hrs.
I am done with select statement part, how can i find system status or how to calculate system status .