Product Information
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.
- Important steps
- Processing
- Output
- 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.
- 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.
- 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
- SAP S/4HANA Finance – New Additions, Features and Functionality
https://blogs.sap.com/2019/03/26/sap-s4-hana-features/
- 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
- LSMW Recording for Transaction Data – FB01
https://blogs.sap.com/2020/06/26/lsmw-for-transaction-data-fb01/
- SAP FICO Data Migration – Global Execution, Planning and Approach
https://blogs.sap.com/2020/06/01/sap-fico-data-migration-global-execution/
- 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
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
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
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.
You can wrap LSMW project with SE38: /SAPDMC/SAP_LSMW_INTERFACE and a variant into a transaction allowing for users only execution steps.
Hi Sergiu
Noted. Thank you for this info
Regards
Zunaid
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.
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.
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
Hi Manikanthan
Yes. increase the number and try to post.
Regards
Zunaid
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
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.