topic Re: LSMW in Application Development and Automation Discussions

LSMW

former_member214498 — Tue, 13 Nov 2007 19:37:01 GMT

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

Re: LSMW

Former Member — Wed, 14 Nov 2007 04:46:27 GMT

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

Re: LSMW

Former Member — Wed, 14 Nov 2007 05:00:40 GMT

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

Re: LSMW

Former Member — Wed, 14 Nov 2007 05:08:12 GMT

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

Re: LSMW

Former Member — Wed, 14 Nov 2007 08:22:17 GMT

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

Re: LSMW

Former Member — Wed, 14 Nov 2007 08:45:29 GMT

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

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

Withdrawal).

All the Best

Reward Points if Useful

Regards

Gokul