This document provides you the step by step procedure to do mass user creation or changes in SAP systems using LSMW.
We do use LSMW – Legacy system Migration Workbench to convert the legacy data as per our requirement in SAP system. Generally Customer, Material master data and Bill of Materials can be migrated.
We are going to see the mass user creation or changes in this document.
Open transaction LSMW. Here we need to create a new project, subproject and object. Click on the “New” Button and create a project with your desired naming convention.
Now execute the created project,
Maintain Object Attributes:
Here we would capture the sample changes in SU01 as a recording.
Execute the first step and Click on “Change”. Go for “Batch Input Recording” and click the “Recording Overview” icon at the right side.
You would need to create a New Recording by giving the suitable name and description,
Next give the transaction code as SU01,
Once you execute, it will take you to the next screen of SU01 to record. Let’s say here my requirement is to create five users (We can create as many as users possible).
I have created one test user thereby recorded the same for further user creations and once I save the creation then the below screen will appear,
Highlighted areas shows that those are the fields which can be changed and to be removed by editing for further inputs.
After removing the fields then following screen appears,
In this example I have removed the default “Last Name” and “SAP ID” fields.
Save the recording and give the name of the recording and save as below,
Maintain Source Structures:
In this step, we will have to create a source structure as below and name as you wish,
Maintain Source Fields:
In this step, we will have to do the table maintenance by clicking the highlighted icon,
Following screen will appear where provide the fields which you need,
As per my requirements, User Name(SAP ID), Last Name are the mandatory fields and this is the place where you will provide whether the field is alphanumerical or Numerical etc.
Length of the field and the description is mandatory.
Once you are done with it, your structure will have the following fields,
Save it and Proceed to next step.
Maintain Structure relations:
In this step just save the settings because already source structure TXTFILE is assigned to Target Structure of our recording SU01_REC.
Maintain Field Mapping and Conversion Rules:
In this step, you will have to click on “Source Field” after selecting the respective field “BNAME” and “LAST”.
You can skip the next field : “Maintain Fixed Values, Translations, User-Defined Routines”.
Before proceeding with this step, we need to keep our legacy information handy. In my case following are the data with respect to user creation,
Save the data in “Notepad” as below,
Get into Change Mode and upload the file from your PC by double clicking on “On the PC (Front End)”.
Make sure that all the necessary settings as per the below screenshots are selected,
Save it and proceed to the next step.
Edit and save it.
All the Data from Notepad will be read in this step,
Here four records are read,
Display Read Data:
Just press enter and save it. In this step all the read data will be shown,
Execute it and view the content and proceed to next step,
Display Converted Data:
Execute it and view the converted content and proceed to next step,
Create Batch Input Session:
Execute and create a batch session,
Run Batch Input Session:
Select the session and Process it,
Make sure that the following settings are enabled and Process it.
It’s Done now. Once the Batch Input session completes then you will have the following screen.
Note : We can use this for any role level changes which are identical for all the roles and also user modifications.
Hope this document could have provided a better insight with respect to LSMW creation.