material listing

[Former Member]

Dear Gurus,

can we extract the material list defined under a particular division.

as far as i know that material number is present in table RMMG1, field MATNR and division in table MARA, field SPART.

any way to extract the material list as per the division.

Wishes,

Abhishek

[Former Member · Accepted solution]

hi,

You can extract list of materials for particular division from table MARA itself. Just enter the required division in selection screen and execute.

Regards

Chetan

[Former Member · Accepted solution]

hi chetan,

pls let me know how can i extract the material list based on "sales organization, distribution channel and language"

is there any way?

Abhishek

[Former Member · Accepted solution]

Hi Abhishek,

You can get list of materials based sales org and division from MVKE table. For material list based on language you can use MAKT table. But using all 3 selection parameter it is difficult to get material list.

Regards

Chetan

[Former Member · Accepted solution]

hi chetan,

i think the best possible way to extract these data to contact a ABAPer and prepare a report, otherwise it is not possible. so i am closing the question.

Wishes,

Abhishek

[Former Member]

Look into report MM60 after execution you can filter based on division or you neeed to go for simple ABAp development

Edited by: Antony James Vijay on Mar 24, 2010 10:42 AM