Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to extract the data from SAP using Msaccess tool ?

Hi Experts,

Purpose u2013

Want to extract the data in a better way rather than using the T.code u2013 SE16


Kedar Kulkarni

Former Member
Former Member replied


Try this...

Please use the standard ABAP program "RIACCESS".

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

It is available in the "\SAPGUI\PS 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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question