SAP ABAP Table IFMFINCODE (Structure of table FMFINCODE, plus text)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-FM (Application Component) Funds Management
     ⤷ FMRP_CORE (Package) Funds Management: Information System Core Objects

Basic Data

Table Category	INTTAB	Structure
Structure	IFMFINCODE	Table Relationship Diagram
Short Description	Structure of table FMFINCODE, plus text

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	FIFM: Financing code
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
4	FINCODE	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
5	SPONSOR	☐	FM_SPONSOR	KUNNR	CHAR	10	0	Customer account number for fund	KNA1
6	FINUSE	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	FMFUSE
7	ERFNAME	☐	FM_ERFNAME	USNAM	CHAR	12	0	FIFM: Created by
8	ERFDAT	☐	FM_ERFDAT	DATUM	DATS	8	0	FIFM: Entry Date
9	AENNAME	☐	FM_AENNAME	USNAM	CHAR	12	0	FIFM: Name of Last Person to Make a Change
10	AENDAT	☐	FM_AENDAT	DATUM	DATS	8	0	FIFM: Changed on
11	PROFIL	☐	BP_PROF_SP	BP_PROFIL	CHAR	6	0	Budget profile for fund	*
12	KZBST	☐	FM_KZBST	FM_KZBST	CHAR	1	0	"Balance update" indicator
13	AUGRP	☐	FM_AUTHGRF	CHAR10	CHAR	10	0	FM: Fund authorization group
14	DATAB	☐	FM_DATAB	DATUM	DATS	8	0	FM: Valid from date
15	DATBIS	☐	FM_DATBIS	DATUM	DATS	8	0	FM: Valid to date
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
17	TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	FMFUNDTYPE
18	DATE_EXP	☐	FM_DATE_EXP	DATUM	DATS	8	0	Expiration Date
19	DATE_CAN	☐	FM_DATE_CAN	DATUM	DATS	8	0	Reversal Date
20	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
21	DECKUNG	☐	FM_DECKUNG	XFELD	CHAR	1	0	Relevant for Real Cover Eligibility
22	.INCLUDE	☐				0	0
23	.INCLU--AP	☐				0	0	Additional fields for Budget Period
24	BLANK_BPD	☐	FM_BLANK_BPD	XFELD	CHAR	1	0	Indicator: Blank Budget Period Allowed
25	.INCLU--AP	☐				0	0	Append for Fund substrings
26	.INCLUDE	☐				0	0	Substructure Fonds
27	STR_ID	☐	FM_STR_ID	CHAR10	CHAR	10	0	Master Data Subdivision ID	FMMDSTRID
28	FDSUB1	☐	FM_FDSUB1	CHAR10	CHAR	10	0	Substring 1 of Fund	FMMDFDSUB1
29	FDSUB2	☐	FM_FDSUB2	CHAR10	CHAR	10	0	Substring 2 of Fund	FMMDFDSUB2
30	BEZEICH	☐	FM_BEZEICH	TEXT20	CHAR	20	0	Name
31	BESCHR	☐	FM_BESCHR	TEXT40	CHAR	40	0	Description
32	.INCLUDE	☐				0	0	Fund: Text Fields for Screens
33	FIKRS_TXT	☐	FITXT	TEXT25	CHAR	25	0	Name of FM area
34	FINUSE_TXT	☐	FM_BEZEICH	TEXT20	CHAR	20	0	Name
35	PROFIL_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
36	PERIV_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
37	SPONSOR_TXT	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
38	TYPE_TXT	☐	FM_FUNDTYPET	FM_FUNDTYPET	CHAR	35	0	FM Fund Type Description
39	.INCLUDE	☐				0	0	Screen for Alternative Long Text Maintenance
40	ID	☐	FM_TTXID_ID	FM_TTXID_ID	NUMC	2	0	Text types
41	TDTEXT	☐	TDTEXT	TDTEXT	CHAR	30	0	Short text
42	LTEXT	☐	TXLINE	TXLINE	CHAR	72	0	Text editor text line
43	LTXKZ	☐	LTXKZ	XFELD	CHAR	1	0	More Text Exists
44	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
45	.INCLU--AP	☐				0	0	Append for Fund substring texts
46	.INCLUDE	☐				0	0	Substructures of Funds - Text descriptions
47	FDSUB1T_SH	☐	FM_BESCHR1	TEXT50	CHAR	50	0	Description 1
48	FDSUB1T_LO	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2
49	FDSUB2T_SH	☐	FM_BESCHR1	TEXT50	CHAR	50	0	Description 1
50	FDSUB2T_LO	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMFINCODE	FDSUB1	FMMDFDSUB1	FDSUB1
2	IFMFINCODE	FDSUB2	FMMDFDSUB2	FDSUB2
3	IFMFINCODE	FIKRS	FM01	FIKRS	KEY	1	CN
4	IFMFINCODE	FINUSE	FMFUSE	FINUSE	KEY	1	CN
5	IFMFINCODE	LOGSYSTEM	TBDLS	LOGSYS	REF
6	IFMFINCODE	MANDT	T000	MANDT	KEY	1	CN
7	IFMFINCODE	PERIV	T009	PERIV	REF	1	CN
8	IFMFINCODE	SPONSOR	KNA1	KUNNR	KEY	1	CN
9	IFMFINCODE	STR_ID	FMMDSTRID	STR_ID
10	IFMFINCODE	TYPE	FMFUNDTYPE	FUND_TYPE	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in