Start of Content Area

Function documentation Inventory During Opening Hours (PIPE)   Locate the document in its SAP Library structure

Use

You can use this function to request POS transactions from the POS Inbound Processing Engine (PIPE) during physical inventory during opening hours. For more information about PIPE, see also POS Interface.

Prerequisites

If you implement the PIPE and want to execute an inventory during opening hours, then you must have made the following settings in Customizing:

      In Customizing for the Inventory, you have chosen the option Request POS Transactions From PIPE under Enhancement: Control of Store Physical Inventory for the Control of POS Data Determination setting.

      You have defined the RFC destination under PIPE-Specific Communication Settings.

      You have activated the Send Confirmation setting under Control of Aggregated Sales in the POS inbound profile of your store.

      You have made the following settings in PIPE Customizing. For more information, see Preparation of POS Transactions for Online Stock Queriess.

Features

Determination of the POS transactions (sales or returns)

If you implement PIPE, then the system first transfers the POS transaction data to the PIPE, where it is aggregated and then transferred to the SAP ERP system. This has the advantage that is reduces significantly the data volume that is transferred to the SAP ERP system. In the case of a physical inventory during opening hours, the SAP ERP system requests transaction data from PIPE to enable calculation of the book inventory at count time.

During determination of POS transactions for physical inventory of an article, the system also includes the POS transactions of the single articles of this value-only article. Additionally, an inventory for an article that is a component in a sales set also includes the POS transactions of the sales set (provided that closure is executed for the sales set in a logistical run).

Note 

If you use the database tables WSTI_MKPF_INDEX, WSTI_ART_REL and WSTI_POS_EVENT, you must reorganize them regularly using the program R_SRS_PI_DELETE_POS_EVENTS.

Check of Unposted, Relevant POS Transactions in PIPE

When requesting the POS transactions from PIPE, the system checks whether additional POS transactions exist in PIPE that are relevant for the book inventory of the article but have not been posted to the SAP ERP system yet. If such POS transactions do exist, the system cancels the calculation of the book inventory for the affected article and issues a corresponding error message. Once the relevant POS transactions have been posted, you can restart the calculation.

Caution 

The check for unposted POS transactions in PIPE is not complete, as the system only checks if POS transactions exist in the transaction database of PIPE. If there are still POS transactions in the cash system that have not been posted successfully to the transaction database of PIPE, then they are not included in the check.

Customizing: Save Processed POS Transactions

Under General Settings for Inventory During Opening Hours, you can activate the Save Processed POS Transactions. We recommend that you do this as an exception only due to the high volumes of data that result. If you activate this setting, the system saves all POS transactions included in the calculation of the book inventory to the WSTI_POS_EVENT database table. This is helpful if you want to analyze the calculation of the book inventory at a later count time using the R_SRS_PI_CALC_SHOW program. It enables you to identify the POS transactions that have been used already and those that have been posted to PIPE in the meantime. This enables more detailed analysis if an error occurs.

 

 

 

End of Content Area