Plant & Warehouse linkage in WMS

[Former Member]

Dear all,

I have created a program to extend the WMS view. Functional also requested for a download option, so that they can verify the data uploaded for the extension.

okay, am able to get all the data from MLGN and MLGT, for the material extended. However, am also looking for the PLANT that this extension took place in.

T320 table isn't the right one - because a warehouse number can be assigned to multiple plant.

Kindly advise, if there is any table, that links the warehouse and material back to the plant .

Many thanks in advance.

[Former Member · Accepted solution]

Hi,

First for a given material check if there is any entry in marc where pstat CA 'S' ( Maintanance status for ware house.).

if entry exists in this means ware house management view exists for this material. now fetch material and plant from marc passing matnr where pstat ca 'S'.

for above entries fetched check in mlgn by passing material number. if entry exists ware house is extended for that plant and ware house number.

Regards

Siva.