Skip to Content
0
Jan 26, 2023 at 01:07 PM

Logic for Payments against FM Budget Commitments

353 Views

Dear Experts,

I am trying to devise the logic for a custom report where requirement is to show the aggregate of all the payments made to Vendors (e.g. via F-53/F-58/F110) against the FM budget commitments saved at MIRO/FB60 level.

Putting it simply, in one column, I have to show the total of payments made against the budget commitments adopted at MIRO/FB60 (commitments are always same in full P2P cycle as client is strictly following the document adoption approach while creating subsequent document PR->PO->GR->IR).

This is basically an extended version of Budget Consumption Report where "Payments against Budget" Column will depict above requirement.

OF29 settings are not applied so online paymeny update solution is not relevant, that's why I have to opt for Z report.

My logic for "Consumable Budget" column is Table FMAVCT and field RRCTY = 1 and for "Consumed Budget" column is again Table FMAVCT and field RRCTY = 0. "Available Budget" column is of course Consumable - Consumed.

Regarding "Payments against Budget" column, I am stuck at the point "How to build the functional logic to get the payment data against invoices on the basis of FM budget address given in selection parameters of the report". If it was to get data on basis of invoice document number given in selection parameters then it was not difficult but when it comes to extract payment data on basis of budget address, here I am facing difficulty to define the connection.

Please guide.

Regards,