Upload custom table using LSMW

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

This message was moderated.