topic Upload custom table using LSMW in Application Development and Automation Discussions

Upload custom table using LSMW

Former Member — Fri, 10 Jul 2009 19:40:48 GMT

I need to upload data from excel file to a custom table using LSMW. I have custom program and no transaction code.

Can someone provide me steps how to upload data using LSMW.

I have seen 4 options in LSMW out of which batch input requires a transaction code,direct input requires object,method & program name.

I cant use IDOC & BAPI .

please provide some inputs.

Re: Upload custom table using LSMW

Former Member — Mon, 13 Jul 2009 09:35:54 GMT

create tcode for custome program and use the LSMW recording method other wise update directly useing update statment any this is custom table , and use record level locking..

Re: Upload custom table using LSMW

Former Member — Mon, 13 Jul 2009 09:36:46 GMT

create tcode for custome program and use the LSMW recording method other wise update directly useing update statment any this is custom table , and use record level locking..

Re: Upload custom table using LSMW

Former Member — Mon, 13 Jul 2009 12:00:15 GMT

hi,

Create a t-code for your program using t-code se93 .you can even create a message type for your t-code

in we30 ( i guess ).

with regards,

M.Sreeram.

Re: Upload custom table using LSMW

Former Member — Mon, 13 Jul 2009 12:05:44 GMT

Hi,

Incase it is a custom table then update it via custom program only making use of INSERT, UPDATE or MODIFY statement.

Incase you want lsmw; then create a table maintainance generator of the table.

The table then can be maintained via SM30.

In LSMW do a recording for transaction SM30 giving your table name and saving the entry.

Use this recording in LSMW to map your fields and then upload the data.

Regards,

Ankur Parab

Re: Upload custom table using LSMW

Former Member — Tue, 14 Jul 2009 08:55:59 GMT

Thanks for the answers. We are trying to copy manually the entries to the view.

Re: Upload custom table using LSMW

Former Member — Sun, 18 Mar 2012 11:37:22 GMT

This message was moderated.