I have to develop a report that gives the lowest level "purchase" items used to make a final sales item.
I mean, when an item is shipped in tdsls045, if the sales item lot is "manufactured" then it should get the production items from ticst001.

If the production order still has "manufactured" items in its consumption then even those should be taken from ticst001 so on and so forth..

I believe that sales can be picked from "tdsls045" and lot transactions from "tdltc102",

But any one help with the resursion bit(tdltc102 and ticst001).