SAP table FMDECKRG (Cover Pool)
SAP table FMDECKRG has 4 primary key fields being MANDT,DECKRNG,GJAHR,FIKRS.
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
*
MANDT
DECKRNG
Cover pool
CHAR
16
0
FM_DECKRNG
GJAHR
Fiscal Year
NUMC
4
0
GJAHR
FIKRS
Financial Management Area
CHAR
4
0
FM01
FIKRS
FONDS
Fund
CHAR
10
0
*
BP_GEBER
REV_EXP_CVP
Revenues or Expenditures Cover Pool
CHAR
1
0
FM_REV_EXP_CVP
Possible values
Expenditure Cover Pool
2
Revenues Cover Pool
SORTGRP
Characteristic Group
CHAR
4
0
FMDKSRTGRP
FM_SORTGRP
HVMTNR
Budget memo
CHAR
10
0
FMHVMTXT
FM_HVMTNR
GDPAY
Copy pool for payment budget
CHAR
1
0
FM_GDPAY
GDCOM
Cover pool for commitment budget
CHAR
1
0
FM_GDCOM
HSART
Commitment Item Type
CHAR
1
0
*
FM_HSART
DEAKTIV
Deactivation Indicator
CHAR
1
0
FM_DEAKTIV
NO_ERROR
Warning Instead of Error, when Budget is Exceeded
CHAR
1
0
FM_CVP_NO_AVC_ERROR
LASTFIPEX
Commitment Item
CHAR
24
0
FM_FIPEX
LASTFICTR
Funds Center
CHAR
16
0
*
FM_FICTR
LASTFONDS
Fund
CHAR
10
0
*
BP_GEBER
FMDECKRG foreign key relationships
Table
Field
Check Table
Check Field
0 FMDECKRG
FIKRS
FM01
Financial Management Areas
FIKRS
1 FMDECKRG
HVMTNR
FMHVMTXT
Budget Memo
MANDT
1 FMDECKRG
HVMTNR
FMHVMTXT
Budget Memo
HVMTNR
0 FMDECKRG
SORTGRP
FMDKSRTGRP
Groups of Sort Criteria for Cover Eligibility
MANDT
0 FMDECKRG
SORTGRP
FMDKSRTGRP
Groups of Sort Criteria for Cover Eligibility
SORTGRP
0 FMDECKRG
SORTGRP
FMDKSRTGRP
Groups of Sort Criteria for Cover Eligibility
FIKRS