The FMSNRULE table in SAP ERP or S/4HANA stores Collective Expenditure Rules data. There are total 30 fields in FMSNRULE table. The Collective Expenditure Rules table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMSNRULE table. It is in Cover Eligibility and Collective Expenditure Core Objects (FMOV_CORE) ABAP package and is part of the Funds Management (FI-FM) module.
SAP FMSNRULE Table Fields
Following is the list of fields that are available in SAP FMSNRULE table. The primary key fields of the table are MANDT (Client), VFIPEX (Commitment item), VFICTR (Funds Center), VFONDS (Fund), GJAHR (Fiscal Year), FIKRS (Financial Management Area), DISTRIB (CBA rule used).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| VFIPEX | Commitment item | FM_FIPEX | FMCI | CHAR (24) |
| VFICTR | Funds Center | FM_FICTR | * | CHAR (16) |
| VFONDS | Fund | BP_GEBER | * | CHAR (10) |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| FIKRS | Financial Management Area | FIKRS | FM01 | CHAR (4) |
| DISTRIB | CBA rule used | FM_DISTRIB | CHAR (1) | |
| PCOLTYP | Collective budget adminstration category | FM_COLLTYP | CHAR (1) | |
| PCFIPEX | Commitment item | FM_FIPEX | * | CHAR (24) |
| PCFICTR | Funds Center | FM_FICTR | * | CHAR (16) |
| PCFONDS | Fund | BP_GEBER | * | CHAR (10) |
| PCQUANTITY | Distribution basis | FM_VALUE | DEC (17) | |
| PCBUDGET | Reassigned budget for CBA | FM_SNBUDGT | CURR (15) | |
| PCACTUAL | Act.revenues increasing the budget for an FM acct assignment | FM_TOTLINC | CURR (15) | |
| PBUDGDAT | Date of last transfer in collective budget administration | FM_BUDGDAT | DATS (8) | |
| PDISTDAT | Date of last distribution in collective budget admin. | FM_DISTDAT | DATS (8) | |
| CCOLTYP | Collective budget adminstration category | FM_COLLTYP | CHAR (1) | |
| CCFIPEX | Commitment item | FM_FIPEX | * | CHAR (24) |
| CCFICTR | Funds Center | FM_FICTR | * | CHAR (16) |
| CCFONDS | Fund | BP_GEBER | * | CHAR (10) |
| CCQUANTITY | Distribution basis | FM_VALUE | DEC (17) | |
| CCBUDGET | Reassigned budget for CBA | FM_SNBUDGT | CURR (15) | |
| CCACTUAL | Act.revenues increasing the budget for an FM acct assignment | FM_TOTLINC | CURR (15) | |
| CBUDGDAT | Date of last transfer in collective budget administration | FM_BUDGDAT | DATS (8) | |
| CDISTDAT | Date of last distribution in collective budget admin. | FM_DISTDAT | DATS (8) | |
| HHFIPEX | Commitment item | FM_FIPEX | * | CHAR (24) |
| HHFICTR | Funds Center | FM_FICTR | * | CHAR (16) |
| HHFONDS | Fund | BP_GEBER | * | CHAR (10) |
| DEAKTIV | Deactivation Indicator | FM_DEAKTIV | CHAR (1) | |
| SNERROR | Error in budget transfer | FM_SNERROR | CHAR (1) |
