Skip to Content
author's profile photo Former Member
Former Member

How to find production order through serial number

Dear all,

If I created some production orders and assigned serial numbers in each production order, is there a report or standard function to search production order# through serial numbers? I know we can use IQ02 to check the history for each serial number so as to find the production order. But if we get many serials numbers, is SAP providing a report to show which production orders are producing these serial numbers?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2010 at 08:43 AM

    hi

    have you tries with IQ09

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2010 at 10:12 AM

    Lets have 3 serial numbers in a production order .. GO to table SER05, enter the order number.. you will get the object list number.. give this order number in table OBJK, you will get the serial numbers..

    YOu can have a SQVI report linking OBJK and SER05..

    Hope this solves..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2016 at 03:04 PM

    You could create a SQVI / SQ01 query with 4 tables: SER05, OBJK, CAUFV, EQBS.

    The joins are:

    SER05-OBKNR = OBJK-OBKNR

    SER05-PPAUFNR = CAUFV-AUFNR

    and finally if you want to show if the equipment is in stock or not:

    OBJK-EQUNR = EQBS-EQUNR (Make sure to right click the join and define as "Left Outer Join" as there may be equipments that are not in stock and you still want to report on those

    then make the selection parameters including CAUFV-AUART for order types and the ones you been looking for OBJK-MATNR for material # and OBJK-SERNR for Equipment serial number

    hope it helps others

    Add a comment
    10|10000 characters needed characters exceeded

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.