In the SAP MM (Material Management) module, there are indeed primarily master data tables that store information about materials, vendors, and other relevant data for managing materials in the organization.
However, there are also some transactional tables in MM that store information about goods movements, such as inventory transactions, goods receipts, and goods issues. For example, the table MSEG stores the line items of a material document and contains information about the movement of goods.
Additionally, the module SD (Sales and Distribution) also contains transactional data tables that store information about sales orders and deliveries, such as VBAK (sales order header) and VBAP (sales order item).
As for your specific need of Key-figures for an Analysis in SAP Analytics Cloud, you can use the data in the transactional tables to calculate the quantity of products of Type X in Plant Y. You can join the transactional tables with the master data tables to get the necessary information.
I find that the harder I work, the more luck I seem to have.