Skip to Content

Link between start/end time of a production order and the worker

Dear SAP expert,

I'm having trouble trying to found a link between a production order and the worker (or the operator) that worked in that range of time.

In particular, my client have a custom tcode where he can see the working hours of the machine and the worker associated to the time range:

In the field 'persNo' there is the code associated to the worker, in the fields start time and finish time the working hours linked to the worker.

I tried many tables like so02, afvv and all the related tables to PP sap module but I didn't find a field related to my needs.

Any suggest?

Best regards.

Alessandro

zco73.png (23.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 03, 2019 at 05:18 AM

    Hello,

    Did you check the AFVC table? Here you will get the link of personal number PERNR and in AFVV you can have the start time and finished time for order counter APLZL. Or you can also refer table VIAUF_AFVC in case of mainataince order.

    Best Regards,

    R.Brahmankar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 03, 2019 at 05:39 AM

    Hello

    During the Production Order Confirmation e.g. CO11N Transaction Code, We have the options to enter the Personel No and Start and Finish Date & Times for the Production Order.

    Those details will be updated in the AFRU table, So Kindly pass the Production Order Confirmation Number into the table to get the all confirmation details

    Please check these fields in the table, which may be relevant to your given screenshots

    PERNR - Personnel number

    ISDD - Confirmed date for start of execution

    ISDZ - Confirmed time for 'Execution start"

    IEDD - Confirmed date for execution finish

    IEDZ - Confirmed time for 'Execution finish"

    Please let me know if any further help required on this.

    Thanks & Regards,

    Ramkumar RV

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks Ramkumar RV, I found the fields of interest. I have just one more question, the working hours are not the same between the fields in the AFRU table and the custom TCODE where the client see the mix of working hours/operators/downtime machine.

      AFRU:

      Custom Tcode, the marked row is about the working hour of an operator, while in the AFRU I found always the same time of start (6:26) in the tcode I see a different time of start and a different end time (17:17 in the AFRU and 14 in tcode):

      Any suggest?

      Best regards

      afru.png (33.0 kB)
      zco732.png (7.0 kB)
  • Posted on Jul 03, 2019 at 10:23 AM

    Update

    I found the table with the right information hours. There is a custom table made by other.

    Thanks for the support.

    regards!

    Add a comment
    10|10000 characters needed characters exceeded

    • Welcome.

      Hopefully your problem solved.

      May be the custom table has been created based on these below information

      In the AFRU table, You can also check the fields IERZ (Setup finish time), IEBZ (Processing finish time), IEDZ (teardown finish time).

      Thanks & Regards,

      Ramkumar RV

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.