SAP FNCT Functional Area for Logical Database FMF Table data and field list

FNCT 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 "Functional Area for Logical Database FMF" 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_FNCT TYPE FNCT.

The FNCT table consists of various fields, each holding specific information or linking keys about Functional Area for Logical Database FMF data available in SAP. These include FTEXT (Name of the functional area), AUTHGRP (FM: Authorization Group of Functional Area), STR_ID (Master Data Subdivision ID), FNSUB1 (Substring 1 of 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. .

FNCT structure Technical Details:

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


SAP FNCT 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 FNCT 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
FAREAFunctional Area FM_FAREACHAR16TFKBFKBERFBE
FTEXTName of the functional area FKBTXCHAR25TEXT25
AUTHGRPFM: Authorization Group of Functional Area FM_AUTHGR_FAREACHAR10CHAR10
STR_IDMaster Data Subdivision ID FM_STR_IDCHAR10CHAR10FMS
FNSUB1Substring 1 of Functional Area FM_FNSUB1CHAR10CHAR10
FNSUB2Substring 2 of Functional Area FM_FNSUB2CHAR10CHAR10
FNSUB3Substring 3 of Functional Area FM_FNSUB3CHAR10CHAR10
FNSUB1T_SHDescription 1 of Substring 1 of Functional Area FM_FNSUB1T_SHCHAR50CHAR50
FNSUB1T_LODescription 2 of Substring 1 of Functional Area FM_FNSUB1T_LOCHAR50CHAR50
FNSUB2T_SHDescription 1 of Substring 2 of Functional Area FM_FNSUB2T_SHCHAR50CHAR50
FNSUB2T_LODescription 2 of Substring 2 of Functional Area FM_FNSUB2T_LOCHAR50CHAR50
FNSUB3T_SHDescription 1 of Substring 3 of Functional Area FM_FNSUB3T_SHCHAR50CHAR50
FNSUB3T_LODescription 2 of Substring 3 of Functional Area FM_FNSUB3T_LOCHAR50CHAR50

Key field Non-key field



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

As FNCT 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 FNCT as there is no data to select.

How to access SAP table FNCT

Within an ECC or HANA version of SAP you can also view further information about FNCT 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 FNCT

    FKRS - Financial Management Area
        FMB_SEL_SCREEN - General selection criteria
    FMAA_CO - FMAA - Availability Control Objects
        FMAA_BA - FMAA - Budget Addresses
            FMAA_PA - FMAA - Posting Addresses
    FMAA_CO_CG - FMAA - Avail. Control Objects of Aut. Cover Group
        FMAA_BA_CG - FMAA - Budget Addresses of Automatic Cover Group
            FMAA_PA_CG - FMAA - Posting Addresses of Automatic Cover Group
    AVCT - AVC Totals (BCS)
        BUDT - Budget Totals (BCS)
            BUDP - Budget Line Items (BCS)
            BUHL - Budget Entry Documents (BCS)
    FFND - Funds
            CONVAL - Consumed Values (BCS)
    FMTOX - Totals Records: Commitments and Actuals
    FMOIX - Line Items of Commitment Documents
    FMFIX - Line Items of FI Documents
        FMBKPF - FI Documents: Relevant Fields in Document Header
    FMCOX - Line Items of CO Documents
    FBPD - Budget Period
    FCTR - Funds centers
    FPOS - Commitment items
    FNCT - Functional Areas
    FMAS - Funded Programs
    FGMG - Grants
    BVSN - Budget/planning version

    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