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	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
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
Portfolio and Project Management :: Portfolio Management
1	ERP EHP7	6.0	/RPM/ITEM_D_DER	49	1	Project data	Portfolio Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	GUID	Guid for application objects	varbinary	16	0
3	RISK_PRCNT	Risk Group - Upper Limit	nvarchar	3	0	Allow NULL?
4	RISK_GROUP	Risk Group Assessed	nvarchar	2	0	Allow NULL?
5	RISK_ICON	Project Risk	nvarchar	4	0	Allow NULL?
6	DERIVED_RISK	Derived Risk	nvarchar	3	0	Allow NULL?
7	HEADC_ACTUAL	Actual Headcount	decimal	10	2
8	PRIORITY_ICON	Priority	nvarchar	4	0	Allow NULL?
9	PHASE_ICON	Stage	nvarchar	4	0	Allow NULL?
10	PHASE_COLOR	Alert Object Color Status	nvarchar	7	0	Allow NULL?
11	CHANGED_ON	Time Stamp	decimal	15	0
12	BUDGET_ICON	Budget	nvarchar	4	0	Allow NULL?
13	SCHEDULE_ICON	Schedule	nvarchar	4	0	Allow NULL?
14	STAFFING_ICON	Staffing	nvarchar	4	0	Allow NULL?
15	BUDGET_TOTAL	Total Budget	decimal	16	2
16	BUDGET_ANNUAL	Annual Budget	decimal	16	2
17	PLANNED_COST	Planned Costs	decimal	16	2
18	PLANNED_COST_YTD	Planned Costs Year to Date	decimal	16	2
19	ACTUAL_COST	Actual Costs	decimal	16	2
20	ACTUAL_COST_YTD	Actual Cost Year to Day	decimal	16	2
21	CURRENCY	Currency key	nvarchar	5	0	Allow NULL?
22	PROPOSAL	Proposal	char	1	0	Allow NULL?
23	STATUS_GROUP	Status Group	nvarchar	4	0	Allow NULL?
24	ACT_PHASE_GUID	Application Object GUID	varbinary	16	0
25	WORKEFFORT_TOTAL	Actual Effort	decimal	26	8
26	WORKEFFORT_YTD	Work Effort Year-to-Date	decimal	26	8
27	PLANNED_EFFORT	Planned Effort	decimal	26	8
28	PLANNED_EFRTYTD	Planned Effort Year-to-Date	decimal	26	8
29	ROI	Return on Investment in % (manual)	decimal	16	2
30	IRR	Internal Rate of Return in % (manual)	decimal	16	2
31	RISK_GROUP_D	Risk Group Derived	nvarchar	2	0	Allow NULL?
32	RISK_D_ICON	Derived Risk	nvarchar	4	0	Allow NULL?
33	FORCTED_DURATION	Forecasted Duration	decimal	4	0
34	PLANNED_DURATION	Planned Duration	decimal	4	0
35	ACTUAL_DURATION	Actual Duration	decimal	4	0
36	STAFFING_GROUP	Staffing Status Group	nvarchar	2	0	Allow NULL?
37	BUDGET_GROUP	Budget Status Group	nvarchar	2	0	Allow NULL?
38	SCHEDULE_GROUP	Schedule Status Group	nvarchar	2	0	Allow NULL?
39	PLANNED_REVENUE	Planned Revenues	decimal	16	2
40	PLANNED_REV_YTD	Planned Revenues Year to Date	decimal	16	2
41	ACTUAL_REVENUE	Actual Revenues	decimal	16	2
42	ACTUAL_REV_YTD	Actual Revenues Year to Day	decimal	16	2
43	NPV_PLAN	Net Present Value	decimal	16	2
44	IRR_PLAN	Internal Rate of Return in %	decimal	16	2
45	ROI_PLAN	Return on Investment in %	decimal	16	2
46	PAYBACK_PLAN	Payback Periods in Months	nvarchar	6	0	Allow NULL?
47	ECV_PLAN	Expected Commercial Value	decimal	16	2
48	EA_DUMMY_KPI	Single-Character Indicator	char	1	0	Allow NULL?
49	EA_DUMMY	Single-Character Indicator	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

49 COLUMNS | 1 INDEXES | ERP 6.0 | /RPM/ITEM_D_DER TABLE

TOP ERP 6.0 | /RPM/ITEM_D_DER COLUMNS

TOP ERP 6.0 | /RPM/ITEM_D_DER 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

49 COLUMNS | 1 INDEXES | ERP 6.0 | /RPM/ITEM_D_DER TABLE

TOPERP 6.0 | /RPM/ITEM_D_DER COLUMNS

TOPERP 6.0 | /RPM/ITEM_D_DER INDEXES

TOP ERP 6.0 | /RPM/ITEM_D_DER COLUMNS

TOP ERP 6.0 | /RPM/ITEM_D_DER INDEXES