Purpose

The purpose of this document is to document the entire Configuration required for Budget Availability Control (BAC) including Budget Profile and Tolerance Limits. At the end of the document, examples of BAC response based on the tolerance limit set are documented.

General Information

The configuration for BAC can be divided into two steps

– Maintaining Budget Profile

– Defining Tolerance Limits

Maintaining Budget Profile

Detail Configuration steps with screen shots for Budget profile are listed below:

Go to Maintain Budget Profile using the Transaction code or Menu Path stated below:

Transaction Code OPS9
Menu Path SPRO
> SAP Reference IMG
>>  Project System
>>> Costs
>>>> Budget
>>>>> Maintain Budget Profile<

IMG1.jpg

Select “New Entries”

• Profile – Budget Profile Enter the name for the new Budget Profile, say “ZCAP”

• Text – Description for Budget Profile

Enter the Description for the Budget Profile, Example -> “Profile for Capital Projects“

• Timeframe: Based on the business requirement, specify the number of years in the past/future you would like to plan/budget projects for.

For the purpose of illustration, the budget profile is maintained such that the Budget can be maintained for 5 years in the past/ 5 years in the future and the start year (current year) as the reference point.

IMG2.jpg

Total values (Indicator): Check this indicator so that overall values can be maintained for budget.

Annual values (Indicator): Check this indicator if business prefer to maintain the budget on annual basis.

Representation: • Decimal places and the Scaling factor would help in controlling the layout of the filed group values that have constant units.

                            • Decimal Places – Number of Decimal Places (say ‘2’ )

IMG3.jpg

• Exchange Rate Type – M

IMG4.jpg

Maintain the exchange rate type that would be used for the BAC calculations.

• Program Type Budget – Program type for budgeting In case of Investment Projects, this field will be significant, as this will ensure that WBS elements with a given budget profile cannot receive overall or annual budgets unless the WBS element (or a WBS element above it in the hierarchy) is assigned to a program position of an investment program with the correct program type entered here.

Select the Program Type for the Budget Profile, example “Z001”

IMG5.jpg

• Activation Type – Availability Control Activation Type

IMG6.jpg

This Field determines whether and how availability control should be activated.

IMG7.jpg

There are three activation types:

0 = cannot activate: This activity type may cause an already active availability control to be deactivated.

1 = automatic activation when budget is assigned. Upon selecting this activation type, at least one tolerance limit should be maintained for the budget profile.

2 = background activation when percentage of consumption is exceeded For the Project used in this illustration, as we want to activate Budget Availability

Control when Budget is allocated, maintained the Activation Type as “1“

Usage – Usage in % for background activator.

– Use this indicator, only when the activation type ‘2’ has been used. By maintaining a percentage value in this field, say 50, the system will activate BAC when the assigned funds of the WBS is more than the 50 % of the budget available on the WBS. Since we have opted for Activation type ‘1’ – Automatic activation during Budget allocation, this usage field is left blank.

Overall- Availability control against overall value.

– Select the Overall indicator so that the budget checks would be done against the Overall budget values and not against the annual values.

Object Currency (Indicator) – Availability Control in Object Currency

– In case if business prefers budget checks to be done against the Object currency values, only then check this indicator.

Releases(Indicator) – Availability control against releases

– If the business requirement is such that the budget is released as and when required and the budget check accordingly should be for the released budget

only, then check this indicator. If the Budget check needs to be done for the entire amount budgeted, then leave this indicator deselected.

Budgeting Currency-

– Controlling Area Currency(Indicator) – Budgeting/Planning in the Controlling Area Currency

– Object Currency (Indicator) – Budgeting/Planning in the Object Currency

– Transaction curency (Indicator) – Budgeting/Planning in the Transaction Currency

IMG8.jpg

Select the Controlling Area currency.

• Save the Budget Profile.

Result

Configuration of Budget Profile is completed for which Tolerance limits are to be set.


Example

Below is the screen shot for Budget Profile ZCAP as an Example.

IMG9.jpg

Define Tolerance Limits

Tolerance Limits are set for defining what actions are to be taken when the Budget is overrun. Example: Warning will be shown if the Budget Exceeds 70% of Budget available. Warning with mail to the Person responsible when the Budget Exceeds 90% of Budget available. Hard stop Error will be shown if the Budget Exceeds 100% of Budget available. Different Budget Profiles can have different Tolerance settings.

Detail Configuration steps with screen shot for Tolerance limits are listed below:

• Go to Maintain Define Tolerance Limits using the Menu Path stated below:

Menu Path SPRO –> SAP Reference IMG –> Costs –> Budget –> Tolerance Budget

Select “New Entries”

• COAr – Controlling Area. Enter Controlling area.

• Prof. – Budget Profile

Enter Budget Profile for which you want to set the Tolerance Limits. In this example, “ZCAP”

Tr. Grp – Tolerance Group

Tolerance Group is the Activity Group for which you want to set the Tolerance

limits.

E.g. Activity Group 00 – Purchase Requisition, Tolerance settings for this activity group will be applied only for Budget overrun due to Purchase Requisition.

Below is the list of allowed Activity Groups:

IMG10.jpg

Select Activity Group “00” for setting Tolerance limits to give warning message and an email when PR exceeds 90% of Budget.

Act. – Availability control action

This field indicates what action is triggered if the defined tolerance limit is exceeded.

