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
Industry Specific :: Defense Forces and Public Security :: Master Data Distribution
1	ERP EHP7	6.0	/ISDFPS/TL1	221	1	Task List - Operation/Activity	Master Data Distribution

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

221 COLUMNS | 1 INDEXES | ERP 6.0 | /ISDFPS/TL1 TABLE

TOP ERP 6.0 | /ISDFPS/TL1 COLUMNS

TOP ERP 6.0 | /ISDFPS/TL1 INDEXES

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PLNTY	Task List Type	char	1	0	Allow NULL?
3	PLNNR	Key for Task List Group	nvarchar	8	0	Allow NULL?
4	PLNKN	Number of the task list node	nvarchar	8	0	Allow NULL?
5	ZAEHL	Internal counter	nvarchar	8	0	Allow NULL?
6	DATUV	Valid-From Date	nvarchar	8	0	Allow NULL?
7	TECHV	Technical status from	nvarchar	12	0	Allow NULL?
8	AENNR	Change Number	nvarchar	12	0	Allow NULL?
9	LOEKZ	Deletion Indicator	char	1	0	Allow NULL?
10	PARKZ	Indicator: inactive changes	char	1	0	Allow NULL?
11	ANDAT	Date record created on	nvarchar	8	0	Allow NULL?
12	ANNAM	User who created record	nvarchar	12	0	Allow NULL?
13	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
14	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
15	SUMNR	Node number of the superior operation	nvarchar	8	0	Allow NULL?
16	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
17	STEUS	Control key	nvarchar	4	0	Allow NULL?
18	ARBID	Object ID	nvarchar	8	0	Allow NULL?
19	OBJTY	Object types of the CIM resource	nvarchar	2	0	Allow NULL?
20	WERKS	Plant	nvarchar	4	0	Allow NULL?
21	KTSCH	Standard text key	nvarchar	7	0	Allow NULL?
22	LTXA1	Operation short text	nvarchar	40	0	Allow NULL?
23	LTXA2	Second line of the description	nvarchar	40	0	Allow NULL?
24	TXTSP	Language Key	char	1	0	Allow NULL?
25	VPLTY	Type of the referenced task list	char	1	0	Allow NULL?
26	VPLNR	Group of the referenced task list	nvarchar	8	0	Allow NULL?
27	VPLAL	Group counter of the referenced task list	nvarchar	2	0	Allow NULL?
28	VPLFL	Referenced sequence in routing	nvarchar	6	0	Allow NULL?
29	VINTV	Increment between referenced operations	decimal	3	0
30	MEINH	Unit of Measure for Activity/Operation	nvarchar	3	0	Allow NULL?
31	UMREN	Denominator for converting rtg and op units of measure	decimal	5	0
32	UMREZ	Numerator for converting task list and oper. un. of measure	decimal	5	0
33	BMSCH	Base Quantity	decimal	13	3
34	ZMERH	Break	decimal	9	3
35	ZEIER	Unit for the break time	nvarchar	3	0	Allow NULL?
36	LAR01	Activity Type	nvarchar	6	0	Allow NULL?
37	VGE01	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
38	VGW01	Standard Value	decimal	9	3
39	LAR02	Activity Type	nvarchar	6	0	Allow NULL?
40	VGE02	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
41	VGW02	Standard Value	decimal	9	3
42	LAR03	Activity Type	nvarchar	6	0	Allow NULL?
43	VGE03	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
44	VGW03	Standard Value	decimal	9	3
45	LAR04	Activity Type	nvarchar	6	0	Allow NULL?
46	VGE04	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
47	VGW04	Standard Value	decimal	9	3
48	LAR05	Activity Type	nvarchar	6	0	Allow NULL?
49	VGE05	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
50	VGW05	Standard Value	decimal	9	3
51	LAR06	Activity Type	nvarchar	6	0	Allow NULL?
52	VGE06	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
53	VGW06	Standard Value	decimal	9	3
54	ZERMA	Type of standard value calculation	nvarchar	5	0	Allow NULL?
55	ZGDAT	Date when the standard value was calculated	nvarchar	4	0	Allow NULL?
56	ZCODE	Reference number for standard value code	nvarchar	6	0	Allow NULL?
57	ZULNR	Basis for standard value calculation	nvarchar	5	0	Allow NULL?
58	RSANZ	Number of confirmation slips	nvarchar	3	0	Allow NULL?
59	PDEST	Printer for shop papers	nvarchar	4	0	Allow NULL?
60	LOANZ	Number of Time Tickets	decimal	3	0
61	LOART	Wage Type	nvarchar	4	0	Allow NULL?
62	QUALF	Suitability	nvarchar	2	0	Allow NULL?
63	ANZMA	Number of employees	decimal	5	2
64	RFGRP	Setup group category	nvarchar	10	0	Allow NULL?
65	RFSCH	Setup group key	nvarchar	10	0	Allow NULL?
66	RASCH	Setup Type Key	nvarchar	2	0	Allow NULL?
67	AUFAK	Scrap factor	decimal	5	3
68	LOGRP	Wage group	nvarchar	3	0	Allow NULL?
69	UEMUS	Required overlapping	char	1	0	Allow NULL?
70	UEKAN	Optional overlapping	char	1	0	Allow NULL?
71	FLIES	Indicator: continuous flow production	char	1	0	Allow NULL?
72	ZEIMU	Unit for the minimum overlap time	nvarchar	3	0	Allow NULL?
73	ZMINU	Minimum overlap time	decimal	9	3
74	MINWE	Minimum Send-Ahead Quantity	decimal	13	3
75	SPMUS	Required splitting	char	1	0	Allow NULL?
76	SPLIM	Maximum number of splits	decimal	3	0
77	ZEIMB	Unit for the minimum processing time	nvarchar	3	0	Allow NULL?
78	ZMINB	Minimum processing time	decimal	9	3
79	ZEILM	Unit for the maximum wait time	nvarchar	3	0	Allow NULL?
80	ZLMAX	Maximum wait time	decimal	9	3
81	ZEILP	Unit for the required wait time	nvarchar	3	0	Allow NULL?
82	ZLPRO	Minimum wait time	decimal	9	3
83	ZEIWN	Unit for the standard queue time	nvarchar	3	0	Allow NULL?
84	ZWNOR	Standard queue time	decimal	9	3
85	ZEIWM	Unit for the minumum queue time	nvarchar	3	0	Allow NULL?
86	ZWMIN	Minimum queue time	decimal	9	3
87	ZEITN	Unit for the standard move time	nvarchar	3	0	Allow NULL?
88	ZTNOR	Standard move time	decimal	9	3
89	ZEITM	Unit for the minimum move time	nvarchar	3	0	Allow NULL?
90	ZTMIN	Minimum move time	decimal	9	3
91	ABLIPKZ	Indicator: simultaneous teardown and wait	char	1	0	Allow NULL?
92	RSTRA	Reduction strategy per operation/activity	nvarchar	2	0	Allow NULL?
93	BZOFFB	Reference date for start of sub-operation	nvarchar	2	0	Allow NULL?
94	OFFSTB	Offset to sub-operation start	decimal	5	0
95	EHOFFB	Unit for offset to start	nvarchar	3	0	Allow NULL?
96	BZOFFE	Reference date for finish of sub-operation	nvarchar	2	0	Allow NULL?
97	OFFSTE	Offset to sub-operation finish	decimal	5	0
98	EHOFFE	Unit for offset to finish	nvarchar	3	0	Allow NULL?
99	SORTL	Sort Term for Non-Stock Info Records	nvarchar	10	0	Allow NULL?
100	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
101	PLIFZ	Planned Delivery Time in Days	decimal	3	0
102	PREIS	Net Price in Purchasing Info Record	decimal	11	2
103	PEINH	Price Unit	decimal	5	0
104	SAKTO	Cost Element	nvarchar	10	0	Allow NULL?
105	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
106	INFNR	Number of Purchasing Info Record	nvarchar	10	0	Allow NULL?
107	ESOKZ	Purchasing info record category	char	1	0	Allow NULL?
108	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
109	EKGRP	Purchasing group for external processing	nvarchar	3	0	Allow NULL?
110	KZLGF	Indicator: fixed lot external processing	char	1	0	Allow NULL?
111	MATKL	Material Group	nvarchar	9	0	Allow NULL?
112	DAUNO	Normal duration of the activity	decimal	5	1
113	DAUNE	Normal duration/unit	nvarchar	3	0	Allow NULL?
114	DAUMI	Minimum activity duration	decimal	5	1
115	DAUME	Unit for the minimum duration	nvarchar	3	0	Allow NULL?
116	DDEHN	Indicator: flexible duration	char	1	0	Allow NULL?
117	EINSA	Constraint on the basic start date for the activity	char	1	0	Allow NULL?
118	EINSE	Constraint on the finish date of the activity	char	1	0	Allow NULL?
119	ARBEI	Work involved in the activity	decimal	7	1
120	ARBEH	Unit for work	nvarchar	3	0	Allow NULL?
121	ANZZL	Number of capacities required	tinyint	3	0
122	PRZNT	Work percentage	tinyint	3	0
123	VERTL	Distribution function for capacity requirements	nvarchar	2	0	Allow NULL?
124	MLSTN	Usage	nvarchar	5	0	Allow NULL?
125	PPRIO	Priority	nvarchar	2	0	Allow NULL?
126	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
127	SLWID	Key word ID for user-defined fields	nvarchar	7	0	Allow NULL?
128	USR00	User field with 20 characters	nvarchar	20	0	Allow NULL?
129	USR01	User field with 20 characters	nvarchar	20	0	Allow NULL?
130	USR02	User field with 10 characters	nvarchar	10	0	Allow NULL?
131	USR03	User field with 10 characters	nvarchar	10	0	Allow NULL?
132	USR04	User field for quantity (length 10.3)	decimal	13	3
133	USE04	User field: Unit for quantity fields	nvarchar	3	0	Allow NULL?
134	USR05	User field for quantity (length 10.3)	decimal	13	3
135	USE05	User field: Unit for quantity fields	nvarchar	3	0	Allow NULL?
136	USR06	User-defined field for values (length 10,3)	decimal	13	3
137	USE06	User field: Unit for value fields	nvarchar	5	0	Allow NULL?
138	USR07	User-defined field for values (length 10,3)	decimal	13	3
139	USE07	User field: Unit for value fields	nvarchar	5	0	Allow NULL?
140	USR08	User field for date	nvarchar	8	0	Allow NULL?
141	USR09	User field for date	nvarchar	8	0	Allow NULL?
142	USR10	User-defined field: Indicator for reports	char	1	0	Allow NULL?
143	USR11	User-defined field: Indicator for reports	char	1	0	Allow NULL?
144	ANFKO	Requesting cost center	nvarchar	10	0	Allow NULL?
145	ANFKOKRS	Controlling area of the requesting cost center	nvarchar	4	0	Allow NULL?
146	KAPAR	Capacity category	nvarchar	3	0	Allow NULL?
147	INDET	Key for calculation	char	1	0	Allow NULL?
148	LARNT	Activity Type	nvarchar	6	0	Allow NULL?
149	PRKST	Costs in the activity	decimal	11	2
150	QRASTERMNG	Quantity for Grid Point Definition	decimal	5	2
151	QRASTEREH	Grid Unit of Measure	nvarchar	3	0	Allow NULL?
152	ANLZU	Syst.Condition	char	1	0	Allow NULL?
153	ISTRU	Assembly	nvarchar	18	0	Allow NULL?
154	ISTTY	BOM category	char	1	0	Allow NULL?
155	ISTNR	Bill of material	nvarchar	8	0	Allow NULL?
156	ISTKN	BOM item node number	nvarchar	8	0	Allow NULL?
157	ISTPO	Internal counter	nvarchar	8	0	Allow NULL?
158	IUPOZ	Subitem Number	nvarchar	4	0	Allow NULL?
159	EBORT	Installation Point for Subitem	nvarchar	20	0	Allow NULL?
160	KALID	Factory Calendar	nvarchar	2	0	Allow NULL?
161	FRSP	Earliest possible activity / Latest possible activity	char	1	0	Allow NULL?
162	VERTN	Distr.cap.reqmts (plant maint.,process order, network)	nvarchar	8	0	Allow NULL?
163	ZGR01	Key for performance efficiency rate	nvarchar	3	0	Allow NULL?
164	ZGR02	Key for performance efficiency rate	nvarchar	3	0	Allow NULL?
165	ZGR03	Key for performance efficiency rate	nvarchar	3	0	Allow NULL?
166	ZGR04	Key for performance efficiency rate	nvarchar	3	0	Allow NULL?
167	ZGR05	Key for performance efficiency rate	nvarchar	3	0	Allow NULL?
168	ZGR06	Key for performance efficiency rate	nvarchar	3	0	Allow NULL?
169	MDLID	Model ID for charge calculation	nvarchar	4	0	Allow NULL?
170	RUZUS	Key: rounding and additional values	nvarchar	4	0	Allow NULL?
171	BMEIH	Operation order quantity unit	nvarchar	3	0	Allow NULL?
172	BMVRG	Purchase order quantity operation	decimal	13	3
173	CKSELKZ	Indicator for Relevancy to Costing	char	1	0	Allow NULL?
174	KALKZ	Cost	char	1	0	Allow NULL?
175	NPRIO	Priority	char	1	0	Allow NULL?
176	PVZKN	Number of the task list node	nvarchar	8	0	Allow NULL?
177	PHFLG	Indicator: Phase	char	1	0	Allow NULL?
178	PHSEQ	Control Recipe Destination	nvarchar	2	0	Allow NULL?
179	KNOBJ	Number of Object with Assigned Dependencies	nvarchar	18	0	Allow NULL?
180	ERFSICHT	Recording View	nvarchar	2	0	Allow NULL?
181	PSPNR	Standard WBS element	nvarchar	8	0	Allow NULL?
182	QLOTYPE	Object Type	nvarchar	2	0	Allow NULL?
183	QLOBJEKTID	Object ID	nvarchar	8	0	Allow NULL?
184	QLKAPAR	Capacity category	nvarchar	3	0	Allow NULL?
185	QKZPRZEIT	Interval = Time (Time-Related)	char	1	0	Allow NULL?
186	QKZZTMG1	Quantity Confirmation for Each Partial Lot	char	1	0	Allow NULL?
187	QKZPRMENG	Creation Cycle = Quantity (Quantity-Reference)	char	1	0	Allow NULL?
188	QKZPRFREI	Interval Without Reference to Time or Quantity	char	1	0	Allow NULL?
189	QRASTZEHT	Time Unit	nvarchar	3	0	Allow NULL?
190	QRASTZFAK	Time Factor	decimal	5	2
191	QRASTMENG	Quantity Between Two Inspections	decimal	13	3
192	QPPKTABS	Flow Variants for Inspection Point Completion	char	1	0	Allow NULL?
193	KRIT1	Planning object	nvarchar	18	0	Allow NULL?
194	CLASSID	Internal Class Number	nvarchar	10	0	Allow NULL?
195	PACKNO	Package number	nvarchar	10	0	Allow NULL?
196	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
197	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
198	CAPOC	Type of CAPP calculation at order creation	char	1	0	Allow NULL?
199	FLG_CAPTXT	Ind: CAPP text exists	char	1	0	Allow NULL?
200	CN_WEIGHT	Aggregation weight for POC (PS progress)	decimal	8	0
201	QKZTLSBEST	Operation with Stock-Related Partial Lot Assignment	char	1	0	Allow NULL?
202	AUFKT	Execution Factor	decimal	3	0
203	DAFKT	Average execution factor	decimal	5	2
204	RWFAK	Rework factor (is not used yet)	decimal	5	3
205	AAUFG	Indicator: Work center operation set	char	1	0	Allow NULL?
206	VERDART	Grouping Category	char	1	0	Allow NULL?
207	UAVO_AUFL	Suboper. do not apply to order	char	1	0	Allow NULL?
208	FRDLB	Indicator: Externally processed op. with subcontracting	char	1	0	Allow NULL?
209	QPART	Inspection Type	nvarchar	8	0	Allow NULL?
210	PRZ01	Business Process	nvarchar	12	0	Allow NULL?
211	TAKT	takt within a line segment	nvarchar	4	0	Allow NULL?
212	OPRID	External operation ID	nvarchar	8	0	Allow NULL?
213	NVADD	Indicator for non-value-added operations	char	1	0	Allow NULL?
214	EVGEW	Aggregation weight for POC (PS progress)	decimal	8	0
215	RFPNT	Reference point for BOM transfer	nvarchar	20	0	Allow NULL?
216	FLG_TSK_GROUP	Group operation	char	1	0	Allow NULL?
217	ADPSP	Reference Element PM/PS	nvarchar	40	0	Allow NULL?
218	SUBPLNAL	Subordinate Task List Group Counter	nvarchar	2	0	Allow NULL?
219	SUBPLNNR	Key for Subordinate Task List Group	nvarchar	8	0	Allow NULL?
220	SUBPLNTY	Task List Type: Subordinate Task List	char	1	0	Allow NULL?
221	XEXCLTL	Sign: Exclude Subordinate Task List (and in All Tree)	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

221 COLUMNS | 1 INDEXES | ERP 6.0 | /ISDFPS/TL1 TABLE

TOPERP 6.0 | /ISDFPS/TL1 COLUMNS

TOPERP 6.0 | /ISDFPS/TL1 INDEXES

TOP ERP 6.0 | /ISDFPS/TL1 COLUMNS

TOP ERP 6.0 | /ISDFPS/TL1 INDEXES