Skip to Content
Product Information
Author's profile photo CA 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

LTMC Process LTMC Process SAP S/4HANA – Simple Steps | SAP Blogs
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/
Fiori App List /blogs.sap.com/2021/11/25/fiori-app-list-s-4hana/
FI – SD Integration – VKOA – Understanding Flow – SAP ECC https://blogs.sap.com/2020/11/12/fi-sd-integration-understanding-concept-sap-ecc/
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/
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./
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./
AUC Automatic Creation from WBS – S/4 HANA https://blogs.sap.com/2019/09/27/auc-automatic-creation-from-wbs-s4-hana/
S/4HANA Finance – New vs Old transaction code https://blogs.sap.com/2019/09/23/sap-hana-new-vs-old-transaction-code./
Profit Center – Assignment/Removal of Company code and Activation https://blogs.sap.com/2019/07/17/profit-center-assignmentremoval-of-company-code-and-activation/
AS91 – Asset Master Upload https://blogs.sap.com/2019/03/25/as91-asset-master-upload./
Asset Reconciliation Account Posting ABF1L- No OAMK, OASV https://blogs.sap.com/2019/03/13/asset-reconciliation-account-posting/
Mass Upload Functionality – SAP https://blogs.sap.com/2019/03/12/mass-upload-functionality-sap/
Data Migration Learning https://blogs.sap.com/2021/12/29/data-migration-learnings/
SAP Interface Development Process – Detailed Guide https://blogs.sap.com/2022/01/13/sap-interface-development/
Fiori Apps Learning https://blogs.sap.com/2022/02/22/fiori-apps-learning/
Screen Recordings Screen Recordings, Video Export, GIF, Save as Show using PowerPoint Presentation – SAP Business Scenarios, Training Documents, End user Videos etc. | SAP Blogs
SAP S/4HANA Finance – New Additions, Features and Functionality https://blogs.sap.com/2019/03/26/sap-s4-hana-features/
Automatic Idoc Generation while Creating Purchase Order, Nace Config – Material Management Automatic Idoc Generation while Creating Purchase Order, Nace Config – Material Management | SAP Blogs
Transport of Copies – SAP Transport of Copies – SAP | SAP Blogs
Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision | SAP Blogs
Terms of Payment for Installment – SAP Finance Terms of Payment for Installment – SAP Finance | SAP Blogs
SAP Project Knowledge Transfer Guide/Checklist (KT) SAP Project Knowledge Transfer Guide/Checklist (KT) | SAP Blogs
Vendor Ageing Report Vendor Ageing Report – S_ALR_87012085 SAP FICO
SAP Important Tcodes SAP Important Tcodes – FICO MM SD PM BODS
LSMW Recording for Transaction Data – FB01 LSMW Recording for Transaction Data – FB01
SAP FICO Data Migration – Global Execution, Planning and Approach SAP FICO Data Migration – Global Execution, Planning and Approach
FBZP Configuration template https://blogs.sap.com/2023/08/01/fbzp-configuration-ready-to-use-template-fico-banking/?preview_id=1813070

Assigned Tags

      11 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 CA Zunaid Hingora
      CA 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 for users only execution steps.

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

      Hi Sergiu

      Noted. Thank you for this info

      Regards

      Zunaid

      Author's profile photo Jose Fernando Gutiérrez Rodríguez
      Jose Fernando Gutiérrez Rodríguez

      Hi all,

      Thanks for this information.

      @Marek Turczynski, do you have any documentation for the BAPI_ACC_DOCUMENT_POST in LSMW, please?

      Thank you!

      Regards,

      Jose F.

      Author's profile photo Jose Fernando Gutiérrez Rodríguez
      Jose Fernando Gutiérrez Rodríguez

      Hi all,

      Thanks for this information.

      @@Marek Turczynski, do you have any documentation for the BAPI_ACC_DOCUMENT_POST in LSMW, please?, do you have any documentation about the BAPI_ACC_DOCUMENT_POST in LSMW, please?

      Thank you.

      Regards,

      Jose F.

      Author's profile photo Manikanthan Venkateswaran
      Manikanthan Venkateswaran

      Wonderful Blog Zunaid.

       

      Can we have steps for LSMW creation for an FB01 with multiple line items (more than 2 line items).

       

      Regards

      V Mani

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

      Hi Manikanthan

       

      Yes. increase the number and try to post.

       

      Regards

      Zunaid

      Author's profile photo Manikanthan Venkateswaran
      Manikanthan Venkateswaran

      Thanks for your reply Zunaid.

       

      We can always have BAPI / BDC for the purpose. But if the number of distribution lines are not known (it is dynamic; one JV might have 5 lines and the next one can have 25 lines, in the same feed file).

       

      Regards

      Mani V

       

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

      see as per my experience this kind of documents are very less. mostly we use lsmw for data upload. when we upload, most of time lines are single and the other line is upload account. for documents having more than 2 lines or 3 lines are rare. if it happens i suggest to just do recording instead of gong for bapi and badi. if more than 2 or 3 line or uncertain numbers are recurring than you can use bapi or badi.