Transaction Code MB52 is using following table.
- MSKU - Special Stocks with Customer
- MSPR - Project Stock
- MCHBH - Batch Stocks: History
- MSSA - Total Customer Orders on Hand
- T136F - Fields for stock display: basic list/detail list
You can find entrance and exit of material from MSEG, MKPF table by movement type.
Try to see the following sap tables:
MBEW is the table with qty and amount of stock, by Plant and Material code .
MBEWH is the same with Historical data by Fiscl period.
S031 Contains total qty recepit and total qty consuption by period
S032 contains last recepit date (entrance ) and last good issue date (exit) by plant material .
In table S031 you can see the qty consumption , it can be the qty of sales but it's not sure , you need to verify if in your company the consumption is only incremented by sales and not by other inventory movement .
analyze the number in table s031 and compares the qty with qty in sap transaction MB51.
Hi Celia thanks for the help
I think my problem is more bigger, I have see the stock for Stores and C.D (center of distribution)
It's something like : Factory (I have that information not come from sap) --> C.D --> Stores
But i Have Store to CD , when the product its no more in you valid date
I Look this tables and i Thinks this is something like MB5B or MB52
Here i see the product go and back but my balance the day or last day not