Here is a trick. Some time ago I found how to load hierarchical structures in LSMW from one file. We need to create a file in a special way so that structure record is repeated. These files are hard to create in legacy system particularly when there are no local developers who support the system. That’s why we prefer to work with flat simple files where one file is a single table. But, let me show you how to load multiple files in SAP LSMW tool with ease.
Couple days ago I was loading payroll wage types into SAP with a standard BUS7023 ManagerExtPayroll object. In the output, there is an IDOC which is stored in T558* tables for payroll migration. IDOC structure is a hierarchy itself, where on the top there is an employee, periods are below, and wage types are on the bottom line.
Loading multiple files in SAP LSMW
To simplify I decided to create three files:
- Wage types
Every other file contains a reference to the previous one. Look what I’ve got.
Let’s define LSMW source structures which are related to each other in a file hierarchy. This hierarchy represents our data files we want to load at once.
Then we need to create source fields for our LSMW source structures.
Remember, our relations in this scenario are one to one. One file from our multiple file list connects to one source structure.
Finally, we need to do the field-based mapping connecting the source and destination fields per data file.
Define the file location for every logical file.
And connect source structures to logical files. We’re done with setting LSMW project to load multiple files in one batch.