Skip to Content
avatar image
Former Member

Retrieving Quality Results from SAP QM

Hi,

Wondering if anybody has had to do this of yet. Basically need to get to the stage where i can loop through a returned list of LotID's to retrieve a result by initially passing in a material number etc.

I know SAP have provided an application for the transfer of data between a QM and an ERP system which gets me to a one result basis - i want to pull historical values for the test and return them to an SPC chart.

Most of the queries are there except for the actual - being able to feed a Lot List and return the individual for each to a table.

Any tips ?

Thanks,

Emmett

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 11, 2008 at 02:46 PM

    Hi Emmett,

    You can attack this a couple of ways.

    1) Build a Query in ERP that returns your dataset. Sam Castro wrote a nice SDN article about executing the queries remotely. The BAPIs all begin with RSAQ if you want to look them over in ERP. You can use the RSAQ_FieldName (not sure of the exact name) to find the actual system generated field name of the query. It will not be what you expect (the only item not covered in the SDN article). Here is the link: [SQ01Queries|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/390b889b-0e01-0010-e4af-c9a062b9b880]

    2) You might be able to do a table read RFC_READ_TABLE if all the data resides in a table.

    3) Search through SE37 (or BAPI) on "QM" and you may find an RFC which will retrieve the data you are looking for. It has been a couple of years since I played with QM data, so I am not sure what is out there. Your available RFCs will be determined by the version of ERP and your security. You may end up having to get the permissions changed. You may have to do something funky using BAPI_PRODORD_GET_LIST. Run the material and plant to get a list of Production Orders with associated information, including BATCH which you can then match to the Lot number to use the production order number to find the correct inspection lot results.

    4) Build a custom BAPI.

    Good luck,

    Mike

    If you need more explanation on any of these except 4 (I am just learning ABAP), post again.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Michael Appleby

      Lads,

      Have gotten pretty close to where i want to be retrieving results etc. thanks for all the help. I am currently authenticating to the ERP server three times to call the three seperate RFC's i am using, not ideal. I wanted to use the JCO connector start session > JCO Function > JCO Function .... > Close session to see if this would help speed wise. But the Start Session fails to connect with a wrong username or password, this isn't the case as i am using the same configured server via the ERP JCO Interface without trouble, anyone ever seen this before ?

      Thanks again for all the help,

      Emmett

  • avatar image
    Former Member
    Sep 12, 2008 at 02:05 AM

    You can use the BAPI that Mike suggested...

    the following BAPI might be helpful to retrieve the data

    BAPI_INSPLOT_GETLIST

    BAPI_INSPOPER_GETDETAIL

    BAPI_INSPCHAR_GETRESULT

    Regards,

    Ajay.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 12, 2008 at 01:04 PM

    Emmett,

    Have you looked on the SDN Downloads area, in the for Manufacturing section? There are a bunch of sample BLS transactions (including the BAPI's Ajay mentioned) that will probably be a huge help in your efforts.

    Regards,

    Jeremy

    Add comment
    10|10000 characters needed characters exceeded