on 02-12-2009 10:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.