EWM: Storage Bin to MM Storage Location or Plant for valuated inventory - How to linK?

[john_hawk]

Hi Friends,

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,

John Hawk

[Daniil · Accepted solution]

Hi John,

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.

BR,

Daniil

[john_hawk · Accepted solution]

Hi Danill,,

Would your happen to know the tables for "Quant" and " Availability group is mapped to werks / lgort in the interface"?

Thanks,

John Hawk

[Daniil · Accepted solution]

Hi John,

/SCWM/TCAT (stock type to Availability group)

/SCWM/TMAPSTLOC ( Availability group to werks/lgort )

[john_hawk · Accepted solution]

By "In Quant" , do you meant a table?

If so, what is the full table name?

Thanks,

John Hawk

[Daniil · Accepted solution]

Usually physical stock is used to read it.

But you can do with join, if I understood right you want to do it as a CDS view. If not it would be better to use proper FMs, or as well download valuation to EWM

/scwm/quan with one of the (condition, depends on idx_stock)

/SCWM/STOCK_IW01
/SCWM/STOCK_IW02
/SCWM/STOCK_IW03
/SCWM/STOCK_IW04

by stock_guid.

Bin is basically guid_parent if you do not use HUs.