Complete Material Master Extraction

[former_member4887]

Hi everyone

how can i extract all the material master from my current system SAP R/3 4.6C ?

[p391977 · Accepted solution]

Hi,

All material basic data can be extracted from MARA table by putting relevant material type.

If you could tell me the exact requirement we can check for the extracting such data from the system.

Regards,

Radheshyam.

[former_member4887 · Accepted solution]

i want to extract complete material master data

[p391977 · Accepted solution]

Dear Nida,

In Material master different,different data is stored in different,different tables.

PFA image for the list of tables of the MM .

What you can do is, you can build a quick viewer query(T.Code: SQVI) joining the tables( based on the data) & pull the data from that report.

It may have number of entries restriction (let us say 10000 records can be extracted from the dump once), depending on that you need to get the dump.

Regards,

Radheshyam.

[Former Member]

Hi Nida,

Check this thread...

List of all Materials | SCN

TCode  for getting list of material master... | SCN

Regards,

Prithviraj.