cancel
Showing results for 
Search instead for 
Did you mean: 

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

john_hawk
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Daniil
Active Contributor

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Hi John,

/SCWM/TCAT (stock type to Availability group)

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

john_hawk
Active Contributor
0 Kudos

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

If so, what is the full table name?

Thanks,

John Hawk

Daniil
Active Contributor
0 Kudos

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.

Answers (0)