In SAP ECC and S/4HANA, We can mass post accounting documents from an Excel sheet using transaction LSMW. In this video I demonstrate on SAP S/4HANA how to do this through Batch Input Recording of transaction FB01. I explain the limitations of using this option and the most common errors
-Create LSMW project, subproject and object
- Record the transaction FB70
- What's the Dynpro screen and Dynpro field
- Edit the recording to add and remove fields
- Create Source Structure
- Map Source Structure Fields to Target Structure Fields
- Maintain Conversion Rules
- Create the MS Excel upload template
- Assign the MS Excel file to the LSMW project
- Read the data into the source structure
- Convert the data into the target structure
- Run Batch Input Session
- Confirm the results
#Links:#
Access my SAP S/4HANA Server: www.galalconsulting.com/SAPAccess
Book 1:1 Career Coaching Session: www.galalconsulting.com/posts/coaching
Join KZfaq Channel Membership: / @abdullahgalal
Check my SAP Press Books: www.galalconsulting.com/sapbooks