Material Master Data

[Former Member]

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.

[Former Member]

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

[Former Member]

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.