Create Physical Inventory Documents
Procedure
1. Access the transaction using the following navigation option:
SAP Graphical User Interface (SAP GUI)
| SAP ECC menu |
Logistics → Materials Management → Physical Inventory → Sessions → Create Physical Inventory Documents → Own Special Stock → Consgnmt at Customer |
| Transaction code |
MIW1 |
2. In the
Selected Data for Phys. Inventory Documents Customer Consgmt screen, make the following entries:
| Field Name |
User action and values |
Comment |
| Customer |
Optional entry |
You can restrict the number of Customer. |
| Material |
Optional entry |
Choose from dropdown list. |
| Plant |
|
Choose from dropdown list. |
| Materials marked for deletion |
|
Deselect |
| Select data and Issue Log |
|
Select |
| Issue log |
|
Select |
| Max.No.of Items/Doc |
|
For your disposition. |
| Planned Count Date |
|
Enter the date where the Count will commence. |
| Acc. To Stock |
|
Push Button |
| Stock Types |
|
Leave default |
| Physical Inventory Ref. |
Enter any value to be used to link the documents created by this transaction |
|
On the initial screen, material type and material group may be used to narrow the list of materials.
3. Click
to execute.
4. On the following screen, select the materials to be counted or choose Select all if all materials should be counted.
5. Choose Create documents.
Note down the created document number here: _________________.
Result
The system generates physical inventory documents. Take note of it to be used on the next process.
Print PI Documents
Procedure
1. Access the transaction using the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
| SAP ECC menu |
Logistics → Logistics Execution → Internal Whse Processes → Physical Inventory → In Inventory Management → Physical Inventory Document → Print Warehouse Inventory List |
| Transaction code |
MI21 |
2. On the initial screen, enter the following values:
| Field Name |
User action and values |
| Physical Inventory Document |
Your document number, normally proposed by the system |
| Plant |
|
| Storage location |
This is an optional entry |
| Physical Inventory Ref. |
Enter value created in section 1 |
4. On the Output Device screen, select printer for documents and choose Print Immediately.
Result
The system generates a physical inventory count sheet and the documents are printed.
Execute Inventory Count
Procedure
1. Periodically, a warehouse person executes the physical count (manual activity).
Enter Inventory Count
Before entering the inventory count you can check the stock situation for your material in transaction MMBE.
Procedure
1. Access the transaction using the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
| SAP ECC menu |
Logistics → Logistics Execution → Internal Whse Processes → Physical Inventory → In Inventory Management → Count Results → Enter → Manually |
| Transaction code |
MI04 |
2. On the initial screen, enter the following values and choose
Enter.
| Field Name |
User action and values |
| Physical Inventory Document |
Your document number, normally proposed by the system |
| Fiscal Year |
Current year |
| Count date |
Change if different from today’s date |
3. On the
Enter Inventory Count XXX: Collect.Processing screen, enter the following values:
| Field Name |
User action and values |
| Quantity |
Enter a quantity |
| ZC |
Select only if the count is zero |
If the material is batch managed, the batch is displayed here.
4. If a material is found which is not mentioned on the inventory print list, it can be added as a new line item.
If the material is batch managed, the batch needs to be entered as well.
Result
The counts are entered. The inventory count list is reviewed.
List Count Differences
Procedure
1. Access the transaction using the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
| SAP ECC menu |
Logistics → Logistics Execution → Internal Whse Processes → Physical Inventory → In Inventory Management → Difference → Difference List |
| Transaction code |
MI20 |
2. On the initial screen, enter the following values:
| Field Name |
User action and values |
| Plant |
|
| Physical Inventory Document |
Enter your inventory document number if not already proposed by system |
Result
The system generates a report of count differenced which can be printed if required.
Recount
Use
This step is only necessary if the warehouse manager or controller decides to recount a material.
Procedure
1. Access the transaction using the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
| SAP ECC menu |
Logistics → Logistics Execution → Internal Whse Processes → Physical Inventory → In Inventory Management → Count Results → Recount |
| Transaction code |
MI11 |
2. On the initial screen, enter the following values and choose
Enter:
| Field Name |
User action and values |
| Physical Inventory Document |
Enter your physical inventory document number |
| Planned Count date |
Change if different from original planned count date |
3. Select materials to recount and choose Save.
4. Repeat steps from Printing of PI documents.
Result
A new physical inventory document is created.
Post Differences
Use
Once the count is reviewed by the Warehouse Manager, the Warehouse Monitoring can post the inventory count differences.
Procedure
1. Access the transaction using the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
| SAP ECC menu |
Logistics → Logistics Execution → Internal Whse Processes → Physical Inventory → In Inventory Management → Difference → Difference List |
| Transaction code |
MI20 |
2. On the initial screen, enter the following values:
| Field Name |
User action and values |
| Plant |
|
| Physical Inventory Document |
Enter your Physical Inventory Document number if not yet proposed by system |
4. On the List of Inventory Differences screen, select the relevant document(s) and choose Post Difference.
5. On the following screen choose Save.
Result
- The system generates material document(s), accounting document(s), and controlling document(s).
- Financial Postings
| Posting Key |
Account |
Description |
Note |
| 89 / 99 |
131000 or
135010 or
133000 |
Inventory raw materials
Trading goods
Semi - finished products |
Depending on material type |
| 91 / 81 |
520010 |
Gain / Loss - inventory diffs |
|
Appendix
Reversal of Process Steps
See the Recount section for the reversal handling. Alternatively input errors can be corrected by going through the complete process again.
Design Considerations / Assumptions
Due to the delay between a material movement and the posting of that movement, there is a short - term discrepancy between actual warehouse stock and book inventory. To avoid such a discrepancy during physical inventory, materials can be blocked for posting during the physical inventory. The inventory count and adjustment scenario does not block materials as this step is only necessary if physical counts were to take place during normal operations.
You can set a posting block in the following two ways, if required:
- You block the relevant materials when you enter the physical inventory document. This is recommended if you create the physical inventory document immediately before the count.
- You block the relevant materials later by changing the posted physical inventory document. This is recommended if you do not create the physical inventory document immediately before the count.
The posting block is automatically cancelled when you post the counting results for the physical inventory document.
Business Process ProceduresPreview in PDF