Budget Tables in the Database In Former Budgeting, budget data and availability control data is stored together in the same set of tables. However, in BCS, tables that store budget data are used only for this purpose. They are not used by other components and they do not store availability control data (see below).
BCS table |
Description |
Corresponding FB tables |
FMBH |
FM budget header (entry documents) |
BPBK – Hierarchy document header BPDK – Entry document header BPDKT – Entry document header text |
FMBL |
FM budget document lines (entry documents) |
BPEG – Hierarchy documt lines for overall budget BPEJ – Hierarchy documt lines for annual budget BPEP – Hierarchy document lines for period BPDZ – Entry document lines BPDG – Entry document lines for overall budget BPDJ – Entry document lines for annual budget BPDP – Entry document lines for period budget |
Note Budget data is only stored on a period basis, for a specific fiscal year. The annual value should be calculated by adding up all periods fields for the fiscal year. The overall value should be calculated by adding up all period values for
Theses tables only contain budget data created via entry documents. |
||
FMHBH |
FM budget header (held documents) |
None |
FMHBL |
FM budget document lines (held documents) |
None |
NoteHeld documents are incomplete documents or template documents. They do not affect the budget. They should not be considered. |
||
FMBDP |
FM budget change line items table |
None |
Note All budget changes involving entry documents (budgeting workbench, BAPI, mass process, document migration…) or without entry documents (planning processor, mass processes, totals migration…) are stored in this table. For data coming from an entry document, there is no additional data due to the hierarchy (as BCS does not have a budget hierarchy). This is the main difference to the hierarchy tables in Former Budgeting. |
||
FMBDT |
FM budget totals table |
BPGE – Totals for overall values BPJA – Totals for annual values BPPE – Totals for period values |
In all BCS budgeting tables, the sign convention is based on the budget category.
Budget for expenditures is stored with a
negative sign
, meaning that:
Processes which increase the budget will display a negative amount (ENTR, RECV, SUPL…)
Processes which decrease the budget will display a positive amount (RETN, SEND…).
Budget for revenues is stored with a
positive sign
, meaning that:
Processes which increase the budget will display a positive amount
Processes which decrease the budget will display a negative amount

This differs from FB rules, where both budget categories (revenue and expense budget) store data with a positive sign.
Due to the complexity of AVC storage, SAP does not recommend that you directly access the AVC database tables.