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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DCT_PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
3	DCT_PABRJ	Payroll Year	nvarchar	4	0	Allow NULL?
4	DCT_PABRP	Payroll Period	nvarchar	2	0	Allow NULL?
5	DCT_CLTYP	Type of cluster	char	1	0	Allow NULL?
6	DCT_ROWID	Unique Row Number	nvarchar	5	0	Allow NULL?
7	LDATE	Logical Date	nvarchar	8	0	Allow NULL?
8	RUECK	Completion confirmation number for the operation	nvarchar	10	0	Allow NULL?
9	WSID1	Time ticket counter per confirmation no.and day	nvarchar	3	0	Allow NULL?
10	WSID2	Time ticket counter per day	nvarchar	3	0	Allow NULL?
11	SRCSYS	Logical system	nvarchar	10	0	Allow NULL?
12	BEGTM	Start time	nvarchar	6	0	Allow NULL?
13	ENDTM	End time	nvarchar	6	0	Allow NULL?
14	PDSNR_AASS	Time event number with account assignment	nvarchar	12	0	Allow NULL?
15	PDSNR_LAST	Number of last time event for this time ticket	nvarchar	12	0	Allow NULL?
16	DES1F	Destination indicator for external applications	char	1	0	Allow NULL?
17	DES2F	Destination within HR	char	1	0	Allow NULL?
18	SMJRF	Indicator for single/multi operation processing	char	1	0	Allow NULL?
19	EXUPD	External update: yes/no	char	1	0	Allow NULL?
20	VGW01	Standard value of processing time	decimal	13	3
21	VGE01	Measurement unit for standard value	nvarchar	3	0	Allow NULL?
22	SOW01	Target value of processing time	decimal	13	3
23	SOE01	Measurement unit for target value	nvarchar	3	0	Allow NULL?
24	RUW01	Confirmed value of processing time	decimal	13	3
25	RUE01	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
26	BEG01	Start of processing time	nvarchar	6	0	Allow NULL?
27	END01	End of processing time	nvarchar	6	0	Allow NULL?
28	VGW02	Standard value of setup time	decimal	13	3
29	VGE02	Measurement unit for standard value	nvarchar	3	0	Allow NULL?
30	SOW02	Target value of setup time	decimal	13	3
31	SOE02	Measurement unit for target value	nvarchar	3	0	Allow NULL?
32	RUW02	Confirmed value of setup time	decimal	13	3
33	RUE02	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
34	BEG02	Start of setup time	nvarchar	6	0	Allow NULL?
35	END02	End of setup time	nvarchar	6	0	Allow NULL?
36	VGW03	Standard value of machine time	decimal	13	3
37	VGE03	Measurement unit for standard value	nvarchar	3	0	Allow NULL?
38	SOW03	Target value of machine time	decimal	13	3
39	SOE03	Measurement unit for target value	nvarchar	3	0	Allow NULL?
40	RUW03	Confirmed value of machine time	decimal	13	3
41	RUE03	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
42	BEG03	Start machine time	nvarchar	6	0	Allow NULL?
43	END03	End of machine time	nvarchar	6	0	Allow NULL?
44	VGW04	Standard value of variable activity	decimal	13	3
45	VGE04	Measurement unit for standard value	nvarchar	3	0	Allow NULL?
46	SOW04	Target value of variable activity	decimal	13	3
47	SOE04	Measurement unit for target value	nvarchar	3	0	Allow NULL?
48	RUW04	Confirmed value of variable activity	decimal	13	3
49	RUE04	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
50	BEG04	Start of variable activity	nvarchar	6	0	Allow NULL?
51	END04	End of variable activity	nvarchar	6	0	Allow NULL?
52	VGW05	Standard value of teardown time	decimal	13	3
53	VGE05	Measurement unit for standard value	nvarchar	3	0	Allow NULL?
54	SOW05	Target value of teardown time	decimal	13	3
55	SOE05	Measurement unit for target value	nvarchar	3	0	Allow NULL?
56	RUW05	Confirmed value of teardown time	decimal	13	3
57	RUE05	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
58	BEG05	Start of teardown time	nvarchar	6	0	Allow NULL?
59	END05	End of teardown time	nvarchar	6	0	Allow NULL?
60	VGW06	Standard value of variable activity	decimal	13	3
61	VGE06	Measurement unit for standard value	nvarchar	3	0	Allow NULL?
62	SOW06	Target value of variable activity	decimal	13	3
63	SOE06	Measurement unit for target value	nvarchar	3	0	Allow NULL?
64	RUW06	Confirmed value of variable activity	decimal	13	3
65	RUE06	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
66	BEG06	Start of variable activity	nvarchar	6	0	Allow NULL?
67	END06	End of variable activity	nvarchar	6	0	Allow NULL?
68	MEINH	Unit of Measure	nvarchar	3	0	Allow NULL?
69	LMNGA	Yield	decimal	13	3
70	XMNGA	Scrap	decimal	13	3
71	GRUND	Scrap reason	nvarchar	4	0	Allow NULL?
72	BMSCH	Base quantity	decimal	13	3
73	PP_RUW01	Confirmed value of processing time from Logistics	decimal	13	3
74	PP_RUE01	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
75	PP_RUW02	Confirmed value of setup time from Logistics	decimal	13	3
76	PP_RUE02	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
77	PP_RUW03	Confirmed value of machine time from Logistics	decimal	13	3
78	PP_RUE03	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
79	PP_RUW04	Confirmed value of variable activity from Logistics	decimal	13	3
80	PP_RUE04	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
81	PP_RUW05	Confirmed Value of Teardown Time for Logistics	decimal	13	3
82	PP_RUE05	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
83	PP_RUW06	Confirmed value of variable activity from Logistics	decimal	13	3
84	PP_RUE06	Measurement unit of confirmed value	nvarchar	3	0	Allow NULL?
85	SCRPR	Malfunction or interruption reason	nvarchar	4	0	Allow NULL?
86	KUM01	Cumulation rule for activity type	nvarchar	6	0	Allow NULL?
87	LOARR	Wage Type	nvarchar	4	0	Allow NULL?
88	LOGRR	Pay Scale Group	nvarchar	8	0	Allow NULL?
89	TRFST	Pay scale level	nvarchar	2	0	Allow NULL?
90	LSTYP	Time ticket type	nvarchar	2	0	Allow NULL?
91	OPCLS	Transfer lock indicator for time ticket	char	1	0	Allow NULL?
92	GRUNR	Group number	nvarchar	8	0	Allow NULL?
93	GRUNA	Group name	nvarchar	20	0	Allow NULL?
94	PDC_USRUP	Customer-Specific Field	nvarchar	20	0	Allow NULL?
95	USER2	Customer-Specific Field	nvarchar	40	0	Allow NULL?
96	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
97	GSBER	Business Area	nvarchar	4	0	Allow NULL?
98	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
99	LTLST	Activity Type	nvarchar	6	0	Allow NULL?
100	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
101	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
102	POSID	Work Breakdown Structure Element (WBS Element)	nvarchar	24	0	Allow NULL?
103	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
104	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
105	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
106	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
107	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
108	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
109	GEBER	Fund	nvarchar	10	0	Allow NULL?
110	SKOST	Cost Center	nvarchar	10	0	Allow NULL?
111	SBUKR	Company Code	nvarchar	4	0	Allow NULL?
112	SGSBR	Business Area	nvarchar	4	0	Allow NULL?
113	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
114	DART	Service Type (Public Service Germany)	nvarchar	2	0	Allow NULL?
115	UDART	Service Category (Public Service Germany)	nvarchar	2	0	Allow NULL?
116	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
117	PRAKN	Premium Number	nvarchar	2	0	Allow NULL?
118	PRAKZ	Premium Indicator	nvarchar	4	0	Allow NULL?
119	OTYPE	Object Type	nvarchar	2	0	Allow NULL?
120	PLANS	Position	nvarchar	8	0	Allow NULL?
121	AUFKZ	Extra Pay Indicator	char	1	0	Allow NULL?
122	BWGRL	Valuation Basis for Different Payment	decimal	13	2
123	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
124	LOGOS	Time Ticket Status	char	1	0	Allow NULL?
125	ENDDA	End Date	nvarchar	8	0	Allow NULL?
126	COMCH	Interface Assignment	char	1	0	Allow NULL?
127	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
128	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
129	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
130	FIPEX	Commitment Item	nvarchar	24	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

130 COLUMNS | 1 INDEXES | ERP 6.0 | P2B2_WST TABLE

TOP ERP 6.0 | P2B2_WST COLUMNS

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

130 COLUMNS | 1 INDEXES | ERP 6.0 | P2B2_WST TABLE

TOPERP 6.0 | P2B2_WST COLUMNS

TOPERP 6.0 | P2B2_WST INDEXES

TOP ERP 6.0 | P2B2_WST COLUMNS

TOP ERP 6.0 | P2B2_WST INDEXES