How to Upload Project Stock from EWM with External Amount in Local Currency

Deployment- EWM in S/4 HANA 2021 via Initial Stock Upload ( /SCWM/ISU).

From EWM S/4 HANA 2021 OP both for Embedded & Decentralized Version, Stock upload provides field for Local Currency to upload stock with Moving average price and Standard Price.

This functionality is not available in the EWM standard until S/4HANA 2021 release. Before that, the EWM standard design did not foresee any price management. Every stock posting from EWM had to be done based on the existing price data on S/4 side.Customer are asked to use BAdI /SCWM/EX_ERP_GOODSMVT_EXT to update the price-related fields AMOUNT_LC and AMOUNT_SV in table CT_GOODSMVT_ITEM for every item to be posted.

However from 2021, there is field in /SCMW/ISU file to upload stock with external amount in local currency.

Prepare the .CSV file with a rule of :The structure of this file must correspond to the fields of structure /SCWM/S_STOCK_UPLOAD_EXT(SE11).

The stock gets updated in S/4 and table QBEW Project Stock Valuation

EWM Stock:

S/4 Stock:

Stock Price updated with Project Stock with External amount in Local Currency.

Thanks for reading, All test is performed in S/4 HANA 2022 Embedded EWM Sandbox system.

Reference: 3445575 - EWM Initial Stock Upload with External Amount in Local Currency