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: Continue reading

One-stop SAP Reference & Collaboration: All SAP Transaction Codes (Tcodes) Detail

Have you ever found difficulties in remembering or searching a certain SAP transaction code (tcode)? With so many tcodes available in SAP, I bet you have.

There are more than 100,000 tcodes in SAP. It’s impossible for someone to know them all.

SAP has a tcode to search tcodes based on the text of tcode’s name or menu path. The tcode is ‘SEARCH_SAP_MENU‘. But, the search criteria is not flexible, and the search result is not user-friendly presented. It’s much worse if you forget the ‘SEARCH_SAP_MENU’ tcode’s name itself, or if you don’t have the authorization to run that tcode.

Continue reading

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

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