IMG11.jpg

Enter “2” in this field as we want a warning message and an email when PR exceeds 90% of Budget.

• Usage – Usage rate in %

The “usage” represents the ratio of funds commitments to the budget, expressed as a percentage. If this value is exceeded because of budget reductions or assigned funds in commitments which are too high, the specified action is triggered.

Enter “90” in Usage Field.

• Save the Tolerance Limits for PR for 90% Usage.

• Below is sample of business requirement for Tolerance Limits for below Activity Group and Budget Profile combinations.

IMG12.jpg

Result

Tolerance Limits were successfully set for Budget Profiles and Activity Groups.


Example

Below is the screen shot of a Tolerance Settings for Budget profile ZCAP when budget exceeds 90% and 100% of WBS Budget.

IMG13.jpg

Examples of BAC actions:

• Created a project (FS00141) and assigned the WBS FS00141 to an Investment Program.

• Distributed the budget to the project using transaction IM52 for a value (USD 1000.00).

IMG14.jpg

• Since the activation type maintained for the budget profile ZCAP is automatic activation upon budget allocation, the status of the WBS for which the budget is

distributed will now be BUDG AVAC

• WBS Person responsible is maintained on the WBS

IMG14.jpg

Now create a PR for USD 901.00, which is 90.1% of the available budget (USD 1000.00). In this example, created PR for qty 1, hence the valuation price is same as the PR amount.

IMG16.jpg

Check that the account assigned object is the WBS element for which the budget has been maintained.

IMG17.jpg

• If the requisitioned tries to save the PR, then system will pop-up the below messages

IMG18.jpg

IMG19.jpg

• Once the PR is saved, a warning mail will be triggered to the person responsible maintained on the WBS. Below is the screen shot of how the message will look like at the SAP Business Workplace (SBWP) in the inbox of the person responsible maintained on the WBS.

IMG20.jpg

• In the above message, the following details can be noticed.

– PR number which has triggered this warning message

– WBS FS00141 for which the PR has been assigned and for which the budget check was done

– Assigned funds are 99.00 USD less than budget which means the available budget on the WBS is now 99.00 USD

• For this same WBS copying the above created PR 20001251, if the Purchase Order is tried to create for USD 1001.00 which is a dollar over the budget allocated, the system as per the tolerance limit set (Hard stop error when assigned funds exceed 100% of available budget) should throw a hard stop error.

• With reference to PR 20001251, create a PO for USD 1,001.00. Check that the WBS is the same used on the PR and budgeted FS00141

• When the buyer, tries to save the PO, the following message window will pop-up and prevents from saving the PO. The message displays the amount by which the available budget exceeded. (USD 1.00)

IMG21.jpg

IMG22.jpg

• Similarly in case of the other activity groups, BAC would trigger appropriate action based on the tolerance limits set.

To report this post you need to login first.

28 Comments

You must be Logged on to comment or reply to a post.

  1. Pankaj Bhalerao Post author

    Hi All,

    Please find above document on “Budget Availability Control” via Project System. I hope this will be helpful for all community members.

    Improvement suggestions, comments are welcome !

    Thank you.

    Regards,

    Pankaj Bhalerao.

    (0) 
    1. Tushar Vhora

      Hi Pankaj,

      Very good document clearly explaining Budget availability control- How it is setup in SAP project systems.

      Apperciate if you can include more scenarios related to Budget related error messages.

      Thanks

      Tushar

      (0) 
  2. lolly oshin

    Hi,

    Nice document and very useful. Please is it same when using internal order for your budget. We are not using project system.

    Thank you

    (0) 
  3. Herbert Larange

    A quick question on this. We only want AVAC on POs and PRs, and no check against budget on any other transaction type (FI and CO docs for example). Do I just have to enter settings for POs and PRs? Because this works slightly differently to BCS, where if you dont enter anything for a transaction type, it defaults in a value of “error message” rather than not having any AVAC.

    Good document by the way, thanks, Herb

    (0) 
    1. Pankaj Bhalerao Post author

      Hello Herbert,

      Apologies for late reply. Just maintain the settings as said by Sammar. This should work though.

      Cheers,

      Regards,

      Pankaj Bhalerao.

      (0) 
  4. Patricia Marina Rodrigues Do Nascimento

    Hi Pankaj!

    Excellent document! Thanks for sharing.

    In your document, was not setting activity group ++. I have an question on this. If I just setting activity group ++ for 100% usage and 3 – Hard stop. When will be create a PR which is 100.1%, should the system throw a hard stop error?

    My question is because in my settings I define activity group ++. Then I created the PR which is 100.1% and Acc.***.Cat. is P Capital Project, but the system didn’t throw stop error.

    Thanks Patricia

    (0) 
  5. vitti deraldo

    Hi Pankaj

    Excellent document.

    I have a question: in my Client the configuration is similar. But why in some budget projects is not taken into account when we place a larger commitment than budget?
    Budget and Investment Profiles are configured for Global rather than Annual control. Availability control is enabled in the Project. The service code is directed to a cost class that is not in the exception control.Example: Budget = 10 K USD; ML81N with 20 K USD. We do not have a “budget exceeded” error message. Tolerance limit = 3 for 100% of the Budget.

    I would like to get your comment about it.

    Thanks and best regards.

    Vitti

     

     

    (0) 

Leave a Reply