Skip to Content
Product Information
Author's profile photo Zunaid Hingora

LSMW Recording for Transaction Data – FB01

In SAP ECC, LSMW tool is preferred for Master data uploads. For transaction data, most of the time BDC recordings are preferred over LSMW. It’s a belief that FB01 recording in LSMW is not feasible. This is untrue. LSMW can be used for FB01 recording.

In this blog focus will not be on LSMW recording steps. Prime focus will be on significant steps required for FB01 recording.

Pre-requisite: Readers should possess basic LSMW knowledge.

This blog coves below steps.

  1. Important steps
  2. Processing
  3. Output

 

  1. Important steps

Go to LSMW transaction and Create Project. Double click on ‘Maintain Object Attributes’.

Create entries as below. Create your own recording.

Once recording is completed, below screen will be displayed. This is most important part.

NEWBS, NEWKO, WRBTR and KOSTL are repeating in both screen. First screen represent line 1 in document and second screen line 2. We need to make some minor changes in 2 line entries.

Double click on NEWBS and change to NEWBS2. Please see below screenshot. Carry out this activity for KOSTL, WRBTR, NEWKO and change to KOSTL2, WRBTR2, NEWKO2.

Once done, changes should appear as shown in below screen.

Click on Maintain Source structure.

Maintain entry here.

Click on ‘Maintain Source Fields’

In below screenshot, for first line it is NEWBS, NEWKO, WRBTR, KOSTL. For line 2 its NEWBS2, NEWKO2, WRBTR2, KOSTL2. This will help system to identify 1st and 2nd line item from the file. If there are 3 or more lines, enter 3 or next number for above fields and complete recordings.

Click on specify files. Step 4 and 5 are skipped.

Select the file, click on Tabulator and check ‘Field Name at Start of file’. Steps till Display Converted Data are skipped.

File converted successfully.

Create Batch Input Session.

  1. Processing

Click on Run Batch Input session and execute. Select Session FB01.Select foreground mode to see if LSMW picks correct values.

Check below screen. Its picking up.

.Convert this Session to background

Click on Session Overview. Double click on session.

  1. Output

Documents are posted.

Check in FB03.

I hope this document is useful to you.

Any suggestion/mistakes/opinions are welcomed.

Zunaid Hingora

Other Blogs

  1. Why choosing SAP Profile as a career could be best decision for anyone?

https://blogs.sap.com/2021/08/18/why-choosing-sap-profile-as-a-career-could-be-best-decision-for-anyone/

  1. FI – SD Integration – VKOA – Understanding Flow – SAP ECC

https://blogs.sap.com/2020/11/12/fi-sd-integration-understanding-concept-sap-ecc/

  1. IDOC Management – Mass Change – WLF_IDOC, Foreground Processing and other IDOC Activities.

https://blogs.sap.com/2020/08/04/idoc-mass-change-mass-processing-wlf_idoc/

  1. SAP ‘ Z Process Re-Engineering’ – Enhance the productivity of the implemented solution

https://blogs.sap.com/2020/08/03/enhance-the-productivity-of-the-implemented-solution-sap-process-re-engineering./

  1. LSMW Recording for Transaction Data – FB01

https://blogs.sap.com/2020/06/26/lsmw-for-transaction-data-fb01/

  1. SAP FICO Data Migration – Global Execution, Planning and Approach

https://blogs.sap.com/2020/06/01/sap-fico-data-migration-global-execution/

  1. LTMC S/4HANA replacing LSMW – Migration cockpit – Data Migration

https://blogs.sap.com/2020/01/18/ltmc-s-4-hana-replacing-lsmw/

  1. S/4 Hana – House Bank, Bank Account and Account ID Overview

https://blogs.sap.com/2019/10/18/s4-hana-house-bank-bank-account-and-account-id-overview./

  1. AUC Automatic Creation from WBS – S/4 HANA

https://blogs.sap.com/2019/09/27/auc-automatic-creation-from-wbs-s4-hana/

  1. S/4HANA Finance – New vs Old transaction code

https://blogs.sap.com/2019/09/23/sap-hana-new-vs-old-transaction-code./

  1. Profit Center – Assignment/Removal of Company code and Activation

https://blogs.sap.com/2019/07/17/profit-center-assignmentremoval-of-company-code-and-activation/

  1. SAP S/4HANA Finance – New Additions, Features and Functionality

https://blogs.sap.com/2019/03/26/sap-s4-hana-features/

  1. AS91 – Asset Master Upload

https://blogs.sap.com/2019/03/25/as91-asset-master-upload./

  1. Asset Reconciliation Account Posting ABF1L- No OAMK, OASV

https://blogs.sap.com/2019/03/13/asset-reconciliation-account-posting/

  1. Mass Upload Functionality – SAP

https://blogs.sap.com/2019/03/12/mass-upload-functionality-sap/

 

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Marek Turczynski
      Marek Turczynski

      Hi Zunaid ,

      your FB01 LSMW recording is nice and fine but bear in mind that it records the screen numbers. Each posting key triggers a different screen. So for example if you make recording for vendors you cannot reuse it for vendors with special GL indicator because it calls different screen.

      Therefore it is better to use the batch input program RFBIBL00 that by its own chooses the correct screen or BAPI_ACC_DOCUMENT_POST (yes, you can use BAPI in LSMW).

      Regards,

      Marek

       

       

      Author's profile photo Zunaid Hingora
      Zunaid Hingora
      Blog Post Author

      Hi Marek,

      Thank you for your message. I hope you are safe and doing well in this COVID pandemic.

      I agree with you. Purpose of this blog is make community aware of this LSMW feasibility. This can also be adopted for other tcodes like FB50. This blog could be very helpful for last moment uploads or one time upload.

      For fix and regular upload, we often write BDC or use standard LSMW programmes.

      Please keep sharing your inputs and i highly appreciate your above message.

      Regards

      Zunaid

      Author's profile photo Nathan Genez
      Nathan Genez

      100% agree.  I don't know why people continue to use BDC-based solutions when a BAPI is available.  Speed, ease of use, error correction, error management... all of it is easier with a BAPI.

      Author's profile photo Sergiu Iatco
      Sergiu Iatco

      You can wrap LSMW project with SE38: /SAPDMC/SAP_LSMW_INTERFACE and a variant into a transaction allowing to user only execution step.

      Author's profile photo Zunaid Hingora
      Zunaid Hingora
      Blog Post Author

      Hi Sergiu

      Noted. Thank you for this info

      Regards

      Zunaid