LSMW – Create Purchase Requisition (PR)

LSMW (Legacy System Migration Workbench), from its name, is a tool in SAP ERP that allows us to do the migration data from Non-SAP system to SAP system. It’s usually used in the Go-live preparation phase of SAP implementation project to create multiple records of SAP master data or transaction data (such as material master, vendor master , customer master, purchasing document, etc), without entering them one by one.
With LSMW, SAP can read an input file, for example a .txt file, which contains multiple records with some columns, and then convert them into SAP data. Of course, we had to define the format of the input file and the conversion rule first before we run the LSMW tool. The contents of the input file can be the master or transaction data form legacy system that needs to be migrated to SAP system.
LSMW can be used not only for data migration, but it also can be used in the production phase of SAP implementation for various needs, such as to create or update master data or transaction data which are not efficient if we do it one by one. Although SAP has provided “mass change” functionalities such as MM17, MEMASSRQ, MEMASSPO tcodes, with LSMW, we have more flexibility in terms of fields that can be changed.

Simple but Useful Tips for SAP Users

SAP T-code for searching SAP t-code or SAP menu
You can use this t-code to search any SAP t-code or SAP menu: SEARCH_SAP_MENU. With this t-code you can search t-code or menu with specified keyword, such as “customer list” will bring S_ALR_87012179 t-code in the search results.
For more searching functionalities you can visit http://Tcodes.ofSAP.com.

How to close all sap screens quickly?
If you”re opening some sap screens of one sap client, eg. Production client, and you want to close all of them (you don’t bother to save any data on the opened screens), you can do it in two ways.

First, you can access menu: “system->log off” on one of the screen. Then, there will pop up a dialog box that ask whether you want to log off. If you click “Yes”, then all the screens will be closed.

Alternatively, you can close all the screens in the quickest way by typing “/nex” in the t-code box (command field) and press “enter”. There will be no dialog box, all the screens will be closed immediately, but carefull, all the unsaved data or documents on any screens will be lost.

How to create t-code from SQVI query?
Continue reading

SAP Enterprise Structure – A Case Study (part 10): Assign Plant to Company Code

This is the part 10 of the series of articles about SAP Enterprise Structure – A Case Study. Read part 1 here.

Assign Plant to Company Code
For the business scenario we’ve explained before on part 1, we will assign:

  • A001 and A002 plant to ABCD company code
  • E001 plant to EFGH company code.

We assign plant to company code with OX18 t-code or from the following menu path of “SPRO” t-code: IMG – Enterprise Structure – Assignment – Logistics-General – Assign plant to company code. Continue reading

SAP Enterprise Structure – A Case Study (part 9): Define Division

This is the part 9 of the series of articles about SAP Enterprise Structure – A Case Study. Read part 1 here.

Define Division
For the business scenario we will define two divisions:

  • A1 for starter pack product.
  • A2 for handset product.

We define division from the following menu path of “SPRO” t-code: IMG – Enterprise Structure – Definition – Logistics – General – Define, copy, delete, check division. Continue reading

SAP Enterprise Structure – A Case Study (part 8): Define Valuation Level

This is the part 8 of the series of articles about SAP Enterprise Structure – A Case Study. Read part 1 here.

Define Valuation Level
We define valuation level with OX14 t-code or form the following menu path of “SPRO” t-code: IMG – Enterprise Structure – Definition – Logistics – General – Define Valuation Level. Continue reading