Skip to Content

LSMW for Master Data upload Simple Explanation (Part – 2)

August 12, 2014 | 2,447 Views |
 legacy data migration workbenchlsmw
Follow

This blog is in continuation to my previous blog “LSMW for Master Data upload Simple Explanation (Part – 1)” – LSMW for Master Data upload Simple Explanation (Part – 1)

We will continue here with Step 9 – Specify Files

Step 9 – Specify Files:

Before performing this Step, you need to create your File format with exact field sequence.

For creating the Format, simply transpose your Excel File fields from column to Row as shown below:

/wp-content/uploads/2014/08/33_518233.png

(Here I have mentioned only Single line for data you should have all the data which you wish to create in one time as in screen shot below)

Select only the Data from excel sheet and copy it to notepad file as shown below and Save:

/wp-content/uploads/2014/08/34_518240.png

Now in SAP, double click “Specify Files” in the Menu List screen which will guide you to the screen as shown below:

/wp-content/uploads/2014/08/35_518241.png

Double click on “Legacy Data – On the PC (Frontend)” which will pop-up the dialog box as shown below:

/wp-content/uploads/2014/08/36_518263.png

In File field select the Notepad File created, in the Name Field assign any desired name and make other selections exactly as shown in the screen and Press Enter, Save and Back.

Step 10 – Assign Files:

Double click “Assign Files” in the Menu List screen, which will guide you to the screen as shown below:

/wp-content/uploads/2014/08/37_518276.png

As we have single Structure and Single File, it is auto assigned to Structure. Just Press Save and Back

Step 11 – Read Data:

Double click “Read Data” in the Menu List screen, which will guide you to the screen as shown below:

/wp-content/uploads/2014/08/38_518277.png

Without making any changes to this screen, press execute button which will show the screen as below:

/wp-content/uploads/2014/08/39_518278.png

This will Show the exact number of total records/ Masters which you have mentioned in your notepad file. If this does not match the exact value, check your notepad and excel file for data. Once Confirmed, Press back twice

Step 12 – Display Read Data:


Double click “Display Read Data” in the Menu List screen, will pop-up a dialog box as shown below:

/wp-content/uploads/2014/08/40_518279.png

Without making any changes to this screen press enter, which will show the screen as below:

/wp-content/uploads/2014/08/41_518280.png

This screen is displaying all the Master Data Records which are read from your notepad file. Double Clicking any record will show Field-wise Data where you can check the correctness of your data (this step is not mandatory).

Once confirmed press back twice.

Step 13 – Convert Data:


Double click “Convert Data” in the Menu List screen, which will guide you to the screen as shown below:

/wp-content/uploads/2014/08/43_518281.png

Without making any changes to this screen, press execute button which will show the screen as below:

/wp-content/uploads/2014/08/44_518285.png

This will Show the exact number of total records/ Masters which are converted from your notepad file to Structure. If this does not match the exact value, check your notepad and excel file for data. Once Confirmed, Press back twice

Step 12 – Display Convert Data:

Doubleclick “Display Convert Data” in the Menu List screen, will pop-up a dialog box as shown below:

/wp-content/uploads/2014/08/45_518287.png

Without making any changes to this screen press enter, which will show the screen as below:

/wp-content/uploads/2014/08/46_518288.png

This screen is displaying all the Master Data Records which are read from your notepad file. Double Clicking any record will show Field-wise Data where you can check the correctness of your data (this step is not mandatory).

Once confirmed press back twice.

Step 13 – Create Batch Input Session:

Double click “Create Batch Input Session” in the Menu List screen, which will guide you to the screen as shown below:

/wp-content/uploads/2014/08/48_518289.png

Make the selections as per shown in the screen above and press execute. This will guide you to screen as shown below:

/wp-content/uploads/2014/08/49_518290.png

This will display the number of transactions saved for execution. This all fields should be in green. If any record is in red, please check your entries again. If all records are green, press back twice.

