SAP table FMPG (Commitment Items in FM Area/Fiscal Year)

SAP table FMPG has 5 primary key fields being MANDT,FIKRS,VARNT,GJAHR,FIPEX.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
VARNT Commitment Item Hierarchy Variant CHAR 3 0 FMVARNT FM_VARNT
GJAHR Fiscal Year NUMC 4 0 GJAHR
FIPEX Commitment Item CHAR 24 0 FMPP FM_FIPEX
PPLAN Chart of Commitment Items CHAR 4 0 FMPPLAN FM_PPLAN
POSIT Internal Commitment Item Number CHAR 8 0 FM_POSIT
FICTR Funds Center Default Value CHAR 16 0 FMFCTR FM_DFICTR
VPTYP Carryforward Item Category for Commitment Item CHAR 2 0 FMVORTR0 FM_VPTYP
SNTYP Collective budget adminstration category CHAR 1 0 FM_COLLTYP
1 Collective Expenditure within Funds Center
2 Collective Expenditure across Funds Centers
SNROL Use type in collective budget administration CHAR 1 0 FM_COLLROL
KRGRP Criterion Category Group CHAR 4 0 FMKRG FM_KRGRP
STATS Statistical commitment item CHAR 1 0 FM_STATPOS
NCBUD No Budget for Future Years CHAR 1 0 FM_NCBUD
AUGRP Authorization Group for Commitment Item CHAR 10 0 FM_AUTHGRP
NDAKZ Indicator: NDA Budget CHAR 1 0 FM_NDAB
AZPKZ Indicator: Accrued Budget CHAR 1 0 FM_AZPB
DRUCK Not Relevant for Budget Print CHAR 1 0 FM_DRUCK
CFFLG Able to Carry Forward at Fiscal Year Change CHAR 1 0 FM_CFFLG
CVFLG (Negative) Clearing Item CHAR 1 0 FM_CVFLG
BEZIRK District CHAR 4 0 FM_BEZIRK
BSAMT Managed Position/Clearing Lower Section CHAR 16 0 FMFCTR FM_BSAMT
UBFLG Local Authorities: Budget Execution Account CHAR 1 0 FM_UBFLG
HSFLG Budget Balancing Concept CHAR 1 0 FM_HSFLG

FMPG foreign key relationships

Table Field Check Table Check Field
0 FMPG BSAMT FMFCTR Funds Center Master Record FIKRS
0 FMPG BSAMT FMFCTR Funds Center Master Record DATBIS
1 FMPG FICTR FMFCTR Funds Center Master Record FIKRS
1 FMPG FICTR FMFCTR Funds Center Master Record DATBIS
0 FMPG FIKRS FM01 Financial Management Areas FIKRS
1 FMPG FIPEX FMPP Commitment Item in Chart of Commitment Items PPLAN
1 FMPG FIPEX FMPP Commitment Item in Chart of Commitment Items VARNT
1 FMPG FIPEX FMPP Commitment Item in Chart of Commitment Items FIPEX
0 FMPG KRGRP FMKRG Commitment Item Criterion Category Group MANDT
0 FMPG KRGRP FMKRG Commitment Item Criterion Category Group KRGRP
1 FMPG MANDT T000 Clients MANDT
0 FMPG PPLAN FMPPLAN Chart of Commitment Items: Entities MANDT
0 FMPG PPLAN FMPPLAN Chart of Commitment Items: Entities PPLAN
1 FMPG VARNT FMVARNT Chart of Commitment Items Variant: Entity Texts MANDT
1 FMPG VARNT FMVARNT Chart of Commitment Items Variant: Entity Texts PPLAN
1 FMPG VARNT FMVARNT Chart of Commitment Items Variant: Entity Texts VARNT
0 FMPG VPTYP FMVORTR0 Carryforward Item Categories of Totals Records MANDT
0 FMPG VPTYP FMVORTR0 Carryforward Item Categories of Totals Records FIKRS