Material Master report

[Former Member]

Good day!

Is there such report in MM where in we could extract Valuation price, Base Unit of Measure and Quantity in one standard form?

Thank you.

[Former Member · Accepted solution]

Hi Marlon,

So far I do not know any standard report which contains all 4 information. In MM60 you can see the material, UOM and valuation price per material data. MB52 on the other hand shows the material, UOM, total stocks and total value of the stocks (per location). Good thing is you can extract those information from table MBEW in transaction SE16. You may also create an ABAP query to show all these information in one report. 😃

[Former Member · Accepted solution]

Thank you very much, ADP! Your answer was very helpful because we badly needed the table. Thanks to you again.

[pankaj_singh9]

Hi,

Use MB5L Report,

In selection screen, use Period - Select Balance, Current Period

Execute

In output screen,

Double click on the GL Account, it will show the report having current details of material with stock qty, Base UoM, Stock Value and Valuation Price with Price Control.

Do layout setting as per requirement.

You can also use MB52, select "Non-hierarchial display" in selection screen.

[former_member192897]

Hi,

Try Standard Reports MM60 and MB52

Regards,

Ashok

[Former Member]

Hi

Try with T.code : MM60 - Material List

T.code : MB5S - List of GR / IR Balances

Regards,

senthil.

[Former Member]

Dear,

Check mm60, in this report you can see material moving average price plant, unit of measure.

But what you means by "Quantity in one standard form"

Regards,

Mahesh Wagh

[Former Member]

Hi,

You can try with MM60, or otherwise you can creat quarry report with SQVI.

Subrahmanyam

[Former Member]

Thank you, Subrahmanyam! Your response was helpful. I have something new to work one.

[Former Member]

pl check = MM60.

SAP11