topic Re: view material master tables for extracting data in Application Development and Automation Discussions

view material master tables for extracting data

Former Member — Fri, 25 Aug 2006 19:29:58 GMT

i have to extract material master data ,itseems some ztables are also used so how do we know which tables are to be used .I appreciate your response.

Re: view material master tables for extracting data

RichHeilman — Fri, 25 Aug 2006 19:33:25 GMT

HEre are some material master tables..

MARA

MARC

MARD

MBEW

MFHM

MARM

MAKT

MLGN

MPOP

MVKE

Just to name a few.

Regards

Rich Heilman

Re: view material master tables for extracting data

Former Member — Fri, 25 Aug 2006 19:37:35 GMT

some ztables were also used itseems. what data must be extracted from those .

Re: view material master tables for extracting data

RichHeilman — Fri, 25 Aug 2006 19:39:45 GMT

I am pretty sure that I would have no idea as they are "Z" tables and were custom built for that company. I have no idea what is contained in the "Z" tables. You must ask the functional lead for your company.

Regards,

Rich Heilman

Re: view material master tables for extracting data

Former Member — Fri, 25 Aug 2006 20:07:44 GMT

You could go to the data ditionary and enter MATNR as the data type and then do a where use list. Page to the bottom and you'll see if this is used in any Y or Z tables - not just master data though.

Of course if a Z data element is used in a Z table, this won't find them. So you could do an F4 on ZMAT in the data type field of the dictionary. Then use the above procedure an any that look promissing.

However - this is <b>not</b> guaranteed to find all of the Z tables, but it should give you a start.

Rob