FMFINCODE SAP (FIFM: Financing code) Table details
Dictionary Type: Table
Description: FIFM: Financing code
Description: FIFM: Financing code
Table field list including key, data, relationships and ABAP select examples
FMFINCODE is a standard SAP Table which is used to store FIFM: Financing code data and is available within R/3 SAP systems depending on the version and release level.
The FMFINCODE table consists of various fields, each holding specific information or linking keys about FIFM: Financing code data available in SAP. These include FIKRS (Financial Management Area), FINCODE (Fund), SPONSOR (Customer account number for fund), FINUSE (Application of Secondary Source Funds).. 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)
Text table = FMFINT
SAP FMFINCODE 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 | ||
FINCODE | Fund | BP_GEBER | CHAR | 10 | BP_GEBER | FIC | |||
SPONSOR | Customer account number for fund | FM_SPONSOR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
FINUSE | Application of Secondary Source Funds | FM_FINUSE | CHAR | 16 | FMFUSE | FM_FINUSE | FIU | ||
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 | ||||
PROFIL | Budget profile for fund | BP_PROF_SP | CHAR | 6 | Assigned to domain | BP_PROFIL | BP1 | ||
KZBST | 'Balance update' indicator | FM_KZBST | CHAR | 1 | FM_KZBST | ||||
AUGRP | FM: Fund authorization group | FM_AUTHGRF | CHAR | 10 | CHAR10 | ||||
DATAB | FM: Valid from date | FM_DATAB | DATS | 8 | DATUM | FM_DATAB | |||
DATBIS | FM: Valid to date | FM_DATBIS | DATS | 8 | DATUM | FM_DATBIS | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
TYPE | FM Fund Type | FM_FUNDTYPE | CHAR | 6 | FMFUNDTYPE | FM_FUNDTYPE | |||
DATE_EXP | Expiration Date | FM_DATE_EXP | DATS | 8 | DATUM | ||||
DATE_CAN | Reversal Date | FM_DATE_CAN | DATS | 8 | DATUM | ||||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
DECKUNG | Relevant for Real Cover Eligibility | FM_DECKUNG | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
BLANK_BPD | Indicator: Blank Budget Period Allowed | FM_BLANK_BPD | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
STR_ID | Master Data Subdivision ID | FM_STR_ID | CHAR | 10 | FMMDSTRID | CHAR10 | FMS | ||
FDSUB1 | Substring 1 of Fund | FM_FDSUB1 | CHAR | 10 | FMMDFDSUB1 | CHAR10 | |||
FDSUB2 | Substring 2 of Fund | FM_FDSUB2 | CHAR | 10 | FMMDFDSUB2 | CHAR10 |
Key field | Non-key field |
How do I retrieve data from SAP table FMFINCODE using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMFINCODE to SELECT all data from the tableDATA: WA_FMFINCODE TYPE FMFINCODE.
SELECT SINGLE *
FROM FMFINCODE
INTO CORRESPONDING FIELDS OF WA_FMFINCODE
WHERE...
How to access SAP table FMFINCODE
Within an ECC or HANA version of SAP you can also view further information about FMFINCODE 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