Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 1 of 6

Physical inventory procedures in EWM

9 min

Listen to this lesson

0:00 / 6:54

Auditors want to know that the inventory on the balance sheet exists. Warehouse managers want to know that the bin the scanner sends a picker to really holds what EWM says. Physical inventory in EWM serves both, and it does so at bin level, not storage location level. This lesson introduces the procedures EWM offers and how Contoso Motor Co. combines them in warehouse 1710.

Two ways to count: by bin or by product

A storage-bin-specific count counts everything in a bin: all products and handling units. A product-specific count counts one product wherever it sits in the selected bins or handling units. Bin-specific counts find stock that should not be there; product-specific counts focus effort on valuable or troublesome products.

When to count: the procedures

ProcedureTriggerContoso use
Periodic (annual)All stock counted on one day or a short window, usually at fiscal year end; movements can be stoppedNot used in Detroit; replaced by cycle counting
Ad hocStarted manually when needed, bin- or product-specificAfter damage or a pick denial
Low stock / zero stockCreated in the background when picking takes a bin below a threshold (zero for zero-stock)Fixed bins in 0020: count when a bin empties
Low stock check without documentCheck during picking with the same threshold; no PI documentNot used
PutawayFirst putaway into a bin in the fiscal year; worker confirms the bin contentHigh-rack 0010
Cycle countingProducts counted at intervals by class (for example A, B, C)All products; A every 20 workdays, B every 60, C every 120
Storage bin checkVerifies a product is in its bin; no quantity count, no documentSpot checks by Marcus
ExternalCounting or sampling done outside EWM; data uploaded and downloadedNot used

EWM physical inventory procedures and Contoso's choices.

Cycle counting uses a cycle counting indicator on the warehouse product (from an ABC classification). Each indicator has an interval in workdays, so fast or valuable products are counted more often. The putaway procedure is cheap: a bin is counted the moment it is first used in the year. Low stock counts are cheaper still: counting an almost empty bin takes seconds.

Cycle counting is driven by the product: its cycle counting indicator sets the interval, and the cycle count run creates documents only when a product is due.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204
Storage bin checkVery low effort; confirms location only, no quantity.
Low stock and putawayLow effort per count; covers bins as they empty or fill.
Ad hocTargeted effort where problems appear.
Cycle and periodic countsPlanned effort that proves coverage of all stock over the year.
Trading counting effort against coverage.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204

Physical inventory areas and completeness

Each warehouse defines one or more physical inventory areas, each assigned to an activity area with a sort sequence. That activity area is the one SAP says every EWM warehouse really needs. The PI area carries settings for the procedures it allows, low-stock thresholds, what the counter sees (for example whether the book quantity is shown), and whether small differences post automatically after counting. SAP advises agreeing display and posting options with your auditor.

EWM tracks completeness. A PI area is complete when all its relevant bins are counted in the fiscal year; a product is complete when all its stock is counted per PI area and party entitled to dispose. Completeness persists through the fiscal year: a bin counted in January still counts in December. That is how continuous procedures can replace a year-end count, provided every bin and product is covered by year end.

Completeness per fiscal year: any posted count marks a bin as counted for the rest of the year, which lets continuous procedures replace the year-end count.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204
  1. JanuaryFiscal year opensCompleteness resets; putaway counts start as bins are first used
  2. MonthlyCycle countsA products every 20 workdays, B every 60, C every 120
  3. DailyLow and zero stock countsFixed bins counted as they empty
  4. NovemberCompleteness reviewMarcus and Dan list uncounted bins and products
  5. DecemberClose the gapsAd hoc or periodic counts for what is still uncounted
How continuous counting adds up to a complete year at Contoso.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204

What goes wrong in testing

SymptomUsual causeCheck before the cycle
Cycle count run finds no products dueCycle counting indicator missing on migrated warehouse productsList warehouse products in 0020 without an indicator
No low-stock documents although bins emptyPI area does not allow the procedure, or threshold not setRead the PI area settings for each activity area in scope
Completeness report shows bins as uncounted after a countCount entered but never postedInclude posting, not just counting, in every PI test
Counts land in the wrong PI areaBins assigned to an activity area that is not linked to a PI areaCheck activity area assignment of every storage type

Physical inventory set-up defects that show up as "nothing happened" in testing.

In SAP S/4HANA Cloud Public Edition, the same EWM physical inventory concepts apply, but configuration is done through the settings the Public Edition exposes and users work in the Fiori apps and the mobile (RF) framework. Check the apps and procedures available in your release before writing test cases.

Key points
  • EWM counts at bin level: storage-bin-specific or product-specific.
  • Procedures: periodic, ad hoc, low/zero stock, putaway, cycle counting, bin check, external.
  • PI areas are built on an activity area and carry thresholds and display and posting settings.
  • Completeness per fiscal year lets continuous counting replace a year-end count.

Check your understanding · not graded

Lesson check

  1. 1. Which count finds stock of a product that is in a bin where it should not be?

  2. 2. What triggers a low stock physical inventory document?

  3. 3. What sets how often a product is cycle counted?

  4. 4. A bin was counted in January. Is it complete for the year in December?