7 Replies Latest reply: Jun 25, 2009 6:16 AM by Muralidharan Subramani RSS

production order report

sap125 P
Currently Being Moderated

dear all ,

 

we have serial numbers in production orders.

 

how to get all the production orders in a plant along with the respective serial numbers in a reoport...

 

sap125

  • Re: production order report
    karthick PP
    Currently Being Moderated

    why cant u go for sqvi report for that...

     

    join tables OBJK and ser05.

     

    check and revert back..

     

    karthick

    • Re: production order report
      sap125 P
      Currently Being Moderated

      Dear karthik,

       

      can you guied me how to use the SQVI. i know it can be used to generate reports. but can u explain steps.

      sap125

      • Re: production order report
        karthick PP
        Currently Being Moderated

        Go to tcode SQVI.

         

        Enter some name..like zserord. Create..

         

        Enter description.

         

         

        Data source: select table join

         

        Enter

         

        Click the insert table iconu2026enter the first table name

         

        Again Click the insert table iconu2026enter the second table name

         

        Then come back..

         

        You will see all the fields in both the tables with two boxes next to each field..

         

        The first box is the thing which you need to get in the output and the next box is for the inputting stuff..

         

        Put tick mark in the relevant boxes according to ur requirementsu2026and execute...

         

        karthick

  • Re: production order report
    Tejas  Kantilal Pujara
    Currently Being Moderated

    Hi,

     

    COOIS  Production Order Info System is the best available std report to view the Production Orders in Plant.However as per my knowledge, you can get serial number info at order level only in CO03 / CO02. Even though you will get order list in COOIS you will have to go to them single order wise.

     

    You can get serial numbers at material level in MMBE / IQ03.But at order level you need to check for individual order as I mentioned above.

     

    Pls. check above Tcodes.

     

    Hope this helps.

     

    Regards,

    Tejas

  • Re: production order report
    Muralidharan Subramani
    Currently Being Moderated

    Hi

     

    Follow the procedure which kartik has given earlier. While selecting the fields for report you have to select the key fileds for selection screen from the both the table. Key fields only enable you to enter the selection criteria for the report.

     

    Make note the key fields when you join the tables in table join mode.

     

     

    Thanks

    S.Murali

Actions