This website is not affiliated with, sponsored by, or approved by SAP AG.

Exchanging SAP table data with table in Microsoft Access?

Interfaces (ALE, IDOC, RFC, EDI etc.)

Moderators: Snowy, thx4allthefish

Exchanging SAP table data with table in Microsoft Access?

Postby adi2011 » Mon Sep 24, 2012 2:51 pm

Hello,

I have table "YXY" in SAP which holds the data which I would like to read in Microsoft Acces (MA) in real-time. For example, table "YXY" which holds some transaction data contains 1.000 records and I would like to see that records in MA also in real-time.

How can do this (perhaps some example?) and is there any way I could violate my Oracle license? I wouldn't like that to happen.

I hope someone can help me with this because it is very important to me.

Thank you.
adi2011
 
Posts: 18
Joined: Thu Apr 28, 2011 1:13 am

Re: Exchanging SAP table data with table in Microsoft Access?

Postby Gothmog » Tue Sep 25, 2012 3:18 am

You could use an RFC connection to call function module RFC_READ_TABLE.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1942
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Exchanging SAP table data with table in Microsoft Access?

Postby adi2011 » Tue Sep 25, 2012 7:28 am

I will try that definitely, I have already found some useful info on web.

If I understood correctly I will set VBA code in Microsoft Access which will "tell" SAP to send data from SAP table "YXY" to M.Access table using RFC connection? Is it possible to define time interval (for example every 30minutes) when the data between two tables will be send?

And do I at any time on this time violate Oracle licence or not?

Many thanks in advance!
Adi
adi2011
 
Posts: 18
Joined: Thu Apr 28, 2011 1:13 am

Re: Exchanging SAP table data with table in Microsoft Access?

Postby Gothmog » Tue Sep 25, 2012 7:37 am

It's more that your VBA code will ask SAP for the data - if you want to refresh periodically, you'll have to set the timer there and ask again, I guess.
Doing it this way won't violate your license - you're accessing the data via the SAP system, you're not connecting directly to the Oracle database.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1942
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Exchanging SAP table data with table in Microsoft Access?

Postby adi2011 » Tue Sep 25, 2012 2:59 pm

Hi Gothmog,

Thank you very much for great explanation, I understand it much better.

I will try with RFC connection and let you know if it works out.

Thank you.
Adi
adi2011
 
Posts: 18
Joined: Thu Apr 28, 2011 1:13 am

Re: Exchanging SAP table data with table in Microsoft Access?

Postby Sharpshooter » Wed Sep 26, 2012 6:41 am

ODBC connection is also possible and eliminates the 'refresh' issue. But it can make both basis people and auditors very nervous!
Good luck!
Sharpshooter
 
Posts: 1171
Joined: Wed Mar 17, 2010 12:01 pm
Location: In the dark

Re: Exchanging SAP table data with table in Microsoft Access?

Postby adi2011 » Sun Sep 30, 2012 11:27 am

@Sharpshooter

Thank you very much for useful advice!

I kind of stuck right now, unfortunatly.. I have found and read many useful articles and also found similar topics on web, for example

http://www.tek-tips.com/viewthread.cfm?qid=1629884
http://help.sap.com/saphelp_nw04/helpda ... ontent.htm
http://scn.sap.com/thread/129358

BUT I really don't know where to start. All I know I must make some simple form in Microsoft Access which will read data from certain table in SAP. What I don't know is:

- how to make this first form,
- on which event should I set this code (on load form, on button click etc?),
- I can't find any simple example made in M. Access on web?

Any help is appreciated and many thanks in advance!
Adi
adi2011
 
Posts: 18
Joined: Thu Apr 28, 2011 1:13 am


Return to Interfaces

Who is online

Users browsing this forum: No registered users and 6 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.