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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DB_KEY	NodeID	varbinary	16	0	RAW		No		/BOBF/CONF_KEY
3	NODE_CAT_KEY	NodeID	varbinary	16	0	RAW		Yes		/BOBF/CONF_KEY
4	ISSUE_ID	Issue ID	nvarchar	20	0	CHAR	(N' ')	Yes		/IAM/ISSUE_ID	Allow NULL?
5	APPLICATION	Application in Issue and Activity Engine	nvarchar	3	0	CHAR	(N' ')	Yes	/IAM/I_APPL	/IAM/APPLICATION	Allow NULL?
6	ISSUE_TYPE	Issue Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	/IAM/ISSUE_TYPE	Allow NULL?
7	ISSUE_CATEGORY	Issue Category	nvarchar	3	0	CHAR	(N' ')	Yes	*	/IAM/ISS_CATEGORY	Allow NULL?
8	PAR_ISSUE_UUID	NodeID	varbinary	16	0	RAW		Yes		/BOBF/CONF_KEY
9	ROOT_ISSUE_UUID	NodeID	varbinary	16	0	RAW		Yes		/BOBF/CONF_KEY
10	SORTNO	Sort Number	nvarchar	4	0	NUMC	(N'0000')	Yes		/IAM/SORTNO	Allow NULL?
11	AUTH_GROUP	Authorization Group	nvarchar	4	0	CHAR	(N' ')	Yes	*	/IAM/AUTH_GROUP	Allow NULL?
12	CRITICALITY	Criticality	nvarchar	2	0	CHAR	(N' ')	Yes	*	/IAM/CRITICALITY	Allow NULL?
13	PRIORITY	Priority	nvarchar	3	0	CHAR	(N' ')	Yes		/IAM/PRIORITY	Allow NULL?
14	EMERGENCY	Emergency Indicator	char	1	0	CHAR	(N' ')	Yes		/IAM/EMERGENCY	Allow NULL?
15	REPORTED_BY	Business Partner Name	nvarchar	50	0	CHAR	(N' ')	Yes		/IAM/BU_DESCRIP	Allow NULL?
16	DURATION_CD	Duration	nvarchar	3	0	CHAR	(N' ')	Yes	*	/IAM/DURATION	Allow NULL?
17	COUNTRY	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
18	DEF_QUANT_UNIT	Default Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/IAM/DEF_QTY_UNIT	Allow NULL?
19	TERM_REDEF_ID	Redefinition of Semantics	nvarchar	3	0	CHAR	(N' ')	Yes	*	/IAM/REDEFINITION	Allow NULL?
20	ACT_DET_COUNT	Counter for Activity Determination	tinyint	3	0	INT1	((0))	Yes		/IAM/ACT_DET_COUNT
21	ARCHIVING_OF_ACT	Activities of Issue Are Archived	char	1	0	CHAR	(N' ')	Yes		/IAM/ARCHIVING_OF_ACT	Allow NULL?
22	STATUS_PROFILE	Status Profile	nvarchar	3	0	CHAR	(N' ')	Yes		/IAM/USER_STATUS_PROFILE	Allow NULL?
23	DATE_SCHEMA	Date Schema	nvarchar	3	0	CHAR	(N' ')	Yes		/IAM/DATE_SCHEMA	Allow NULL?
24	LCYCLE_CD	Issue Lifecycle Status Code	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/ISSUE_LCYCLE_STAT_CD	Allow NULL?
25	CONSIST_CD	Consistency Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/CONSISTENCY_STATUS_CD	Allow NULL?
26	DEFERRAL_CD	Deferral Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/DEFERRAL_STATUS_CD	Allow NULL?
27	ARCHIVING_CD	Archiving Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/ARCHIVING_STATUS_CD	Allow NULL?
28	VALIDATION_CD	Validation Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/VALIDATION_STATUS_CD	Allow NULL?
29	EFFECTIVENESS_CD	Effectiveness Check Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/EFFECTIVENESS_STATUS_CD	Allow NULL?
30	APPROVAL_CD	Approval Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/APPROVAL_STATUS_CD	Allow NULL?
31	ISSUE_TYPE_CD	Issue Type Status of an Object	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/ISSUE_TYPE_STATUS_CD	Allow NULL?
32	DIGSIGN_CD	Digital Signature Status Code	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/DIGIT_SIGN_CD	Allow NULL?
33	DIGSIGN_ACTION	Action	varbinary	16	0	RAW		Yes		/BOBF/ACT_KEY
34	USER_STATUS_01	User Status Code 1	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/USER_STATUS1	Allow NULL?
35	USER_STATUS_02	User Status Code 2	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/USER_STATUS2	Allow NULL?
36	USER_STATUS_03	User Status Code 3	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/USER_STATUS3	Allow NULL?
37	USER_STATUS_04	User Status Code 4	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/USER_STATUS4	Allow NULL?
38	USER_STATUS_05	User Status Code 5	nvarchar	2	0	CHAR	(N' ')	Yes		/IAM/USER_STATUS5	Allow NULL?
39	CREATED_BY	Created By	nvarchar	12	0	CHAR	(N' ')	Yes	*	/BOFU/USER_ID_CREATED_BY	Allow NULL?
40	CREATED_ON	Created on	decimal	15	0	DEC	((0))	Yes		/BOFU/TSTMP_CREATION_TIME
41	CHANGED_BY	Changed By	nvarchar	12	0	CHAR	(N' ')	Yes	*	/BOFU/USER_ID_CHANGED_BY	Allow NULL?
42	CHANGED_ON	Changed On	decimal	15	0	DEC	((0))	Yes		/BOFU/TSTMP_CHANGED_TIME
43	I_ROOT	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
44	/CPD/MC_MP_GUID	NodeID	varbinary	16	0	RAW		Yes		/BOBF/CONF_KEY
45	ARCHIVING	Archiving Status	nvarchar	2	0	CHAR	(N' ')	Yes		/BOFU/ARCHIVING_STATUS_CODE	Allow NULL?
46	OBJECT_GUID	NodeID	varbinary	16	0	RAW		Yes		/BOBF/CONF_KEY
47	IDENTIFY_STAGE	Master Project: Stage	nvarchar	4	0	CHAR	(N' ')	Yes	*	/CPD/PWS_WS_MP_STG	Allow NULL?
48	RISK_ID	Risk ID	nvarchar	20	0	CHAR	(N' ')	Yes		/CPD/RM_RISK_ID	Allow NULL?
49	CAT_ID	Category ID	nvarchar	4	0	CHAR	(N' ')	Yes		/CPD/RM_CAT_ID	Allow NULL?
50	SUB_CAT_ID	Sub Category ID for Risk Management	nvarchar	4	0	CHAR	(N' ')	Yes		/CPD/RM_SUB_CAT_ID	Allow NULL?
51	RISK_TXT	Short Description	nvarchar	40	0	CHAR	(N' ')	Yes		/CPD/RM_DESCRIPTION	Allow NULL?
52	PROBABILITY_ID	Probability	nvarchar	2	0	CHAR	(N' ')	Yes		/CPD/RM_PROBABILITY	Allow NULL?
53	SEVERITY_ID	Severity	nvarchar	2	0	CHAR	(N' ')	Yes		/CPD/RM_SEVERITY	Allow NULL?
54	RISK_LEVEL_ID	Risk Management: Risk Level ID	nvarchar	4	0	CHAR	(N' ')	Yes		/CPD/RM_RISK_LEVEL_ID	Allow NULL?
55	RISK_STATUS	Risk Status ID	nvarchar	4	0	CHAR	(N' ')	Yes		/CPD/RM_STATUS_ID	Allow NULL?
56	EST_COST_IMPACT	Estimated Cost Impact	decimal	15	2	CURR	((0))	Yes		/CPD/RM_EST_COST
57	EST_SHDL_DELAY	Estimated Schedule Delay	int	10	0	INT4	((0))	Yes		/CPD/RM_EST_DELAY	Allow NULL?
58	RESP_TYPE	Risk Response Type	nvarchar	4	0	CHAR	(N' ')	Yes		/CPD/RM_RESPONSE_TYPE	Allow NULL?
59	RESP_STATUS	Response Status	nvarchar	4	0	CHAR	(N' ')	Yes		/CPD/RM_RESP_STATUS	Allow NULL?
60	RISK_MIT_COST	Estimated Cost Impact	decimal	15	2	CURR	((0))	Yes		/CPD/RM_EST_COST
61	RM_CURRENCY	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS_CURC	Allow NULL?
62	RISK_OPPT	Risk or Opportunity	char	1	0	CHAR	(N' ')	Yes		/CPD/RM_RISK_OPPT	Allow NULL?
63	COST	Impact	nvarchar	3	0	CHAR	(N' ')	Yes		/CPD/RM_IMPACTS	Allow NULL?
64	SCHEDULE	Impact	nvarchar	3	0	CHAR	(N' ')	Yes		/CPD/RM_IMPACTS	Allow NULL?
65	QUALITY	Impact	nvarchar	3	0	CHAR	(N' ')	Yes		/CPD/RM_IMPACTS	Allow NULL?
66	SCOPE	Impact	nvarchar	3	0	CHAR	(N' ')	Yes		/CPD/RM_IMPACTS	Allow NULL?
67	EST_COST	Estimated Cost	decimal	10	2	CURR	((0))	Yes		/PICM/EST_COST
68	CURRENCY	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS_CURC	Allow NULL?
69	EST_DELAY	Estimated Delay	int	10	0	INT4	((0))	Yes		/PICM/EST_DELAY	Allow NULL?
70	EST_DELAY_TYPE	Estimated Delay Type	nvarchar	15	0	CHAR	(N' ')	Yes		/PICM/ELM_DELAY_TYPE	Allow NULL?
71	SEND_NOTI	E-mail notification sent	char	1	0	CHAR	(N' ')	Yes		/PICM/SEND_NOTI	Allow NULL?
72	STAT_CD	Status Code	nvarchar	2	0	CHAR	(N' ')	Yes		/PICM/STATUS_CD	Allow NULL?
73	REFCR	Reference Change Request Number	nvarchar	20	0	CHAR	(N' ')	Yes		/PICM/REFCR	Allow NULL?
74	CRCAT	Change Request Category (Single, Collective, Blank)	char	1	0	CHAR	(N' ')	Yes		/PICM/CRCAT	Allow NULL?
75	PLAN_ID	Plan	nvarchar	24	0	CHAR	(N' ')	Yes		/PICM/PLAN_ID	Allow NULL?
76	PLAN_VERSION	Plan Version	nvarchar	2	0	NUMC	(N'00')	Yes		/PICM/PLAN_VERSION	Allow NULL?
77	PLAN_VERSION_ID	Plan Version	nvarchar	30	0	CHAR	(N' ')	Yes		/PICM/VERSION_ID	Allow NULL?
78	PLAN_VERSION_TYPE	Version Type	nvarchar	10	0	CHAR	(N' ')	Yes		/PICM/VER_TYPE_ID	Allow NULL?
79	MASTER_PROJ	Master Project	nvarchar	40	0	CHAR	(N' ')	Yes		/PICM/MASTER_PROJ	Allow NULL?
80	PICM_LCYCLE_CD	Issue Lifecycle Status Code	nvarchar	2	0	CHAR	(N' ')	Yes		/PICM/ISS_LCYCLE_STAT_CD	Allow NULL?
81	PROBABILITY	Probability	decimal	5	2	DEC	((0))	Yes		/PICM/PROBABILITY
82	ARCHIVING_STATUS	Archiving Status	nvarchar	2	0	CHAR	(N' ')	Yes		/BOFU/ARCHIVING_STATUS_CODE	Allow NULL?
83	PLAN_KEY	NodeID	varbinary	16	0	RAW		Yes		/BOBF/CONF_KEY

Name	Primary	Unique	Type	Columns
/IAM/D_I_ROOT~0	Yes	Yes	CLUSTERED	DB_KEY, MANDT
/IAM/D_I_ROOT~AK1	No	No	NONCLUSTERED	ISSUE_ID, MANDT
/IAM/D_I_ROOT~PI	No	No	NONCLUSTERED	PAR_ISSUE_UUID, MANDT
/IAM/D_I_ROOT~RI	No	No	NONCLUSTERED	ROOT_ISSUE_UUID, MANDT

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

83 COLUMNS | 4 INDEXES | ERP 6.0 | /IAM/D_I_ROOT TABLE

TOP ERP 6.0 | /IAM/D_I_ROOT COLUMNS

TOP ERP 6.0 | /IAM/D_I_ROOT 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

83 COLUMNS | 4 INDEXES | ERP 6.0 | /IAM/D_I_ROOT TABLE

TOPERP 6.0 | /IAM/D_I_ROOT COLUMNS

TOPERP 6.0 | /IAM/D_I_ROOT INDEXES

TOP ERP 6.0 | /IAM/D_I_ROOT COLUMNS

TOP ERP 6.0 | /IAM/D_I_ROOT INDEXES