Skip to Content
Technical Articles
Author's profile photo Roman Gorbenko

Inventory in SAP S/4HANA, SAP EWM, and SAP ATTP. Step-by-step guide

Prerequisites in SAP EWM

P.1.  All transit bins must be empty

All transit bins must be empty before the inventory process start
Move stock (for example from the acceptance area, etc) to a storage area

P.2.  All opened WT must be closed

All opened WT must be closed before the inventory process start
Understand and finish all WTs
/SCWM/MON/ -> Documents -> Warehouse Task – > Open WTs
The result (ideal picture) must be – 0(zero) WTs
P.3. Align EWM/ERP stock
Transaction – /SCWM/ERP_STOCKCHECK
Stock comparison with ERP System with option ‘Display Differences Only’
Understand and fix Differences before the inventory process start
(For example, Inbound/Outbound deliveries not completed, queues was stacked in an SMQ1/SMQ2, etc)
The result (ideal picture) must be – 0 (zero) products

P.4. Determine the employees responsible for the inventory

Check (adjust) roles assignment in EWM for employees responsible for the inventory
Don’t forget about settings in:
/SCWM/PI_USER (Assignment of User to Tolerance Group Posting and Recounting) for working with /SCWM/PI_PROCESS
/SCWM/PI_USER_DIFF  (Assignment of User to Tolerance Group Difference Analyze) for working with /SCWM/DIFF_ANALYZER

P.5. Enter a physical inventory year

Enter a physical inventory year under ‘Settings -> Default Values’ (/SCWM/UI_PI008)
Submit Warehouse number and year in transaction /SCWM/PI_PROCESS

P.6. Optimize Whse Order (INVE) creation

Consider a typical warehouse structure almost all pallets during the inventory process are located in a storage area.
For the counting process employees, typical used Medium and high-level order pickers (something like Jungheinrich 412s with Max Picking Height – 14.3m)
Order pickers driving at the same height is more time economical than moving up and down
So in an ideal picture – 1 WHse Order (INVE) for 1 row in 1 Storage Area
Based on this idea before the inventory process start transform Physical Stock from EWM to Pivot table in MS Excel
Sheet #1 – Excel export from /SCWM/MON – > Stock and Bin -> Physical Stock
Sheet #2 – Pivot table with filters (Storage Bin, Storage Area, Row, Highest-Level HU, etc)
With this file, you can easily print useful paper tips for the employees responsible for the inventory and easily retrieve Storage bins sets for the Inventory process in SAP EWM. Step #1

Step 1. Physical Inventory Document Creation (EWM)

Transaction – /SCWM/PI_CREATE (Physical Inventory Document Creation)
Open Advanced Search.
Fill out
Planned Count Date
Physical Inventory Procedure (for example – AL, Annual Physical Inventory, storage bin specific)
Storage Bins set (for example from Pivot table described in Prerequisites section)
Search bins
Set Flag and Set Block Indicators
Save
Result – WHse Order (INVE) created
Find WHse number(s) in /SCWM/MON -> Physical Inventory -> Physical Inventory Documents

Step 2. Physical Inventory Count (EWM)

Transaction – /SCWM/RFUI
04 Internal Processes -> 01 Inventory Counting -> 02 Inventory Counting Manually
Whse Ordr – WHse Order (INVE) created on Step #1
Confirm storage bin
Possible scenarios (a few examples):
Scenario 1. Integrity confirmation
Scenario 2. Empty HU
Scenario 3. Performing inventory without discrepancies
Scenario 4. Performing inventory with discrepancies
Scenario 5. Finding a new product in the empty bin
Scenario 6. Finding a new product is a not empty bin
Consider Scenario 1 in more detail.
Scan storage bin – scan HU in the storage bin – Enter
F3 (HUCmp) – F11(Save)
Step 3. Physical Inventory Processing (EWM)
Transaction – /SCWM/PI_PROCESS
Search (Filter with WHse Order (INVE) or by Physical Inventory Doc. Number)
Possible options:
  • Recount (New WHse Order (INVE) and Physical Inventory Doc. Number will be created)
  • Delete
  • Post (For Scenarios with finding a new product you must specify packaging)
Save

Step 4. Physical Inventory Difference Analyzer (EWM)

Transaction – /SCWM/DIFF_ANALYZER
Find Difference after Physical Inventory
Filter – Product number, * – also acceptable
Find the difference and Post-it
Save
At this moment:
The difference with +: HU with a product and specified packaging material will be created in the desired bin
The difference with -: Stock will be removed from the warehouse
Integration to ERP(S/4HANA) will be triggered

Step 5. Physical Inventory List (S/4HANA)

Transaction – MI24
Find a Physical Inventory Documents number created after difference posting in EWM (Step 4)
Filter with Plant + Storage Location and Fiscal Year / Count Date

Step 6. Print country-specific forms (S/4HANA)

Transactions – J3RALFINV1, J3RALFINV3, J3RALFINV19

Example for INV-19 form:
With Physical Inventory Documents number from Step 5 print an INV-19 form by the report J3RALFINV19 (related for customer with compliance in Russia)
This report creates and prints the Difference List for Stock (INV-19) form.
This form reflects how the stock figures recorded during physical inventory deviates from the book inventory.
The accountant prints this form in two copies. Separate forms are printed for each storage location.

Step 7. Inventory in SAP ATTP

A current situation for SAP Advanced Track and Trace for Pharmaceuticals Release 2.0 Feature Pack 5 and STTPEW and STTPEC Add-ons
any out of box tools are available.
But these tools are mandatory during inventory.
For example, in your scenario:
After inventory HU (SSCC box) contains XXX SGTINs but in ATTP in this SSCC YYYY SGTINs
You must have at least two custom reports and QR-code scanner:
Report 1 – Scan parent epc (SSCC box / SSCC pallet), SCAN child epc (SSCC box, SGTINs)
Report 2 – Find a difference (ALV report with an opportunity copy difference and create (for example) 552 message on it)

Conclusion

SAP EWM routine task with examples from real life was provided.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.