Post Re-Count of Physical Inventory Document in SAP S4 Hana Public Cloud via Excel
– By Prathmesh Sutar

The purpose of this blog is to demonstrate how we can post physical inventory recount via excel.
Why Excel?
One of the requirements of the client was to capture the existing physical inventory items for the financial
year end activities, from third party ERP Software into their new SAP S/4 Hana System. This can be done
using SAP HCI (CPI), but this was not the scope.
Previous years records were more than 20,000 items that must be listed into the new S/4 System.
For this scenario we used OData Service from SAP S/4 to perform this task.

1. End to End Process Divided into Sub Parts for Understanding
1.1 Process Flow
1.2 Prerequisites (MUST)
1.3 Flow Chart for Coding
2. OData Service Selection
3. Excel Configuration
4. VBA Script
5. Testing
6. Handover

Read full Document at