SAP FMFGKEY97 Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2T Table data and field list

FMFGKEY97 is a standard SAP Table which is used to store Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2T data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMFGKEY97 table consists of various fields, each holding specific information or linking keys about Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2T data available in SAP. These include FMFG_SUBKEY (Subkey for FMUSFGFACTS2T), RFISTL (Funds Center), MEASURE (Funded Program), TRANSFER_AGCY_9 (Transfer Agency)... 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. .

FMFGKEY97 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP FMFGKEY97 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 FMFGKEY97 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
FMFG_SUBKEYSubkey for FMUSFGFACTS2T FMFG_SUBKEY97CHAR10CHAR10
RFISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
TRANSFER_AGCY_9Transfer Agency FMFG_TRANSFER_AGCYCHAR2Assigned to domainFMFG_TRANSFER
TRANSFER_ACCT_9Transfer Account FMFG_TRANSFER_ACCTCHAR4Assigned to domainFMFG_TRAN_ACCT
YEAR_BDGT_AUTH_9Year of Budget Authority FMFG_YR_BUD_AUTHCHAR4FMFG_YR_BUD_AUTH
FLG_ADVANCE_9Advanced Flag FM_FLG_ADVANCECHAR1FMFG_FLG_ADVANCE
DEFENSE_INDIC_9Defense Indicator FMFG_DEFENSE_INDICATORCHAR3FMFG_DEFENSE_INDICATOR
PROG_REPT_CAT_9Program Reporting Category FMFG_PROGRAM_REPORT_CATEGORYCHAR3FMFG_PROGRAM_REPORT_CATEGORY
BUDGET_PD_9FM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER

Key field Non-key field



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

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

SELECT SINGLE *
FROM FMFGKEY97
INTO CORRESPONDING FIELDS OF WA_FMFGKEY97
WHERE...

How to access SAP table FMFGKEY97

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

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