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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transfer to Financial Accounting
1	ERP EHP7	6.0	TLVC_DFT_ASSGN	274	1	Assign Update Types for Valuation	Transfer to Financial Accounting

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

274 COLUMNS | 1 INDEXES | ERP 6.0 | TLVC_DFT_ASSGN TABLE

TOP ERP 6.0 | TLVC_DFT_ASSGN COLUMNS

TOP ERP 6.0 | TLVC_DFT_ASSGN INDEXES

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	POS_MAN_PROC	Position Management Procedure	nvarchar	4	Allow NULL?
3	V100	Update Type	nvarchar	8	Allow NULL?
4	V101	Update Type	nvarchar	8	Allow NULL?
5	V102	Update Type	nvarchar	8	Allow NULL?
6	V103	Update Type	nvarchar	8	Allow NULL?
7	V104	Update Type	nvarchar	8	Allow NULL?
8	V105	Update Type	nvarchar	8	Allow NULL?
9	V106	Update Type	nvarchar	8	Allow NULL?
10	V107	Update Type	nvarchar	8	Allow NULL?
11	R100	Update Type	nvarchar	8	Allow NULL?
12	R101	Update Type	nvarchar	8	Allow NULL?
13	R102	Update Type	nvarchar	8	Allow NULL?
14	R103	Update Type	nvarchar	8	Allow NULL?
15	R104	Update Type	nvarchar	8	Allow NULL?
16	R105	Update Type	nvarchar	8	Allow NULL?
17	R106	Update Type	nvarchar	8	Allow NULL?
18	R107	Update Type	nvarchar	8	Allow NULL?
19	V150	Update Type	nvarchar	8	Allow NULL?
20	V151	Update Type	nvarchar	8	Allow NULL?
21	V152	Update Type	nvarchar	8	Allow NULL?
22	V153	Update Type	nvarchar	8	Allow NULL?
23	V154	Update Type	nvarchar	8	Allow NULL?
24	V155	Update Type	nvarchar	8	Allow NULL?
25	V156	Update Type	nvarchar	8	Allow NULL?
26	V157	Update Type	nvarchar	8	Allow NULL?
27	R150	Update Type	nvarchar	8	Allow NULL?
28	R151	Update Type	nvarchar	8	Allow NULL?
29	R152	Update Type	nvarchar	8	Allow NULL?
30	R153	Update Type	nvarchar	8	Allow NULL?
31	R154	Update Type	nvarchar	8	Allow NULL?
32	R155	Update Type	nvarchar	8	Allow NULL?
33	R156	Update Type	nvarchar	8	Allow NULL?
34	R157	Update Type	nvarchar	8	Allow NULL?
35	V200	Update Type	nvarchar	8	Allow NULL?
36	V201	Update Type	nvarchar	8	Allow NULL?
37	V202	Update Type	nvarchar	8	Allow NULL?
38	V203	Update Type	nvarchar	8	Allow NULL?
39	V204	Update Type	nvarchar	8	Allow NULL?
40	V205	Update Type	nvarchar	8	Allow NULL?
41	V206	Update Type	nvarchar	8	Allow NULL?
42	V207	Update Type	nvarchar	8	Allow NULL?
43	V250	Update Type	nvarchar	8	Allow NULL?
44	V251	Update Type	nvarchar	8	Allow NULL?
45	V252	Update Type	nvarchar	8	Allow NULL?
46	V253	Update Type	nvarchar	8	Allow NULL?
47	V254	Update Type	nvarchar	8	Allow NULL?
48	V255	Update Type	nvarchar	8	Allow NULL?
49	V256	Update Type	nvarchar	8	Allow NULL?
50	V257	Update Type	nvarchar	8	Allow NULL?
51	V260	Update Type	nvarchar	8	Allow NULL?
52	V261	Update Type	nvarchar	8	Allow NULL?
53	V262	Update Type	nvarchar	8	Allow NULL?
54	V263	Update Type	nvarchar	8	Allow NULL?
55	R200	Update Type	nvarchar	8	Allow NULL?
56	R201	Update Type	nvarchar	8	Allow NULL?
57	R202	Update Type	nvarchar	8	Allow NULL?
58	R203	Update Type	nvarchar	8	Allow NULL?
59	R204	Update Type	nvarchar	8	Allow NULL?
60	R205	Update Type	nvarchar	8	Allow NULL?
61	R206	Update Type	nvarchar	8	Allow NULL?
62	R207	Update Type	nvarchar	8	Allow NULL?
63	R250	Update Type	nvarchar	8	Allow NULL?
64	R251	Update Type	nvarchar	8	Allow NULL?
65	R252	Update Type	nvarchar	8	Allow NULL?
66	R253	Update Type	nvarchar	8	Allow NULL?
67	R254	Update Type	nvarchar	8	Allow NULL?
68	R255	Update Type	nvarchar	8	Allow NULL?
69	R256	Update Type	nvarchar	8	Allow NULL?
70	R257	Update Type	nvarchar	8	Allow NULL?
71	R260	Update Type	nvarchar	8	Allow NULL?
72	R261	Update Type	nvarchar	8	Allow NULL?
73	R262	Update Type	nvarchar	8	Allow NULL?
74	R263	Update Type	nvarchar	8	Allow NULL?
75	V300	Update Type	nvarchar	8	Allow NULL?
76	V301	Update Type	nvarchar	8	Allow NULL?
77	V302	Update Type	nvarchar	8	Allow NULL?
78	V303	Update Type	nvarchar	8	Allow NULL?
79	V350	Update Type	nvarchar	8	Allow NULL?
80	V351	Update Type	nvarchar	8	Allow NULL?
81	V352	Update Type	nvarchar	8	Allow NULL?
82	V353	Update Type	nvarchar	8	Allow NULL?
83	V360	Update Type	nvarchar	8	Allow NULL?
84	V361	Update Type	nvarchar	8	Allow NULL?
85	R300	Update Type	nvarchar	8	Allow NULL?
86	R301	Update Type	nvarchar	8	Allow NULL?
87	R302	Update Type	nvarchar	8	Allow NULL?
88	R303	Update Type	nvarchar	8	Allow NULL?
89	R350	Update Type	nvarchar	8	Allow NULL?
90	R351	Update Type	nvarchar	8	Allow NULL?
91	R352	Update Type	nvarchar	8	Allow NULL?
92	R353	Update Type	nvarchar	8	Allow NULL?
93	R360	Update Type	nvarchar	8	Allow NULL?
94	R361	Update Type	nvarchar	8	Allow NULL?
95	V400	Update Type	nvarchar	8	Allow NULL?
96	V401	Update Type	nvarchar	8	Allow NULL?
97	R400	Update Type	nvarchar	8	Allow NULL?
98	R401	Update Type	nvarchar	8	Allow NULL?
99	V500	Update Type	nvarchar	8	Allow NULL?
100	V501	Update Type	nvarchar	8	Allow NULL?
101	V502	Update Type	nvarchar	8	Allow NULL?
102	V503	Update Type	nvarchar	8	Allow NULL?
103	V504	Update Type	nvarchar	8	Allow NULL?
104	V505	Update Type	nvarchar	8	Allow NULL?
105	V506	Update Type	nvarchar	8	Allow NULL?
106	V507	Update Type	nvarchar	8	Allow NULL?
107	R500	Update Type	nvarchar	8	Allow NULL?
108	R501	Update Type	nvarchar	8	Allow NULL?
109	R502	Update Type	nvarchar	8	Allow NULL?
110	R503	Update Type	nvarchar	8	Allow NULL?
111	R504	Update Type	nvarchar	8	Allow NULL?
112	R505	Update Type	nvarchar	8	Allow NULL?
113	R506	Update Type	nvarchar	8	Allow NULL?
114	R507	Update Type	nvarchar	8	Allow NULL?
115	V550	Update Type	nvarchar	8	Allow NULL?
116	V551	Update Type	nvarchar	8	Allow NULL?
117	V552	Update Type	nvarchar	8	Allow NULL?
118	V553	Update Type	nvarchar	8	Allow NULL?
119	V558	Update Type	nvarchar	8	Allow NULL?
120	V559	Update Type	nvarchar	8	Allow NULL?
121	R550	Update Type	nvarchar	8	Allow NULL?
122	R551	Update Type	nvarchar	8	Allow NULL?
123	R552	Update Type	nvarchar	8	Allow NULL?
124	R553	Update Type	nvarchar	8	Allow NULL?
125	R558	Update Type	nvarchar	8	Allow NULL?
126	R559	Update Type	nvarchar	8	Allow NULL?
127	V570	Update Type	nvarchar	8	Allow NULL?
128	V571	Update Type	nvarchar	8	Allow NULL?
129	V572	Update Type	nvarchar	8	Allow NULL?
130	V573	Update Type	nvarchar	8	Allow NULL?
131	R570	Update Type	nvarchar	8	Allow NULL?
132	R571	Update Type	nvarchar	8	Allow NULL?
133	R572	Update Type	nvarchar	8	Allow NULL?
134	R573	Update Type	nvarchar	8	Allow NULL?
135	V304	Update Type	nvarchar	8	Allow NULL?
136	V305	Update Type	nvarchar	8	Allow NULL?
137	R304	Update Type	nvarchar	8	Allow NULL?
138	R305	Update Type	nvarchar	8	Allow NULL?
139	V220	Update Type	nvarchar	8	Allow NULL?
140	V221	Update Type	nvarchar	8	Allow NULL?
141	V230	Update Type	nvarchar	8	Allow NULL?
142	V231	Update Type	nvarchar	8	Allow NULL?
143	V270	Update Type	nvarchar	8	Allow NULL?
144	V271	Update Type	nvarchar	8	Allow NULL?
145	V280	Update Type	nvarchar	8	Allow NULL?
146	V281	Update Type	nvarchar	8	Allow NULL?
147	V240	Update Type	nvarchar	8	Allow NULL?
148	V241	Update Type	nvarchar	8	Allow NULL?
149	V244	Update Type	nvarchar	8	Allow NULL?
150	V245	Update Type	nvarchar	8	Allow NULL?
151	R240	Update Type	nvarchar	8	Allow NULL?
152	R241	Update Type	nvarchar	8	Allow NULL?
153	R244	Update Type	nvarchar	8	Allow NULL?
154	R245	Update Type	nvarchar	8	Allow NULL?
155	V306	Update Type	nvarchar	8	Allow NULL?
156	V307	Update Type	nvarchar	8	Allow NULL?
157	R306	Update Type	nvarchar	8	Allow NULL?
158	R307	Update Type	nvarchar	8	Allow NULL?
159	V370	Update Type	nvarchar	8	Allow NULL?
160	V371	Update Type	nvarchar	8	Allow NULL?
161	V380	Update Type	nvarchar	8	Allow NULL?
162	V381	Update Type	nvarchar	8	Allow NULL?
163	R370	Update Type	nvarchar	8	Allow NULL?
164	R371	Update Type	nvarchar	8	Allow NULL?
165	R380	Update Type	nvarchar	8	Allow NULL?
166	R381	Update Type	nvarchar	8	Allow NULL?
167	V180	Update Type	nvarchar	8	Allow NULL?
168	V181	Update Type	nvarchar	8	Allow NULL?
169	V182	Update Type	nvarchar	8	Allow NULL?
170	V183	Update Type	nvarchar	8	Allow NULL?
171	V184	Update Type	nvarchar	8	Allow NULL?
172	V185	Update Type	nvarchar	8	Allow NULL?
173	V186	Update Type	nvarchar	8	Allow NULL?
174	V187	Update Type	nvarchar	8	Allow NULL?
175	R180	Update Type	nvarchar	8	Allow NULL?
176	R181	Update Type	nvarchar	8	Allow NULL?
177	R182	Update Type	nvarchar	8	Allow NULL?
178	R183	Update Type	nvarchar	8	Allow NULL?
179	R184	Update Type	nvarchar	8	Allow NULL?
180	R185	Update Type	nvarchar	8	Allow NULL?
181	R186	Update Type	nvarchar	8	Allow NULL?
182	R187	Update Type	nvarchar	8	Allow NULL?
183	V210	Update Type	nvarchar	8	Allow NULL?
184	V211	Update Type	nvarchar	8	Allow NULL?
185	R210	Update Type	nvarchar	8	Allow NULL?
186	R211	Update Type	nvarchar	8	Allow NULL?
187	V382	Update Type	nvarchar	8	Allow NULL?
188	V383	Update Type	nvarchar	8	Allow NULL?
189	R382	Update Type	nvarchar	8	Allow NULL?
190	R383	Update Type	nvarchar	8	Allow NULL?
191	V212	Update Type	nvarchar	8	Allow NULL?
192	V213	Update Type	nvarchar	8	Allow NULL?
193	R212	Update Type	nvarchar	8	Allow NULL?
194	R213	Update Type	nvarchar	8	Allow NULL?
195	V290	Update Type	nvarchar	8	Allow NULL?
196	V291	Update Type	nvarchar	8	Allow NULL?
197	V294	Update Type	nvarchar	8	Allow NULL?
198	V295	Update Type	nvarchar	8	Allow NULL?
199	R290	Update Type	nvarchar	8	Allow NULL?
200	R291	Update Type	nvarchar	8	Allow NULL?
201	R294	Update Type	nvarchar	8	Allow NULL?
202	R295	Update Type	nvarchar	8	Allow NULL?
203	V214	Update Type	nvarchar	8	Allow NULL?
204	V215	Update Type	nvarchar	8	Allow NULL?
205	R214	Update Type	nvarchar	8	Allow NULL?
206	R215	Update Type	nvarchar	8	Allow NULL?
207	V272	Update Type	nvarchar	8	Allow NULL?
208	V273	Update Type	nvarchar	8	Allow NULL?
209	R272	Update Type	nvarchar	8	Allow NULL?
210	R273	Update Type	nvarchar	8	Allow NULL?
211	V600	Update Type	nvarchar	8	Allow NULL?
212	V601	Update Type	nvarchar	8	Allow NULL?
213	V602	Update Type	nvarchar	8	Allow NULL?
214	V603	Update Type	nvarchar	8	Allow NULL?
215	R600	Update Type	nvarchar	8	Allow NULL?
216	R601	Update Type	nvarchar	8	Allow NULL?
217	R602	Update Type	nvarchar	8	Allow NULL?
218	R603	Update Type	nvarchar	8	Allow NULL?
219	V604	Update Type	nvarchar	8	Allow NULL?
220	V605	Update Type	nvarchar	8	Allow NULL?
221	V606	Update Type	nvarchar	8	Allow NULL?
222	V607	Update Type	nvarchar	8	Allow NULL?
223	R604	Update Type	nvarchar	8	Allow NULL?
224	R605	Update Type	nvarchar	8	Allow NULL?
225	R606	Update Type	nvarchar	8	Allow NULL?
226	R607	Update Type	nvarchar	8	Allow NULL?
227	V608	Update Type	nvarchar	8	Allow NULL?
228	V609	Update Type	nvarchar	8	Allow NULL?
229	R608	Update Type	nvarchar	8	Allow NULL?
230	R609	Update Type	nvarchar	8	Allow NULL?
231	V111	Update Type	nvarchar	8	Allow NULL?
232	V112	Update Type	nvarchar	8	Allow NULL?
233	V121	Update Type	nvarchar	8	Allow NULL?
234	V122	Update Type	nvarchar	8	Allow NULL?
235	V160	Update Type	nvarchar	8	Allow NULL?
236	V161	Update Type	nvarchar	8	Allow NULL?
237	V170	Update Type	nvarchar	8	Allow NULL?
238	V171	Update Type	nvarchar	8	Allow NULL?
239	V345	Update Type	nvarchar	8	Allow NULL?
240	V347	Update Type	nvarchar	8	Allow NULL?
241	R345	Update Type	nvarchar	8	Allow NULL?
242	R347	Update Type	nvarchar	8	Allow NULL?
243	V349	Update Type	nvarchar	8	Allow NULL?
244	V348	Update Type	nvarchar	8	Allow NULL?
245	R349	Update Type	nvarchar	8	Allow NULL?
246	R348	Update Type	nvarchar	8	Allow NULL?
247	V343	Update Type	nvarchar	8	Allow NULL?
248	V344	Update Type	nvarchar	8	Allow NULL?
249	R343	Update Type	nvarchar	8	Allow NULL?
250	R344	Update Type	nvarchar	8	Allow NULL?
251	V246	Update Type	nvarchar	8	Allow NULL?
252	V247	Update Type	nvarchar	8	Allow NULL?
253	V248	Update Type	nvarchar	8	Allow NULL?
254	V249	Update Type	nvarchar	8	Allow NULL?
255	R246	Update Type	nvarchar	8	Allow NULL?
256	R247	Update Type	nvarchar	8	Allow NULL?
257	R248	Update Type	nvarchar	8	Allow NULL?
258	R249	Update Type	nvarchar	8	Allow NULL?
259	V296	Update Type	nvarchar	8	Allow NULL?
260	V297	Update Type	nvarchar	8	Allow NULL?
261	V298	Update Type	nvarchar	8	Allow NULL?
262	V299	Update Type	nvarchar	8	Allow NULL?
263	R296	Update Type	nvarchar	8	Allow NULL?
264	R297	Update Type	nvarchar	8	Allow NULL?
265	R298	Update Type	nvarchar	8	Allow NULL?
266	R299	Update Type	nvarchar	8	Allow NULL?
267	V242	Update Type	nvarchar	8	Allow NULL?
268	V243	Update Type	nvarchar	8	Allow NULL?
269	V292	Update Type	nvarchar	8	Allow NULL?
270	V293	Update Type	nvarchar	8	Allow NULL?
271	R242	Update Type	nvarchar	8	Allow NULL?
272	R243	Update Type	nvarchar	8	Allow NULL?
273	R292	Update Type	nvarchar	8	Allow NULL?
274	R293	Update Type	nvarchar	8	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

274 COLUMNS | 1 INDEXES | ERP 6.0 | TLVC_DFT_ASSGN TABLE

TOPERP 6.0 | TLVC_DFT_ASSGN COLUMNS

TOPERP 6.0 | TLVC_DFT_ASSGN INDEXES

TOP ERP 6.0 | TLVC_DFT_ASSGN COLUMNS

TOP ERP 6.0 | TLVC_DFT_ASSGN INDEXES