LSMW – Create Vendor Master Data

Part 1:

http://www.youtube.com/watch?feature=player_embedded&v=WryqzGUlEpI

Part 2:

http://www.youtube.com/watch?v=xBynCYbcU9Y&feature=player_embedded

• Go to LSMW tcode
• On “Legacy System Migration Workbench” screen, place cursor on “Project” field and, click “Create Entry” button () 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 ().
• On “LSM Workbench:XXXX” screen, choose “Maintain Object Attributes” radio button, and click “execute” button ().
• On “LSM Workbench – Display Object Attribute” screen, click the “display – change” button (). Click the “Batch Input Recording” radio button and then click “Recordings: Overview” button ().
• On “Recording of Project XXXX: Overview” screen, click “Create Recording” button ().
• 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 ()
• 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 ()
• 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 ()
• 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 ()
• On “Create Vendors: Accounting Information Accounting” screen, fill the relevant fields like on the video above. Click “Enter” button ()
• On “Create Vendors: Payment Transactions Accounting” screen, fill the relevant fields like on the video above. Click “Enter” button ()
• 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 ()
• On “Create Vendors: Purchasing Data” screen, fill the relevant fields like on the video above. Click “Enter” button ()
• 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 ()
• 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 (), then “back” button ().
• On “Recording of Project XXXX: Overview” screen, click “back” button ().
• On “LSM Workbench – Display Object Attribute” screen, fill the “Recording” field with the recording name that we’ve just created. Click “save” button (), then “back” button ().
• On “LSM Workbench:XXXX” screen, choose “Maintain Source Structures” radio button, and click “execute” button ().
• On the “LSM Workbench: Display Source Structure”, click “Display – Change” button (), then click “Create a structure” button (). Fill the “Source Structure” and “Description” fields, and press Enter. Click “save” button (), then “back” button ().
• On “LSM Workbench:XXXX” screen, choose “Maintain Source Fields” radio button, and click “execute” button ().
• On the “LSM Workbench: Display Source Fields”, click “Display – Change” button (). Place the cursor n the source field we created before, then click “Table Maintenance” button ().
• 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 (), then “back” button ().
• On the “LSM Workbench: Change Source Fields”, click “save” button (), then “back” button ().
• On “LSM Workbench:XXXX” screen, choose “Maintain Structure Relations” radio button, and click “execute” button ().
• On the “LSM Workbench: Display Structure Relationships”, click “Display – Change” button ().Click “save” button (), then “back” button ().
• On “LSM Workbench:XXXX” screen, choose “Maintain Field Mapping and Conversion Rules” radio button, and click “execute” button ().
• On the “LSM Workbench: Display Field Mapping and Conversion Rules”, click “Display – Change” button (). 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 (), then “back” button ().
• On “LSM Workbench:XXXX” screen, choose “Specify Files” radio button, and click “execute” button ().
• On the “LSM Workbench: Specify Files (Display)”, click “Display – Change” button (). Place cursor on “On the PC (frontend)” text, and click “Add Entry” button (). 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 (), then “back” button ().
• On “LSM Workbench:XXXX” screen, choose “Assign Files” radio button, and click “execute” button ().
• On the “LSM Workbench: Assign Files (Display)”, click “Display – Change” button ().Click “save” button (), then “back” button ().
• Do the next steps like on the video above.