One of the recent discoveries I found was that you can download the table structures and populate them in Access on a local machine. This is kind of a cool concept, as I never realized this functionality was available. So I decide to dig in a little further. The baseline configuration is pretty easy (check out my post in SDN if you want more details – Service Management – Basic Settings – Print Control – Download – Download Structures to PC). Now, what isn’t really explained is that you need some stuff in place in order to be able to use this. The main piece being a couple of RFC’s. Now, I’ve been able to piece together a few things, so I thought I’d share them with you.
First and foremost, before you can do anything, you need to get or find several files:
wdpsastr.exe
wdpsatab.exe
Without these 2 files, you won’t be able to create the RFC. Now, after some digging I’ve found a few things. First, there are some OSS notes that explain a lot of this, so I”m going to include them here.
443027 – MS Access Interface – Access 97, 2000, 2002, 2003
583698 – FAQ note – MS Access Interface
118827 – Interface MS Access, setting the TCP/IP connection
These notes explain what I’ll be going over here, but consider my post a short cut for service 🙂
Also, if you have trouble finding these files, check out the SDN post.
http://scn.sap.com/thread/292398
I had trouble getting the files from Service.sap.com, but I was able to find them in an old version of my gui installation. However, it doesn’t appear to have the installation files to put the correct dll files in place.
Once you have this installed, you can go to SM59 to create the 2 new RFC destinations.
Press create to make a new connection. You will need to do this twice.
Now, you should be able to proceed with the actual configuration to download the service management tables into access.
Thanks for reading,
As always, thanks for reading and don't forget to check out our SAP Service Management Products at my other company JaveLLin Solutions,Mike