SAP FMKF_TERM Key Figures - FM Terms Table data and field list

FMKF_TERM is a standard SAP Table which is used to store Key Figures - FM Terms data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMKF_TERM table consists of various fields, each holding specific information or linking keys about Key Figures - FM Terms data available in SAP. These include KEYFIG (ID of the Key Figure), DATASOURCE (Key Figures - Data source), TERMNUM (Row number), SIGN (Key Figures - Sign of the term)... 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. .

FMKF_TERM table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP FMKF_TERM table 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 FMKF_TERM 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
CLIENTClient MANDTCLNT3T000MANDT
KEYFIGID of the Key Figure BUKF_KEYFIGCHAR15BUKF_KFBUKF_KEYFIG
DATASOURCEKey Figures - Data source BUKF_DATASOURCECHAR4BUKF_DSRCCHAR4
TERMNUMRow number FC_LINENUMNUMC4NUMC04
SIGNKey Figures - Sign of the term BUKF_SIGNCHAR1SIGN_CL
VERSIONKey Figures - Version BUKF_VERSIONCHAR3ALPHABUKF_VERSION
BUDCATKey Figures - Budget Category BUKF_BUDCATCHAR2CHAR2
VALTYPEKey Figures - Value Type BUKF_VALTYPECHAR2CHAR2
PROCESSKey Figures - Process BUKF_PROCESSCHAR4CHAR4
BUDTYPEKey Figures - Budget Type BUKF_BUDTYPECHAR4CHAR4
WFSTATEKey Figures - Workflow Status BUKF_WFSTATECHAR1CHAR1
FISCYEARKey Figures - Fiscal Year BUKF_FISCYEARCHAR4BUKF_YEAR
CEFFYEARKey Figures - Year of cash effectivity BUKF_CEFFYEARCHAR4BUKF_YEAR
CTEM_CATEGORYKey figure - Commitment item category BUKF_FM_POTYPCHAR1CHAR1
PERIODKey Figures - Period BUKF_PERIODCHAR3BUKF_PERIOD

Key field Non-key field



How do I retrieve data from SAP table FMKF_TERM using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMKF_TERM to SELECT all data from the table
DATA: WA_FMKF_TERM TYPE FMKF_TERM.

SELECT SINGLE *
FROM FMKF_TERM
INTO CORRESPONDING FIELDS OF WA_FMKF_TERM
WHERE...

How to access SAP table FMKF_TERM

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

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