Video: LSMW Recording – Create Vendor Master Data




On previous post, I have explained how to create SAP LSMW program with Standard batch/direct input method to create Purchase Requisition (PR) document with multiple items. In this post, I will show you how to create LSMW program with recording method in videos training. You can see the videos and the explanation of step by step guide how to create LSMW program with recording method for creating vendor master data (XK01) as follow:

The above video is © SAP AG 2011. All rights reserved

 


The above video is © SAP AG 2011. All rights reserved

 

  • Go to LSMW tcode
  • On “Legacy System Migration Workbench” screen, place cursor on “Project” field and, click “Create Entry” button (Create Entry) to create a new project, sub project, and object if you haven’t had one yet.
  • Fill the project/sub project/object and its description fields.
  • Click the “execute” button (Execute).
  • On “LSM Workbench:XXXX” screen, choose “Maintain Object Attributes” radio button, and click “execute” button (Execute).
  • On “LSM Workbench – Display Object Attribute” screen, click the “display – change” button (Display - Change). Click the “Batch Input Recording” radio button and then click “Recordings: Overview” button (Overview).
  • On “Recording of Project XXXX: Overview” screen, click “Create Recording” button (Create Recording).
  • On “Create Recording” pop up window, fill the “Recording” and “Description” fields, and press Enter.
  • On “Transaction Code” pop up window, fill the “Transaction Code” with “XK01”, and press Enter. This will bring you to the Create Vendor transaction (XK01).
  • On “Create Vendor: Initial Screen” screen, fill the “Company Code”, “Purchasing Organization”, and “Account Group” fields. In this example, we only fill those fields. Then click “Enter” button (Enter)
  • Note: All fields that we fill on the LSMW recording screen will be the input parameters and can be the input fields on the template file.
  • On “Create Vendors: Address” screen, fill the relevant fields like on the video above. Click “Enter” button (Enter)
  • On “Create Vendors: Control” screen, fill the relevant fields. In this example we don’t fill any fields, but if you need to fill some of them, go ahead, those fields will be input parameters of your LSMW recording program. Click “Enter” button (Enter)
  • On “Create Vendors: Payment Transactions” screen, fill the relevant fields. In this example we don’t fill any fields, but if you need to fill some of them, go ahead, those fields will be input parameters of your LSMW recording program. Click “Enter” button (Enter)
  • On “Create Vendors: Accounting Information Accounting” screen, fill the relevant fields like on the video above. Click “Enter” button (Enter)
  • On “Create Vendors: Payment Transactions Accounting” screen, fill the relevant fields like on the video above. Click “Enter” button (Enter)
  • On “Create Vendors: Corresponding Accounting” screen, fill the relevant fields. In this example we don’t fill any fields, but if you need to fill some of them, go ahead, those fields will be input parameters of your LSMW recording program. Click “Enter” button (Enter)
  • On “Create Vendors: Purchasing Data” screen, fill the relevant fields like on the video above. Click “Enter” button (Enter)
  • On “Create Vendors: Partner Functions” screen, fill the relevant fields. In this example we don’t fill any fields, but if you need to fill some of them, go ahead, those fields will be input parameters of your LSMW recording program. Click “Enter” button (Enter)
  • On “Last data screen reached” pop up window, click “Yes” button to save the vendor master data we’ve just created.
  • On “Create Recording” screen, click “Default All” button to assign the input parameter field name with the corresponding field name in SAP table.
  • Press “Ctrl+Y” on the keyboard to change the cursor to selection tool. Select the field name and field description, press “Ctrl+C” on the keyboard to copy the selected text. Paste it to a spreadsheet file. Scroll down and do the same step for other fields. Edit the spreadsheet like the above video. We will use the text on the spreadsheet on the next step.
  • Back to SAP screen. On “Create Recording”, click “save” button (Save), then “back” button (Back).
  • On “Recording of Project XXXX: Overview” screen, click “back” button (Back).
  • On “LSM Workbench – Display Object Attribute” screen, fill the “Recording” field with the recording name that we’ve just created. Click “save” button (Save), then “back” button (Back).
  • On “LSM Workbench:XXXX” screen, choose “Maintain Source Structures” radio button, and click “execute” button (Execute).
  • On the “LSM Workbench: Display Source Structure”, click “Display – Change” button (Display - Change), then click “Create a structure” button (Create). Fill the “Source Structure” and “Description” fields, and press Enter. Click “save” button (Save), then “back” button (Back).
  • On “LSM Workbench:XXXX” screen, choose “Maintain Source Fields” radio button, and click “execute” button (Execute).
  • On the “LSM Workbench: Display Source Fields”, click “Display – Change” button (Display - Change). Place the cursor n the source field we created before, then click “Table Maintenance” button (Table Maintenance).
  • Go to the spreadsheet that we created before and insert two columns like on the video above. Copy the text and go to SAP screen.
  • On “Source Fields for Source Structure XXXX” screen, paste the text from the spreadsheet. Click “save” button (Save), then “back” button (Back).
  • On the “LSM Workbench: Change Source Fields”, click “save” button (Save), then “back” button (Back).
  • On “LSM Workbench:XXXX” screen, choose “Maintain Structure Relations” radio button, and click “execute” button (Execute).
  • On the “LSM Workbench: Display Structure Relationships”, click “Display – Change” button (Display - Change).Click “save” button (Save), then “back” button (Back).
  • On “LSM Workbench:XXXX” screen, choose “Maintain Field Mapping and Conversion Rules” radio button, and click “execute” button (Execute).
  • On the “LSM Workbench: Display Field Mapping and Conversion Rules”, click “Display – Change” button (Display - Change). Go to “Extra – Auto-Field Mapping” menu. On the “Auto-Field Mapping: Settings” pop up window, choose “Edit All Target Fields”, “Only Edit Initial Target Fields”, “Match Fields with the Same Name”, “Only Apply Rule ‘Transfer (Move)’”, “No Confirmation” radio buttons. Click “save” button (Save), then “back” button (Back).
  • On “LSM Workbench:XXXX” screen, choose “Specify Files” radio button, and click “execute” button (execute).
  • On the “LSM Workbench: Specify Files (Display)”, click “Display – Change” button (Display - Change). Place cursor on “On the PC (frontend)” text, and click “Add Entry” button (Add Entry). Browse to a .txt file that you will use as the template. If you haven’t had one yet, create a new one first.
  • On “File on Front End: Maintain Properties” pop up window, “Delimiter” section, choose “Tabulator” radio button. Press Enter. Click “save” button (Save), then “back” button (Back).
  • On “LSM Workbench:XXXX” screen, choose “Assign Files” radio button, and click “execute” button (Execute).
  • On the “LSM Workbench: Assign Files (Display)”, click “Display – Change” button (Display - Change).Click “save” button (Display - Change), then “back” button (Back).
  • Do the next steps like on the video above.

3 thoughts on “Video: LSMW Recording – Create Vendor Master Data

  1. When I try to process the foreground batch session, it asks for OK code for each and every screen. When I click the check box and it goes to next screen and ask s for OK code again. Please help….

Leave a Reply to Anonymous Cancel reply

Your email address will not be published. Required fields are marked *