The FMCFSIF table in SAP ERP or S/4HANA stores FI-FM: Selected Open Documents from FI Update data. There are total 40 fields in FMCFSIF table. The FI-FM: Selected Open Documents from FI Update 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 FMCFSIF table. It is in FIFM: Basis (FMBS) ABAP package and is part of the Funds Management (FI-FM) module.
SAP FMCFSIF Table Fields
Following is the list of fields that are available in SAP FMCFSIF table. The primary key fields of the table are MANDT (Client), FMBELNR (Document Number of FM Line Item), FIKRS (Financial Management Area), FMBUZEI (Number of a posting line in a TR-FM line item), RLDNR (Ledger), GJAHR (Fiscal Year), STUNR (Number That Clearly Identifies the Line Key in Database), XREAL (Checkbox).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| FMBELNR | Document Number of FM Line Item | FM_BELNR | CHAR (10) | |
| FIKRS | Financial Management Area | FIKRS | FM01 | CHAR (4) |
| FMBUZEI | Number of a posting line in a TR-FM line item | FM_BUZEI | NUMC (3) | |
| RLDNR | Ledger | RLDNR | CHAR (2) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| STUNR | Number That Clearly Identifies the Line Key in Database | FM_STUNR | CHAR (16) | |
| XREAL | Checkbox | XFELD | CHAR (1) | |
| TWAER | Transaction Currency | TWAER | CUKY (5) | |
| FKBTR | Balance carried forward in local currency | HSLVT9_CS | CURR (17) | |
| TRBTR | Balance carried forward in transaction currency | TSLVT9_CS | CURR (17) | |
| BUKRS_REF | Company Code | BUKRS | CHAR (4) | |
| GJAHR_REF | Fiscal Year | GJAHR | NUMC (4) | |
| BELNR_REF | Accounting Document Number | BELNR_D | CHAR (10) | |
| BUZEI_REF | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| WRTTP | Value Type | CO_WRTTP | CHAR (2) | |
| CFSTAT | FM Commitment Carryforward: Status | FM_CFST | NUMC (2) | |
| CPUDTSEL | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTMSEL | Time of Entry | CPUTM | TIMS (6) | |
| UNAMESEL | User Name | UNAME | CHAR (12) | |
| CPUDTCF | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTMCF | Time of Entry | CPUTM | TIMS (6) | |
| UNAMECF | User Name | UNAME | CHAR (12) | |
| FISTL | Funds Center | FISTL | CHAR (16) | |
| FONDS | Fund | BP_GEBER | CHAR (10) | |
| FIPOS | Commitment Item | FIPOS | CHAR (14) | |
| FIPEX | Commitment item | FM_FIPEX | CHAR (24) | |
| FAREA | Functional Area | FM_FAREA | CHAR (16) | |
| FISTL_E | Funds Center | FISTL | CHAR (16) | |
| FONDS_E | Fund | BP_GEBER | CHAR (10) | |
| FIPOS_E | Commitment Item | FIPOS | CHAR (14) | |
| FIPEX_E | Commitment item | FM_FIPEX | CHAR (24) | |
| FAREA_E | Functional Area | FM_FAREA | CHAR (16) | |
| CFRULE | FM Carryforward Rule (Fiscal Year Change) | FM_CFRULE | CHAR (10) | |
| FLG_AC | Checkbox | XFELD | CHAR (1) | |
| GNJHR | Year of Cash Effectivity | GNJHR | NUMC (4) | |
| RLDNR_E | Ledger | RLDNR | CHAR (2) | |
| CFLEV | Carryforward Level | FM_CFLEV | CHAR (1) | |
| STATS | Funds Management Statistical Indicator | FM_STATS | CHAR (1) | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) |
