LSMW for migrating data in Custom Z tables...

[Former Member]

Hello,

I know that we can use LSMW for business obejcst data migration like Customer Master, Invoices, PO, etc. Can I use LSMW just for simple migration of data in SAP custom Z tables from Excel sheet ?

Regards,

Jainam.

[ThomasZloch · Accepted solution]

Yes, just record your transaction e.g. SM30 for one entry and then build your LSMW object around that.

Thomas

[Former Member · Accepted solution]

What do you mean by recording transaction for LSMW ?

[former_member191735 · Accepted solution]

If the custom tables are being used in the transaction and want to use LSMW to upload them you can do so by recording the transaction - Go to LSMW first and then go to first step - you can see batch recording.

Why dont you post your question more clear than 'upload data from excel to Z tables using LSMW;

My question is--- why do you want to use LSMW? What are those custom tables i mean where are they used?

[ThomasZloch · Accepted solution]

>

> What do you mean by recording transaction for LSMW ?

http://help.sap.com/saphelp_erp60_sp/helpdata/EN/1a/178ac72d3011d3bc3500105a6588b2/frameset.htm

Record SM30 maintenance for one entry of your Z-table, incl. saving the data and returning to the SM30 entry screen. This recording is the basis for your LSMW object that you will have to build and that will read the entries from your Excel list and insert them into your Z-table.

Thomas

P.S. Link changed

[Former Member · Accepted solution]

Hi Thomas,

your answer is very helpful. i have created a LSMW recording (transaction: SM30) for updating few fields with my txt. file.

when i run batch input session on processing mode - (process foreground / display errors only), system works fine and updating the ztable from txt. file.but if i run batch input session on processing mode-(Background), system throws an error on very first record itself. system is not taking up my "ztable" name which was given as the default value "ztable" in the recording. Could you please let me know what could be the reason for it ?

[former_member191735]

> I know that we can use LSMW for business obejcst data migration like Customer Master, Invoices, PO, etc. Can I use LSMW just for simple migration of data in SAP custom Z tables from Excel sheet ?

That is not migration... that is a simple upload program. Write a program which takes the excel file and upload into your coustom Z table.