Need to create a report: all materials in one storage location incl. value

[Former Member]

Hello,

we have the requirement to create a report: all materials in one storage location incl. value.

What are the database-tables we need to use in the report?

Is there a standard transaction which shows all materials on one storage location?

Thanks a lot.

Kind regards

Manfred

[Former Member · Accepted solution]

Hello,

MB52 is ok - but not good performance.

What are the important tables we need to join in an own report?

Kind regards

Manfred

[Former Member · Accepted solution]

Hi,

try with tables join between MARD and MBEW,

and if any project stock there then join MARD and QBEW

chenna kesava reddy

[former_member187989]

Join tables MARA,MARD

[Former Member]

Go to MB52, and give Material,Plant,Storage Location,Batch.

[former_member187989]

Use report MB52,in selection option tick mark Don't display values or Table - MARD

[Former Member]

Hi,

try with mc.9 report,

u will get the stock and value for materials , storage location wise

chenna kesava reddy