Inventory transfer based data input to next inventory transfer transaction

Dear Friends,

I am trying to get field level as well document level data from inventory transaction with particular series into next inventory transfer document entry. that is automatic pulling of data while entering next inventory transaction.

is it possible with temporary table then please guide me to create the temporary table and to fetch the data. else through fms pls quide to create fms query.

Regards:

Balaji.S