ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Public Sector Management :: Grants Management :: Grantee Management :: Master Data
1	ERP EHP7	6.0	GMGR	64	5	Grant Master	Master Data

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
3	REVISION_NBR	Grant Revision Number	nvarchar	3	0	Allow NULL?
4	INT_REFERENCE	Alternate Grant Identifier	nvarchar	24	0	Allow NULL?
5	EXT_REFERENCE	Alternate Grant Identifier	nvarchar	24	0	Allow NULL?
6	VALID_FROM	Valid-from Date	nvarchar	8	0	Allow NULL?
7	VALID_TO	Valid-to Date	nvarchar	8	0	Allow NULL?
8	GRANT_TYPE	Grant Type	nvarchar	2	0	Allow NULL?
9	COMPANY_CODE	Company Code	nvarchar	4	0	Allow NULL?
10	AWARD_TYPE	Award Type	nvarchar	3	0	Allow NULL?
11	AWARD_START	Valid-from Date	nvarchar	8	0	Allow NULL?
12	AWARD_END	Valid-to Date	nvarchar	8	0	Allow NULL?
13	FINAL_BILL_DATE	Final Bill Date	nvarchar	8	0	Allow NULL?
14	LETTER_OF_CREDIT	Letter of Credit	nvarchar	20	0	Allow NULL?
15	BLOCKING_IND	Blocking Indicator	char	1	0	Allow NULL?
16	SPLIT_OF_YEARS	Allow Year Split	char	1	0	Allow NULL?
17	GRANT_FY_VARIANT	Fiscal year variant of grant	nvarchar	2	0	Allow NULL?
18	GRANT_CURRENCY	Grant currency	nvarchar	5	0	Allow NULL?
19	GRANT_TOTAL	Total Grant Value in Sponsor Currency	decimal	13	2
20	EXCHANGE_RATE	Grant exchange rate	decimal	9	5
21	EXCHANGE_DATE	Exchange Rate Date	nvarchar	8	0	Allow NULL?
22	FROM_FACTOR	Ratio for the "From" Currency Units	decimal	9	0
23	TO_FACTOR	Ratio for the "To" Currency Units	decimal	9	0
24	CFDA	Number in Catalog of Federal Domestic Assistance	nvarchar	10	0	Allow NULL?
25	FUNDING_ORIGIN	Origin of Grant Funding	nvarchar	30	0	Allow NULL?
26	PARTNER	Grant Sponsor	nvarchar	10	0	Allow NULL?
27	SALES_ORDER	Sales Document	nvarchar	10	0	Allow NULL?
28	SALESORG	Sales Organization	nvarchar	4	0	Allow NULL?
29	DISTR_CHAN	Distribution Channel	nvarchar	2	0	Allow NULL?
30	DIVISION	Division	nvarchar	2	0	Allow NULL?
31	WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
32	BILLING_RULE	Rule Used as a Basis for Billing	nvarchar	4	0	Allow NULL?
33	PAYMENT_RULE	Payment Rule	nvarchar	4	0	Allow NULL?
34	INSTALLMENT_AMT	Installment amount for periodic billing	decimal	12	2
35	MILESTONE_TOTAL	Total Billing Amount (for milestone and periodic billing)	decimal	12	2
36	IDC_RULE	Rule for Determining Indirect Costs	nvarchar	4	0	Allow NULL?
37	SPLITTING_RULE	Rule Used to Split Time Intervals Between Fiscal Years	nvarchar	4	0	Allow NULL?
38	BUDGET_TRANSFER	Budget transfer restrictions	char	1	0	Allow NULL?
39	IDC_CAP	Maximum IDC allowed	decimal	12	2
40	IDC_ACCUMULATED	Total accumulated IDC per grant	decimal	12	2
41	CS_RULE	Rule for Determining Cost Sharing Requirements	nvarchar	4	0	Allow NULL?
42	CS_RATE	Overall Cost Sharing Rate for Grant	decimal	7	3
43	OBJECT_NO	General Object Number	nvarchar	22	0	Allow NULL?
44	LIFECYCLE_STATUS	Lifecycle Status	nvarchar	5	0	Allow NULL?
45	USER_STATUS	User Status	nvarchar	5	0	Allow NULL?
46	WORKFLOW_STATUS	Workflow status	char	1	0	Allow NULL?
47	TASK_LIST	Task List for Schedule Manager	nvarchar	10	0	Allow NULL?
48	APPLICATION_LOG	Application Log: Log Handle	nvarchar	22	0	Allow NULL?
49	CREATED_BY	Record Created by	nvarchar	12	0	Allow NULL?
50	CREATED_ON	Created on	nvarchar	8	0	Allow NULL?
51	CREATED_AT	Created at	nvarchar	6	0	Allow NULL?
52	COPY_SOURCE	Source grant	nvarchar	20	0	Allow NULL?
53	MODIFIED_BY	Last Modified by	nvarchar	12	0	Allow NULL?
54	MODIFIED_ON	Date last modified	nvarchar	8	0	Allow NULL?
55	MODIFIED_AT	Last Modified Time	nvarchar	6	0	Allow NULL?
56	AUTHGR	Grants Management: Authorization Groups	nvarchar	10	0	Allow NULL?
57	XDELE	Deletion Indicator	char	1	0	Allow NULL?
58	PRE_AWARD_COSTS	Pre-award cost control	char	1	0	Allow NULL?
59	WORKFLOW_BLOCK	GM Blocks grant editing pending approval	char	1	0	Allow NULL?
60	OUTGOING	Outgoing Grant Indicator	char	1	0	Allow NULL?
61	ORDERID	Order Number	nvarchar	12	0	Allow NULL?
62	EXCHANGE_RULE	GM Exchange Rule for Revaluation	nvarchar	4	0	Allow NULL?
63	OBJECTID	GUID	nvarchar	32	0	Allow NULL?
64	DOCUMENT_CLASS	Storage Location of Document in SRM (Content Model)	nvarchar	10	0	Allow NULL?

Name	Primary	Unique	Type	Columns
GMGR~0	Yes	Yes	CLUSTERED	GRANT_NBR, CLIENT
GMGR~1	No	No	NONCLUSTERED	EXT_REFERENCE, CLIENT
GMGR~2	No	No	NONCLUSTERED	INT_REFERENCE, CLIENT
GMGR~3	No	No	NONCLUSTERED	USER_STATUS, LIFECYCLE_STATUS, GRANT_TYPE, CLIENT
GMGR~4	No	No	NONCLUSTERED	LIFECYCLE_STATUS, OUTGOING, CLIENT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

64 COLUMNS | 5 INDEXES | ERP 6.0 | GMGR TABLE

TOP ERP 6.0 | GMGR COLUMNS

TOP ERP 6.0 | GMGR INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

64 COLUMNS | 5 INDEXES | ERP 6.0 | GMGR TABLE

TOPERP 6.0 | GMGR COLUMNS

TOPERP 6.0 | GMGR INDEXES

TOP ERP 6.0 | GMGR COLUMNS

TOP ERP 6.0 | GMGR INDEXES