RIACCESS - ooxxvv/MySAPnotes GitHub Wiki

PageOutline {{{#!comment -------------------- 以上的部份是固定的，不要變動 ----- --------------------------------------- 在建立連結時，請標明連結的頁面類型，例如：wiki:WikiStart，而不要只用 WikiStart ----- }}}

RIACCESS

  • 將 Table 的資料存成 Office Access 的格式
  • 尚未成功 download 過

Download data to MS access 97/2000

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.
  1. 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.

{{{#!comment

EXPORTING

IMPORTING

TABLES

EXCEPTIONS

Attributes

Methods

Code

{{{#!abap }}} }}}

{{{#!comment -------------------- 以下的部份是固定的，不要變動 ----- }}}