Use

This activity is performed to create physical inventory documents collectively on per plant - per storage location - per stock type technique. The facility mimics the functionality of SAP standard transaction code MI01 - Creating Physical Inventory Documents. The resulting PIDs will be automatically exported into an excel file template that will serve as the count sheets.

Procedure

1. Access the transaction using the following navigation option:

Transaction code

ZMM060

2. On the Create Phys. Inv. Documents (Collective) initial screen, make the following entries:

Field Name	User action and values	Comment
Document Date	Required.	The document date is the date on which the original document was issued.
Planned Count Date	Required.	Indicates the date on which the physical inventory count is to take place.
Location of Physical Inventory
Plant	Required.	Key uniquely identifying a plant.
Storage Location	Required.	Number of the storage location at which the material is stored. A plant may contain one or more storage locations.
Limit Batch Count to	300.	Maximum number of line items to be generated after creation PIDs.
Other Information
Posting Block	Tick Box - Check	Indicates that no goods movements involving the materials listed in the physical inventory document can be posted for the duration of a physical inventory count.
Batches w. del. Flag	Check Box.	Select if you want to include batches with deletion flag indicator.
Selected Materials Only	Optional.	Fill this parameter if you want to generate PIDs for a specific material(s) only.
Stock Types
Unrestricted Use	Option Button.	Indicates that the unrestricted - use stock is affected by the transaction. Select this option to generate PID for this stock type.
In Quality Inspection	Option Button.	Indicates that the stocks in - quality inspection is affected by the transaction. Select this option to generate PID for this stock type.
Blocked	Option Button.	Indicates that the blocked stock is affected by the transaction. Select this option to generate PID for this stock type.

3. Click the Execute button or press F8. The program will attempt to create physical inventory documents for all of the materials maintained in the input storage location of the input plant. The generated PIDs will be then extracted into an excel file templates.

4. A system message will appear informing the user that the excel file templates were succesfully saved. The template file location will be displayed on the next screen after execution.

5. Further details will be displayed like logs summary, number of encounted errors and template file location as well as the date and time of extraction.

6. Click the Back icon to go back on the previous screen.

Result

Enter Physical Inventory Count on the count sheet (Excel Template)

1. Navigate to the template file location of your extracted templates.

2. Open the excel file template to enter the physical inventory count on the selected PID.

If you did not specify the unit of entry, the system will then assume and take the default base unit of measure of the material.

3. Press Ctrl + S to save the file.

Result