Yes. The LSM workbench can read the data directly from your PC. Only when using the periodic interface, the data has to be on a server accessible by R/3
Yes, transaction codes can be created from SHD0 for LSMW Objects.
Yes. It is possible to build periodic interfaces using the frame program /SAPDMC/SAP_LSMW_INTERFACE
Importing legacy data from PC spreadsheet tables or sequential files
Converting data from its original (legacy system) format to the target (R/3) format
Importing the data using the standard interfaces of R/3 (IDoc inbound processing, batch input, direct input)
Yes. The data is loaded via the standard interfaces of the applications. This will include all checks that are run for online transactions. Invalid data will be rejected.
Yes, data can be transferred from one R/3 System to another. Export functionality has to be programmed to achieve the same.
LSMW is not suitable for frequent data transfer as there are a number of steps that are to be repeated every time.
No. Business objects such as material master, customer master or FI document are migrated
Yes, Validations can be carried out in LSMW. Similarly custom code can also be added in LSMW. Validations can be handled in 5th step (Maintain field mapping and conversion rules) of LSMW.
For example, if you are updating Vendor Master, You will need to carry out a validation to check whether vendor is valid or not.
There is no specific training course for LSMW LSMW is part of the 5-day standard training BC420 Workshops at customer site are done at customers charge Examples in the media center can be used for self-study
No. The LSM Workbench can be downloaded for free from SAPNET: http://service.sap.com/LSMW
No. of steps varies for different import methods. Initially there will be 20 steps but after processing step 1 it will reduced to 14 for session method.
No. The LSM Workbench is available free of charge to SAP’s customers and partners
There are four standard import methods available in LSMW.
IDOC's:
BAPI’s:
STANDARD/DIRECT INPUT:
BATCH INPUT:
The LSM Workbench is an R/3-based tool that supports single or periodic data transfer from your non-SAP system to R/3.
No. The LSM workbench provides the main conversion techniques at the push of a button. For complex conversions, individual ABAP coding can be added.
The 3 main functions of the LSMW are:
Transaction Code to start the LSM Workbench is LSMW.
Wide range of Master Data (e.g. G/L accounts, customer master, vendor master, material master, bills of material) and Transaction Data (e.g. financial documents, sales orders) can be migrated using LSMW.
Yes, the imported data will be consistent because the data is loaded via standard interfaces of the applications which will include all checks that are run for online transactions.
Data Migration stands for data transfer between two like or alike systems. During SAP R/3 implementation the data needs to be moved from legacy system to the SAP system. Sometimes periodic data transfer between R/3 and other system (interfacing) is also required. Both of the above form a part of data migration.
Significance of data migration are:
The tools for data migration are:-
Generally Multiple Recordings are done for transactions which has multiple access sequences like VK11, TK11, etc. Batch Input Method is capable of handling multiple recording and Batch Input recording is one of the import methods available in LSMW. So yes, LSMW can be used for handling multiple recordings.
By means of standard transfer programs: a wide range of master data (e.g. G/L accounts, customer master, vendor master, material master, bills of material) and transaction data (e.g. financial documents, sales orders)
By means of recording of transactions: further data objects (if the transaction can be run in batch input mode)
Yes. The LSM Workbench works on the principle of central (reusable) rules. This approach guarantees that, for example, the material number is converted in the same way wherever the reusable rule is used for conversion.
LSMW is a tool provided by SAP in order to upload huge amount of data from legacy file to R/3 system. The Legacy System Migration Workbench (LSMW) is a tool to transfer data from legacy systems (Non SAP System) into an R/3 System (SAP System).
LSMW supports a step-by-step procedure; if one step is executed and saved then next step automatically follows.
Apart from creation of project/ subproject/ object and recording, there are 14 basic steps included in LSMW.
Through LSMW one can create Master data, create transactional data, modify existing master data etc. This tool is very useful when some mass changes are to be carried out and no standard SAP transactions are available for that.
There are few standard objects available in LSMW e.g. material master, vendor master, customer master, purchasing info record, purchase requisitions, purchase orders etc. Using these standard objects one can do mass data upload and mass transactions.
Apart from this LSMW provides another functionality of recording the transaction and then carrying that out many times with large data. Examples are mass deletion of purchase requisitions, mass deletion of planned orders etc.
Yes, but:
Export has to be programmed
Source structures have to be defined
Fields of the source structures can be loaded from the dictionary
Mapping has to be done manually è a lot of fields!! Automatic fieldmapping might be used Import of large data amounts can take a lot of time (most of the time data amount is higher than for Migration from legacy systems) History data can not be build up most of the time