We manage our capital projects in PS and settle them to assets under construction (AUCs) until final settlement. The problem I am trying to solve is that there may be older AUCs associated with closed projects with non-zero balances. We only started using Investment Measures with our capital projects in 2003 when we upgraded to 4.7 (R/3 Enterprise) so every project before then settled to an AUC that was generated manually. If I was worried about more recent projects it would be no problem for me to relate projects to AUCs by means of the investment measure. I'm not worried about the new projects, though, because the final settlement/project close process is mostly automated now.
But with these older AUCs I am having trouble finding the relationship between asset and project. By means of joining PRPS and JEST on object number, I have been able to come up with a list of all closed projects. Now I just need to get the assets associated with these projects and their balances.