Skip to Content
avatar image
Former Member

Pulling order header and details from SAP

I need to identify the fastest and most efficient way to get order header and details from SAP to an MES system or MII? We are currently relying on our customer to do this and the queries take six minutes to pull this information for a specific user. We need the most efficient way to pull this information and this would be used here and any place that would need this in the future. Any help would be greatly appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 09, 2010 at 01:55 PM

    I would recommend JCO to pull information from ERP and then either display it in MII or push it to a MES system. You are going to have to use the appropiate BAPI and pass in your selection criteria.

    How are you currently doing this that it takes so long to pull in the information?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 10, 2010 at 03:36 PM

    Hi Gregory,

    We have used SOA and JCO for these interfaces with excellent results.

    SOA is a bit slower, but I think more thorough and better documented.

    You can view the documentation in http://esworkplace.sap.com

    The services will use for these interfaces are:

    - ECC_ProductionOrderSEQR to read the header of an order list using a filters combinations.

    ECC_ProductionOrderBYIDQR to view details of a particular order.

    With JCO you can use the BAPIs below:

    BAPI_PRODORD_GET_LIST to read the header of an order list using a filter combinations

    BAPI_PRODORD_GET-DETAIL to view details of a particular order.

    I have helped with this message.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2010 at 06:01 PM

    Hi Gergory,

    using what ever kind of approach - this will never take 6 minutes. As far as I know every Transaction has a timeout of approxamatly 3 minutes in Test mode - so the only change you have to test it is to schedule the TRX. However it would be useful to learn more about what you like to achive: What is daterange of your orders. Which MES etc. I'd would rather look for a appoarch sending data from ERP eventbased to the MES then polling from MII. That means you need to customize your SAP ERP calling a MII Transaction (e.g. as a webservice). You will find more information about this browsing the SDN / MII Wiki. But please give use more information.

    Ciao Martin

    Add comment
    10|10000 characters needed characters exceeded