SAP ABAP Table FMAA (FM Account Assignment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FI-FM-IS (Application Component) Information System
     ⤷ FMRP (Package) ISPS reporting

Basic Data

Table Category	INTTAB	Structure
Structure	FMAA	Table Relationship Diagram
Short Description	FM Account Assignment

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	GJAHR	☐	FM_PGJAHR	GJAHR	NUMC	4	0	Fiscal Year of Commitment Item
2	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
3	FNAME	☐	FM_FNAME	TEXT20	CHAR	20	0	Fund name
4	FDSCR	☐	FM_BESCHR	TEXT40	CHAR	40	0	Description
5	SPONSOR	☐	FM_SPONSOR	KUNNR	CHAR	10	0	Customer account number for fund	KNA1
6	NAME1_FONDS	☐	FM_SPONTXT	NAME	CHAR	35	0	Source of funds name (customer name 1)
7	FINUSE	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	FMFUSE
8	UNAME	☐	FM_FUSETXT	TEXT20	CHAR	20	0	Application of funds description
9	UDSCR	☐	FM_FUSEBSH	TEXT40	CHAR	40	0	Application of funds description
10	AUGRP_FONDS	☐	FM_AUTHGRF	CHAR10	CHAR	10	0	FM: Fund authorization group
11	FUND_TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	FMFUNDTYPE
12	FUND_TYPET	☐	FM_FUNDTYPET	FM_FUNDTYPET	CHAR	35	0	FM Fund Type Description
13	PROFIL	☐	BP_BPROFIL	BP_PROFIL	CHAR	6	0	Budget Profile	TBP1C
14	KZBST	☐	FM_KZBST	FM_KZBST	CHAR	1	0	"Balance update" indicator
15	ERFNAME_FONDS	☐	FM_ERFNAME	USNAM	CHAR	12	0	FIFM: Created by
16	ERFDAT_FONDS	☐	FM_ERFDAT	DATUM	DATS	8	0	FIFM: Entry Date
17	AENNAME_FONDS	☐	FM_AENNAME	USNAM	CHAR	12	0	FIFM: Name of Last Person to Make a Change
18	AENDAT_FONDS	☐	FM_AENDAT	DATUM	DATS	8	0	FIFM: Changed on
19	DATAB_FONDS	☐	FM_DATAB	DATUM	DATS	8	0	FM: Valid from date
20	DATBIS_FONDS	☐	FM_DATBIS	DATUM	DATS	8	0	FM: Valid to date
21	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
22	DATE_EXP	☐	FM_DATE_EXP	DATUM	DATS	8	0	Expiration Date
23	DATE_CAN	☐	FM_DATE_CAN	DATUM	DATS	8	0	Reversal Date
24	LOGSYSTEM_FONDS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
25	FDSTR_ID	☐	FM_FDSTR_ID	CHAR10	CHAR	10	0	Subdivision ID of the fund	FMMDSTRID
26	FDSUB1	☐	FM_FDSUB1	CHAR10	CHAR	10	0	Substring 1 of Fund
27	FDSUB2	☐	FM_FDSUB2	CHAR10	CHAR	10	0	Substring 2 of Fund
28	.INCLUDE	☐				0	0	Substructures of Funds - Text descriptions
29	FDSUB1T_SH	☐	FM_BESCHR1	TEXT50	CHAR	50	0	Description 1
30	FDSUB1T_LO	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2
31	FDSUB2T_SH	☐	FM_BESCHR1	TEXT50	CHAR	50	0	Description 1
32	FDSUB2T_LO	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2
33	.INCLUDE	☐				0	0
34	FICTR	☐	FM_FICTR	FISTL	CHAR	16	0	Funds Center	FMFCTR
35	CNAME	☐	FM_CNAME	TEXT20	CHAR	20	0	Funds center name
36	CDSCR	☐	FM_BESCHR	TEXT40	CHAR	40	0	Description
37	CLEVL	☐	FM_CTRLEVL	INT4	INT4	10	0	Level in funds center hierarchy
38	HIVARNT	☐	FM_HIVARNT	FM_HIVARNT	CHAR	4	0	Hierarchy Variant of Funds Center	FMHIVARNT
39	FICTR_UP	☐	FM_HFICTR	FISTL	CHAR	16	0	Superior funds center	FMFCTR
40	CTR_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
41	DATBIS	☐	DATBI	DATUM	DATS	8	0	Valid To Date
42	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
43	AUGRP_FICTR	☐	FM_AUTHGRC	CHAR10	CHAR	10	0	FM: Funds center authorization group
44	ERFDAT_FICTR	☐	FM_ERFDAT	DATUM	DATS	8	0	FIFM: Entry Date
45	ERFNAME_FICTR	☐	FM_ERFNAME	USNAM	CHAR	12	0	FIFM: Created by
46	AENDAT_FICTR	☐	FM_AENDAT	DATUM	DATS	8	0	FIFM: Changed on
47	AENNAME_FICTR	☐	FM_AENNAME	USNAM	CHAR	12	0	FIFM: Name of Last Person to Make a Change
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
50	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
51	LOGSYSTEM_FICTR	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
52	BOSS_CODE	☐	FM_BOSSCOD	PS_VERNR	NUMC	8	0	FIFM: Code for a Person Responsible	TCJ04
53	BOSSOT	☐	FM_BOSSOT	OTYPE	CHAR	2	0	FIFM: Object Type for Funds Center Manager in HR	T778O
54	BOSSID	☐	FM_BOSSID	HROBJID_12	CHAR	12	0	Funds Center Manager in Organization Model
55	BOSSNAME	☐	FM_BOSSNAM	TEXT20	CHAR	20	0	FM: Name of Person Responsible
56	DFINCODE	☐	FM_DFONDS	BP_GEBER	CHAR	10	0	Fund (Default Value in a Funds Center)	FMFINCODE
57	FCSTR_ID	☐	FM_FCSTR_ID	CHAR10	CHAR	10	0	Subdivision ID of the funds center	FMMDSTRID
58	FCSUB1	☐	FM_FCSUB1	CHAR10	CHAR	10	0	Substring 1 of Funds Center
59	FCSUB2	☐	FM_FCSUB2	CHAR10	CHAR	10	0	Substring 2 of Funds Center
60	FCSUB3	☐	FM_FCSUB3	CHAR10	CHAR	10	0	Substring 3 of Funds Center
61	.INCLUDE	☐				0	0	Substructures of Fund Center - Text Descriptions
62	FCSUB1T_SH	☐	FM_FCSUB1T_SH	TEXT50	CHAR	50	0	Description 1 of Substring 1 of Funds Center
63	FCSUB1T_LO	☐	FM_FCSUB1T_LO	TEXT50	CHAR	50	0	Description 2 of Substring 1 of Funds Center
64	FCSUB2T_SH	☐	FM_FCSUB2T_SH	TEXT50	CHAR	50	0	Description 1 of Substring 2 of Funds Center
65	FCSUB2T_LO	☐	FM_FCSUB2T_LO	TEXT50	CHAR	50	0	Description 2 of Substring 2 of Funds Center
66	FCSUB3T_SH	☐	FM_FCSUB3T_SH	TEXT50	CHAR	50	0	Description 1 of Substring 3 of Funds Center
67	FCSUB3T_LO	☐	FM_FCSUB3T_LO	TEXT50	CHAR	50	0	Description 2 of Substring 3 of Funds Center
68	.INCLUDE	☐				0	0
69	VARNT	☐	FM_VARNT	FM_VARNT	CHAR	3	0	Commitment Item Hierarchy Variant	FMCIVARNT
70	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	FMCI
71	PNAME	☐	FM_PNAME	TEXT20	CHAR	20	0	Commitment item name
72	TEXT1	☐	FM_BESCHR0	TEXT50	CHAR	50	0	Description
73	TEXT2	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2
74	TEXT3	☐	FM_BESCHR3	TEXT50	CHAR	50	0	Description 3
75	PLEVL	☐	FM_POSLEVL	INT4	INT4	10	0	Level in the commitment item hierarchy
76	DFICTR	☐	FM_DFICTR	FISTL	CHAR	16	0	Funds Center (Default Value in a Commitment Item)	FMFCTR
77	VPTYP	☐	FM_VPTYP	FM_VPTYP	CHAR	2	0	Carryforward item category for commitment item	FMVORTR0
78	SNTYP	☐	FM_COLLTYP	FM_COLLTYP	CHAR	1	0	Collective budget adminstration category
79	SNROL	☐	FM_COLLROL	FM_COLLECT	CHAR	1	0	Use type in collective budget administration
80	NDAKZ	☐	FM_NDAB	FM_NDAB	CHAR	1	0	Indicator: NDA Budget
81	AZPKZ	☐	FM_AZPB	FM_AZPB	CHAR	1	0	Indicator: Accrued Budget
82	KRGRP	☐	FM_KRGRP	FM_KRGRP	CHAR	4	0	Criterion category group	FMKRG
83	AUGRP_FIPEX	☐	FM_AUTHGRP	CHAR10	CHAR	10	0	Authorization Groups of the Commitment Item
84	STATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
85	NCBUD	☐	FM_NCBUD	XFELD	CHAR	1	0	No Budget for Future Years
86	POSIT	☐	FM_POSITI	BP_POSIT	CHAR	8	0	Internal commitment item (8 chars)
87	STVAR	☐	FM_STVAR	XFELD	CHAR	1	0	Standard variant
88	NEGBUD	☐	FM_NEG_BUDGET_FLG	XFELD	CHAR	1	0	Negative Budget Permitted
89	LOGSYSTEM_FIPEX	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
90	BUTYP	☐	BUTYP	PM_BUTYP	CHAR	4	0	Budget structure element type	*
91	EFICTR	☐	FM_SDFICTR	FISTL	CHAR	16	0	Balance Funds Center	FMFCTR
92	EFIPEX1	☐	FM_SDFIPEX	FM_FIPEX	CHAR	24	0	Balance Cmmt Item	FMCI
93	EFIPEX2	☐	FM_SDFIPX2	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+1	FMCI
94	EFIPEX3	☐	FM_SDFIPX3	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+2	FMCI
95	EFIPEX4	☐	FM_SDFIPX4	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+3	FMCI
96	EFIPEX5	☐	FM_SDFIPX5	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+4	FMCI
97	CISTR_ID	☐	FM_CISTR_ID	CHAR10	CHAR	10	0	Subdivision ID of the commitment item	FMMDSTRID
98	CISUB1	☐	FM_CISUB1	CHAR10	CHAR	10	0	Substring 1 of Commitment Item
99	CISUB2	☐	FM_CISUB2	CHAR10	CHAR	10	0	Substring 2 of Commitment Item
100	CISUB3	☐	FM_CISUB3	CHAR10	CHAR	10	0	Substring 3 of Commitment Item
101	CISUB4	☐	FM_CISUB4	CHAR10	CHAR	10	0	Substring 4 of Commitment Item
102	CISUB5	☐	FM_CISUB5	CHAR10	CHAR	10	0	Substring 5 of Commitment Item
103	.INCLUDE	☐				0	0	Subtructures of Commitment Item - Text descriptions
104	CISUB1T_SH	☐	FM_CISUB1T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 1 of Commitment Item
105	CISUB1T_LO	☐	FM_CISUB1T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 1 of Commitment Item
106	CISUB2T_SH	☐	FM_CISUB2T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 2 of Commitment Item
107	CISUB2T_LO	☐	FM_CISUB2T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 2 of Commitment Item
108	CISUB3T_SH	☐	FM_CISUB3T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 3 of Commitment Item
109	CISUB3T_LO	☐	FM_CISUB3T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 3 of Commitment Item
110	CISUB4T_SH	☐	FM_CISUB4T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 4 of Commitment Item
111	CISUB4T_LO	☐	FM_CISUB4T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 4 of Commitment Item
112	CISUB5T_SH	☐	FM_CISUB5T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 5 of Commitment Item
113	CISUB5T_LO	☐	FM_CISUB5T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 5 of Commitment Item
114	.INCLUDE	☐				0	0	Data Structure for Commitment Items in Chart of Cmmt Items
115	KATEG	☐	FM_KATEG	FM_KATEG	NUMC	1	0	Attribute: Can be Posted To
116	FIVOR	☐	FM_FIVOR	FM_FIVOR	NUMC	2	0	Financial transaction
117	POTYP	☐	FM_POTYP	FM_POTYP	NUMC	1	0	Commitment Item Category
118	KRTYP	☐	FM_KRTYP	FM_KRTYP	CHAR	5	0	Commitment item criterion category	FMKRTP
119	FPART	☐	FM_FPART	FM_FPART	CHAR	3	0	Commitment Item Type
120	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
121	FIPUP	☐	FIPEX_UP	FM_FIPEX	CHAR	24	0	Superior Commitment Item	*
122	.INCLUDE	☐				0	0	Local Authority Add.Fields for Cmmt Items in Chart of CIs
123	HSART	☐	FM_HSART	FM_HSART	CHAR	1	0	Commitment Item Type	FMHSART
124	GKFLG	☐	FM_GKFLG	XFELD	CHAR	1	0	Relevant to total costs
125	.INCLUDE	☐				0	0	Add.Local Authority Fields for Cmmt Items in FM Area/Fisc.Yr
126	DRUCK	☐	FM_DRUCK	XFELD	CHAR	1	0	Not relevant for budget print
127	CFFLG	☐	FM_CFFLG	XFELD	CHAR	1	0	Able to carry forward at fiscal year change
128	CVFLG	☐	FM_CVFLG	XFELD	CHAR	1	0	(Negative) clearing item
129	BEZIRK	☐	FM_BEZIRK	CHAR4	CHAR	4	0	District
130	BSAMT	☐	FM_BSAMT	FISTL	CHAR	16	0	Managed position / clearing lower section	FMFCTR
131	UBFLG	☐	FM_UBFLG	CHAR1	CHAR	1	0	Local authorities: Budget execution account
132	HSFLG	☐	FM_HSFLG	XFELD	CHAR	1	0	Budget balancing concept
133	.INCLUDE	☐				0	0
134	H_ID	☐	FM_BSPEL	FM_INTCNT	CHAR	10	0	Budget structure element (internal number)
135	POST_CARRIER	☐	BP_ACCAR	X	CHAR	1	0	Indicator: posting object
136	BUDGET_CARRIER	☐	BP_BPCAR	X	CHAR	1	0	Budget Object
137	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
138	FTEXT	☐	FKBTX	TEXT25	CHAR	25	0	Name of the functional area
139	FNSTR_ID	☐	FM_FNSTR_ID	CHAR10	CHAR	10	0	Subdivision ID of functional area	FMMDSTRID
140	FNSUB1	☐	FM_FNSUB1	CHAR10	CHAR	10	0	Substring 1 of Functional Area
141	FNSUB2	☐	FM_FNSUB2	CHAR10	CHAR	10	0	Substring 2 of Functional Area
142	FNSUB3	☐	FM_FNSUB3	CHAR10	CHAR	10	0	Substring 3 of Functional Area
143	.INCLUDE	☐				0	0	Substructures of Function - Text Descriptions
144	FNSUB1T_SH	☐	FM_FNSUB1T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 1 of Functional Area
145	FNSUB1T_LO	☐	FM_FNSUB1T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 1 of Functional Area
146	FNSUB2T_SH	☐	FM_FNSUB2T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 2 of Functional Area
147	FNSUB2T_LO	☐	FM_FNSUB2T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 2 of Functional Area
148	FNSUB3T_SH	☐	FM_FNSUB3T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 3 of Functional Area
149	FNSUB3T_LO	☐	FM_FNSUB3T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 3 of Functional Area
150	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
151	FP_CATEGORY	☐	PSM_FP_CATEGORY	PSM_FP_CATEGORY	CHAR	3	0	Funded Program Category
152	FP_TYPE	☐	PSM_FP_TYPE	PSM_FP_TYPE	CHAR	4	0	Funded Program Type	*
153	ME_VALID_FROM	☐	FM_DATAB	DATUM	DATS	8	0	FM: Valid from date
154	ME_VALID_TO	☐	FM_DATBIS	DATUM	DATS	8	0	FM: Valid to date
155	ME_AUTHGRP	☐	FM_AUTHGR_MEASURE	CHAR10	CHAR	10	0	FM: Funded Program Authorization Group
156	ME_SHORT_DESC	☐	FM_ME_NAME	TEXT20	CHAR	20	0	Name of Funded Program (20-character)
157	ME_DESCRIPTION	☐	FM_ME_DESC	TEXT50	CHAR	50	0	Description of Funded Program (50 character)
158	.INCLUDE	☐				0	0
159	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
160	GM_VALID_FROM	☐	GM_FROM_DATE	DATUM	DATS	8	0	Valid-from Date
161	GM_VALID_TO	☐	GM_TO_DATE	DATUM	DATS	8	0	Valid-to Date
162	GRANT_TYPE	☐	GM_GRANT_TYPE	GM_GRANT_TYPE	CHAR	2	0	Grant Type	*
163	GM_AUTHGR	☐	GM_AUTHGR	GM_AUTHGR	CHAR	10	0	Grants Management: Authorization Groups	*
164	GM_SHORT_DESC	☐	FM_GM_NAME	TEXT20	CHAR	20	0	Name of Grant
165	GM_DESCRIPTION	☐	FM_GM_DESC	TEXT80	CHAR	80	0	Grant Description
166	.INCLUDE	☐				0	0
167	.INCLUDE	☐				0	0	Cover Pools
168	DECKRNG	☐	FM_DECKRNG	FM_DECKRNG	CHAR	16	0	Cover pool	FMDECKRG
169	DNAME	☐	FM_BESCHR	TEXT40	CHAR	40	0	Description
170	DEAKTIV	☐	FM_DEAKTIV	XFELD	CHAR	1	0	Deactivation Indicator
171	HVMTNR	☐	FM_HVMTNR	FM_HVMTNR	CHAR	10	0	Budget memo	*
172	REV_EXP_CVP	☐	FM_REV_EXP_CVP	FM_REV_EXP_CVP	CHAR	1	0	Revenues or Expenditures Cover Pool
173	REV_EXP_CVPT	☐	REV_EXP_CVPT	TEXT41	CHAR	41	0	Revenue/Expenditure

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMAA	BOSSOT	T778O	OTYPE
2	FMAA	BOSS_CODE	TCJ04	VERNR
3	FMAA	BSAMT	FMFCTR	FICTR
4	FMAA	CISTR_ID	FMMDSTRID	STR_ID
5	FMAA	DECKRNG	FMDECKRG	DECKRNG	REF
6	FMAA	DFICTR	FMFCTR	FICTR
7	FMAA	DFINCODE	FMFINCODE	FINCODE
8	FMAA	EFICTR	FMFCTR	FICTR
9	FMAA	EFIPEX1	FMCI	GJAHR
10	FMAA	EFIPEX2	FMCI	GJAHR
11	FMAA	EFIPEX3	FMCI	GJAHR
12	FMAA	EFIPEX4	FMCI	GJAHR
13	FMAA	EFIPEX5	FMCI	GJAHR
14	FMAA	FAREA	TFKB	FKBER
15	FMAA	FCSTR_ID	FMMDSTRID	STR_ID
16	FMAA	FDSTR_ID	FMMDSTRID	STR_ID
17	FMAA	FICTR	FMFCTR	FICTR
18	FMAA	FICTR_UP	FMFCTR	FICTR
19	FMAA	FINUSE	FMFUSE	FINUSE
20	FMAA	FIPEX	FMCI	GJAHR
21	FMAA	FNSTR_ID	FMMDSTRID	STR_ID
22	FMAA	FONDS	FMFINCODE	FINCODE
23	FMAA	FUND_TYPE	FMFUNDTYPE	FUND_TYPE
24	FMAA	HIVARNT	FMHIVARNT	HIVARNT
25	FMAA	HSART	FMHSART	HSART	REF	1	CN
26	FMAA	KRGRP	FMKRG	KRGRP
27	FMAA	KRTYP	FMKRTP	KRTYP
28	FMAA	PROFIL	TBP1C	PROFIL
29	FMAA	SPONSOR	KNA1	KUNNR
30	FMAA	VARNT	FMCIVARNT	VARNT
31	FMAA	VPTYP	FMVORTR0	VPTYP

History

Last changed by/on	SAP	20130529
SAP Release Created in