Monday 21 November 2011

LSMW - Create Purchase Requisition (PR)

SAP Study Materials Store
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.

We can use LSMW to do various SAP transactions as it has four object types and import methods, which are:

Standard batch/direct input
Batch input recording
Business Object Method (BAPI)
Intermediate Document (IDOC)


The first two methods can be run without any ABAP programming knowledge, so it can be created by anyone who understand the specific transaction well including the functional analyst, or even end-users. But, the first two methods can be enhanced, if needed, with a simple ABAP logic, because SAP has provided the functionalities. The next two methods needs ABAP programming.

In this example, I will show how to use LSMW to create Purchase Requisition (PR) documents from a set of input files. I will use the Standard batch/direct input method because it requires no ABAP programming, and unlike Batch Input Recording method, it can be used to create multiple records in a purchasing document.

With Batch input recording, which you can think like macro recording in MS office, it’s difficult to create a document with multiple records because there might be different count of the records in each document in the input files, while we must determined it in the recording process when we create the LSMW program.

In this example I will generate LSMW program for creating PR documents which can have multiples items with single account assignment “cost center”.

You can download the screenshots of step by step guide how to use LSMW to create PR documents with multiple items here. You can learn the concept behind it and apply it to your own needs. If you have any comments, opinion, or questions, you can post it in the “comment” section below.

23 comments:

Unknown said...

hi,

where is the file? please provide link to it. Thanks.

thanhtam23 said...

Hi,
Where is the file? I need to create LSMW for create PR with multiple items also.

Unknown said...

The contents of the input file can be the master or transaction data form legacy system that needs to be migrated to SAP system. real estate marketing plan

21cssIndia said...

SAP FI/CO Online Training
SAP - FI/CO (Financial and Controlling) - In Finance - In Logistics - In Purchases - In Sales - Financial Accounting basic settings - General ledger basic settings - Posting the transactions using different applications - Open Item Management - Foreign currency - Bank accounting - Accounts receivable - Accounts payable - Advance configuration steps - Dunning - Bills of Exchange - Interest calculation - Taxes - Asset Accounting - Continution Of Asset Accounting - Controlling - Cost Element Accounting - Cost center Accounting - Internal orders - Profit center Accounting - Profit center wise variance report for B/Sheet a/c's & p&l a/c's - Profitability Analysis - Integration With Mm & Sd - sap fico : sap fico training, sap fico online training, sap fico corporate training,best sap fico training, expert sap fico training, best sap fico online training, expert sap fico online training
http://www.21cssindia.com/courses/sap-fi-co-online-training-40.html

21cssIndia said...

SAP FI/CO Online Training
www.21cssindia.com/courses/sap-fi-co-online-training-40.html
SAP FI/CO Online Training, SAP FI/CO training, SAP FI/CO course contents, SAP FI/CO, SAP FI/CO enquiry, SAP FI/CO online training institute, SAP FI/CO ...

21cssIndia said...

Plant Maintenance SAP Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/plant-maintenance-sap-online-training-132.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit: http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - contact@21cssindia.com

Unknown said...

Thanks for Information SAP FICO Online Training

simashree said...

Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP FICO.
http://thecreatingexperts.com/sap-fico-training-in-chennai/

Unknown said...

various sap training institute gives best online training with affordable fees in India

sap fico training in Hyderabad | India

Unknown said...

Thanks for good information about SAP FICO Online Training. It was so nice article and useful to SAP learners. We also provide all SAP Courses online training our Hyderabadsys Online Training is leader in providing Software Training SAP FICO Online Training

suresh666 said...

these articles are very inspiring to all those who want learn sap fico and become sap fico professionals.thank you for offering such wonderful articles on with clear explanation

sap fico online training

sap fico online training in hyderabad

Unknown said...

To get the best training with hands on real-time projects for SAP FICO take a glance at http://thecreatingexperts.com/sap-fico-training-in-chennai/

Saranya Rajendran said...

Training with hands on real-time projects for SAP FICO

Take a glance at http://thecreatingexperts.com/sap-fico-training-in-chennai/

THE CREATING EXPERTS is one of the best place to schedule your career.

Anonymous said...

If you are looking for information regarding SAP FICO then take a look at this link which would be more helpful for deciding your career

http://thecreatingexperts.com/sap-fico-training-in-chennai/

contact +91-08122241286

Anonymous said...

Thanks for providing such a great post...

To get the best training with hands on real-time projects for SAP FICO take a glance at

http://thecreatingexperts.com/sap-fico-training-in-chennai/

contact +91-08122241286

Unknown said...

Hey nice blog...One of the leading trainers in Chennai THE CREATING EXPERTS is providing training for professional courses in SAP if you are looking for SAP FICO here is the link

http://thecreatingexperts.com/sap-fico-training-in-chennai/

contact +91-08122241286

Ayam Sate said...

Tehknik Jitu Memenangkan Permainan Sabung Ayam Online Klik Di Sini

Informasi Terlengkap Mengenai Sabung Ayam

http://bvayamsate.blogspot.com/2018/09/ciri-sabung-ayam-bangkok-memiliki.html/

Video Teraveloka said...

Permainan judi ini tentu sangat membuat kamu semua sebagai salah pemain judi online, akan merasa nyaman dan aman di dalam mengakses dan memainkan permainan judi ini menggunakan smartphone pribadi. Dan tentunya juga kamu akan bisa mainkan di (Baca Selengkapnya...)

jonet said...

I have bookmarked your website, idnlive the articles are route superior to anything other comparative web journals...a debt of gratitude is in order for an awesome site!

svrtechnologies said...

thanks for sharing such an informative stuff..

Sap Fico Training

Sudharshan said...


It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
http://chennaitraining.in/sap-fico-training-in-chennai/
http://chennaitraining.in/sap-fscm-training-in-chennai/
http://chennaitraining.in/sap-grc-training-in-chennai/
http://chennaitraining.in/sap-hana-training-in-chennai/
http://chennaitraining.in/sap-hcm-training-in-chennai/
http://chennaitraining.in/sap-hr-training-in-chennai/
http://chennaitraining.in/sap-le-training-in-chennai/
http://chennaitraining.in/sap-mii-training-in-chennai/

IICT said...

Great blog Post Loved it...
SAP FICO Training in Chennai

zianab zyada said...


شركة تنظيف بالمدينة المنورة
شركة تنظيف خزانات بالمدينة المنورة
شركة نقل عفش بالمدينة المنورة
شركة مكافحة الحمام بالمدينة المنورة
شركة مكافحة حشرات بالمدينة المنورة
شركة عزل اسطح بالمدينة المنورة
شركة جلي رخام بالمدينة المنورة

Post a Comment