FMPG SAP table for – Commitment Items in FM Area/Fiscal Year

Here we would like to draw your attention to FMPG 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). FMPG is a SAP standard transp table used for storing Commitment Items in FM Area/Fiscal Year related data in SAP. It comes under the package FMMD_CORE.

SAP FMPG table

Table FMPG technical data

TableFMPG
Data storingCommitment Items in FM Area/Fiscal Year
ModuleFI
Sub ModuleFI-FM
SAP PackageFMMD_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FMPG 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 FMPG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • FIKRS : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VARNT : Commitment Item Hierarchy Variant
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • FIPEX : Commitment item
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • PPLAN : Chart of Commitment Items
    Its data type is CHAR (Character String) with field length 4
  • POSIT : Item (Internal Commitment Item Number)
    Its data type is CHAR (Character String) with field length 8
  • FICTR : Funds Center (Default Value in a Commitment Item)
    Its data type is CHAR (Character String) with field length 16
  • VPTYP : Carryforward item category for commitment item
    Its data type is CHAR (Character String) with field length 2
  • SNTYP : Collective budget adminstration category
    Its data type is CHAR (Character String) with field length 1
  • SNROL : Use type in collective budget administration
    Its data type is CHAR (Character String) with field length 1
  • KRGRP : Criterion category group
    Its data type is CHAR (Character String) with field length 4
  • STATS : Statistical commitment item
    Its data type is CHAR (Character String) with field length 1
  • NCBUD : No Budget for Future Years
    Its data type is CHAR (Character String) with field length 1
  • AUGRP : Authorization Groups of the Commitment Item
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Append for the EU
  • NDAKZ : Indicator: NDA Budget
    Its data type is CHAR (Character String) with field length 1
  • AZPKZ : Indicator: Accrued Budget
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Append Structure for Cmmt Item (FMPG) (Local Authority)
  • .INCLUDE : Add.Local Authority Fields for Cmmt Items in FM Area/Fisc.Yr
  • DRUCK : Not relevant for budget print
    Its data type is CHAR (Character String) with field length 1
  • CFFLG : Able to carry forward at fiscal year change
    Its data type is CHAR (Character String) with field length 1
  • CVFLG : (Negative) clearing item
    Its data type is CHAR (Character String) with field length 1
  • BEZIRK : District
    Its data type is CHAR (Character String) with field length 4
  • BSAMT : Managed position / clearing lower section
    Its data type is CHAR (Character String) with field length 16
  • UBFLG : Local authorities: Budget execution account
    Its data type is CHAR (Character String) with field length 1
  • HSFLG : Budget balancing concept
    Its data type is CHAR (Character String) with field length 1