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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
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
Materials Management :: External Services
1	ERP EHP7	6.0	ESLL	101	5	Lines of Service Package	External Services

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PACKNO	Package number	nvarchar	10	0	Allow NULL?
3	INTROW	Line Number	nvarchar	10	0	Allow NULL?
4	EXTROW	Line Number	nvarchar	10	0	Allow NULL?
5	DEL	Deletion Indicator	char	1	0	Allow NULL?
6	SRVPOS	Activity Number	nvarchar	18	0	Allow NULL?
7	RANG	Hierarchy level of group	tinyint	3	0
8	EXTGROUP	Outline Level	nvarchar	8	0	Allow NULL?
9	PACKAGE	Service Assignment	char	1	0	Allow NULL?
10	SUB_PACKNO	Subpackage number	nvarchar	10	0	Allow NULL?
11	LBNUM	Short Description of Service Type	nvarchar	3	0	Allow NULL?
12	AUSGB	Edition of Service Type	nvarchar	4	0	Allow NULL?
13	STLVPOS	Standard Service Catalog Item	nvarchar	18	0	Allow NULL?
14	EXTSRVNO	Vendor's Service Number	nvarchar	18	0	Allow NULL?
15	MENGE	Quantity with Sign	decimal	13	3
16	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
17	UEBTO	Overfulfillment Tolerance	decimal	3	1
18	UEBTK	Unlimited Overfulfillment	char	1	0	Allow NULL?
19	WITH_LIM	Also Search in Limits	char	1	0	Allow NULL?
20	SPINF	Update Conditions	char	1	0	Allow NULL?
21	PEINH	Price Unit	decimal	5	0
22	BRTWR	Gross Price	decimal	11	2
23	NETWR	Net Value of Item	decimal	11	2
24	FROMPOS	Lower Limit	nvarchar	6	0	Allow NULL?
25	TOPOS	Upper Limit	nvarchar	6	0	Allow NULL?
26	KTEXT1	Short Text	nvarchar	40	0	Allow NULL?
27	VRTKZ	Distribution indicator for multiple account assignment	char	1	0	Allow NULL?
28	TWRKZ	Partial Invoice Indicator	char	1	0	Allow NULL?
29	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
30	MOLGA	Country Grouping	nvarchar	2	0	Allow NULL?
31	LGART	Wage Type	nvarchar	4	0	Allow NULL?
32	LGTXT	Wage Type Long Text	nvarchar	25	0	Allow NULL?
33	STELL	Job	nvarchar	8	0	Allow NULL?
34	IFTNR	Sequence Number for CO/MM-SRV Interface Tables	nvarchar	10	0	Allow NULL?
35	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
36	INSDT	Date on Which This Record was Stored in the Table	nvarchar	8	0	Allow NULL?
37	PLN_PACKNO	Source package number	nvarchar	10	0	Allow NULL?
38	PLN_INTROW	Entry: Planned package line	nvarchar	10	0	Allow NULL?
39	KNT_PACKNO	Entry: Unplanned from contract	nvarchar	10	0	Allow NULL?
40	KNT_INTROW	Entry: Unplanned from contract	nvarchar	10	0	Allow NULL?
41	TMP_PACKNO	Entry: Unplanned service from model specifications	nvarchar	10	0	Allow NULL?
42	TMP_INTROW	Entry: Unplanned service from model specifications	nvarchar	10	0	Allow NULL?
43	STLV_LIM	Service line refers to standard service catalog limits	char	1	0	Allow NULL?
44	LIMIT_ROW	Entry: Unplanned, limit line	nvarchar	10	0	Allow NULL?
45	ACT_MENGE	Purchase Order: Entered Quantity	decimal	13	3
46	ACT_WERT	Entered Value	decimal	11	2
47	KNT_WERT	Contract: Value Released (via Release Orders)	decimal	11	2
48	KNT_MENGE	Contract: Quantity Released (by Issue of Release Orders)	decimal	13	3
49	ZIELWERT	Target Value	decimal	11	2
50	UNG_WERT	Contract: Unplanned Released Value	decimal	11	2
51	UNG_MENGE	Contract: Unplanned Released Quantity	decimal	13	3
52	ALT_INTROW	Alternatives: Reference to basic item	nvarchar	10	0	Allow NULL?
53	BASIC	Basic Line	char	1	0	Allow NULL?
54	ALTERNAT	Alternative Line	char	1	0	Allow NULL?
55	BIDDER	Bidder's Line	char	1	0	Allow NULL?
56	SUPPLE	Supplementary Line	char	1	0	Allow NULL?
57	FREEQTY	Line with Open Quantity	char	1	0	Allow NULL?
58	INFORM	Informatory Line	char	1	0	Allow NULL?
59	PAUSCH	Blanket Line	char	1	0	Allow NULL?
60	EVENTUAL	Contingency Line	char	1	0	Allow NULL?
61	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
62	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
63	PRS_CHG	Price Change in Entry Sheet	char	1	0	Allow NULL?
64	MATKL	Material Group	nvarchar	9	0	Allow NULL?
65	TBTWR	Gross Price	decimal	11	2
66	NAVNW	Non-deductible input tax	decimal	11	2
67	BASWR	Tax base amount	decimal	11	2
68	KKNUMV	Number of the document condition	nvarchar	10	0	Allow NULL?
69	IWEIN	Unit for Work	nvarchar	3	0	Allow NULL?
70	INT_WORK	Internal Work	decimal	8	2
71	EXTERNALID	SRM Reference Key	nvarchar	40	0	Allow NULL?
72	KSTAR	Cost Element	nvarchar	10	0	Allow NULL?
73	ACT_WORK	Internal Work	decimal	8	2
74	MAPNO	Mapping Field f. PACKNO, INTROW at Item Level for Commitment	nvarchar	4	0	Allow NULL?
75	SRVMAPKEY	Item Key for eSOA Messages	nvarchar	10	0	Allow NULL?
76	TAXTARIFFCODE	Tax Tariff Code	nvarchar	16	0	Allow NULL?
77	SDATE	Date	nvarchar	8	0	Allow NULL?
78	BEGTIME	Start Time	nvarchar	6	0	Allow NULL?
79	ENDTIME	End Time	nvarchar	6	0	Allow NULL?
80	PERSEXT	External Personnel Number	nvarchar	40	0	Allow NULL?
81	CATSCOUNTE	Counter for Records in Time Recording	nvarchar	12	0	Allow NULL?
82	STOKZ	Indicator: Document Has Been Reversed	char	1	0	Allow NULL?
83	BELNR	Document Number	nvarchar	10	0	Allow NULL?
84	FORMELNR	Formula Number	nvarchar	10	0	Allow NULL?
85	FRMVAL1	Formula Value	decimal	13	3
86	FRMVAL2	Formula Value	decimal	13	3
87	FRMVAL3	Formula Value	decimal	13	3
88	FRMVAL4	Formula Value	decimal	13	3
89	FRMVAL5	Formula Value	decimal	13	3
90	USERF1_NUM	User-Defined Field	nvarchar	10	0	Allow NULL?
91	USERF2_NUM	User-Defined Field	decimal	13	3
92	USERF1_TXT	User-Defined Field	nvarchar	40	0	Allow NULL?
93	USERF2_TXT	User-Defined Field	nvarchar	10	0	Allow NULL?
94	KNOBJ	Number of Object with Assigned Dependencies	nvarchar	18	0	Allow NULL?
95	CHGTEXT	Short Text Change Allowed	char	1	0	Allow NULL?
96	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	Allow NULL?
97	KLVAR	Costing Variant	nvarchar	4	0	Allow NULL?
98	EXTREFKEY	External Reference Key for Service	nvarchar	40	0	Allow NULL?
99	INV_MENGE	Purchase Order: Quantity Entered from the Invoice	decimal	13	3
100	PER_SDATE	Period of Performance Start Date	nvarchar	8	0	Allow NULL?
101	PER_EDATE	Period of Performance End Date	nvarchar	8	0	Allow NULL?

Name	Primary	Unique	Type	Columns
ESLL~0	Yes	Yes	CLUSTERED	INTROW, PACKNO, MANDT
ESLL~003	No	No	NONCLUSTERED	INTROW, PACKNO, KTEXT1, MANDT
ESLL~1	No	No	NONCLUSTERED	INTROW, PACKNO, SRVPOS, MANDT
ESLL~2	No	No	NONCLUSTERED	INTROW, PACKNO, STLVPOS, AUSGB, LBNUM, MANDT
ESLL~4	No	No	NONCLUSTERED	INTROW, PACKNO, SUB_PACKNO

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

101 COLUMNS | 5 INDEXES | ERP 6.0 | ESLL TABLE

TOP ERP 6.0 | ESLL COLUMNS

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

101 COLUMNS | 5 INDEXES | ERP 6.0 | ESLL TABLE

TOPERP 6.0 | ESLL COLUMNS

TOPERP 6.0 | ESLL INDEXES

TOP ERP 6.0 | ESLL COLUMNS

TOP ERP 6.0 | ESLL INDEXES