FMBL and FMBDT Issue
One of my client have BO implemented which takes budget related data from table "FMBL". It was found that their SAP ERP report and BO is not reconciling.
Upon analysis it was identified that they used T-Code "FMPLCPD" to create budget planning data in version "XX". Once their planned data was approved, they used the same T-Code to enter their final figures in version 0. The table used behind FMPLCPD is "FMBDT". During sometime period, they made adjustment within the Fund Centers and Commitment Item using T-Code "FMBB" which updates the table "FMBL". This is the reason that their figures are not matching.
In order to resolve this issue, I have suggested the following:
1 - Using T-Code: FMCYLOAD, generated budget data from that entered in FMPLCPD for version "0" in update mode "0 - Reset and overwrite" with the correct budget type for process "Enter". This will update table "FMBL" from which the budget figures are being sent to BO.
2 - Using T-Code: FMPLCPD, make the amounts equal to "0" of the budget address (i.e. Fund + Fund Center + Commitment Item) so that the amounts are not duplicated.
I require your advice whether it is the correct way to get the issue resolved or is there any other process.
Looking forward to your expert advice!