topic Create a table and upload data in MS ACCESS from SAP ABAP programming? in Application Development and Automation Discussions

Create a table and upload data in MS ACCESS from SAP ABAP programming?

Former Member — Sat, 08 Aug 2009 07:00:39 GMT

Hi All,

How to create a table in MS ACCESS database and Upload SAP database table data into MS ACCESS table using ABAP programming?

Explain: My client requirement is " If he/she runs a ABAP Program, that will create a table and upload data into MS ACCESS Database table in background. "

Could you please give the solution or code? I know the program RIACCESS and I went through the SAP Note 583698.

Is this only solution for this? Or Any other possibilities?

Please give me solution.

Thanks in advance.

Re: Create a table and upload data in MS ACCESS from SAP ABAP programming?

Former Member — Sat, 08 Aug 2009 10:10:22 GMT

Hi,

It is not possible to create tables in a non SAP schema from inside SAP.

The SAP-Oracle license also does not allow you to create the table (see note 581312):

the following actions, among other things, are therefore forbidden at database level:

Creating database users
Creating database segments
Querying/changing/creating data in the database
Using ODBC or other SAP external access methods

Please refer following link,

[Ckick Here|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes.do]

You can also do it by LSMW,

If you are using Access 97, you can download directly into an access

database from SAP. See program RIACCESS for details. You have to establish

an RFC destination PS_ACCESS_1 and 2.

There are then a couple of function modules. Go to SE37 and put in

msaccess and hit PF4.

The following is from the readme file: sapgui/ps/readme.sap

For the MS-Access interface SAP delivers 4 files:

WDPSASTR.EXE This is an RFC server program that is called by SAP R/3

(PS module). This program creates a MS Access database. The structure

information of the tables is transferred from R/3. In addition to

these tables a table named DDIC is created. This table contains the

structure information and should in no case be modified or deleted.

WDPSATAB.EXE This is an RFC server program that is called by SAP R/3

after WDPSASTR. This program filles the tables of the database with data.

There must not be made any changes of the structure of

the tables between the calls of WDPSASTR and WDPSATAB.

WDPSAZET.EXE This is an RFC client program that triggers work/time

confirmations in the PS module of SAP R/3 (like transaction CN27 Collectiv

confirm).

WDPSAMAT.EXE This is an RFC client program that triggers material

confirmations in the PS module of SAP R/3 (like transaction MB1A - Goods

Please also refer following links,

[Click here|;

Before using the program "RIACCESS", you need to install the PS utilities, which are part of SAPGUI install CD.

It is available in the "SAPGUIPS directory".

Then do the followings :

1. Select transaction code SALE -> Systems in network-> Define RFC Destination.

2. You will need two RFC destinations (TCP/IP connections for the front-end workstation).

Setup the two RFC destinations PS_ACCESS_1 and PS_ACCESS_2 and you'll have to get them to point to

wdpsastr.exe and wdpsatab.exe respectively.

3. Then execute RIACCESS and choose PS_ACCESS_1 to generate access tables.

The system must also be able to access the RFC-DLL files (librfc2.dll, librfc3.dll, librfc4.dll, librfc5.dll, librfc6.dll, vrfc.dll).

Please note that Access only supports tables with up to 255 fields.

Re: Create a table and upload data in MS ACCESS from SAP ABAP programming?

Former Member — Mon, 05 Oct 2009 11:53:27 GMT

Self

Re: Create a table and upload data in MS ACCESS from SAP ABAP programming?

Former Member — Mon, 05 Oct 2009 13:53:57 GMT

Hi,

You solved it by yourself and its great .But if you could share the solution , it would of more help to us.

Comradely,

K.Sibi

Re: Create a table and upload data in MS ACCESS from SAP ABAP programming?

Former Member — Mon, 05 Oct 2009 13:54:02 GMT

Hi,

You solved it by yourself and its great .But if you could share the solution , it would of more help to us.

Comradely,

K.Sibi

Re: Create a table and upload data in MS ACCESS from SAP ABAP programming?

Former Member — Tue, 13 Oct 2009 10:55:07 GMT

Hi there,

I have similar requirement can you share your solution please?

Rhea.