How to get balance of closed project AUCs?

[Former Member]

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.

Any ideas?

[Former Member]

IF you are using SAP fixed assets, the AUC is really an asset. You can select asset reporting for the AUC asset class (usually 950100) and sort by number (internally assigned) and the review the balances for those AUC's before your conversion. Something like S_ALR_87011994 should work.

[Former Member]

That's helpful, but I'm only concerned about assets related to closed WBSEs. I'm having trouble finding a way to hook back to the project tables and restrict my asset results based on whether or not they are closed projects. A pseudocode-y way of saying it is

SELECT * FROM whatever WHERE original_project_status = 'CLSD' AND asset_class = 'A.U.C.' AND asset_balance > 0.