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

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Plant Data Collection
1	ERP EHP7	6.0	RUECK	153	2	Temp. storage for subsystem confirmations	Plant Data Collection

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PDSNR	Sequential number for PDC messages	nvarchar	12	0	Allow NULL?
3	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
4	INFTY	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	Allow NULL?
5	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
6	OBJPS	Character field, length 2	nvarchar	2	0	Allow NULL?
7	SPRPS	Single-Character Indicator	char	1	0	Allow NULL?
8	ENDDA	End Date	nvarchar	8	0	Allow NULL?
9	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
10	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
11	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
12	GSBER	Business Area	nvarchar	4	0	Allow NULL?
13	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
14	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
15	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
16	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
17	POSNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
18	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
19	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
20	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
21	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
22	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
23	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
24	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
25	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
26	GEBER	Fund	nvarchar	10	0	Allow NULL?
27	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
28	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
29	LSTNR	Activity Number	nvarchar	18	0	Allow NULL?
30	LTLST	Activity Type	nvarchar	6	0	Allow NULL?
31	SBUKR	Company Code	nvarchar	4	0	Allow NULL?
32	SGSBR	Business Area	nvarchar	4	0	Allow NULL?
33	SKOST	Cost Center	nvarchar	10	0	Allow NULL?
34	LSTAR	Activity Type	nvarchar	6	0	Allow NULL?
35	EXBEL	Field length 18	nvarchar	18	0	Allow NULL?
36	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
37	OTYPE	Object Type	nvarchar	2	0	Allow NULL?
38	STELL	Job	nvarchar	8	0	Allow NULL?
39	POHRS	Number of Hours for Activity Allocation/External Services	decimal	7	2
40	DART	Character field, length 2	nvarchar	2	0	Allow NULL?
41	UDART	Character field, length 2	nvarchar	2	0	Allow NULL?
42	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
43	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
44	LDATE	Logical Date	nvarchar	8	0	Allow NULL?
45	LTIME	Logical time	nvarchar	6	0	Allow NULL?
46	ERDAT	Created on	nvarchar	8	0	Allow NULL?
47	ERTIM	Created at	nvarchar	6	0	Allow NULL?
48	SATZA	Time Event Type	nvarchar	3	0	Allow NULL?
49	TERID	Terminal ID	nvarchar	4	0	Allow NULL?
50	ABWGR	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	Allow NULL?
51	EXLGA	Employee Expenditures	nvarchar	4	0	Allow NULL?
52	ZEINH	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
53	HRAZL	Number	decimal	7	2
54	HRBET	Amount for remuneration information	decimal	9	2
55	ORIGF	Origin Indicator of PDC Message	char	1	0	Allow NULL?
56	DALLF	Single-Character Indicator	char	1	0	Allow NULL?
57	PDC_OTYPE	Object Type	nvarchar	2	0	Allow NULL?
58	PDC_PLANS	Position	nvarchar	8	0	Allow NULL?
59	PDC_USRUP	Customer-Specific Field	nvarchar	20	0	Allow NULL?
60	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
61	ORDEX	Single-Character Indicator	char	1	0	Allow NULL?
62	ZAUSW	Time Recording ID Number	nvarchar	8	0	Allow NULL?
63	ORIND	Origin Indicator of PDC Message (Application)	char	1	0	Allow NULL?
64	INDEU	Insert/delete or update indicator	char	1	0	Allow NULL?
65	RUECK	Completion confirmation number for the operation	nvarchar	10	0	Allow NULL?
66	SPLIT	Split number	tinyint	3	0
67	RMZHL	Confirmation counter	nvarchar	8	0	Allow NULL?
68	BUDAT	Posting date	nvarchar	8	0	Allow NULL?
69	WERKS	Plant	nvarchar	4	0	Allow NULL?
70	ARBPL	Work center	nvarchar	8	0	Allow NULL?
71	KAPAR	Capacity category	nvarchar	3	0	Allow NULL?
72	LTXA1	Confirmation text	nvarchar	40	0	Allow NULL?
73	ISERH	Confirmed break time	decimal	9	3
74	ZEIER	Unit for the break time	nvarchar	3	0	Allow NULL?
75	ILE01	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
76	ISM01	Activity currently to be confirmed	decimal	13	3
77	OFM01	Forecast value used to update the standard value	decimal	9	3
78	OFE01	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
79	LEK01	Indicator: No remaining activity expected	char	1	0	Allow NULL?
80	ILE02	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
81	ISM02	Activity currently to be confirmed	decimal	13	3
82	OFM02	Forecast value used to update the standard value	decimal	9	3
83	OFE02	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
84	LEK02	Indicator: No remaining activity expected	char	1	0	Allow NULL?
85	ILE03	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
86	ISM03	Activity currently to be confirmed	decimal	13	3
87	OFM03	Forecast value used to update the standard value	decimal	9	3
88	OFE03	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
89	LEK03	Indicator: No remaining activity expected	char	1	0	Allow NULL?
90	ILE04	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
91	ISM04	Activity currently to be confirmed	decimal	13	3
92	OFM04	Forecast value used to update the standard value	decimal	9	3
93	OFE04	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
94	LEK04	Indicator: No remaining activity expected	char	1	0	Allow NULL?
95	ILE05	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
96	ISM05	Activity currently to be confirmed	decimal	13	3
97	OFM05	Forecast value used to update the standard value	decimal	9	3
98	OFE05	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
99	LEK05	Indicator: No remaining activity expected	char	1	0	Allow NULL?
100	ILE06	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
101	ISM06	Activity currently to be confirmed	decimal	13	3
102	OFM06	Forecast value used to update the standard value	decimal	9	3
103	OFE06	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
104	LEK06	Indicator: No remaining activity expected	char	1	0	Allow NULL?
105	ISMNW	Actual work	decimal	7	1
106	ISMNE	Unit for work	nvarchar	3	0	Allow NULL?
107	LEARR	Activity Type for Confirmation	nvarchar	6	0	Allow NULL?
108	OFMNW	Remaining work	decimal	7	1
109	OFMNE	Unit of measure for remaining work	nvarchar	3	0	Allow NULL?
110	LEKNW	Indicator: No Remaining Work Expected	char	1	0	Allow NULL?
111	ABARB	Confirmation: Degree of processing	nvarchar	3	0	Allow NULL?
112	IDAUR	Actual Duration for Confirmation	decimal	5	1
113	IDAUE	Unit for actual duration	nvarchar	3	0	Allow NULL?
114	ODAUR	Remaining duration of activity	decimal	5	1
115	ODAUE	Unit for remaining duration	nvarchar	3	0	Allow NULL?
116	LOART	Wage Type	nvarchar	4	0	Allow NULL?
117	QUALF	Suitability	nvarchar	2	0	Allow NULL?
118	ANZMA	Number of employees	decimal	5	2
119	LOGRP	Wage group	nvarchar	3	0	Allow NULL?
120	LMNGA	Yield to Be Confirmed	decimal	13	3
121	XMNGA	Scrap to Be Confirmed	decimal	13	3
122	MEINH	Confirmation unit of measure	nvarchar	3	0	Allow NULL?
123	GRUND	Reason for Variance	nvarchar	4	0	Allow NULL?
124	ISDD	Confirmed date for start of execution	nvarchar	8	0	Allow NULL?
125	ISDZ	Confirmed time for 'Execution start'	nvarchar	6	0	Allow NULL?
126	IERD	Confirmed date for 'Setup finish'	nvarchar	8	0	Allow NULL?
127	IERZ	Confirmed time for 'Setup finish'	nvarchar	6	0	Allow NULL?
128	ISBD	Confirmed date for 'Processing start'	nvarchar	8	0	Allow NULL?
129	ISBZ	Confirmed time for 'Processing start'	nvarchar	6	0	Allow NULL?
130	IEBD	Confirmed date for 'processing finish'	nvarchar	8	0	Allow NULL?
131	IEBZ	Confirmed time for 'processing finish'	nvarchar	6	0	Allow NULL?
132	ISAD	Confirmed date for 'teardown start'	nvarchar	8	0	Allow NULL?
133	ISAZ	Confirmed time for 'teardown start'	nvarchar	6	0	Allow NULL?
134	IEDD	Confirmed date for execution finish	nvarchar	8	0	Allow NULL?
135	IEDZ	Confirmed time for 'Execution finish'	nvarchar	6	0	Allow NULL?
136	PEDD	Forecast finish date of operation from confirmation	nvarchar	8	0	Allow NULL?
137	PEDZ	Forecast finish time of operation from confirmation	nvarchar	6	0	Allow NULL?
138	AUERU	Activation of Final Confirmation	char	1	0	Allow NULL?
139	AUSOR	Post open reservations	char	1	0	Allow NULL?
140	APLFL	Sequence	nvarchar	6	0	Allow NULL?
141	UVORN	Suboperation	nvarchar	4	0	Allow NULL?
142	AUTYP	Order category	nvarchar	2	0	Allow NULL?
143	PKNUM	Control cycle number	nvarchar	7	0	Allow NULL?
144	PKPOS	Kanban item number / control cycle item	nvarchar	3	0	Allow NULL?
145	PKBST	Kanban status	char	1	0	Allow NULL?
146	PKAMG	Reduced quantity in the planned order	decimal	13	3
147	RMNGA	Total confirmed rework quantity	decimal	13	3
148	PKKEY	Identification Number	nvarchar	10	0	Allow NULL?
149	PKIMG	Actual quantity	decimal	13	3
150	PKLUZ	Delivery time for a kanban, time of day	nvarchar	6	0	Allow NULL?
151	PKLDT	Delivery time for a kanban, date	nvarchar	8	0	Allow NULL?
152	PKBMG	Quantity requested	decimal	13	3
153	CHARG	Batch Number	nvarchar	10	0	Allow NULL?

Name	Primary	Unique	Type	Columns
RUECK~0	Yes	Yes	CLUSTERED	PDSNR, MANDT
RUECK~1	No	No	NONCLUSTERED	ORIND, 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

153 COLUMNS | 2 INDEXES | ERP 6.0 | RUECK TABLE

TOP ERP 6.0 | RUECK COLUMNS

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

153 COLUMNS | 2 INDEXES | ERP 6.0 | RUECK TABLE

TOPERP 6.0 | RUECK COLUMNS

TOPERP 6.0 | RUECK INDEXES

TOP ERP 6.0 | RUECK COLUMNS

TOP ERP 6.0 | RUECK INDEXES