FMFUSE SAP (FIFM: Application of Funds from Secondary Sources) Table details
Dictionary Type: Table
Description: FIFM: Application of Funds from Secondary Sources
Description: FIFM: Application of Funds from Secondary Sources
Table field list including key, data, relationships and ABAP select examples
FMFUSE is a standard SAP Table which is used to store FIFM: Application of Funds from Secondary Sources data and is available within R/3 SAP systems depending on the version and release level.
The FMFUSE table consists of various fields, each holding specific information or linking keys about FIFM: Application of Funds from Secondary Sources data available in SAP. These include FIKRS (Financial Management Area), FINUSE (Application of Secondary Source Funds), DATAB (FM: Valid from date), DATBIS (FM: Valid to date).. 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)
Text table = FMFUSET
SAP FMFUSE 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 | |||
| FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
| FINUSE | Application of Secondary Source Funds | FM_FINUSE | CHAR | 16 | FM_FINUSE | FIU | |||
| DATAB | FM: Valid from date | FM_DATAB | DATS | 8 | DATUM | FM_DATAB | |||
| DATBIS | FM: Valid to date | FM_DATBIS | DATS | 8 | DATUM | FM_DATBIS | |||
| ERFNAME | FIFM: Created by | FM_ERFNAME | CHAR | 12 | USNAM | ||||
| ERFDAT | FIFM: Entry Date | FM_ERFDAT | DATS | 8 | DATUM | ||||
| AENNAME | FIFM: Name of Last Person to Make a Change | FM_AENNAME | CHAR | 12 | USNAM | ||||
| AENDAT | FIFM: Changed on | FM_AENDAT | DATS | 8 | DATUM | ||||
| DEPT_REG | Treasury Account Symbol - Department Regular | FM_DEPT_REG | CHAR | 2 | FM_DEPT_REG | ||||
| DEPT_TRAN | Treasury Account Symbol - Department Transfer | FM_DEPT_TRAN | CHAR | 2 | FM_DEPT_TRAN | ||||
| FISCAL_YR | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
| MAIN_ACCT | Treasury Account Symbol - Main Account | FM_MAIN_ACCT | CHAR | 4 | FM_MAIN_ACCT | ||||
| SUB_ACCT | Treasury Account Symbol - Subaccount | FM_SUB_ACCT | CHAR | 3 | FM_SUB_ACCT | ||||
| SPLIT_NUM | Treasury Account Symbol - account split sequence number | FM_SPLIT_NUM | CHAR | 3 | FM_SPLIT_NUM | ||||
| FACTSII_REL | Relevant for FACTS II | FMFG_FACTSII_REL | CHAR | 1 | FMFG_FACTSII_REL | ||||
| PREPARERID | Preparer ID | FM_PREPARER | CHAR | 8 | |||||
| CERTIFIERID | Certifier ID | FMFG_CERTIFIERID | CHAR | 8 | |||||
| .INCLU--AP | 0 | ||||||||
| GTAS_REL | GTAS Relevant Indicator | FMFG_GTAS_REL | CHAR | 1 | FMFG_GTAS_REL | ||||
| SUBLEVL | Sublevel Prefix (SP) | FMFG_SUBLEVL | CHAR | 2 | FMFG_SUBLEVL | ||||
| AGENCID | Agency Identifier (AID) | FMFG_AGENCID | CHAR | 3 | FMFG_AGENCID | ||||
| ALTRAID | Allocation Transfer Agency Identifier (ATA) | FMFG_ALTRAID | CHAR | 3 | FMFG_ALTRAID | ||||
| BEGPER | Beginning Period of Availability (BPOA) | FMFG_BEGPER | NUMC | 4 | GJAHR | FMFG_BEGPER | |||
| ENDPER | Ending Period of Availability (EPOA) | FMFG_ENDPER | NUMC | 4 | GJAHR | FMFG_ENDPER | |||
| AVTYPE | Availability Type Code (A) | FMFG_AVTYPE | CHAR | 1 | FMFG_AVTYPE |
| Key field | Non-key field |
How do I retrieve data from SAP table FMFUSE using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMFUSE to SELECT all data from the tableDATA: WA_FMFUSE TYPE FMFUSE.
SELECT SINGLE *
FROM FMFUSE
INTO CORRESPONDING FIELDS OF WA_FMFUSE
WHERE...
How to access SAP table FMFUSE
Within an ECC or HANA version of SAP you can also view further information about FMFUSE 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