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