The lastest date that a material is consumed in a storage location ?

[Former Member]

hello,

How can we know the latest date ( of a document ) which the given material is consumed in a storage location.

Supposing here we have:

+Material number

+The batch number

+The storage location

and the movement code is 601 ( delivery )..And the table we use is MSEG and MKPF

Thank you for your help.

[JL23 · Accepted solution]

you have to sort all movements you get by posting date or CPU date, descending, then take the first.