Skip to Content
avatar image
Former Member

Looking for service order progress report

Hello,

In my new position as supervisor of a machine repair facility, I have been introduced to SAP. I supervise 30 employees that all have different roles in the repair process (welders, machinist, mechanics). We presently have over 200 open service orders. A lot of these SO's are for parts we repair on a continuous basis and can be 150 open SO's at any time. We assign various processes to the SO and the employees punch in and out of these processes as the job progresses.

The goal here is to gain clarity as to where each SO is in the process.

A perfect report would:

  • Calculate a historical average time spent for each process. This would be compared to the actual time.
  • A graphical report showing green for under, yellow when getting close and red when over average time. If no time has been entered for a process the actual field should be blank (lower right). This will give indication that process has not started.
  • The ability to drill down each process, displaying the employee names and times.
  • Below is a spreadsheet that represents what I am trying to achieve. Hopefully there is an existing transaction that gets close to this.
  • We are running SAP Optimus. I do not know much about the platform so ask me questions and I will get answers.
  • Thanks in advance for the help.
SO DATE ENTERED CUSTOMER DESCRIPTION PROCESSES







4015678 01/27/13 ABC COMPANY ABC COMPANY 5” MANDREL LOWER A B A AVG HRS 0.75 A ACTUAL 0.7 B AVG 1.5 B ACTUAL 2 4015679 01/28/13 ABC COMPANY ABC COMPANY 5” MANDREL LOWER A B A AVG HRS 0.75 A ACTUAL 0.74 B AVG 1.5 B ACTUAL 1.4 4015680 01/29/13 ABC COMPANY ABC COMPANY 5” MANDREL LOWER A B A AVG HRS 0.75 A ACTUAL 0.76 B AVG 1.5 B ACTUAL 1.3 4021234 01/30/13 XYZ COMPANY R-4 HEAD REBUILD M N M AVG HRS 2.2 M ACTUAL 2 N AVG 3.2 N ACTUAL
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 29, 2013 at 09:23 PM

    Terry,  Please repost your question under this forum

    http://scn.sap.com/community/erp/sd

    Bala

    Add comment
    10|10000 characters needed characters exceeded