Use LSMW to Load Files with Multiple Source Structures

by Yuval Nir, Managing Director, TLR Tech Ltd.

Learn how to load sequential files with multiple source structures using the Legacy System Migration Workbench by following an example of uploading journal entries.

Categories: Accounts Receivable/Accounts Payable, Financials, Tax, Tools

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.

Would you like to see the full version of this article?

If you are an electronic license holder to Financials Expert, please click here to log in.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the Financials Expert online knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team.

Isn't your SAP implementation worth world-class information support?

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@financialsexpertonline.com.
Financials Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.