SAP BPBTX Totals Records: Year-Independent Budget for Fund - Extended Table data and field list

BPBTX is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Totals Records: Year-Independent Budget for Fund - Extended" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BPBTX TYPE BPBTX.

The BPBTX table consists of various fields, each holding specific information or linking keys about Totals Records: Year-Independent Budget for Fund - Extended data available in SAP. These include FONDS (Fund), FICTR (Funds Center), FIPEX (Commitment Item), FAREA (Functional Area)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BPBTX structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP BPBTX structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BPBTX table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
FONDSFund BP_GEBERCHAR10FMFINCODEBP_GEBERFIC
FICTRFunds Center FM_FICTRCHAR16FMFCTRFISTLFIS
FIPEXCommitment Item FM_FIPEXCHAR24FMCIFM_FIPEXFPS
FAREAFunctional Area FM_FAREACHAR16TFKBFKBERFBE
FTEXTName of the functional area FKBTXCHAR25TEXT25
WRTTPValue Type CO_WRTTPCHAR2CO_WRTTP
WTEXTVal.type name FM_WRTTPTCHAR40TEXT40
VORGABudget type FM_VORGACHAR4Assigned to domainACTIVITY
VTEXTName of Budget Type FM_VORGATCHAR40TEXT40
SUBVOBudget Subtype BP_SUBVOCHAR4TBP4ABP_SUBVO
UTEXTName of Budget Subtype FM_SUBVOTCHAR30TEXT30
FWAERFM area currency FMWAERCUKY5TCURCWAERS
WLGESOverall budget in FM area currency FM_BTOFKCURR15(2) WERT8
WLGEVDistributed overall budget in FM area currency FM_BTVFKCURR15(2) WERT8
WLGEKDistributable Overall Budget in FM Area Currency FM_BTRFKCURR15(2) WERT8

Key field Non-key field



How do I retrieve data from SAP structure BPBTX using ABAP code?

As BPBTX is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BPBTX as there is no data to select.

How to access SAP table BPBTX

Within an ECC or HANA version of SAP you can also view further information about BPBTX and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to BPBTX

    FKRS - Financial Management Areas
        FMF_SEL_SCREEN - General Selection Criteria for FMF
            FVSN - Budget Versions
                BPBTX - Totals records: overall budget for fund
                    EPBT - Line Items: Overall Budget
                    VEPT - Line items: Commitment/actual for annual budget
                BPBYX - Totals records: annual budget
                    EPBY - Annual budget line items
                    VEPY - Line items: Commitment/actual for annual budget
                BPBPX - Totals Records: Period Budget
                    EPBP - Line Items: Period Budget
            FMTOX - Totals Records: Commitment and Actual
            FFND - Fund
            FMOIX - Line Items
            FMFIX - Line Items from FI Documents
                FMBKPF - FI Documents: Relevant Fields in Document Header
            FMCOX - Line Items from CO Postings
            FMCFX - Year-End Closing
                FMRU - Carryforward Rules for Year-End Closing
            FCTR - Funds Centers
            FPOS - Commitment Items
            FNCT - Functional Area
            FMAA - FM Account Assignments
                FMAAREL - Assigned FM Account Assignments
                    FMFUDRULE - Rules for Revenues Increasing Budget
                FMSNREL - Assigned FM Acct Asst to Collective Expenditures