LSMW Question......Important

[Former Member]

Hi Experts,

LSMW stands for Legacy System Migration Workbench and its used for migration of the data after the implementation is done (main general use).. If I am right??

Well, Now I have a question:

I have a flat file in my desktop which is sequential file and its has the same structure as that of a table which I have created in the data dictionary. Can I use the LSMW to migrate the data in flat file to my table in R/3?? Can I do that??? Here is the structure and file names given below:

For eg:

My flat file looks like this:

location: desktop

file type: sequential file

structure of file:

lifnr c (8)

name1 c (35)

regio c (8)

Land1 c (8)

destination table:

zablif1 (my own created table)

Same structure as that of flat file.

So how do I go forward, which interface method should I select in order to upload to R/3...

Also, what I read in the books was that we can only use LSMW to migrate data to tables like vendor master and customer master and not to the user defined tables like z tables. also, today I tried to migrate some data but with the batch input, we have to give the object name and it has possible entries which are like vendor master, customer master and similiar tables.

so guys give me some infomration about it.. I will greatly appreciate your answers..

Regards,

-Ashok Patel

[Former Member]

Hi Ashok,

With LSMW you can only load supported objects like vendor master , customer master. For uploading data to Z table you will have to write your own code.

If this helps reward and close thread. By closing thread it only means that your qusetion is answered. It will still be available in forum which you can view later .

Cheers

[Former Member]

Hi Sanjay,

Thanks..

But then I have another question... If objects like vendor mater and customer master have so many fields and my flat file data to be migrated has only certain fields like 5 or 6 fields, so is it possible to migrate such a data to the vendor master or customer master??? And after migration of the data, if we go to the data dictionary, we can see the data there in the table contents, right???

Let me know about it.. I am sure that I am asking some useful questions.. well, I am learning you see!!!

Regards,

-Ashok Hansraj

[Former Member]

Hi Ashok,

If you are providing less information to database which are necessary for Vendor/material master creation then it would not be created.

To create vendor you must provide at least all necessary information.

Hope this helps.

Cheers.

[Former Member]

Hi Ashok,

What i think

the LSMW comprises the following main functions:

1. Read data (legacy data in spreadsheet tables and/or sequential files).

You can use any combination of PC and server files.

2.Convert data (from the source into the target format).

3.Import data (<b>to the database used by the SAP application).</b>

so i dont think you will be able to update your own ztable.

to do that you can use GUI_DOWNLOAD.

Hope it works.

Regards

[former_member221770]

Ashok,

LSMW is traditionally used for data migrations (one off conversions) but there is nothing to stop you from using it for interfaces (because an interface is usually nothing more than a conversion which gets run regulararly right?).

As Sanjay said, LSMW is used to load in Business Objects such as vendors, customers, materials, etc. LSMW is not designed to upload Z tables. LSMW is basically a glorified mapping tool which allows you to map your load file(s) to a the file format(s) that standard load programs (or IDocs) use. It is these standard load programs that load the data into SAP.

If you want to maintain a "Z" table, you should write your own ABAP program and use the MODIFY table WITH TABLE itab command.

Hope this helps.

Cheers,

Pat.

PS. Kindly assign Reward Points to the posts you find helpful.