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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Governance, Risk and Compliance
1	ERP EHP7	6.0	GRFNDMAL	68	1	DataMart: Analysis	Governance, Risk and Compliance

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	SNAPSHOT_ID	Datamart - Snapshot ID	nvarchar	32	0	Allow NULL?
3	OBJECT_ID	Object ID	nvarchar	50	0	Allow NULL?
4	AL	Analysis ID	nvarchar	32	0	Allow NULL?
5	AL_CREATED_BY	Analysis Created By	nvarchar	12	0	Allow NULL?
6	AL_CREATE_TIME	Analysis Created On	decimal	15	0
7	AL_CHANGED_BY	Analysis Last Changed By	nvarchar	12	0	Allow NULL?
8	AL_CHANGE_TIME	Analysis Last Changed On	decimal	15	0
9	AL_RESP_USER	Analysis Owner	nvarchar	12	0	Allow NULL?
10	AL_STATUS	Analysis Status	nvarchar	2	0	Allow NULL?
11	AL_CURRENCY	Currency	nvarchar	5	0	Allow NULL?
12	AL_VALID_FROM	Analysis Date	nvarchar	8	0	Allow NULL?
13	AL_VALID_TO	Analysis End Date	nvarchar	8	0	Allow NULL?
14	AL_PROFILE_ID	Cause & Consequence Id	nvarchar	10	0	Allow NULL?
15	AL_FH_ID	Reporting: DRS5 Forecasting Horizon ID	nvarchar	6	0	Allow NULL?
16	AL_INH_PRB	Inherent Probability	decimal	6	4
17	AL_INH_PRS	Inherent Probability Score	decimal	13	5
18	AL_INH_SOO	Inherent Speed of Onset ID	nvarchar	4	0	Allow NULL?
19	AL_INH_SOS	Inherent Speed of Onset Score	decimal	13	5
20	AL_INH_EXL	Inherent Expected Loss	decimal	15	2
21	AL_INH_PRL	Inherent Probability Level	nvarchar	3	0	Allow NULL?
22	AL_INH_IMN	Inherent Impact (Best Case)	decimal	15	2
23	AL_INH_IAV	Inherent Impact (Average Case)	decimal	15	2
24	AL_INH_IMX	Inherent Impact (Worst case)	decimal	15	2
25	AL_INH_IWG	Inherent Impact (Weighted)	decimal	15	2
26	AL_INH_IML	Inherent Impact Level ID	nvarchar	2	0	Allow NULL?
27	AL_INH_IMS	Inherent Impact Score	decimal	13	5
28	AL_INH_RSL	Inherent Risk Level ID	nvarchar	4	0	Allow NULL?
29	AL_INH_RSC	Inherent Risk Level colour	nvarchar	2	0	Allow NULL?
30	AL_INH_RSS	Inherent Risk Score	decimal	13	5
31	AL_INH_PRI	Inherent Risk Priority ID	nvarchar	3	0	Allow NULL?
32	AL_INH_IMM	Inherent Total Loss	decimal	15	2
33	AL_INH_OVR	Reporting: Inherent Impact Overwritten	char	1	0	Allow NULL?
34	AL_RSP_PRB	Planned Probability	decimal	6	4
35	AL_RSP_PRS	Planned Probability Score	decimal	13	5
36	AL_RSP_SOO	Planned Speed of Onset ID	nvarchar	4	0	Allow NULL?
37	AL_RSP_SOS	Planned Speed of Onset Score	decimal	13	5
38	AL_RSP_EXL	Planned Expected Loss	decimal	15	2
39	AL_RSP_PRL	Planned Probabaility Level	nvarchar	3	0	Allow NULL?
40	AL_RSP_IMN	Planned Impact (Best Case)	decimal	15	2
41	AL_RSP_IAV	Planned Impact (Average Case)	decimal	15	2
42	AL_RSP_IMX	Planned Impact (Worst Case)	decimal	15	2
43	AL_RSP_IWG	Planned Impact (Weighted)	decimal	15	2
44	AL_RSP_IML	Planned Impact Level ID	nvarchar	2	0	Allow NULL?
45	AL_RSP_IMS	Planned Impact Score	decimal	13	5
46	AL_RSP_RSL	Planned Risk Level ID	nvarchar	4	0	Allow NULL?
47	AL_RSP_RSS	Planned Risk Score	decimal	13	5
48	AL_RSP_RSC	Planned Risk Level Colour	nvarchar	2	0	Allow NULL?
49	AL_RSP_PRI	Planned Risk Priority ID	nvarchar	3	0	Allow NULL?
50	AL_RSP_IMM	Planned Total Loss	decimal	15	2
51	AL_RSA_PRB	Residual Probability	decimal	6	4
52	AL_RSA_EXL	Residual Expected Loss	decimal	15	2
53	AL_RSA_PRL	Residual Probability Level	nvarchar	3	0	Allow NULL?
54	AL_RSA_PRS	Residual Probability Score	decimal	13	5
55	AL_RSA_SOO	Residual Speed of Onset ID	nvarchar	4	0	Allow NULL?
56	AL_RSA_SOS	Residual Speed of Onset Score	decimal	13	5
57	AL_RSA_IMN	Residual Impact (Best Case)	decimal	15	2
58	AL_RSA_IAV	Residual Impact (Average Case)	decimal	15	2
59	AL_RSA_IMX	Residual Impact (Worst Case)	decimal	15	2
60	AL_RSA_IWG	Residual Impact (Weighted)	decimal	15	2
61	AL_RSA_IML	Residual Impact Level ID	nvarchar	2	0	Allow NULL?
62	AL_RSA_IMS	Residual Impact Score	decimal	13	5
63	AL_RSA_RSL	Residual Risk Level ID	nvarchar	4	0	Allow NULL?
64	AL_RSA_RSC	Residual Risk Level Colour	nvarchar	2	0	Allow NULL?
65	AL_RSA_RSS	Residual Risk Score	decimal	13	5
66	AL_RSA_PRI	Residual Risk Priority ID	nvarchar	3	0	Allow NULL?
67	AL_RSA_IMM	Residual Total Loss	decimal	15	2
68	AL_RSA_OVR	Reporting: Residual Impact Overwritten	char	1	0	Allow NULL?

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

68 COLUMNS | 1 INDEXES | ERP 6.0 | GRFNDMAL TABLE

TOP ERP 6.0 | GRFNDMAL COLUMNS

TOP ERP 6.0 | GRFNDMAL 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

68 COLUMNS | 1 INDEXES | ERP 6.0 | GRFNDMAL TABLE

TOPERP 6.0 | GRFNDMAL COLUMNS

TOPERP 6.0 | GRFNDMAL INDEXES

TOP ERP 6.0 | GRFNDMAL COLUMNS

TOP ERP 6.0 | GRFNDMAL INDEXES