The FMFCTR table in SAP ERP or S/4HANA stores Funds Center Master Record data. There are total 63 fields in FMFCTR table. The Funds Center Master Record table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMFCTR table. It is in Funds Management: Master Data Core Objects (FMMD_CORE) ABAP package and is part of the Master Data (PSM-FM-MD) module.
SAP FMFCTR Table Fields
Following is the list of fields that are available in SAP FMFCTR table. The primary key fields of the table are MANDT (Client), FIKRS (Financial Management Area), FICTR (Funds Center), DATBIS (FM: Valid-To Date).
Field | Description | Data Element | Check Table | Data Type |
---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT (3) |
FIKRS | Financial Management Area | FIKRS | FM01 | CHAR (4) |
FICTR | Funds Center | FISTL | CHAR (16) | |
DATBIS | FM: Valid-To Date | FM_DATBIS | DATS (8) | |
DATAB | FM: Valid-From Date | FM_DATAB | DATS (8) | |
CTR_OBJNR | Object number | J_OBJNR | ONR00 | CHAR (22) |
ERFDAT | FIFM: Entry Date | FM_ERFDAT | DATS (8) | |
ERFNAME | FIFM: Created By | FM_ERFNAME | CHAR (12) | |
AENDAT | FIFM: Changed On | FM_AENDAT | DATS (8) | |
AENNAME | FIFM: Name of Last Person to Make a Change | FM_AENNAME | CHAR (12) | |
BOSS_CODE | FIFM: Code for a Person Responsible | FM_BOSSCOD | TCJ04 | NUMC (8) |
WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
BOSSOT | FIFM: Object Type for Funds Center Manager in HR | FM_BOSSOT | * | CHAR (2) |
BOSSID | Funds Center Manager in Organization Model | FM_BOSSID | CHAR (12) | |
BOSSNAME | Name of Person Responsible | FM_BOSSNAM | CHAR (20) | |
FINCODE | Default Fund Value in a Funds Center | FM_DFONDS | FMFINCODE | CHAR (10) |
AUGRP | Funds Center Authorization Group | FM_AUTHGRC | CHAR (10) | |
BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
GSBER | Business Area | GSBER | TGSB | CHAR (4) |
LOGSYSTEM | Logical System | LOGSYSTEM | TBDLS | CHAR (10) |
DECKUNG | Relevant for Real Cover Eligibility | FM_DECKUNG | CHAR (1) | |
DATE_EXP | Expiration Date | FM_DATE_EXP | DATS (8) | |
ANREDE | Title | ANRED | CHAR (15) | |
NAME1 | Name 1 | NAME1_GP | CHAR (35) | |
NAME2 | Name 2 | NAME2_GP | CHAR (35) | |
NAME3 | Name 3 | NAME3_GP | CHAR (35) | |
NAME4 | Name 4 | NAME4_GP | CHAR (35) | |
STRASSE | Street and House Number | STRAS_GP | CHAR (35) | |
POSTLZ | Postal Code | PSTLZ | CHAR (10) | |
ORT | City | ORT01_GP | CHAR (35) | |
ORTSTEIL | District | ORT02_GP | CHAR (35) | |
POSTFACH | PO Box | PFACH | CHAR (10) | |
POSTLZFACH | P.O. Box Postal Code | PSTL2 | CHAR (10) | |
LAND1 | Country/Region Key | LAND1 | T005 | CHAR (3) |
REGION | Region (State, Province, County) | REGIO | T005S | CHAR (3) |
SPRAS | Language Key | SPRAS | T002 | LANG (1) |
TELEBOX | Telebox number | TELBX | CHAR (15) | |
TELEFON1 | First telephone number | TELF1 | CHAR (16) | |
TELEFON2 | Second telephone number | TELF2 | CHAR (16) | |
TELEFAX | Fax Number | TELFX | CHAR (31) | |
TELETEXT | Teletex number | TELTX | CHAR (30) | |
TELEX | Telex number | TELX1 | CHAR (30) | |
DATENLTNR | Data communication line no. | DATLT | CHAR (14) | |
AGCYCODE | Agency Code | CNFM_AGCYCODE | CHAR (30) | |
ORGCODE | Organization Code | CNFM_ORGCODE | CHAR (21) | |
AGCYTYPE | Agency Type | CNFM_AGCYTYPE | CNFMC_AGCYTYPE | CHAR (1) |
SUPTYPE | Fund Supply Type | CNFM_SUPTYPE | CNFMC_SUPTYPE | CHAR (1) |
REVUNIT | Revenue Unit | CNFM_REVUNIT | CHAR (1) | |
NEWPAY | Payment Reform | CNFM_NEWPAY | CHAR (1) | |
HBKID | Short Key for a House Bank | HBKID | * | CHAR (5) |
MINIS | Ministry | PFM_01MINISTERIO | PFM_TMINIS | CHAR (2) |
SECEST | Secretary of State | PFM_01SEC_ESTADO | PFM_TSECEST | CHAR (1) |
AREA | Fund Center area | PFM_01AREA | PFM_01TP25 | CHAR (2) |
SERFA | Services and independent funds | PFM_01SERVFAUT | PFM_01TP26 | CHAR (2) |
ORGAN | Fund Center organization | PFM_01ORGANISMO | PFM_01TP27 | CHAR (3) |
CAPI | Chapter | PFM_01CAPITULO | PFM_TCAPI | CHAR (2) |
DIVI | Business area | PFM_01DIVISAO | PFM_TDIVI | CHAR (2) |
SUBD | Subdivision | PFM_01SUBDIVISAO | PFM_TSUBD | CHAR (2) |
TORC | Budget type | PFM_TORC | PFM_TSUBD | CHAR (1) |
STR_ID | Master Data Subdivision ID | FM_STR_ID | FMMDSTRID | CHAR (10) |
FCSUB1 | Substring 1 of Funds Center | FM_FCSUB1 | FMMDFCSUB1 | CHAR (10) |
FCSUB2 | Substring 2 of Funds Center | FM_FCSUB2 | FMMDFCSUB2 | CHAR (10) |
FCSUB3 | Substring 3 of Funds Center | FM_FCSUB3 | FMMDFCSUB3 | CHAR (10) |