Akila Wedasinghe
What are you looking for?
SAP Inventory Management Process
A comprehensive visual guide to understanding inventory processes, physical inventory checks, and cycle counting in SAP
Inventory Management in SAP
Inventory management in SAP allows organizations to efficiently track and control materials at different levels of detail.
Material Storage Hierarchy
Materials are stored and managed at different organizational levels:
- Plant: Highest organizational level for inventory
- Storage Location: Physical or logical areas within a plant
- Bin: (In WM/EWM) Specific locations within storage locations
Stock Types
Different categories of stock that can be managed:
- Unrestricted Use: Available for normal consumption
- Quality Inspection: Pending quality check
- Blocked Stock: Not available for use
- Special Stocks: Consignment, subcontracting, project stock, etc.
Key Functions
Operations supported in SAP inventory management:
- Goods Receipts: Entering materials into inventory
- Goods Issues: Removing materials from inventory
- Stock Transfers: Moving materials between locations
- Physical Inventory: Verifying actual stock against system records
- Batch Management: Tracking specific material batches
Why Inventory Management Matters
Effective inventory management helps organizations:
- Maintain accurate financial statements
- Reduce carrying costs and optimize inventory levels
- Improve customer service by ensuring product availability
- Support production planning and scheduling
- Comply with regulatory requirements
Physical Inventory Process
Physical inventory is the process of counting actual stock and reconciling it with system records. It helps identify and correct discrepancies between book inventory and actual inventory.
Why Perform Physical Inventory?
Physical inventory counts are necessary because discrepancies occur due to:
- Goods movements not properly recorded in the system
- Material losses, damage, or theft
- Incorrect consumption reporting
- Using the wrong material but posting a different one
Types of Physical Inventory Checks
Periodic Inventory
Comprehensive count of all inventory items at specific intervals, typically yearly or quarterly.
- Most common approach
- Usually requires operations to stop temporarily
- Thorough verification of all stocks
Continuous Inventory
Ongoing process where different sections of inventory are counted on a rolling schedule.
- Spreads counting workload throughout the year
- Different locations or material categories counted at different times
- Doesn't require operational shutdown
Cycle Inventory
Focused counting based on material characteristics, with different frequencies for different categories.
- High-value/high-movement items counted more frequently
- Low-value/low-movement items counted less frequently
- Often uses ABC classification system
Physical Inventory Process in SAP
Create Physical Inventory Document MI01
Define the scope of the physical inventory by specifying:
- Plant and storage location
- Materials to be counted
- Stock types to be verified
- Document date and planned count date
Perform Physical Count MI04
Count the actual materials in the warehouse and enter the results:
- Enter counted quantities for each material
- System can warn if variance exceeds defined threshold
- Option to request recount for suspicious variances
Post Inventory Differences MI07
Finalize the process by updating the system with actual quantities:
- System creates a material document for the difference
- Financial document is created to adjust inventory value
- Inventory is updated to reflect actual counts
Alternative Transaction Approaches
SAP offers several ways to streamline the physical inventory process:
- MI08: Combine counting and difference posting in one step
- MI09: Count without reference to a pre-created document
- MI10: Create document, count, and post differences all in one step
- MI11: Request a recount when results are suspicious
Cycle Counting Configuration
Cycle counting is an inventory management technique where a small subset of inventory is counted on a specified day. Items are counted at different frequencies based on value, usage, or other criteria.
Class A Items
High value/usage
Count monthly
(12 counts/year)
Class B Items
Medium value/usage
Count quarterly
(4 counts/year)
Class C Items
Low value/usage
Count yearly
(1 count/year)
Setting Up Cycle Counting in SAP
Configure Cycle Counting Parameters
In SAP IMG (Implementation Guide):
- Materials Management > Inventory Management > Physical Inventory > Physical Inventory > Cycle Counting
- Define inventory indicators (A, B, C) for each plant
- Set up number of counts per year (12, 4, 1)
- Specify percentage distribution (e.g., 50%, 30%, 20%)
- Set float time for each indicator
Assign Inventory Indicators to Materials
Two approaches for assigning indicators:
- Manual assignment: Directly set in material master record
- Automatic assignment: Run program to assign based on consumption data
- Use CC Fixed flag to prevent automatic overwriting of manual assignments
Schedule Batch Job for Document Creation
Set up recurring batch jobs for automatic document creation:
- Use transaction MICN to create physical inventory documents
- Use transaction MIBC to calculate indicators and update material master
- Schedule jobs to run at appropriate intervals
Process the Generated Documents
Handle the automatically created physical inventory documents:
- View documents using transaction MI21
- Proceed with counting and posting using standard process
- Monitor cycle count completion using reports
Example Cycle Count Configuration
| Indicator | Plant | Counts/Year | Percentage | Float Time | Description |
|---|---|---|---|---|---|
| A | SG05 | 12 | 50% | 5 days | High-value items (monthly counts) |
| B | SG05 | 4 | 30% | 10 days | Medium-value items (quarterly counts) |
| C | SG05 | 1 | 20% | 20 days | Low-value items (yearly counts) |
Important Considerations
- Ensure adequate resources are available for counting according to the schedule
- Regularly review classification to ensure materials are in appropriate categories
- Monitor completion rates to ensure cycle counts are being performed as scheduled
- Consider business seasonality when scheduling cycle counts
SAP Inventory Management Transaction Codes
Physical Inventory Transaction Codes
| Transaction Code | Description | Process Step |
|---|---|---|
| MI01 | Create Physical Inventory Document | Step 1 |
| MI02 | Change Physical Inventory Document | Step 1 |
| MI03 | Display Physical Inventory Document | Step 1 |
| MI04 | Enter Physical Inventory Count | Step 2 |
| MI05 | Change Physical Inventory Count | Step 2 |
| MI06 | Display Physical Inventory Count | Step 2 |
| MI07 | Post Physical Inventory Differences | Step 3 |
| MI08 | Enter Count and Post Differences | Steps 2+3 |
| MI09 | Enter Count Without Document Reference | Skip Step 1 |
| MI10 | Create Document, Count, and Post Differences | All Steps |
| MI11 | Enter Recount | After Step 2 |
| MI21 | Display Physical Inventory Documents | Reporting |
Cycle Counting Transaction Codes
| Transaction Code | Description | Purpose |
|---|---|---|
| MIBC | Calculate Cycle Counting Indicators | Updates material master with inventory indicators |
| MICN | Create Physical Inventory Documents for Cycle Counting | Creates documents based on indicator assignments |
General Inventory Management Transaction Codes
| Transaction Code | Description | Category |
|---|---|---|
| MIGO | Goods Movement | General |
| MB1C | Enter Other Goods Receipts | Goods Receipt |
| MB1A | Enter Goods Issue | Goods Issue |
| MB1B | Enter Transfer Posting | Stock Transfer |
| MMBE | Stock Overview | Reporting |
| MB52 | List of Warehouse Stocks | Reporting |
| MB51 | Material Document List | Reporting |
Movement Types Reference
Key movement types used in inventory transactions:
- 101: Goods Receipt for Purchase Order
- 102: Goods Receipt for Production Order
- 201: Goods Issue for Cost Center
- 261: Goods Issue for Production Order
- 301: Plant to Plant Transfer
- 311: Storage Location to Storage Location Transfer
- 321/322: Stock Type Transfer (Unrestricted ↔ Quality)
- 701: Physical Inventory Difference Posting