Note: For some masters or for recording method Step 13 would show a simple screen where you need to tick “Keep Batch Input Session” and execute.

Step 13 – Create Batch Input Session:

Double click “Run Batch Input Session” in the Menu List screen, which will guide you to the screen as shown below:

/wp-content/uploads/2014/08/50_518297.png

This screen can also be executed through SM35.


Here select the record you want to process and press/wp-content/uploads/2014/08/9_518298.pngwhich will pop-up a dialog box as shown below:

/wp-content/uploads/2014/08/51_518299.png

Processing Mode:

First Option “Process/ foreground” will guide you to each field of each screen of your Master records.

Second option “Display errors only” will process your program in Background but will stop at Errors in any Field of any Screen which you can change.

Third Option “Background” will process your program completely in background and will update the errors at last.

(Recommended to use “Display errors only” option)

Additional Functions

Select the “Extended Log”, “Expert Mode” and “Dynpro Standard Size” options.

Once made the above selections, press process.

Once all the data are uploaded will pop-up a dialog box as shown below:

/wp-content/uploads/2014/08/52_518300.png

Pressing “Session overview” will show the session details and “Exit Batch input” will exit the transaction.


Here it completes the Legacy Data Migration Workbench (LSMW) process.



Hope I have clarified the process very clearly.



(This is the First time I have written a blog. Request you to please post your honorable comments).

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  3. Former Member

    Hi Chintan,

    Nice document and very well explained….

    For the first time I have read LSMW and it really helped….

    Keep up the good work !!!!!!!!!!

    Cheers 🙂

    Rgds,

    SA

    (0) 
  5. Former Member

    Hi,

    This is a perfect document. I am only facing a small problem. I have created an LSMW program following the above guide which perfectly execute in Development but when i transport the same program to Quality i get an error ANZHL not an input field. The task am caring out is to upload leave balance from excel to IT2006. Where am i going wrong?

    Thanks in advance

    (0) 
    1. Chintan Budhbhatti Post author

      Patrick Mitei

      It seems that LSMW is working perfectly fine but, the issue is with your transaction.

      I am not sure what transaction you are using but the field ANZHL (i.e., a Number field) in your transaction is made as display field (that means it is non editable field).

      I would request you to run the transaction manually and see whether the field is editable there or not.

      If it is in display mode in Quality server, LSMW wont be able to update this field and for that, you need to make the configuration changes to allow it to be editable.

      I hope I have cleared your doubt. If not, I would request you to reply with the transaction code for which you are using the LSMW and the screenshot of transaction which you are executing.

      Hope this helps.

      Regards,

      Chin2.

      (0) 
      1. Former Member

        Thanks Chin2 for your quick reply. The transaction which i am using is PA30 since my objective is to upload leave balance from excel. Again, the funny thing is that when i use foreground during the process, table pa2006 is updated even though it gives me an error message in the status bar. The file which i have to upload is very big and when i try to run on Background mode nothing is processed.

        i will appreciate your assistance.

        Thanks in advance.

        (0) 
        1. Chintan Budhbhatti Post author

          Patrick Mitei

          Sorry but am not much aware about the HR related transactions.

          I see that ANZHL is Quota Number in PA30 (if I am correct).

          Are you using this field as your source fields? If yes, does it have any value in your excel?

          If it does not have any value in your excel I would recommend you to remove this field from your field list in step Maintain Source Fields (mentioned in my previous post).

          Hope this helps.

          Regards,

          Chin2.

          (0) 
  6. Former Member

    Hello,

    I would like to get some help on how to update/change some data using LSMW input recording. i would like to update/change the current BEGDA and ENDA in PA2006. Assume the current dates in pa2006 is BEGDA: 01.01.2015 ENDA: 31.01.9999. I would like to change the above to match the data in the excel which is BEGDA: 01.01.2016 and ENDA: 31.01.2016. I am uploading leave balance manually. The excel file has four fields that is PERNR, BEGDA, ENDA, ANZHL.

    (0) 

Leave a Reply