cancel
Showing results for 
Search instead for 
Did you mean: 

Obtaining QM Historical Data for SPC Analysis

Former Member
0 Kudos

Can someone please advise me if ECC 700 has a standard BAPI/RFC to return historical QM data. I have searched through BAPI Explorer and didn't not see anything which would fill this requirement.

What I did find was the following document, [SAP QM Productivity Pack for SAP xMII (Starter Kit)|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f0b0cf92-af8b-2a10-d8a5-f1e115fa5f7e], which provides detailed code to create an custom RFC. Before proceeding down this path, I wanted to confirm that I did not miss something.

Thanks,

Michael Teti

Senior Solutions Consultant

SeeIT Solutions, LLC

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Micheal

I am Karthik , from SAP Labs India Soultion Mgmt , India . I would like to say , the new RFC is the best soultion . The same we have encountered in our Productivity package MII content . In case you have querirs , please contact me .

- Karthik

0 Kudos

Hi Karthik,

Could you explain a bit more about your "Productivity package MII content"?

Thanks,

Mike

Former Member
0 Kudos

Karthik,

I would greatlly appreciate it if you could ellaborate on the RFC that you mentioned.

Thanks,

Michael Teti

jcgood25
Active Contributor
0 Kudos

I believe Karthik is referring to the SDN download content project for QM Productivity (see one of the sticky threads at the forum top).

Regards,

Jeremy

Former Member
0 Kudos

Ryan/Mike,

Thank you both for your input.

Mike,

Could you direct me to the mentioned document which Sam had written?

Thanks,

Michael Teti

Senior Solutions Consultant

SeeIT Solutions, LLC

Former Member
0 Kudos

QM Data is stored in characteristics which makes anyone familiar cringe.

Here are the relevant tables:

AUSP

KLAH

KLAT

KSML

KSSK

CABN

CABNT

CABNZ

CAWN

I used to have a document that explained the relationships but I cant seem to find it right now. If you start looking at the tables you should be able to it figure out.

I think the BAPIs can give you all the data you need but would require a lot of massaging, esp if you wanted to do something dynamic. Trending within an inspection lot wasnt too bad.

Hope this helps you Michael.

Regards,

Christian

Regards,

Christian

Former Member
0 Kudos

This link might help as well:

[http://www.sap-img.com/quality/important-qm-tables.htm|http://www.sap-img.com/quality/important-qm-tables.htm]

0 Kudos

Michael,

Here is the link. This is considered old tech, but I have not gotten anyone's specific input on why it should not be used. There may be reasons. I have used it twice, once just playing around and with only one caveat, it was pretty easy to implement.

[SQ01 Queries|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/390b889b-0e01-0010-e4af-c9a062b9b880]

The document covers 5 or so RFC calls. You will need to check the field names since they are defined internally and do not use the table column names (of course). Probably the only thing left out of Sam's document. One of the RFC calls will give you the internal field names.

You will also need to create your own query in SQ01 in SAP prior to doing the other stuff. I think there is a way to do it via the BAPI calls, but I could never get it to work the one time I spent half a day trying. It might have been a permissions issue, so if you want, go ahead and play around.

Good luck,

Mike

0 Kudos

Hi Michael,

It is possible to get the information out of direct table reads, probably have to hit more than one, which would be a bit tedious, but would avoid the customization route. Or you can check on SQ01 in ERP which allows custom queries to be written and Sam Castro wrote a nice article on how to use them from MII a couple of years back (Man, has it been that long?). Either way, you will need to do some research on the table structures in ERP to find where the data resides.

If you have the opportunity and resources to build custom BAPIs, and you are analyzing (presumably) fairly large datasets, you are probably better going the custom route anyway. Standard BAPIs are meant to bring back all the data that roughly 98% of the users could need. Which means for 100% of the users, there is a lot more information than necessary.

But if you are not a reasonably experienced ABAP programmer, use caution, especially with large datasets. I would recommend getting some help with the ABAP side.

Good luck,

Mike

Former Member
0 Kudos

I can't talk to your version, but on a project with 4.6c we had to create a custom BAPI. And even with the custom one, it was painfully slow. We actually ended up creating a custom table and summary function in SAP and querying that table. So, I think you'll probably go down the custom route one way or another.