SAP ABAP Table GMRLDI (GM reporting structure to display ledger document items)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-GM-GTE-MD (Application Component) Master Data
     ⤷ GMMASTERDATA_E (Package) Grants management (master data)

Basic Data

Table Category	INTTAB	Structure
Structure	GMRLDI	Table Relationship Diagram
Short Description	GM reporting structure to display ledger document items

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	.INCLUDE	☐				0	0	Actual Line Item Table
2	RCLNT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GL_SIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
4	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
5	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
6	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
7	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
9	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
10	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
16	RSPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	*
17	RSPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	*
18	RBDGT_VLDTY_NBR	☐	GM_BDGT_VLDTY_NBR	GM_BDGT_VLDTY_NBR	CHAR	3	0	Budget Validity Number
19	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
20	RVALUETYPE_9	☐	GM_VALUETYPE	GM_VALUETYPE	CHAR	2	0	GM Value Type
21	RTRANS	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*
22	RSTATS_IND	☐	GM_STATS	GM_STATS	CHAR	1	0	Statistical Indicator
23	RGRANTEE_FY_9	☐	GM_GRANTEE_FY	GJAHR	NUMC	4	0	Fiscal Year of Grantee Organization
24	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
25	BDGT_STATE	☐	GM_BDGT_STATE	GM_BDGT_STATE	CHAR	1	0	Workflow State of a Record in the Budget Totals Table
26	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
27	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
28	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
29	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
30	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
31	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
32	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
33	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
34	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
35	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
36	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
37	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
38	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
39	REFDOC_DETAIL	☐	AWKEY	AWKEY	CHAR	20	0	Object key
40	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
41	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
42	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
43	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
44	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
45	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
46	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
47	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
48	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
49	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
50	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
51	ASSETMAINO	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
52	ASSETSUBNO	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
53	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
54	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
55	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
56	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
57	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
58	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
59	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
60	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
61	ROUTING_NO	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
62	COUNTER_9	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
63	OBJ_ORG_P	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
64	OBJ_TYP_P	☐	AWTYP_PRE	AWTYP	CHAR	5	0	Previous document: Reference procedure	*
65	OBJ_KEY_P	☐	AWKEY_PRE	AWKEY	CHAR	20	0	Previous document: Object key (AWREF_REV and AWORG_REV)
66	OBJ_POS_P	☐	AWPOS_PRE	AWPOS	CHAR	10	0	Previous document: Reference line item
67	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
68	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
69	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
70	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
71	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
72	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	*
73	BILLING_STATUS	☐	GM_BILLING_STATUS	GM_BILLING_STATUS	CHAR	1	0	Billing Status for Item
74	ERLKZ	☐	GM_ERLKZ	CHAR1_X	CHAR	1	0	Completion Indicator for Line Item
75	LOEKZ	☐	GM_LOEKZ	CHAR1_X	CHAR	1	0	Deletion Indicator
76	BILLING_BLOCK_9	☐	GM_BILLING_BLOCK	GM_BILLING_BLOCK	CHAR	1	0	Billing Block Flag for an Item
77	DOC_ORIGIN_9	☐	GM_TECHORG	GM_TECHORG	CHAR	1	0	Document's Technical Origin
78	.INCLUDE	☐				0	0
79	WBS_SHORT_9	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
80	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
81	PGRANT_NBR	☐	GM_PARTNER_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	partner grant number
82	PFUND	☐	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
83	PSPONSORED_PROG	☐	GM_PARTNER_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Partner Sponsored Program	*
84	PSPONSORED_CLASS	☐	GM_PARTNER_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Partner Sponsored Class	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GMRLDI	AWTYP	TTYP	AWTYP	REF	C	CN
2	GMRLDI	DOCTY	T889	DOCTY	REF	C	CN
3	GMRLDI	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	GMRLDI	RBUKRS	T001	BUKRS	REF	C	CN
5	GMRLDI	RCLNT	T000	MANDT	KEY	1	CN
6	GMRLDI	RLDNR	T881	RLDNR	REF	C	CN
7	GMRLDI	RTCUR	TCURC	WAERS	REF	C	CN
8	GMRLDI	RUNIT	T006	MSEHI	REF	C	CN
9	GMRLDI	RVERS	T894	RVERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in