Tables and fields

[Former Member]

Hello friends,

I want to extract some data and I can do a querry for that.

However my question is I need some information on tables and fields.

the extract is for inventory loads and would involve some MM

Also the link to the tables.

Material number,

Storage location,

Moving Average price,

Quantity.

Thanks,

Ster

[Former Member]

hi,

check the tables mara,marc,mard...

mostly on mard.

fields-----

matnr(material)---mard(table)

lgort(storage loc)--mard

LBSTF(quantity)-mard

regards,

venkat.

Edited by: venkat appikonda on Mar 28, 2008 1:57 PM

[Former Member]

Hi,

You can check the tables

MARA - Materila Master Data

MARD - Storage Location Data for Material

MARC - Plant Data for Material

And u can also check for more tables by using M* in SE11.

Thanks and Regards,

Ruthra

[Former Member]

Thanks Venki / Sundaresan .

I found the table that would have Moving average price and the table is MBEW-VERPR.

My question si how would i tie this table to MARD.

Thanks,

Shreekant

[Former Member]

MATNR is the common field for these two tables.

So get MBEW-VERPR from MBEW

for MBEW-MATNR = MARD-MATNR

[Former Member]

Thanks Srinivas.

But the ket to MBEW is not just matnr.

It also has the valuation class and key.

I have to do this for only one plant.

Ster

[Former Member]

Any More Suggestions.

Ster