SAP ABAP Table IFMFGRCN_FIN_FIELDS (Structure for reconciliation derivation tool)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FMFG_RECON_E (Package) Reconciliation Tool

Basic Data

Table Category	INTTAB	Structure
Structure	IFMFGRCN_FIN_FIELDS	Table Relationship Diagram
Short Description	Structure for reconciliation derivation tool

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AGNCY_LCTN_CODE	☐	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	FMFGT_ALC
2	ALLOCATION_TYPE	☐	BUAVC_ALLOCTYPE	BUAVC_ALLOCTYPE	CHAR	4	0	Amount Type (Availability Control)
3	APPLICATION_OF_FUND	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	FMFUSE
4	BUDTYPE	☐	BUKU_BUDTYPE	CHAR4	CHAR	4	0	Budget Type
5	BUS_ACT	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
6	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
7	CASH_YEAR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
8	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
9	COHORT	☐	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
10	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
11	CSPRED	☐	CSPRED	SPRED	CHAR	4	0	Distribution key for currency amounts	*
12	CMMT_ITEM_CATEG	☐	FM_POTYP	FM_POTYP	NUMC	1	0	Commitment Item Category
13	CURRENCY	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
14	DB_CR_IND	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
15	DISTKEY	☐	FM_DISTKEY	FM_DISTKEY	CHAR	4	0	Distribution keys
16	DOCSTATE	☐	BUED_DOCSTATE	BUED_DOCSTATE	CHAR	1	0	Status of a budget entry document
17	DOCTYPE	☐	BUED_DOCTYPE	BUED_DOCTYPE	CHAR	4	0	Budget entry document type	*
18	DOCUMENT_CAT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
19	PERIOD	☐	POPER	POPER	NUMC	3	0	Posting period
20	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
21	FIVOR	☐	FM_FIVOR	FM_FIVOR	NUMC	2	0	Financial transaction
22	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
23	FUNC_AREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
24	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
25	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
26	FUND_TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	FMFUNDTYPE
27	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
28	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
29	LEDGER	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	*
30	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	FMMEASURE
31	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
32	PUBLAW	☐	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
33	AMT_TYPE	☐	FM_BTART	FM_BTART	CHAR	4	0	Amount type
34	RCFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
35	RECORDTYPE	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
36	REV_STATUS	☐	BP_RSTAT	BP_RSTAT	CHAR	1	0	Reversal status
37	RSTATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
38	RUSERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
39	SGL_ACCOUNT	☐	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
40	TRADE_ID	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
41	VALTYPE	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
42	VERSION	☐	RVERS	RVERS	CHAR	3	0	Version	T894
43	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
44	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
45	WBS_ELEM	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
46	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
47	BLSTATUS_9	☐	FMFG_BLSTATUS	FMFG_BLSTATUS	CHAR	5	0	Budgetary ledger status
48	BP_SUBVO	☐	BP_SUBVO	BP_SUBVO	CHAR	4	0	Budget Subtype	*
49	BP_RSTAT	☐	BP_RSTAT	BP_RSTAT	CHAR	1	0	Reversal status
50	BP_BSTAT	☐	BP_BSTAT	BP_BSTAT	CHAR	1	0	Document/Document Line Item Status
51	BP_OBJNR	☐	BP_OBJEKT	J_OBJNR	CHAR	22	0	Object number	*
52	BP_VORGA	☐	BP_VORGANG	ACTIVITY	CHAR	4	0	Budget Type Budgeting/Planning	*
53	TRANSAC	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	TJ01
54	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
55	NETWORK_ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
56	SD_ORDER_LINE	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
57	SD_ORDER	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
58	CO_BUSPROC	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
59	DEB_TYPE	☐	BP_INOUT	BP_INOUT	NUMC	1	0	Debit type
60	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
61	COSTOBJECT	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
62	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
63	OBJECT_NO	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
64	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
65	SPONSORED_PROGRAM	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	GMSPPROGRAM
66	SPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	GMSPCLASS
67	BUDGET_VALIDITY_NUMBER	☐	GM_BDGT_VLDTY_NBR	GM_BDGT_VLDTY_NBR	CHAR	3	0	Budget Validity Number
68	GRANTEE_FISCAL_YEAR	☐	GM_GRANTEE_FY	GJAHR	NUMC	4	0	Fiscal Year of Grantee Organization
69	BUDGET_STATE	☐	GM_BDGT_STATE	GM_BDGT_STATE	CHAR	1	0	Workflow State of a Record in the Budget Totals Table
70	.INCLUDE	☐				0	0	Reconciliation: Target fields for subtotal derivation
71	RCN_SUBTOTAL	☐	FMFGRCN_SUBTOT_ID	CHAR30	CHAR	30	0	Reconciliation tool Subtotal	FMFGRCN_SUBTOT
72	RCN_EXCLUDE	☐	FMFGRCNSEL_EXCLUDE	XFELD	CHAR	1	0	Exclude
73	RCN_NEG_VALUE	☐	FMFGRCNNEGVALUE	XFELD	CHAR	1	0	Negative
74	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMFGRCN_FIN_FIELDS	AGNCY_LCTN_CODE	FMFGT_ALC	ALC
2	IFMFGRCN_FIN_FIELDS	APPLICATION_OF_FUND	FMFUSE	FINUSE
3	IFMFGRCN_FIN_FIELDS	BUS_AREA	TGSB	GSBER
4	IFMFGRCN_FIN_FIELDS	COSTCENTER	CSKS	KOSTL
5	IFMFGRCN_FIN_FIELDS	COSTOBJECT	CKPH	KSTRG
6	IFMFGRCN_FIN_FIELDS	COST_ELEM	CSKA	KSTAR
7	IFMFGRCN_FIN_FIELDS	CO_AREA	TKA01	KOKRS
8	IFMFGRCN_FIN_FIELDS	CO_BUSPROC	CBPR	PRZNR
9	IFMFGRCN_FIN_FIELDS	CURRENCY	TCURC	WAERS
10	IFMFGRCN_FIN_FIELDS	FM_AREA	FM01	FIKRS
11	IFMFGRCN_FIN_FIELDS	FUNC_AREA	TFKB	FKBER
12	IFMFGRCN_FIN_FIELDS	FUND	FMFINCODE	FINCODE
13	IFMFGRCN_FIN_FIELDS	FUNDS_CTR	FMFCTR	FICTR
14	IFMFGRCN_FIN_FIELDS	FUND_TYPE	FMFUNDTYPE	FUND_TYPE
15	IFMFGRCN_FIN_FIELDS	MEASURE	FMMEASURE	MEASURE
16	IFMFGRCN_FIN_FIELDS	NETWORK	AUFK	AUFNR
17	IFMFGRCN_FIN_FIELDS	ORDERID	AUFK	AUFNR
18	IFMFGRCN_FIN_FIELDS	RCN_SUBTOTAL	FMFGRCN_SUBTOT	SUBTOT_ID
19	IFMFGRCN_FIN_FIELDS	SD_ORDER	VBUK	VBELN
20	IFMFGRCN_FIN_FIELDS	SEGMENT	FAGL_SEGM	SEGMENT
21	IFMFGRCN_FIN_FIELDS	SPONSORED_CLASS	GMSPCLASS	SPONSORED_CLASS
22	IFMFGRCN_FIN_FIELDS	SPONSORED_PROGRAM	GMSPPROGRAM	SPONSORED_PROG
23	IFMFGRCN_FIN_FIELDS	TRADE_ID	T880	RCOMP
24	IFMFGRCN_FIN_FIELDS	TRANSAC	TJ01	VRGNG
25	IFMFGRCN_FIN_FIELDS	VERSION	T894	RVERS
26	IFMFGRCN_FIN_FIELDS	WBS_ELEM	PRPS	PSPNR

History

Last changed by/on	SAP	20110901
SAP Release Created in	200