LSMW

[former_member214498]

Hi Folks

How can we fetch data from MS ACCESS to SAP using LSMW.

Any guidance will be highly appreciated.

Will reward points to helpful answers

Regards

Waz

[Former Member]

Hi,

You can get the data to excel from access. The data can be taken from excel into SAP or if you have a middleware tools like Tibco you can try using it.

All the best

Regards

Gokul

Reward Points if useful answer

[former_member214131]

Hi,

Export the processed table data from MS Access to specified directory/your desktop in the from of text file delimited with tab.

Use this data file in your LSMW with appropriate parameters in step 'Specify Files'.

Hope this helps.

Best Regards, Murugesh

[Former Member]

Hi

http://sap4.com/contentid-139.html

[Former Member]

we can use only .txt/.csv in lsmw so convert ur file to these types and upload it

[Former Member]

Hi Waz,

Try this out

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

<b>For the MS-Access interface SAP delivers 4 files:</b>

<b>WDPSASTR.EXE</b> 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.

<b>WDPSATAB.EXE</b> 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.

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

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

confirm).

<b>WDPSAMAT.EXE</b> This is an RFC client program that triggers material

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

Withdrawal).

<b>

All the Best</b>

<b>Reward Points if Useful</b>

Regards

Gokul