We use CJR2 to upload planning data for Projects. This data automatically copies over to GP12N - which is what updates FAGLFLEXT.
Recently, when clearing the planning data from CJR2, which clears GP12N (setting all values to 0)... there was still values in FAGLFLEXT showing in our report painter report.
E.g. when setting CJR2 (and GP12N) planning data to 0 - our report shows 1 650.00
Whatever values you add in CJR2 (GP12N) gets added to the value that exists in FAGLFLEXT.
How do we clear the value in FAGLFLEXT. We're not sure how it got there... we only use CJR2 (and GP12N) for planning. Its possible the users accessed another planning transaction - but can anyone tell me what other transaction affect FAGLFLEXT when it comes to planning data?
I am not sure, how the planning data hits the table FAGLFLEXT, but i think the following information would help you to come to a conclusion :
Assuming that the totals in FAGLFLEXT are correct, you can consider deleting the plan line items through transaction GLDE by activating ONLY the flag 'Plan line items' in the section 'deletion scope'. Once all plan line items are deleted you can then recreate the missing plan line items via FAGLGCLE via activating 'update opening balance'. Then FAGLFLEXT and FAGLFLEXP would fit together again.
Further, assuming that plan line items in FAGLFLEXP are correct, you could delete the totals through GLDE (activate only Totals in deletion scope) and then rebuild the totals out of the line items through report RGUREP01 (refer to SAP note 45747).
It looks this issue has already been raised to SAP. I would also suggest you to wait for our colleagues to complete their investigation on this and look for their results.
Thanks for the info. Yes, the totals in FAGLFLEXT seem to add up to the correct amount.
SAP did reply confirming the above, which we knew already. However, my question to them was, if we clear out the plan data, there is still values in the table... and if we don't see those remaining values in CJR2, GP12N or KP06 (planning transactions) then what other transaction can we view those values in. How did those values get into the table? Still waiting for their reply.
Thanks again for your post - I will take the info and discuss with my colleagues.