Show TOC

 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 all fiscal years.

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

Sign Conventions

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.

Availability Control Data

Due to the complexity of AVC storage, SAP does not recommend that you directly access the AVC database tables.