SAP table FMCCFD (Fiscal Year Change Documents (FM))
SAP table FMCCFD has 4 primary key fields being MANDT,CFDOCNR,FIKRS,RYEAR.
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
CFDOCNR
Document Number of Fiscal Year Change Document (FM)
CHAR
10
0
FM_CFBELNR
FIKRS
Financial Management Area
CHAR
4
0
FIKRS
RYEAR
Closing Operations in FM: Receiver Fiscal Year
NUMC
4
0
FM_CCF_RYEAR
REFBN
Reference Document Number
CHAR
10
0
CO_REFBN
REFBT
Reference Document Category
NUMC
3
0
FM_REFBTYP
010
Purchase requisitions
020
Purchase orders
040
Trips
050
Sales Order Predecessor Document
060
Sales Orders
110
Earmarked Funds
900
Parked documents
910
FI documents
920
CO documents
RFORG
Reference Organizational Units
CHAR
10
0
AWORG
RFPOS
Item Number of Reference Document
NUMC
5
0
CC_RFPOS
RFKNT
Account Assignment Number of Reference Document
NUMC
5
0
CC_RFKNT
RFETE
Reference Document Classification Number
NUMC
4
0
*
CC_RFETE
RCOND
Counter Conditions and Level Number
NUMC
5
0
RCOND
RFTYP
Reference procedure
CHAR
5
0
*
AWTYP
RFSYS
Logical System
CHAR
10
0
*
LOGSYSTEM
BUKRS
Company Code
CHAR
4
0
BUKRS
KNGJAHR
Fiscal year for FI document number
NUMC
4
0
FM_KNGJAHR
FMBELNR
Document Number of FM Line Item
CHAR
10
0
FM_BELNR
FMBUZEI
Number of a posting line in a TR-FM line item
NUMC
3
0
FM_BUZEI
TRANR
Funds Management Transaction Number
CHAR
16
0
FM_TRANR
RLEDGER
Receiver Ledger (Fiscal Year Change FM)
CHAR
2
0
FM_CCF_RLDNR
SLEDGER
Sender Ledger (Fiscal Year FM)
CHAR
2
0
FM_CCF_SLDNR
SYEAR
Closing Operations in FM: Sender Fiscal Year
NUMC
4
0
FM_CCF_SYEAR
SGRANT
Sender Grant (Fiscal Year Change FM)
CHAR
20
0
FM_CCF_SGRANT
SFONDS
Sender Fund (Fiscal Year Change FM)
CHAR
10
0
FM_CCF_SFONDS
SFISTL
Sender Funds Center (Fiscal Year Change FM)
CHAR
16
0
FM_CCF_SFISTL
SFIPEX
Sender Commitment Item (Fiscal Year Change FM)
CHAR
24
0
FM_CCF_SFIPEX
SFAREA
Sender Functional Area (Fiscal Year Change FM)
CHAR
16
0
FM_CCF_SFAREA
SMEASURE
Sender Funded Program (Fiscal Year Change FM)
CHAR
24
0
FM_CCF_SMEASURE
RGRANT
Receiver Grant (Fiscal Year Change FM)
CHAR
20
0
FM_CCF_RGRANT
RFONDS
Receiver Fund (Fiscal Year Change FM)
CHAR
10
0
FM_CCF_RFONDS
RFISTL
Receiver Funds Center (Fiscal Year Change FM)
CHAR
16
0
FM_CCF_RFISTL
RFIPEX
Receiver Commitment Item (Fiscal Year Change FM)
CHAR
24
0
FM_CCF_RFIPEX
RFAREA
Receiver Functional Area (Fiscal Year Change FM)
CHAR
16
0
FM_CCF_RFAREA
RMEASURE
Receiver Funded Program (Fiscal Year Change FM)
CHAR
24
0
FM_CCF_RMEASURE
WRTTP
Value Type
CHAR
2
0
FM_WRTTP
50
Purchase Requisitions
51
Purchase Orders
52
Business Trip Commitments
54
Invoices
57
Payments
58
Down Payment Requests
60
Parked Documents
61
Down Payments
64
Funds Transfers
65
Funds Commitment
66
Transfer Postings
6B
Clarification Worklist FI-CA
80
Funds Block
81
Funds Reservation
82
Funds Precommitment
83
Forecast of Revenue
84
Payment Reservation (Not for General Use)
95
Secondary Cost Postings (CO)
REVRS
Carryback Status Fiscal Year Change Document (FM)
CHAR
1
0
FM_CCF_REVRS
Document Not Carried Back
B
Carryback Document (Partial Reversal)
F
Document Carried Back (Partial Reversal)
R
Document Carried Back (Reversal)
S
Carryback Document (Reversal)
REVDOC
Carryback-reference document number of FYC document (Fm)
CHAR
10
0
FM_REV_CFBELNR
CFLEV
Carryforward Level
CHAR
1
0
FM_CFLEV
Document and Predecessor not Carried Forward
0
Customer Specification: Number of Carryforwards
U
U Customer Flag: Document or Predecessor Carried Forward
X
X Document or Predecessor Carried Forward
CFRULE
FM Carryforward Rule (Fiscal Year Change)
CHAR
10
0
FM_CFRULE
CFCNT
Year-End Closing: Number of Transfers
NUMC
2
0
FM_CFCNT
CCF_OPTION
Amount Adjustment Type for Document Chains
INT1
3
0
FM_CCF_OPTION_CHAIN
1
Value Adjustment of Funds Reservations
2
Value Adjustments up to Funds Precommitment or Pur.Req.
3
Value Adjustment up to Funds Commitment or Pur.Order
4
Value Adjustment of Funds Precommitments and Commitments
FLG_CFB
Commitments Carryforward: Carryforward Budget for Cmmt (FM)
CHAR
1
0
FM_CFB
Carryforward Budget for Commitment not Permitted
N
Carryforward of Commitment Budget Permitted (BCS not Active)
P
Carryfd.of Commitm.Budget Forbidden by Strategy (BCS Active)
R
Carryforward of Commitment Budget Rejected (BCS Active)
X
Carryforward of Commitment Budget Permitted (BCS Active)
FLG_AUTO
Automatic Carryforward for Cross-Year Posting (FM)
CHAR
1
0
FM_AUTOCF
No Automatic Commitments Carryforwrd
L
Automatic Ledger Switch After Commitments Carryforward
N
New Automatic Commitments Carryforwrd
R
Resetting Cmmt Carryforward by Reconstructing FM Cmmt
X
Automatic Commitments Carryforwrd for Cross-Year Posting
FLG_FDOC
Follow-On Document Created for Fiscal Year Change Doc. (FM)
CHAR
1
0
FM_CCF_FOLLOW_ON_DOC
CPUDTCF
Day On Which Accounting Document Was Entered
DATS
8
0
CPUDT
CPUTMCF
Time of Entry
TIMS
6
0
CPUTM
UNAMECF
User Name
CHAR
12
0
UNAME
CFLOTNR
Number to Identify Approval Process
CHAR
10
0
FM_CFLOTNR
SBUDGET_PD
FM: Sender Budget Period
CHAR
10
0
FM_SBUDGET_PERIOD
RBUDGET_PD
FM: Receiver Budget Period
CHAR
10
0
FM_EBUDGET_PERIOD
SUSERDIM
Sender Customer-Specific Field (Fiscal Year Change FM)
CHAR
10
0
FM_CCF_SUSERDIM
RUSERDIM
Receiver Customer-Specific Field (Fiscal Year Change FM)