topic Re: Material Master Data in Application Development and Automation Discussions

Material Master Data

Former Member — Fri, 30 May 2008 18:44:23 GMT

Hi All,

I need to extract data from the material master. I have field names, i need the tables in which these fields are in.

ItemNumber

ProductType (e.g., table)

Manufacturer (e.g., Office Master)

ProductLine (e.g., Paramount)

ShortDescription (e.g., Office Master Paramount Value table)

LongDescription

Thanks.

Re: Material Master Data

Former Member — Fri, 30 May 2008 18:48:04 GMT

hi check this..

ItemNumber TABLE MARA-MATNR

ProductType (e.g., table) MARA-MTART

Manufacturer (e.g., Office Master) MARC-WERKS

ProductLine (e.g., Paramount)

ShortDescription MAKT-MAKTX

LongDescription

check these..

MAKT, MARA, MARM, MAST, MSEG, MKPF

regards,

venkat

Re: Material Master Data

Former Member — Fri, 30 May 2008 19:09:42 GMT

The best way to learn the Table and Fields involved are by going to the Transaction that has the fields you need. Use the F1 Key in the Field and then look at the Technical Information. Much easier than asking a simple question in this forum, and probably much faster.