WM Warehouse assignment table

[former_member202483]

Experts,

I am trying to find a table which has the material number field, the warehouse number and also which plant the warehouse is assigned to. I know how to assign a warehouse to a plant on customizing. I am trying to do a query for my client to view material records.

Thanks,

Alejandro

[Shiva_Ram · Accepted solution]

You need to combine two tables using a ABAP query to get the details.

The table MARD contains the plant + storage location for a material, and table T320 contains the plant+storage location assignment to warehouse.

So try to use MARA, MARD and T320 in the query to get the results.

Regards,

[former_member202483 · Accepted solution]

Thanks to both of you,

Alejandro

[Former Member]

Hi

a query on MARA, MARC and MLGN will give you details of a material with its plant and warehouse data. For Plant and Warehouse comibination, refer to config view V_T320 or table T320

Regards

Virender Singh