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

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