Skip to Content
avatar image
Former Member

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

regards

Kedar Kulkarni

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2008 at 08:21 PM

    Hi,

    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.

    Add comment
    10|10000 characters needed characters exceeded