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 |
|
| 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 | |
FM_RPAY | XFELD | CHAR | 1 | 0 | Receiver of budget increase in payment budget | ||
| 2 | |
FM_RCOM | XFELD | CHAR | 1 | 0 | Receiver of budget increase in commitment budget | ||
| 3 | |
FM_COLLTYP | FM_COLLTYP | CHAR | 1 | 0 | Collective budget adminstration category | ||
| 4 | |
FM_COLLTYPT | TEXT41 | CHAR | 41 | 0 | Collective Expenditure Type | ||
| 5 | |
FM_VALUE | FM_VALUE | DEC | 17 | 2 | Distribution basis | ||
| 6 | |
FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | FMCI | |
| 7 | |
FM_FICTR | FISTL | CHAR | 16 | 0 | Funds Center | FMFCTR | |
| 8 | |
BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | FMFINCODE | |
| 9 | |
0 | 0 | FM Account Assignment | |||||
| 10 | |
FM_PGJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year of Commitment Item | ||
| 11 | |
BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | FMFINCODE | |
| 12 | |
FM_FNAME | TEXT20 | CHAR | 20 | 0 | Fund name | ||
| 13 | |
FM_BESCHR | TEXT40 | CHAR | 40 | 0 | Description | ||
| 14 | |
FM_SPONSOR | KUNNR | CHAR | 10 | 0 | Customer account number for fund | KNA1 | |
| 15 | |
FM_SPONTXT | NAME | CHAR | 35 | 0 | Source of funds name (customer name 1) | ||
| 16 | |
FM_FINUSE | FM_FINUSE | CHAR | 16 | 0 | Application of Secondary Source Funds | FMFUSE | |
| 17 | |
FM_FUSETXT | TEXT20 | CHAR | 20 | 0 | Application of funds description | ||
| 18 | |
FM_FUSEBSH | TEXT40 | CHAR | 40 | 0 | Application of funds description | ||
| 19 | |
FM_AUTHGRF | CHAR10 | CHAR | 10 | 0 | FM: Fund authorization group | ||
| 20 | |
FM_FUNDTYPE | FM_FUNDTYPE | CHAR | 6 | 0 | FM Fund Type | FMFUNDTYPE | |
| 21 | |
FM_FUNDTYPET | FM_FUNDTYPET | CHAR | 35 | 0 | FM Fund Type Description | ||
| 22 | |
BP_BPROFIL | BP_PROFIL | CHAR | 6 | 0 | Budget Profile | TBP1C | |
| 23 | |
FM_KZBST | FM_KZBST | CHAR | 1 | 0 | "Balance update" indicator | ||
| 24 | |
FM_ERFNAME | USNAM | CHAR | 12 | 0 | FIFM: Created by | ||
| 25 | |
FM_ERFDAT | DATUM | DATS | 8 | 0 | FIFM: Entry Date | ||
| 26 | |
FM_AENNAME | USNAM | CHAR | 12 | 0 | FIFM: Name of Last Person to Make a Change | ||
| 27 | |
FM_AENDAT | DATUM | DATS | 8 | 0 | FIFM: Changed on | ||
| 28 | |
FM_DATAB | DATUM | DATS | 8 | 0 | FM: Valid from date | ||
| 29 | |
FM_DATBIS | DATUM | DATS | 8 | 0 | FM: Valid to date | ||
| 30 | |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
| 31 | |
FM_DATE_EXP | DATUM | DATS | 8 | 0 | Expiration Date | ||
| 32 | |
FM_DATE_CAN | DATUM | DATS | 8 | 0 | Reversal Date | ||
| 33 | |
LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
| 34 | |
FM_FDSTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of the fund | FMMDSTRID | |
| 35 | |
FM_FDSUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Fund | ||
| 36 | |
FM_FDSUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Fund | ||
| 37 | |
0 | 0 | Substructures of Funds - Text descriptions | |||||
| 38 | |
FM_BESCHR1 | TEXT50 | CHAR | 50 | 0 | Description 1 | ||
| 39 | |
FM_BESCHR2 | TEXT50 | CHAR | 50 | 0 | Description 2 | ||
| 40 | |
FM_BESCHR1 | TEXT50 | CHAR | 50 | 0 | Description 1 | ||
| 41 | |
FM_BESCHR2 | TEXT50 | CHAR | 50 | 0 | Description 2 | ||
| 42 | |
0 | 0 | ||||||
| 43 | |
FM_FICTR | FISTL | CHAR | 16 | 0 | Funds Center | FMFCTR | |
| 44 | |
FM_CNAME | TEXT20 | CHAR | 20 | 0 | Funds center name | ||
| 45 | |
FM_BESCHR | TEXT40 | CHAR | 40 | 0 | Description | ||
| 46 | |
FM_CTRLEVL | INT4 | INT4 | 10 | 0 | Level in funds center hierarchy | ||
| 47 | |
FM_HIVARNT | FM_HIVARNT | CHAR | 4 | 0 | Hierarchy Variant of Funds Center | FMHIVARNT | |
| 48 | |
FM_HFICTR | FISTL | CHAR | 16 | 0 | Superior funds center | FMFCTR | |
| 49 | |
J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
| 50 | |
DATBI | DATUM | DATS | 8 | 0 | Valid To Date | ||
| 51 | |
DATAB | DATUM | DATS | 8 | 0 | Valid-From Date | ||
| 52 | |
FM_AUTHGRC | CHAR10 | CHAR | 10 | 0 | FM: Funds center authorization group | ||
| 53 | |
FM_ERFDAT | DATUM | DATS | 8 | 0 | FIFM: Entry Date | ||
| 54 | |
FM_ERFNAME | USNAM | CHAR | 12 | 0 | FIFM: Created by | ||
| 55 | |
FM_AENDAT | DATUM | DATS | 8 | 0 | FIFM: Changed on | ||
| 56 | |
FM_AENNAME | USNAM | CHAR | 12 | 0 | FIFM: Name of Last Person to Make a Change | ||
| 57 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
| 58 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
| 59 | |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
| 60 | |
LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
| 61 | |
FM_BOSSCOD | PS_VERNR | NUMC | 8 | 0 | FIFM: Code for a Person Responsible | TCJ04 | |
| 62 | |
FM_BOSSOT | OTYPE | CHAR | 2 | 0 | FIFM: Object Type for Funds Center Manager in HR | T778O | |
| 63 | |
FM_BOSSID | HROBJID_12 | CHAR | 12 | 0 | Funds Center Manager in Organization Model | ||
| 64 | |
FM_BOSSNAM | TEXT20 | CHAR | 20 | 0 | FM: Name of Person Responsible | ||
| 65 | |
FM_DFONDS | BP_GEBER | CHAR | 10 | 0 | Fund (Default Value in a Funds Center) | FMFINCODE | |
| 66 | |
FM_FCSTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of the funds center | FMMDSTRID | |
| 67 | |
FM_FCSUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Funds Center | ||
| 68 | |
FM_FCSUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Funds Center | ||
| 69 | |
FM_FCSUB3 | CHAR10 | CHAR | 10 | 0 | Substring 3 of Funds Center | ||
| 70 | |
0 | 0 | Substructures of Fund Center - Text Descriptions | |||||
| 71 | |
FM_FCSUB1T_SH | TEXT50 | CHAR | 50 | 0 | Description 1 of Substring 1 of Funds Center | ||
| 72 | |
FM_FCSUB1T_LO | TEXT50 | CHAR | 50 | 0 | Description 2 of Substring 1 of Funds Center | ||
| 73 | |
FM_FCSUB2T_SH | TEXT50 | CHAR | 50 | 0 | Description 1 of Substring 2 of Funds Center | ||
| 74 | |
FM_FCSUB2T_LO | TEXT50 | CHAR | 50 | 0 | Description 2 of Substring 2 of Funds Center | ||
| 75 | |
FM_FCSUB3T_SH | TEXT50 | CHAR | 50 | 0 | Description 1 of Substring 3 of Funds Center | ||
| 76 | |
FM_FCSUB3T_LO | TEXT50 | CHAR | 50 | 0 | Description 2 of Substring 3 of Funds Center | ||
| 77 | |
0 | 0 | ||||||
| 78 | |
FM_VARNT | FM_VARNT | CHAR | 3 | 0 | Commitment Item Hierarchy Variant | FMCIVARNT | |
| 79 | |
FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | FMCI | |
| 80 | |
FM_PNAME | TEXT20 | CHAR | 20 | 0 | Commitment item name | ||
| 81 | |
FM_BESCHR0 | TEXT50 | CHAR | 50 | 0 | Description | ||
| 82 | |
FM_BESCHR2 | TEXT50 | CHAR | 50 | 0 | Description 2 | ||
| 83 | |
FM_BESCHR3 | TEXT50 | CHAR | 50 | 0 | Description 3 | ||
| 84 | |
FM_POSLEVL | INT4 | INT4 | 10 | 0 | Level in the commitment item hierarchy | ||
| 85 | |
FM_DFICTR | FISTL | CHAR | 16 | 0 | Funds Center (Default Value in a Commitment Item) | FMFCTR | |
| 86 | |
FM_VPTYP | FM_VPTYP | CHAR | 2 | 0 | Carryforward item category for commitment item | FMVORTR0 | |
| 87 | |
FM_COLLTYP | FM_COLLTYP | CHAR | 1 | 0 | Collective budget adminstration category | ||
| 88 | |
FM_COLLROL | FM_COLLECT | CHAR | 1 | 0 | Use type in collective budget administration | ||
| 89 | |
FM_NDAB | FM_NDAB | CHAR | 1 | 0 | Indicator: NDA Budget | ||
| 90 | |
FM_AZPB | FM_AZPB | CHAR | 1 | 0 | Indicator: Accrued Budget | ||
| 91 | |
FM_KRGRP | FM_KRGRP | CHAR | 4 | 0 | Criterion category group | FMKRG | |
| 92 | |
FM_AUTHGRP | CHAR10 | CHAR | 10 | 0 | Authorization Groups of the Commitment Item | ||
| 93 | |
FM_STATS | FM_STATS | CHAR | 1 | 0 | Funds Management Statistical Indicator | ||
| 94 | |
FM_NCBUD | XFELD | CHAR | 1 | 0 | No Budget for Future Years | ||
| 95 | |
FM_POSITI | BP_POSIT | CHAR | 8 | 0 | Internal commitment item (8 chars) | ||
| 96 | |
FM_STVAR | XFELD | CHAR | 1 | 0 | Standard variant | ||
| 97 | |
FM_NEG_BUDGET_FLG | XFELD | CHAR | 1 | 0 | Negative Budget Permitted | ||
| 98 | |
LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
| 99 | |
BUTYP | PM_BUTYP | CHAR | 4 | 0 | Budget structure element type | * | |
| 100 | |
FM_SDFICTR | FISTL | CHAR | 16 | 0 | Balance Funds Center | FMFCTR | |
| 101 | |
FM_SDFIPEX | FM_FIPEX | CHAR | 24 | 0 | Balance Cmmt Item | FMCI | |
| 102 | |
FM_SDFIPX2 | FM_FIPEX | CHAR | 24 | 0 | Balance commitment item plan year+1 | FMCI | |
| 103 | |
FM_SDFIPX3 | FM_FIPEX | CHAR | 24 | 0 | Balance commitment item plan year+2 | FMCI | |
| 104 | |
FM_SDFIPX4 | FM_FIPEX | CHAR | 24 | 0 | Balance commitment item plan year+3 | FMCI | |
| 105 | |
FM_SDFIPX5 | FM_FIPEX | CHAR | 24 | 0 | Balance commitment item plan year+4 | FMCI | |
| 106 | |
FM_CISTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of the commitment item | FMMDSTRID | |
| 107 | |
FM_CISUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Commitment Item | ||
| 108 | |
FM_CISUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Commitment Item | ||
| 109 | |
FM_CISUB3 | CHAR10 | CHAR | 10 | 0 | Substring 3 of Commitment Item | ||
| 110 | |
FM_CISUB4 | CHAR10 | CHAR | 10 | 0 | Substring 4 of Commitment Item | ||
| 111 | |
FM_CISUB5 | CHAR10 | CHAR | 10 | 0 | Substring 5 of Commitment Item | ||
| 112 | |
0 | 0 | Subtructures of Commitment Item - Text descriptions | |||||
| 113 | |
FM_CISUB1T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 1 of Commitment Item | ||
| 114 | |
FM_CISUB1T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 1 of Commitment Item | ||
| 115 | |
FM_CISUB2T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 2 of Commitment Item | ||
| 116 | |
FM_CISUB2T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 2 of Commitment Item | ||
| 117 | |
FM_CISUB3T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 3 of Commitment Item | ||
| 118 | |
FM_CISUB3T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 3 of Commitment Item | ||
| 119 | |
FM_CISUB4T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 4 of Commitment Item | ||
| 120 | |
FM_CISUB4T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 4 of Commitment Item | ||
| 121 | |
FM_CISUB5T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 5 of Commitment Item | ||
| 122 | |
FM_CISUB5T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 5 of Commitment Item | ||
| 123 | |
0 | 0 | Data Structure for Commitment Items in Chart of Cmmt Items | |||||
| 124 | |
FM_KATEG | FM_KATEG | NUMC | 1 | 0 | Attribute: Can be Posted To | ||
| 125 | |
FM_FIVOR | FM_FIVOR | NUMC | 2 | 0 | Financial transaction | ||
| 126 | |
FM_POTYP | FM_POTYP | NUMC | 1 | 0 | Commitment Item Category | ||
| 127 | |
FM_KRTYP | FM_KRTYP | CHAR | 5 | 0 | Commitment item criterion category | FMKRTP | |
| 128 | |
FM_FPART | FM_FPART | CHAR | 3 | 0 | Commitment Item Type | ||
| 129 | |
FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
| 130 | |
FIPEX_UP | FM_FIPEX | CHAR | 24 | 0 | Superior Commitment Item | * | |
| 131 | |
0 | 0 | Local Authority Add.Fields for Cmmt Items in Chart of CIs | |||||
| 132 | |
FM_HSART | FM_HSART | CHAR | 1 | 0 | Commitment Item Type | FMHSART | |
| 133 | |
FM_GKFLG | XFELD | CHAR | 1 | 0 | Relevant to total costs | ||
| 134 | |
0 | 0 | Add.Local Authority Fields for Cmmt Items in FM Area/Fisc.Yr | |||||
| 135 | |
FM_DRUCK | XFELD | CHAR | 1 | 0 | Not relevant for budget print | ||
| 136 | |
FM_CFFLG | XFELD | CHAR | 1 | 0 | Able to carry forward at fiscal year change | ||
| 137 | |
FM_CVFLG | XFELD | CHAR | 1 | 0 | (Negative) clearing item | ||
| 138 | |
FM_BEZIRK | CHAR4 | CHAR | 4 | 0 | District | ||
| 139 | |
FM_BSAMT | FISTL | CHAR | 16 | 0 | Managed position / clearing lower section | FMFCTR | |
| 140 | |
FM_UBFLG | CHAR1 | CHAR | 1 | 0 | Local authorities: Budget execution account | ||
| 141 | |
FM_HSFLG | XFELD | CHAR | 1 | 0 | Budget balancing concept | ||
| 142 | |
0 | 0 | ||||||
| 143 | |
FM_BSPEL | FM_INTCNT | CHAR | 10 | 0 | Budget structure element (internal number) | ||
| 144 | |
BP_ACCAR | X | CHAR | 1 | 0 | Indicator: posting object | ||
| 145 | |
BP_BPCAR | X | CHAR | 1 | 0 | Budget Object | ||
| 146 | |
FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
| 147 | |
FKBTX | TEXT25 | CHAR | 25 | 0 | Name of the functional area | ||
| 148 | |
FM_FNSTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of functional area | FMMDSTRID | |
| 149 | |
FM_FNSUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Functional Area | ||
| 150 | |
FM_FNSUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Functional Area | ||
| 151 | |
FM_FNSUB3 | CHAR10 | CHAR | 10 | 0 | Substring 3 of Functional Area | ||
| 152 | |
0 | 0 | Substructures of Function - Text Descriptions | |||||
| 153 | |
FM_FNSUB1T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 1 of Functional Area | ||
| 154 | |
FM_FNSUB1T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 1 of Functional Area | ||
| 155 | |
FM_FNSUB2T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 2 of Functional Area | ||
| 156 | |
FM_FNSUB2T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 2 of Functional Area | ||
| 157 | |
FM_FNSUB3T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 3 of Functional Area | ||
| 158 | |
FM_FNSUB3T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 3 of Functional Area | ||
| 159 | |
FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
| 160 | |
PSM_FP_CATEGORY | PSM_FP_CATEGORY | CHAR | 3 | 0 | Funded Program Category | ||
| 161 | |
PSM_FP_TYPE | PSM_FP_TYPE | CHAR | 4 | 0 | Funded Program Type | * | |
| 162 | |
FM_DATAB | DATUM | DATS | 8 | 0 | FM: Valid from date | ||
| 163 | |
FM_DATBIS | DATUM | DATS | 8 | 0 | FM: Valid to date | ||
| 164 | |
FM_AUTHGR_MEASURE | CHAR10 | CHAR | 10 | 0 | FM: Funded Program Authorization Group | ||
| 165 | |
FM_ME_NAME | TEXT20 | CHAR | 20 | 0 | Name of Funded Program (20-character) | ||
| 166 | |
FM_ME_DESC | TEXT50 | CHAR | 50 | 0 | Description of Funded Program (50 character) | ||
| 167 | |
0 | 0 | ||||||
| 168 | |
GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
| 169 | |
GM_FROM_DATE | DATUM | DATS | 8 | 0 | Valid-from Date | ||
| 170 | |
GM_TO_DATE | DATUM | DATS | 8 | 0 | Valid-to Date | ||
| 171 | |
GM_GRANT_TYPE | GM_GRANT_TYPE | CHAR | 2 | 0 | Grant Type | * | |
| 172 | |
GM_AUTHGR | GM_AUTHGR | CHAR | 10 | 0 | Grants Management: Authorization Groups | * | |
| 173 | |
FM_GM_NAME | TEXT20 | CHAR | 20 | 0 | Name of Grant | ||
| 174 | |
FM_GM_DESC | TEXT80 | CHAR | 80 | 0 | Grant Description | ||
| 175 | |
0 | 0 | ||||||
| 176 | |
0 | 0 | Cover Pools | |||||
| 177 | |
FM_DECKRNG | FM_DECKRNG | CHAR | 16 | 0 | Cover pool | FMDECKRG | |
| 178 | |
FM_BESCHR | TEXT40 | CHAR | 40 | 0 | Description | ||
| 179 | |
FM_DEAKTIV | XFELD | CHAR | 1 | 0 | Deactivation Indicator | ||
| 180 | |
FM_HVMTNR | FM_HVMTNR | CHAR | 10 | 0 | Budget memo | * | |
| 181 | |
FM_REV_EXP_CVP | FM_REV_EXP_CVP | CHAR | 1 | 0 | Revenues or Expenditures Cover Pool | ||
| 182 | |
REV_EXP_CVPT | TEXT41 | CHAR | 41 | 0 | Revenue/Expenditure |
Foreign Keys
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |