SAP for Public Sector Discussions
Foster conversations about citizen engagement, resource optimization, and service delivery improvements in the public sector using SAP.
cancel
Showing results for 
Search instead for 
Did you mean: 

FMKFDEF - Key Figure With Values Only Of Current Document in FMBB

Former Member
0 Kudos
552

Hello Colleagues,

For a specific scenario I need to validate the posted available budget against the current prepost document, is there a way to create

a key figure to collect only the input values for the current document in FMBB ?

I've tried to activate the filter in BCS for preposted too, but in this way SAP is checking against all budget, posted and preposted,

I would need the validation only against the inputed prepost value against posted available budget.

Thanks in advance.

Filipe Santos.

8 REPLIES 8

sjajodia
Contributor
0 Kudos
440

Filipe,

You can do this in consistency checking.

Thanks

Shyam

Former Member
0 Kudos
440

Hi Shyamal Jajodia ,

Thanks.

I Have tried to use FMCCA, on Left Side I have available budget and on right the prepost document,

but the key figure is reading the whole database, I would need just the current document being preposted.

Thank in advance.

Filipe Santos.

0 Kudos
440

Filipe,

How can you calculate available budget without reading the database? Available budget is the total of all the budget documents and consumption documents and is being updated real-time in FMAVCT.

Thanks

Shyam

Former Member
0 Kudos
440

Hi Shyam,

The available budget is reading the database, but I need to compare with the current preposted amount, example :

   Available Budget :

   I would need to validate this against the current amount in the FMBB

   Prepost Document :

But this is reading all the preposted documents.

For this scenario I need to compare the current amount, the input values in prepost document in FMBB only, not all preposted documents in database.


Thanks in advance. Regards.

Filipe Santos.

0 Kudos
440

Hi Felipe,

Even though it compares the key figures for the budget address the rule is checked only when the document posted. So it adds the amount in the document to the amount in the database and applies the rule. Isn't this what you want?

Thanks

Shyam

Former Member
0 Kudos
440

Hi Shyam,

The preposted documents in database should not be considered.

The prepost documents will be transfers from one account to another.

The Scenario would be the Following :

  1. Available Budget Of 100.
  2. Transfer Prepost document 1 - Sender Value 50 -  Compare Against 100, OK -> Prepost.
  3. Transfer Prepost document 2 - Sender Value 90 -  Compare Against 100, OK -> Prepost.
  4. Transfer Prepost document 3 - Sender Value 120 - Compare Against 100, Not OK -> Message Error.

Thanks in advance, Regards.

Filipe Santos. 

0 Kudos
440

Hi Filipe,

OK Now I understand why you cannot use consistency checking rules. If you set workflow status to consider only posted documents it will not raise an error when you are preposting. The other option you have is using BADI FMKU_BUDGET_EVNT_CC.


Thanks

Shyam

Former Member
0 Kudos
440

Hi Shyam,

Thanks for your help.

Regards,

Filipe Santos.