FMSNRULEC SAP (Change Documents for Collective Budget Rules) Table details
Dictionary Type: Table
Description: Change Documents for Collective Budget Rules
Description: Change Documents for Collective Budget Rules
Table field list including key, data, relationships and ABAP select examples
FMSNRULEC is a standard SAP Table which is used to store Change Documents for Collective Budget Rules data and is available within R/3 SAP systems depending on the version and release level.
The FMSNRULEC table consists of various fields, each holding specific information or linking keys about Change Documents for Collective Budget Rules data available in SAP. These include VFIPEX (Commitment Item), VFICTR (Funds Center), VFONDS (Fund), GJAHR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP FMSNRULEC table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| VFIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | FM_FIPEX | FPS | |||
| VFICTR | Funds Center | FM_FICTR | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
| VFONDS | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
| DISTRIB | CBA rule used | FM_DISTRIB | CHAR | 1 | XFELD | ||||
| DATBIS | Number that clearly identifies the line key in database | FM_STUNR | CHAR | 16 | CHAR16 | ||||
| DATAB | Number that clearly identifies the line key in database | FM_STUNR | CHAR | 16 | CHAR16 | ||||
| DBACTION | Time Interval Handler (CO): Identifier for database activity | TTDBACTION | CHAR | 1 | TTDBACTION | ||||
| TACTION | Time Interval Handler (CO): Identifier for database activity | TTDBACTION | CHAR | 1 | TTDBACTION | ||||
| AENNAME | FIFM: Name of Last Person to Make a Change | FM_AENNAME | CHAR | 12 | USNAM | ||||
| PCOLTYP | Collective budget adminstration category | FM_COLLTYP | CHAR | 1 | FM_COLLTYP | ||||
| PCFIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | FM_FIPEX | FPS | |||
| PCFICTR | Funds Center | FM_FICTR | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
| PCFONDS | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| PCQUANTITY | Distribution basis | FM_VALUE | DEC | 17(2) | FM_VALUE | ||||
| PCBUDGET | Reassigned budget for CBA | FM_SNBUDGT | CURR | 15(2) | WERTV8 | ||||
| PCACTUAL | Act.revenues increasing the budget for an FM acct assignment | FM_TOTLINC | CURR | 15(2) | WERTV8 | ||||
| PBUDGDAT | Date of last transfer in collective budget administration | FM_BUDGDAT | DATS | 8 | DATUM | ||||
| PDISTDAT | Date of last distribution in collective budget admin. | FM_DISTDAT | DATS | 8 | DATUM | ||||
| CCOLTYP | Collective budget adminstration category | FM_COLLTYP | CHAR | 1 | FM_COLLTYP | ||||
| CCFIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | FM_FIPEX | FPS | |||
| CCFICTR | Funds Center | FM_FICTR | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
| CCFONDS | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| CCQUANTITY | Distribution basis | FM_VALUE | DEC | 17(2) | FM_VALUE | ||||
| CCBUDGET | Reassigned budget for CBA | FM_SNBUDGT | CURR | 15(2) | WERTV8 | ||||
| CCACTUAL | Act.revenues increasing the budget for an FM acct assignment | FM_TOTLINC | CURR | 15(2) | WERTV8 | ||||
| CBUDGDAT | Date of last transfer in collective budget administration | FM_BUDGDAT | DATS | 8 | DATUM | ||||
| CDISTDAT | Date of last distribution in collective budget admin. | FM_DISTDAT | DATS | 8 | DATUM | ||||
| HHFIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | FM_FIPEX | FPS | |||
| HHFICTR | Funds Center | FM_FICTR | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
| HHFONDS | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| DEAKTIV | Deactivation Indicator | FM_DEAKTIV | CHAR | 1 | XFELD | ||||
| SNERROR | Error in budget transfer | FM_SNERROR | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table FMSNRULEC using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMSNRULEC to SELECT all data from the tableDATA: WA_FMSNRULEC TYPE FMSNRULEC.
SELECT SINGLE *
FROM FMSNRULEC
INTO CORRESPONDING FIELDS OF WA_FMSNRULEC
WHERE...
How to access SAP table FMSNRULEC
Within an ECC or HANA version of SAP you can also view further information about FMSNRULEC and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects