Standard Batch/Direct Input LSMW for mass update in Material Master
Using Batch input recording LSMW did not succeed because in Material master, materials have multiple views, which varied according to the Production and MRP Types. Hence, the Batch input recording did not work as the Views of material master (such as accounting views) selected while recording was sequentially different for different types of materials.
BDC also have the same issue for material master update as recording in BDC also works same as LSMW.
Solution:
The above issue will be resolved through using LSMW with Standard Batch/Direct Input.
Steps to perform LSMW
For Example, we are updating commercial price 1, 2 & 3 using LSMW
Initial Setup (T-Code: LSMW)
Go to T-Code – LSMW and create project, subproject and the object. On the initial screen, you can create a new project via Edit -> Create new entry.
- Project: An ID (max 10 chars) to name your data transfer project. Create separate projects for different legacy systems if needed.
- Subproject: An ID (max 10 chars) used as a further structuring attribute.
- Object: An ID (max 10 chars) to name the business object.
Step 1: Maintain Object Attributes
In this example, you will update Material master records using the standard SAP object. Instead of 'Transaction Recording', choose the Standard Batch/Direct Input method.
Business Object ‘0020’ is pre-defined in the system with standard Batch Input Interface Program ‘RMDATIND’.
Steps 2 and 3: Create Source Structure and Fields
Define your source structure and list all fields required for input (e.g., Material Number, Plant, Valuation Type, Commercial Prices).
[Image of Source Fields Definition]Step 4: Maintain Structure Relations
You need to update structure BGR02. Additionally, Standard Object ‘0020’ requires updates to BM00 and BMMH1 structures. Even if you don't update fields in these structures, you must create a relationship with your source structure to avoid errors.
Create relationships between source structure and these target structures using the ‘Create Relationship’ icon.
[Image of Structure Relations Screen]Step 5: Maintain Field Mapping and Conversion Rules
- Choose radio button ‘Constant’ to enter value ‘MM02’ for the transaction code field.
- Map source fields (e.g., MATNR, WERKS, BWPRH, BWPH1, VJBWH) to the corresponding target fields by selecting the field and clicking the source field tab.
Subsequent Steps (6-13)
Steps 6 to 12 follow the standard LSMW process (Maintain Fixed Values, Specify Files, Assign Files, Read Data, Display Read Data, Convert Data, Display Converted Data).
Example Scenario:
Materials Code 427, 436, 438, 441 are to be updated. The marked fields (Commercial Prices) will be updated as shown below.
Step 13: Create Batch Input Session
Once source data is converted to internal format, create and run a BDC session to process the updates. Verify that Commercial Prices 1, 2, and 3 have been updated successfully.
Need Expert Implementation?
If you are looking for implementation of LSMW or other data migration tools for your organization, please contact us.
