SAP ABAP Table FMIOI (Commitment Documents Funds Management)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-FM (Application Component) Funds Management
     ⤷ FMFS_CORE (Package) Update Funds Management Core Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMIOI	Table Relationship Diagram
Short Description	Commitment Documents Funds Management

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key for Table FMIOI
3	.INCLUDE	☑				0	0	Common Key for Funds Management Actual Data
4	REFBN	☑	CO_REFBN	BELNR	CHAR	10	0	Reference Document Number
5	REFBT	☑	FM_REFBTYP	FM_REFBTYP	NUMC	3	0	Reference document category
6	RFORG	☑	AWORG	AWORG	CHAR	10	0	Reference organisational units
7	RFPOS	☑	CC_RFPOS	NUMC05	NUMC	5	0	Item number of reference document
8	RFKNT	☑	CC_RFKNT	NUMC05	NUMC	5	0	Account assignment number of reference document
9	RFETE	☑	CC_RFETE	ETENR	NUMC	4	0	Reference document classification number	*
10	RCOND	☑	RCOND	RCOND	NUMC	5	0	Counter Conditions and Level Number
11	RFTYP	☑	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
12	RFSYS	☑	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
13	.INCLUDE	☑				0	0	Common Key for Funds Management Actual Data
14	BTART	☑	FM_BTART	FM_BTART	CHAR	4	0	Amount type
15	RLDNR	☑	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
16	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
17	STUNR	☑	FM_STUNR	CHAR16	CHAR	16	0	Number that clearly identifies the line key in database
18	.INCLUDE	☐				0	0	Common Data for Funds Management Actual Data
19	ZHLDT	☐	FM_ZHLDT	DATUM	DATS	8	0	Funds Management - Update Date
20	GNJHR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
21	PERIO	☐	CO_PERIO	PERBL	NUMC	3	0	Period
22	CFSTAT	☐	FM_CFST	FM_CFST	NUMC	2	0	FM Commitment Carryforward: Status
23	CFSTATSV	☐	FM_CFSTSV	FM_CFST	NUMC	2	0	Year-End Closing: Status (Back Up)
24	CFCNT	☐	FM_CFCNT	FM_CFCNT	NUMC	2	0	Year-End Closing: Number of Transfers
25	OBJNRZ	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
26	TRBTR	☐	FM_TRBTR	WERTV7	CURR	13	2	Amount in transaction currency
27	FKBTR	☐	FM_FKBTR	WERTV7	CURR	13	2	Amount in FM area currency
28	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
29	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
30	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
31	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
32	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
33	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
34	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
35	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
36	WRTTP	☐	FM_WRTTP	FM_WRTTP	CHAR	2	0	Value Type
37	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	TJ01
38	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
39	STATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
40	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
41	CFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
42	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
43	TRANR	☐	FM_TRANR	CHAR16	CHAR	16	0	Funds Management Transaction Number
44	CTRNR	☐	FM_CTRNR	CHAR20	CHAR	20	0	Funds Management Control Number
45	USERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
46	.INCLUDE	☐				0	0
47	.INCLU--AP	☐				0	0	Field Enhancements for EA-PS 2.0
48	FMVOR	☐	FMVOR	FMVOR	CHAR	4	0	Classification of Document Lines
49	.INCLU--AP	☐				0	0	Budget Period
50	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
51	.INCLUDE	☐				0	0	Clean Open Item Data for Funds Management Actual Data
52	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
53	ERLKZ	☐	ERLKZ	ERLKZ	CHAR	1	0	Completed Indicator for Open Items
54	LOEKZ	☐	KBLLOEKZ	CHAR1_X	CHAR	1	0	Deletion Indicator
55	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
56	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
57	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
58	BL_DOC_TYPE	☐	FM_BL_DOC_TYPE	CHAR4	CHAR	4	0	FM budgetary ledger document type
59	DP_WITH_PO	☐	FM_DP_WITH_PO	FM_DP_WITH_PO	CHAR	1	0	FM Down payment with reference to purchase order for BL
60	.INCLUDE	☐				0	0	Ref. Funds Management Actual Data to Preceding Document
61	VREFBT	☐	FM_VREFBT	FM_REFBTYP	NUMC	3	0	Predecessor document category
62	VREFBN	☐	FM_VREFBN	BELNR	CHAR	10	0	Predecessor document number
63	VRFORG	☐	FM_VRFORG	AWORG	CHAR	10	0	Predecessor document organization
64	VRFPOS	☐	FM_VRFPOS	NUMC05	NUMC	5	0	Predecessor document item
65	VRFKNT	☐	FM_VRFKNT	NUM05	NUMC	5	0	Predecessor account assignment
66	VRFTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
67	VRFSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
68	.INCLUDE	☐				0	0	FM: Append Structure for FMIOI (CCN Fields)
69	ITCNACT	☐	FM_ITCNACT	XFELD	CHAR	1	0	FM: Change with active CCN functionality
70	.INCLU--AP	☐				0	0	Append for new fields ECC50/ERP
71	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
72	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
73	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
74	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
75	BLDOCDATE	☐	FM_BL_DOCDATE	DATUM	DATS	8	0	Budgetary Ledger Document Date
76	.INCLU--AP	☐				0	0	SD order needs quantity
77	QUANT_OPEN	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
78	QUANT_INV	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
79	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
80	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMIOI	BUKRS	T001	BUKRS	REF	1	CN
2	FMIOI	FAREA	TFKB	FKBER
3	FMIOI	FIKRS	FM01	FIKRS
4	FMIOI	FISTL	FMFCTR	FICTR	REF	1	CN
5	FMIOI	FONDS	FMFINCODE	FINCODE
6	FMIOI	LIFNR	LFA1	LIFNR	REF	C	CN
7	FMIOI	MANDT	T000	MANDT	KEY	1	CN
8	FMIOI	MEINS	T006	MSEHI
9	FMIOI	OBJNRZ	ONR00	OBJNR	REF	C	CN
10	FMIOI	RLDNR	T881	RLDNR	KEY	1	CN
11	FMIOI	TWAER	TCURC	WAERS	REF	1	CN
12	FMIOI	VRGNG	TJ01	VRGNG

History

Last changed by/on	SAP	20130529
SAP Release Created in