Data Migration - Step by Step via Standard batch/Direct Input Recording
*Goto T-Code *LSMW and create project, subproject and the object.
On the initial screen, you can create a new project, corresponding subprojects and objects via Edit -> Create new entry.
- Project: An ID with a maximum of 10 characters to name your data transfer project. If you want to transfer data from several legacy systems, you may create a project e.g. for every legacy system.
- Subproject: An ID with a maximum of 10 characters that is used as further structuring attribute.
- Object: An ID with a maximum of 10 characters to name the business object.
*Step 1: Maintain Object attributes In this example, you will be updating the Material master records with the help of recording a transaction (MM01). Choose radio button Batch Input Recording and click
As an alternative to using 'Transaction Recording', you could also use a standard SAP object to update Material Master Records. Business Object '0020' is already pre-defined in the system with standard Batch Input Interface Program 'RMDATIND'.
*Steps 2 and 3 are same as explained in batch input recording.
Step 4: Maintain Structure RelationsYou need to update structure BGR00. However, in addition, the Standard Object '0020' also requires updates to BM00, BMMH1, BMMH2, BMMH3, BMMH4, BMMH5, BMMH6, BMMH7, BMMH8 structures. (If you do not maintain Structure relations for mandatory entries, you might get a message such as 'Target structure needs a relation to a source structure'.) Even though you don't want to update any fields in these structures, you need to create a relationship with source structures.
Create relationship between source structures MM01V4 with these target structures with icon 'Create Relationship' . E.g. click on BM00 and then click on relation tab.
Step 5: Maintain field mapping and conversion rules
Keep your cursor on 'TCODE' field and click on 'Insert Rule' icon.
Choose radio button 'Constant' to enter value 'MM01' transaction code.
Choose source field MATNR, MBRSH, MTART, MEINS, MAKTX and assign source field as shown below by selecting the field and then clicking on the source field tab.
*Steps 6 to step 11 are same as explained in batch input recording.
*Step 12: Display Converted data
When you convert data, LSMW automatically converts into the appropriate structure layouts, as required by Standard program.
Step 13: Create batch input session
Once source data is converted in internal format, you can create a BDC session to process the updates.
Execute to load the data by direct input method.