Kontakt

Ansicht
Dokumentation

/SCWM/ERP_STOCKCHECK - Stock Comparison with ERP System

/SCWM/ERP_STOCKCHECK - Stock Comparison with ERP System

BAL_S_LOG - Application Log: Log header data   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You can use this report to check and compare the stock data between Extended Warehouse Management (EWM) and Inventory Management. If you are using decentralized EWM based on SAP S/4HANA, you can use this report to check and compare the stock data between EWM and the connected enterprise management system, for example SAP S/4HANA or SAP ERP.

If the stock data is different in EWM and Inventory Management, the system considers the stock data in EWM to be correct.

If communication between EWM and Inventory Management uses qRFC, you can use the report to display the stock difference between Inventory Management and EWM caused by the stock that is stuck in queues. Note that the stock can be stuck in the error queues or in the in-process queues.

Integration

Prerequisites

In Inventory Management, you have mapped the plant or storage location to the warehouse number in Customizing.

Features

  • The report performs stock comparison and displays the stock information from EWM and Inventory Management, and the quantity difference between both components. The report performs the following steps:
  1. Reads the stock data from EWM.
  2. Determines the target system, and plant and storage location.
  3. Reads the stock data from Inventory Management for all determined plant or storage location combinations.
Based on this information, the report then calculates the difference between the stock data in EWM and Inventory Management.
  • The report performs the stock comparison and displays a status to indicate whether a stock correction is possible for the stock difference. The following statuses are available:
  • Green

No stock difference and no stock correction required
  • Yellow

A stock difference exists, and stock correction is possible
  • Red

A stock difference exists, but stock correction is not possible. The system displays this status for the following reasons:
>The settings for unit of measure are different in Inventory Management and EWM.
> You are using decentralized EWM and have selected the field Check Full GR Sent,but in the Customizing activity Set Control Parameters for ERP Version Control one of the following goods receipt modes is specified:
,,- Only Send Full GR at End of Putaway Process
,,- Send Full GR When GR Has Been Posted for All Items
However, in EWM, there are inbound deliveries that do not send full GR.
>You have selected Calculate Quantity in Queues, and there is stock that is stuck in the in-process queue or in the error queue.
Note that you must resolve the errors before you perform the stock correction.
  • The system includes the following checks for IDocs or messages stuck in queues:
  • Checks the outbound queues or IDocs in EWM

  • Checks the inbound queues or IDocs in the other SAP S/4HANA components

Note that for a specific party entitled to dispose, if any message is stuck in the queue or the IDoc has failed, the report does not perform the stock comparison for the party entitled to dispose.
  • The report can be used to calculate and display the stock quantity that is stuck in stock movement queues.
Note that Consider Queues or IDoc must be selected before you can choose this option.
The stock that is stuck in the stock movement queues has an impact on the stock difference between Inventory Management and EWM. The system checks the stock that is stuck in the inbound stock movement queues in the other SAP S/4HANA components. However, the system skips the stock comparison if any stock is stuck in the outbound stock movement queues of EWM.
If communication between Inventory Management and EWM occurs through IDocs, the report checks if there are any IDocs that are in-process or that have failed. If there are no IDocs in these states, the system performs the stock comparison but does not calculate the quantity information.
To display queues that affect the stock, select the stock line, and from the Stockdropdown list select Display Queues. The system displays all the queues related to this stock. The system also displays queue information and the quantity that is stuck in these queues.
You can also show the data container of the unprocessed queues. Choose Data Containerin the toolbar of the queue screen. The system navigates to the other SAP S/4HANA components to show the queue container.
The system displays the following information based on the overall status of the stock quantity in the stock movement queue:
  • Red: Stock in Error Queue

The queue is in the SYSFAIL status or NOEXEC status. You must contact your system administrator to fix this error.
Note that if there is a difference between the stock quantities in Inventory Management and EWM, the system cannot perform stock correction since the queue is in an error status. The calculated quantity is displayed for stock in an error queue.
  • Gray: Stock only in In-Process Queues

The queue is in the RUNNINGstatus or READYstatus. The status indicates that the system is currently processing the queue and the stock movement will be processed in a short period of time. You can refresh the queue to get the updated status. However, if this status is displayed for a long period of time, you can contact your system administrator. Note that if there is a difference between the stock quantities in Inventory Management and EWM, the stock correction can't be performed in this status. The calculated quantity is displayed for stock in an in-process queue.
  • Green: No Stock in queue

No quantity is displayed for error queues or in-process queues.
  • Empty

EWM and Inventory Management communicate by IDocs and no IDoc is in the in-process or error status.
Note that the quantity is displayed for both units of measure for a catch weight product.
  • The report can be used to compare the stock quantity in EWM and Inventory Management beyond the third decimal place (rounding residual).
Note that Consider Queues or IDoc must be selected before you can choose this option.
If the stock quantity is different after the third decimal place, Rounding Residual is flagged for the entry, and the report displays all decimal places for the difference in a separate difference quantity field, Rounding Residual Quantity.
You can post the rounding residual quantity to the difference analyzer by choosing Correct Stock for the entry.
  • You can correct the stock data in Inventory Management by choosing Correct Stock after you run the report.
The report corrects the stock quantity in Inventory Management according to the stock quantity in EWM by posting a goods movement in Inventory Management only. In EWM embedded in SAP S/4HANA, the goods movement is done synchronously. In decentralized EWM, the goods movement can be done either synchronously by using RFC or asynchronously by using IDocs.
This can be set up in Customizing for Extended Warehouse Managementunder Interfaces -> ERP Integration-> ERP Integration for Decentralized EWM-> Set Control Parameters for ERP Version Control.
Note: You cannot run the correction for more than 400 differences at the same time because the maximum number of the material document items in Inventory Management is set to 400.
The correction is possible only for differences with the status Posting Possible.
If you do not select Calculate Quantity in Queues, the system can perform checks in real time during correction to check if the unprocessed queue or IDocs exist in the sending system or target system. If you select Calculate Quantity in Queues, the system checks if the selected stock is affected by the unprocessed queue in the system.

Note

  • You can use Business Add-In Enhancement of the ERP Goods Movement Interface(/SCWM/EX_ERP_GOODSMVT_EXT) to make changes and enhancements to the goods movements that EWM reports to Inventory Management.
  • The report does not calculate or display the serial number differences for products between EWM and Inventory Management.
  • The report does not set or check locks for the database. We recommend that you do not execute the report while warehouse activity is performed because the stock information displayed can change for the following reasons:
  • Stock data can change when information is transferred from EWM and Inventory Management.

  • Stock movement queues or IDOC queues could have been processed or reprocessed.

You must refresh the output list in order to get the updated view.

Selection

You must enter the warehouse number. We recommend that you enter a product and a party entitled to dispose to improve performance.

Output

When the report executes a change in the stock data in Inventory Management, EWM displays the material document from Inventory Management in the log.

Activities

Example






rdisp/max_wprun_time - Maximum work process run time   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 11561 Date: 20240425 Time: 160409     sap01-206 ( 173 ms )