topic Re: Material storage location wise:Table in Application Development and Automation Discussions

Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 04:50:41 GMT

Hello Experts,

I want master table in which I get all the materials storage location wise.

I look MARD,but it is not solving my purpose.

Plz suggest,

Aastha

Re: Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 04:53:55 GMT

Why the table MARD(Storage Location Data for Material) is not solving your problem???please explain

Re: Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 04:58:21 GMT

Hi Astha,

Try these tables.

KOTP210 Material/plant/storage location

S195 Material movements: storage location

Much Regards,

Amuktha.

Re: Material storage location wise:Table

viquar_iqbal — Mon, 16 Mar 2009 04:59:33 GMT

check this table

KOTP210

KOTP511

MVRD

MARDH

MSTA

Regards,

Viquar Iqbal

Re: Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 05:12:44 GMT

Hello Amuktha,

No data exists in both there table u refer.

Aastha

Re: Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 05:17:20 GMT

go for these table....these are only master table which gives material storage location wise....


MARD       Storage Location Data for Material
MARDH      Material Master Storage Location Segment: History

Re: Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 05:21:01 GMT

Hello Arunima,

Mard is not solving my problem as .

In selection-screen of MARD when

1. i input Plant ,St location & yr.cur period -> 60 records populate

2.I input same plant, st loc ,yr cur priod as above& current period:12 ->31 reords populate.

3.I input same plant, st loc ,yr cur priod as above& current period:11 ->5 reords populate..

Y it is showing such a behaviour??

Can u tell at which movement data get populated in MARD.

Aastha

Re: Material storage location wise:Table

Former Member — Mon, 16 Mar 2009 05:35:46 GMT

This is probably because the materials are not extended to all the storage locations , and mostly its because its in development system.

Once a material is created , you need to extend it to which all plants its available.Once its extended to plants , you need to extend it to tell which all storage locations in that plant this material is available.

It also depends on the stock available for that material in different storage locations.

But MARD is the right table for material - storage location relationships.

If you are looking to find all the storage locations under a plant - T001L

Mathews