FMCFSIO SAP (FI-FM: Selected Open Commitment Documents) Table details
Dictionary Type: Table
Description: FI-FM: Selected Open Commitment Documents
Description: FI-FM: Selected Open Commitment Documents
Table field list including key, data, relationships and ABAP select examples
FMCFSIO is a standard SAP Table which is used to store FI-FM: Selected Open Commitment Documents data and is available within R/3 SAP systems depending on the version and release level.
The FMCFSIO table consists of various fields, each holding specific information or linking keys about FI-FM: Selected Open Commitment Documents data available in SAP. These include REFBN (Reference Document Number), REFBT (Reference document category), RFORG (Reference Organizational Units), RFPOS (Item number of reference document).. 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. .
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 or numeric)
SAP FMCFSIO table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
REFBN | Reference Document Number | CO_REFBN | CHAR | 10 | ALPHA | BELNR | |||
REFBT | Reference document category | FM_REFBTYP | NUMC | 3 | FM_REFBTYP | ||||
RFORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
RFPOS | Item number of reference document | CC_RFPOS | NUMC | 5 | NUMC05 | ||||
RFKNT | Account assignment number of reference document | CC_RFKNT | NUMC | 5 | NUMC05 | ||||
RFETE | Reference document classification number | CC_RFETE | NUMC | 4 | Assigned to domain | ETENR | |||
RCOND | Counter Conditions and Level Number | RCOND | NUMC | 5 | RCOND | ||||
RFTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
RFSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
RLDNR | Ledger | RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN | H_T881 |
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
STUNR | Number that clearly identifies the line key in database | FM_STUNR | CHAR | 16 | CHAR16 | ||||
XREAL | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
TWAER | Transaction Currency | TWAER | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
FKBTR | Balance carried forward in local currency | HSLVT9 | CURR | 17(2) | WERTV9 | ||||
TRBTR | Balance carried forward in transaction currency | TSLVT9 | CURR | 17(2) | WERTV9 | ||||
WRTTP | Value Type | FM_WRTTP | CHAR | 2 | FM_WRTTP | ||||
CFSTAT | FM Commitment Carryforward: Status | FM_CFST | NUMC | 2 | FM_CFST | ||||
CPUDTSEL | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTMSEL | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
UNAMESEL | User Name | UNAME | CHAR | 12 | UNAME | ||||
CPUDTCF | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTMCF | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
UNAMECF | User Name | UNAME | CHAR | 12 | UNAME | ||||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FONDS | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
FAREA | Functional Area | FM_FAREA | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
FISTL_E | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FONDS_E | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FIPOS_E | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FIPEX_E | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
FAREA_E | Functional Area | FM_FAREA | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
CFRULE | FM carryforward rule (FYC) | FM_CFRULE | CHAR | 10 | FM_CFRULE | CFR | |||
FLG_AC | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
GNJHR | Year of Cash Effectivity | GNJHR | NUMC | 4 | GJAHR | GJAHR | GNJHR | ||
RLDNR_E | Ledger | RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN | H_T881 |
CFLEV | Carryforward level | FM_CFLEV | CHAR | 1 | FM_CFLEV | ||||
STATS | Funds Management Statistical Indicator | FM_STATS | CHAR | 1 | FM_STATS | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC |
Key field | Non-key field |
How do I retrieve data from SAP table FMCFSIO using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMCFSIO to SELECT all data from the tableDATA: WA_FMCFSIO TYPE FMCFSIO.
SELECT SINGLE *
FROM FMCFSIO
INTO CORRESPONDING FIELDS OF WA_FMCFSIO
WHERE...
How to access SAP table FMCFSIO
Within an ECC or HANA version of SAP you can also view further information about FMCFSIO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects