Assigned Budget in Annual Budget Table (BPJA)

[Former Member]

Hi,

Hopefully someone can help me shed some light into my question.

I need to create a budget report which will display the annual values of a Projectu2019s budget and the available budget. Now I know there are at least 2 budget tables, which is:

BPGE : Total for Overall Value

BPJA : Total for Annual Value

Since I need annual values, I wanted to use table BPJA (Total for Annual Value) of which I need to extract Budget and Assigned Budget values. However when I look at the table, no records exist for value type = u201842u2019 (Assigned Budget). There exists only value type u201841u2019 (Budget) or u201847u2019 (Program Budget). This is different with table BPGE, where records exist for assigned budget.

In accordance to above values in table BPJA, the Assigned Budget column in t-code CJ31 (Display Original Project Budget) also doesnu2019t display any values for annual rows. However, the Assigned Budget for overall row is displayed.

Now my question: is that how the table is normally behaved, i.e. value type u201842u2019 (Assigned Budget) is only written to table for Overall Value (BPGE) and not for Annual Value (BPJA)? Also that CJ31 only displays Assigned Budget values for Overall and not for Annual Rows? Or did I miss something? I need the assigned budget value because I need to calculate the available budget, whereas calculating the values from other tables (COSP, COSS, RPSCO) would require a more complex extraction.

Iu2019ve searched in the SAP forums and also SAP Notes and couldnu2019t find anything that mentions about the above problem Iu2019m having.

Thanks in advance for any of your input.

cheers.

[former_member230675]

Please check your Budget Profile in OPS9. May be it is allowing only Total Values.

[Former Member]

Hi Abdul,

The budget profile settings for the Project Definitions allow Total and Annual values and the budgets are entered for annual and overall values.

[former_member230675]

Normally Value type 42 shows in table BPJA under Budget Type KBFC.

May be BPJA is updating if Budget profile allows only annual values (without Total Values), not 100% sure please check, and also let us wait for other expert advise.

[Former Member]

Hi Abdul,

How's your Budget Profile setting which allows BPJA to display Assigned Budget? Is it Time Frame = "Annual values" only and Availability Control with "Overall" unchecked?

I just tested using another setting where only Annual values is checked and Overall tickbox in Availability Control must be unchecked, and the assigned budget does show up in BPJA. Seems like this setting might be why Assigned Budget won't show up in BPJA table, since value type "42" is tied to business transaction "KBFC" (Availability Control). Based on the test result, Assigned Budget only shows up in either BPGE or BPJA based on the availability control, but not both. If the availability control is set to Overall then value type shows up in BPGE, whereas when it's set to Annual then value type shows up in BPJA.

Would be great if someone can back me up on this conclusion.

Thanks.

[former_member230675]

 Time Frame = "Annual values" only and Availability Control with "Overall" unchecked. 

The profile I checked exactly same as you mentioned above.

I think your assumption is correct.