SAP ABAP Table GMRBIL (GM report structure for billing list)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-GM-GTE-GM (Application Component) Grants Management - Specific Postings
     ⤷ GMBILLING_E (Package) Grants Management (billing)

Basic Data

Table Category	INTTAB	Structure
Structure	GMRBIL	Table Relationship Diagram
Short Description	GM report structure for billing list

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	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
2	SPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	*
3	SPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	*
4	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
5	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
6	GL_SIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
7	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
9	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
10	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
11	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	BDGT_VLDTY_NBR	☐	GM_BDGT_VLDTY_NBR	GM_BDGT_VLDTY_NBR	CHAR	3	0	Budget Validity Number
15	VALUETYPE	☐	GM_VALUETYPE	GM_VALUETYPE	CHAR	2	0	GM Value Type
16	RTRANS	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*
17	RSTATS_IND	☐	GM_STATS	GM_STATS	CHAR	1	0	Statistical Indicator
18	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
19	BDGT_STATE	☐	GM_BDGT_STATE	GM_BDGT_STATE	CHAR	1	0	Workflow State of a Record in the Budget Totals Table
20	TSL	☐	GM_AMT_TSL	WERTV9	CURR	17	2	GM Amount in Grant Currency
21	HSL	☐	GM_AMT_HSL	WERTV9	CURR	17	2	GM Amount in Company Code Currency
22	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
23	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
24	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
25	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
26	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
27	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
28	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
29	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
30	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
31	REFDOC_DETAIL	☐	AWKEY	AWKEY	CHAR	20	0	Object key
32	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
33	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
34	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
35	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
36	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
37	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
38	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
39	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
40	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
41	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
42	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
43	ASSETMAINO	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
44	ASSETSUBNO	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
45	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
46	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
47	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
48	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
49	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
50	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
51	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
52	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
53	ROUTING_NO	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
54	COUNTER	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
55	OBJ_ORG_P	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
56	OBJ_TYP_P	☐	AWTYP_PRE	AWTYP	CHAR	5	0	Previous document: Reference procedure	*
57	OBJ_KEY_P	☐	AWKEY_PRE	AWKEY	CHAR	20	0	Previous document: Object key (AWREF_REV and AWORG_REV)
58	OBJ_POS_P	☐	AWPOS_PRE	AWPOS	CHAR	10	0	Previous document: Reference line item
59	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
60	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
61	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
62	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
63	BILLING_STATUS	☐	GM_BILLING_STATUS	GM_BILLING_STATUS	CHAR	1	0	Billing Status for Item
64	ERLKZ	☐	GM_ERLKZ	CHAR1_X	CHAR	1	0	Completion Indicator for Line Item
65	LOEKZ	☐	GM_LOEKZ	CHAR1_X	CHAR	1	0	Deletion Indicator
66	EXPENSELINE	☐	GM_EXPENSELINE	FLAG	CHAR	1	0	GM Specifies the Expense Line
67	EXPENSEDOC	☐	GM_EXPENSEDOC	BELNR	CHAR	10	0	GM Expense Document Number
68	BILLINGDOC	☐	GM_BILLINGDOC	BELNR	CHAR	10	0	GM Billing Document Number
69	WAERS	☐	GM_COMP_CODE_CURRENCY	WAERS	CUKY	5	0	GM Company Code Currency	*
70	AMOUNT_UNBILLED	☐	GM_AMOUNT_UNBILLED	WERTV9	CURR	17	2	GM Amount to be billed
71	AMOUNT_BILLED	☐	GM_AMOUNT_BILLED	WERTV9	CURR	17	2	GM Amount Billed
72	AMOUNT_SUMBILLED	☐	GM_AMOUNT_SUMBILLED	WERTV9	CURR	17	2	GM Amount Unbilled and Billed
73	CURRENCY	☐	GM_REPORTING_CURRENCY	WAERS	CUKY	5	0	GM reporting currency	*
74	GRANT_SHORT_DESCRIPTION	☐	GM_GRANT_SHORT_DESC	CHAR20	CHAR	20	0	Name of Grant
75	SPONSOR	☐	GM_SPONSOR	BU_PARTNER	CHAR	10	0	Grant Sponsor	*
76	SPONSOR_DESCRIPTION	☐	GM_SPONSOR_DESCRIPTION	TEXT80	CHAR	80	0	Sponsor Description
77	COMPANY_CODE_TEXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
78	SPONSORED_PROG_TEXT	☐	GM_PROGRAM_TEXT	TEXT30	CHAR	30	0	Sponsored Program Description
79	SPONSORED_CLASS_TEXT	☐	GM_CLASS_TEXT	TEXT30	CHAR	30	0	Sponsored Class Description
80	FUND_TEXT	☐	FM_FUND_DESCR	TEXT40	CHAR	40	0	Description of funds
81	VALUETYPE_TEXT	☐	GM_VALUETYPE_TXT	TEXT40	CHAR	40	0	Value Type Text
82	BILLING_RULE	☐	GM_BILLING_RULE	GM_BILLING_RULE	NUMC	4	0	Rule Used as a Basis for Billing	*
83	BILLING_RULE_TEXT	☐	GM_BILLING_RULE_TXT	TEXT30	CHAR	30	0	Billing Rule Description
84	ICO_STATUS	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
85	SORT	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
86	PGRANT_NBR	☐	GM_PARTNER_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	partner grant number
87	PFUND	☐	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
88	PSPONSORED_PROG	☐	GM_PARTNER_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Partner Sponsored Program	*
89	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	GMRBIL	AWTYP	TTYP	AWTYP	REF	C	CN
2	GMRBIL	BUKRS	T001	BUKRS	REF	C	CN
3	GMRBIL	DOCTY	T889	DOCTY	REF	C	CN
4	GMRBIL	LOGSYS	TBDLS	LOGSYS	REF	C	CN
5	GMRBIL	RTCUR	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110