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