We would need a bit more information to help you. Which information do you have that could be used?

Hi,

It would be great if you can provide some detail info on your query.

Thanks.

Hi,

we're looking in the same direction. Assuming the case identifier would be SKU+Batch you would be able to trace the storage time by first appearance of goods receipt (MSEG-SHKZG 'S') and last appearance of goods issue (MSEG-SHKZG 'H'). The challenge is more to find the right case-key.

Hello Joao,

besides using the MSEg.SHKZG = S and = H, you can you MSEG.CPUDT_MKPF as it contains the Day On Which Document Was Entered.

If you want to leverage Celonis PQL functions, I'd suggest adding all the material movements to the activity table

Best,

Gabriel