Physical Inventory: Processing Store Count Data
Use
After physical inventory is carried out in a store, the results are passed on to the head office in the form of printed lists or as intermediate documents (IDocs).
When intermediate documents are passed on, they are automatically processed in the head office. The following functions are provided:
Features
Transfer of count data in physical inventory documents
The following situations are possible:
This is needed if, for example, you want to send physical inventory documents to the store and convert them to count lists there. In this case, you must assign the results of the count to the head office physical inventory documents. If the document number was not passed on to the head office, the system determines the document on the basis of article numbers or EANs/UPCs.
If the system is unable to find the correct document number, this is recorded in the error log. You can evaluate this error log using the POS monitor. This would be the case, for example, if an article were counted in a store that the central system in the head office has listed as not being available in the store. A physical inventory document must be created subsequently for these items.
You can create the missing physical inventory documents manually or by workflow. If the appropriate settings are made in Customizing, work items are created which you can process to create these missing physical inventory documents.
You use this method if, for example, the store creates count lists from its store retailing system, and therefore does not need document data from the head office. In this case, physical inventory documents can be generated automatically when count data is processed. Document creation can be controlled by the following Customizing settings:
In the POS monitor, you receive an error message for each physical inventory document item for which no corresponding physical inventory document was found.
You can then repeat processing for an IDoc, and thereby create physical inventory documents for all the open items in that IDoc.
The Customizing settings apply to one site. You can overwrite these settings for individual IDocs using a user exit. By doing this, you can have different control settings in two storage locations for a site, for example.
The system can group documents together according to merchandise category and storage bin information from the article master. You can configure the store physical inventory parameters for each store to determine whether documents are grouped together and, if so, how.
The name of the person entering the store physical inventory results can be entered in the header of the physical inventory IDoc. When the store order IDoc is transferred to the inbound interface of the SAP System, this information is adopted in the associated physical inventory document items in the central SAP System.
This information must be passed on to the head office. Any EAN/UPC of your choice can be used. It is then converted to the base unit of measure in the head office.
Since different stock types are taken into consideration for physical inventory, the different stock types should, if possible, be available. If they are not available, the system sets the default to "warehouse."
A batch number must be available for articles that are managed in batches.
The sales value or the sales price must be available for value-only articles. If the sales value is passed onto the head office, the quantity field does not have to be filled. The value or price can be given in a different currency to the local currency of the head office. In inbound processing, this currency is then automatically converted to the local currency.
Data aggregation
A number of different count results can be sent for the one article. Head office then aggregates them at article level. (This may be necessary if an article, for example, is stocked at different locations in the store.)
If value-only articles were broken down into the individual articles assigned to them when physical inventory documents were passed onto the stores, the system aggregates them again when the results are received in the head office.
User exits
The following user exits are provided for the store physical inventory:
You can make settings in Customizing to control the automatic creation of physical inventory documents when count data is processed. The Customizing settings apply to one site. You can override these settings for individual IDocs using a user exit.
(User exit WVFI0001 with component EXIT_SAPLWVFI_001)
You can add customer-specific fields to the IDoc type for physical inventory data in a special segment. A number of these segments can be assigned to each individual item of an IDoc.
If the system recognizes customer-specific segments during inbound processing, a user exit is executed in which you can process the data as you wish.
(User exit WVFI0002 with component EXIT_SAPLWVFI_002)
Error handling
A number of errors can occur; data can be missing, or the results of a count might be sent more than once, for example. When errors occur, the error log is updated. You can evaluate this log via the POS monitor.
When the error has been solved, the user can start processing the results that were sent again. Only those items previously containing errors are then processed.
See also:
POS Interface Monitor.