Developing a report for Enhanced Warehouse Management (EWM) which displays the plant (WERKS) as characteristic and valuated inventory in the EWM storage bin (LGPLA).
Is there a table which contains this data?
Is there a table to connect the EWM storage bit to the ERP MM Storage location (LGORT) and/or Plant (WERKS) which I could use to join to MBEW to get the standard cost or average cost at the plant level?
Thanks for your help,
EWM is able to load Price information with report /SCWM/R_VALUATION_SET. Prices are used for user access (authorizations) in Inventory processes.
There is no direct connection from storage bin (LGPLA) to storage location (LGORT). Storage location it is quant attribute in EWM. You can have several different "storage locations" in same storage bin.
In Quant stock type is available. It is a combination of availability group and location independent stock type. Availability group is mapped to werks / lgort in the interface. In general you can call stock mapper to get ERP data. (see for example /SCWM/CL_ERP_STOCK_MAPPER or /SCWM/IF_STOCKID_MAPPING ), or FM /SCWM/TMAPSTLOC_READ_SINGLE.
But I would suggest to try it first with standard report. After you can use /SCWM/MATERIAL_VALUATION_GET to get needed prices.