topic Re: Tables and fields in Application Development and Automation Discussions

Tables and fields

Former Member — Fri, 28 Mar 2008 12:51:12 GMT

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

Re: Tables and fields

Former Member — Fri, 28 Mar 2008 12:53:41 GMT

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

Re: Tables and fields

Former Member — Fri, 28 Mar 2008 12:55:11 GMT

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

Re: Tables and fields

Former Member — Fri, 28 Mar 2008 13:04:38 GMT

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

Re: Tables and fields

Former Member — Fri, 28 Mar 2008 13:09:56 GMT

MATNR is the common field for these two tables.

So get MBEW-VERPR from MBEW

for MBEW-MATNR = MARD-MATNR

Re: Tables and fields

Former Member — Fri, 28 Mar 2008 13:13:28 GMT

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

Re: Tables and fields

Former Member — Fri, 28 Mar 2008 13:43:32 GMT

Any More Suggestions.

Ster