FMSNRULE SAP table for – Collective Expenditure Rules

Here we would like to draw your attention to FMSNRULE table in SAP. As we know it is being mainly used with the SAP FI-FM (Funds Management in FI) component which is coming under FI module (Financial Accounting). FMSNRULE is a SAP standard transp table used for storing Collective Expenditure Rules related data in SAP. It comes under the package FMOV_CORE.

SAP FMSNRULE table

Table FMSNRULE technical data

TableFMSNRULE
Data storingCollective Expenditure Rules
ModuleFI
Sub ModuleFI-FM
SAP PackageFMOV_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FMSNRULE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMSNRULE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VFIPEX : Commitment item
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • VFICTR : Funds Center
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • VFONDS : Fund
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • FIKRS : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DISTRIB : CBA rule used
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • PCOLTYP : Collective budget adminstration category
    Its data type is CHAR (Character String) with field length 1
  • PCFIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • PCFICTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • PCFONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • PCQUANTITY : Distribution basis
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 17
  • PCBUDGET : Reassigned budget for CBA
    Its data type is CURR (Currency Field) with field length 15
  • PCACTUAL : Act.revenues increasing the budget for an FM acct assignment
    Its data type is CURR (Currency Field) with field length 15
  • PBUDGDAT : Date of last transfer in collective budget administration
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PDISTDAT : Date of last distribution in collective budget admin.
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CCOLTYP : Collective budget adminstration category
    Its data type is CHAR (Character String) with field length 1
  • CCFIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • CCFICTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • CCFONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • CCQUANTITY : Distribution basis
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 17
  • CCBUDGET : Reassigned budget for CBA
    Its data type is CURR (Currency Field) with field length 15
  • CCACTUAL : Act.revenues increasing the budget for an FM acct assignment
    Its data type is CURR (Currency Field) with field length 15
  • CBUDGDAT : Date of last transfer in collective budget administration
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CDISTDAT : Date of last distribution in collective budget admin.
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HHFIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • HHFICTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • HHFONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • DEAKTIV : Deactivation Indicator
    Its data type is CHAR (Character String) with field length 1
  • SNERROR : Error in budget transfer
    Its data type is CHAR (Character String) with field length 1