GMIA - Actual Line Item Table

Actual Line Item Table information is stored in SAP table GMIA.
It is part of development package GMBASIS_E in software component PSM-GM-GTE. This development package consists of objects that can be grouped under "Grants management (basis)".

Fields for table GMIA

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
RCLNT	Client	X	MANDT	CLNT	6	T000
GL_SIRID	Record number of the line item record	X	GU_RECID	CHAR	36
RLDNR	Ledger		RLDNR	CHAR	4	T881
RRCTY	Record Type		RRCTY	CHAR	2
RVERS	Version		RVERS	CHAR	6	T894
RYEAR	Fiscal Year		GJAHR	NUMC	8
RTCUR	Currency Key		RTCUR	CUKY	10	TCURC
RUNIT	Base Unit of Measure		MEINS	UNIT	6	T006
POPER	Posting period		POPER	NUMC	6
DOCCT	Document Category		DOCCT	CHAR	2
DOCNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
DOCLN	Six-Character Posting Item for Ledger		DOCLN6	CHAR	12
RBUKRS	Company Code		BUKRS	CHAR	8	T001
RGRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
RSPONSORED_PROG	Sponsored Program		GM_SPONSORED_PROG	CHAR	40
RSPONSORED_CLASS	Sponsored Class		GM_SPONSORED_CLASS	CHAR	40
RBDGT_VLDTY_NBR	Budget Validity Number		GM_BDGT_VLDTY_NBR	CHAR	6
RFUND	Fund		BP_GEBER	CHAR	20
RVALUETYPE_9	GM Value Type		GM_VALUETYPE	CHAR	4
RTRANS	Business Transaction		J_VORGANG	CHAR	8
RSTATS_IND	Statistical Indicator		GM_STATS	CHAR	2
RGRANTEE_FY_9	Fiscal Year for Grantee Organization		GM_GRANTEE_FY	NUMC	8
LOGSYS	Logical system		LOGSYS	CHAR	20	TBDLS
BDGT_STATE	Workflow State of a Record in the Budget Totals Table		GM_BDGT_STATE	CHAR	2
TSL	Value in Transaction Currency		VTCUR9_CS	CURR	9
HSL	Value in local currency		VLCUR9_CS	CURR	9
MSL	Quantity		QUAN1	QUAN	8
SGTXT	Item Text		SGTXT	CHAR	100
DOCTY	FI-SL Document Type		DOCTY	CHAR	4	T889
ACTIV	Business Transaction		GLVOR	CHAR	8
BUDAT	Posting Date in the Document		BUDAT	DATS	16
WSDAT	Value Date for Currency Translation		WSDAT	DATS	16
REFDOCNR	Reference document number of an accounting document		REFBELNR	CHAR	20
REFRYEAR	Reference fiscal year		REFGJAHR	NUMC	8
REFDOCLN	Six-Digit Number of the Reference Posting Line		REFBUZEI6	NUMC	12
REFDOCCT	Reference Document Category		REFDOCCT	CHAR	2
REFACTIV	FI-SL Business Reference Transaction		REFGLVOR	CHAR	8
REFDOC_DETAIL	Reference Key		AWKEY	CHAR	40
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
CPUTM	Time of Entry		CPUTM	TIMS	12
USNAM	User Name		USNAM	CHAR	24
AWTYP	Reference procedure		AWTYP	CHAR	10	TTYP
AWORG	Reference Organizational Units		AWORG	CHAR	20
GL_ACCOUNT	General Ledger Account		HKONT	CHAR	20
CO_AREA	Controlling Area		KOKRS	CHAR	8
COSTCENTER	Cost Center		KOSTL	CHAR	20
ORDERID	Order Number		AUFNR	CHAR	24
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
PROFIT_CTR	Profit Center		PRCTR	CHAR	20
ASSETMAINO	Main Asset Number		BF_ANLN1	CHAR	24
ASSETSUBNO	Asset Subnumber		BF_ANLN2	CHAR	8
MATERIAL	Material Number		MATNR	CHAR	80
FM_AREA	Financial Management Area		FIKRS	CHAR	8
BUS_AREA	Business Area		GSBER	CHAR	8
FUNDS_CTR	Funds Center		FISTL	CHAR	32
CMMT_ITEM	Commitment Item		FM_FIPEX	CHAR	48
FAREA	Functional Area		FM_FAREA	CHAR	32
MEASURE	Funded Program		FM_MEASURE	CHAR	48
NETWORK	Network Number for Account Assignment		NPLNR	CHAR	24
ROUTING_NO	Routing number of operations in the order		CO_AUFPL	NUMC	20
COUNTER_9	Internal counter		CIM_COUNT	NUMC	16
OBJ_ORG_P	Reference Organizational Units		AWORG	CHAR	20
OBJ_TYP_P	Previous document: Reference procedure		AWTYP_PRE	CHAR	10
OBJ_KEY_P	Previous document: Object key (AWREF_REV and AWORG_REV)		AWKEY_PRE	CHAR	40
OBJ_POS_P	Previous document: Reference line item		AWPOS_PRE	CHAR	20
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
LINETYPE	Item Category		LINETYPE	CHAR	10
XSPLITMOD	Item Changed by Document Splitting		XSPLITMOD	CHAR	2
WSL	Value in Original Transaction Currency (Document Currency)		VWCUR12	CURR	12
RWCUR	Currency key of the original transaction currency		RWCUR	CUKY	10
BILLING_STATUS	Billing Status for Item		GM_BILLING_STATUS	CHAR	2
ERLKZ	Completion Indicator for Line Item		GM_ERLKZ	CHAR	2
LOEKZ	Deletion Indicator		GM_LOEKZ	CHAR	2
BILLING_BLOCK_9	Billing Block Flag for an Item		GM_BILLING_BLOCK	CHAR	2
DOC_ORIGIN_9	Document's Technical Origin		GM_TECHORG	CHAR	2
.INCLUDE				INCL_EEW_COBL	0
.INCLUDE				CI_COBL	0
DUMMY_INCL_EEW_COBL	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
WBS_SHORT_9	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16
AWSYS	Logical system		LOGSYS	CHAR	20