Use LSMW to Load Files with Multiple Source Structures

  • by Yuval Nir, Managing Director, TLR Tech Ltd.
  • May 15, 2008
Learn how to load sequential files with multiple source structures using the Legacy System Migration Workbench by following an example of uploading journal entries.
Key Concept

When using Legacy System Migration Workbench, you may need to load data with multiple source and target structures. Your source structures may be a set of journal entries in which the fields in the header record are obviously different from the fields in the different line items. You need a method to identify the different types of records in the multiple structure (sequential) file so they are mapped correctly to the target structures. Using the STYPE field enables you to identify the different records in the source file and thus enable correct mapping between the source and target structures.

One of the basic steps in an SAP implementation is data migration. Legacy System Migration Workbench (LSMW) is often the tool of choice for loading legacy data into the SAP system. On occasion you may be required to load data with a master and detail structure — for example, journal entries that are composed of header and line items or asset master data with corresponding transactions.

Assuming that most of you know how to use LSMW, I’ll focus on the key issues required in LSMW setup when loading a file of this type, which I learned through my own experience. I’ll do this by providing an example of loading a journal entry using a sequential input file with the SAP program RFBIBL00.

Yuval Nir

Yuval Nir is managing director of financial systems consulting at TLR Tech Ltd. He has more than 15 years of global financial systems expertise focusing on the SAP Financial and Treasury modules. He holds a bachelor of science degree in economics, a master of science degree in accounting, and a CPA license.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.