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
Financial Accounting
1	ERP EHP7	6.0	LFA1	139	8	Vendor Master (General Section)	Financial Accounting

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
3	LAND1	Country Key	nvarchar	3	0	Allow NULL?
4	NAME1	Name 1	nvarchar	35	0	Allow NULL?
5	NAME2	Name 2	nvarchar	35	0	Allow NULL?
6	NAME3	Name 3	nvarchar	35	0	Allow NULL?
7	NAME4	Name 4	nvarchar	35	0	Allow NULL?
8	ORT01	City	nvarchar	35	0	Allow NULL?
9	ORT02	District	nvarchar	35	0	Allow NULL?
10	PFACH	PO Box	nvarchar	10	0	Allow NULL?
11	PSTL2	P.O. Box Postal Code	nvarchar	10	0	Allow NULL?
12	PSTLZ	Postal Code	nvarchar	10	0	Allow NULL?
13	REGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
14	SORTL	Sort field	nvarchar	10	0	Allow NULL?
15	STRAS	House number and street	nvarchar	35	0	Allow NULL?
16	ADRNR	Address	nvarchar	10	0	Allow NULL?
17	MCOD1	Search term for matchcode search	nvarchar	25	0	Allow NULL?
18	MCOD2	Search term for matchcode search	nvarchar	25	0	Allow NULL?
19	MCOD3	Search term for matchcode search	nvarchar	25	0	Allow NULL?
20	ANRED	Title	nvarchar	15	0	Allow NULL?
21	BAHNS	Train station	nvarchar	25	0	Allow NULL?
22	BBBNR	International location number (part 1)	nvarchar	7	0	Allow NULL?
23	BBSNR	International location number (Part 2)	nvarchar	5	0	Allow NULL?
24	BEGRU	Authorization Group	nvarchar	4	0	Allow NULL?
25	BRSCH	Industry key	nvarchar	4	0	Allow NULL?
26	BUBKZ	Check digit for the international location number	char	1	0	Allow NULL?
27	DATLT	Data communication line no.	nvarchar	14	0	Allow NULL?
28	DTAMS	Indicator for Data Medium Exchange	char	1	0	Allow NULL?
29	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	Allow NULL?
30	ERDAT	Date on which the Record Was Created	nvarchar	8	0	Allow NULL?
31	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
32	ESRNR	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
33	KONZS	Group key	nvarchar	10	0	Allow NULL?
34	KTOKK	Vendor account group	nvarchar	4	0	Allow NULL?
35	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
36	LNRZA	Account Number of the Alternative Payee	nvarchar	10	0	Allow NULL?
37	LOEVM	Central Deletion Flag for Master Record	char	1	0	Allow NULL?
38	SPERR	Central posting block	char	1	0	Allow NULL?
39	SPERM	Centrally imposed purchasing block	char	1	0	Allow NULL?
40	SPRAS	Language Key	char	1	0	Allow NULL?
41	STCD1	Tax Number 1	nvarchar	16	0	Allow NULL?
42	STCD2	Tax Number 2	nvarchar	11	0	Allow NULL?
43	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	Allow NULL?
44	STKZU	Liable for VAT	char	1	0	Allow NULL?
45	TELBX	Telebox number	nvarchar	15	0	Allow NULL?
46	TELF1	First telephone number	nvarchar	16	0	Allow NULL?
47	TELF2	Second telephone number	nvarchar	16	0	Allow NULL?
48	TELFX	Fax Number	nvarchar	31	0	Allow NULL?
49	TELTX	Teletex number	nvarchar	30	0	Allow NULL?
50	TELX1	Telex number	nvarchar	30	0	Allow NULL?
51	XCPDK	Indicator: Is the account a one-time account?	char	1	0	Allow NULL?
52	XZEMP	Indicator: Alternative payee in document allowed ?	char	1	0	Allow NULL?
53	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
54	FISKN	Account number of the master record with fiscal address	nvarchar	10	0	Allow NULL?
55	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
56	STKZN	Natural Person	char	1	0	Allow NULL?
57	SPERQ	Function That Will Be Blocked	nvarchar	2	0	Allow NULL?
58	GBORT	Place of birth of the person subject to withholding tax	nvarchar	25	0	Allow NULL?
59	GBDAT	Date of birth of the person subject to withholding tax	nvarchar	8	0	Allow NULL?
60	SEXKZ	Key for the Sex of the Person Subject to Withholding Tax	char	1	0	Allow NULL?
61	KRAUS	Credit information number	nvarchar	11	0	Allow NULL?
62	REVDB	Last review (external)	nvarchar	8	0	Allow NULL?
63	QSSYS	Vendor's QM system	nvarchar	4	0	Allow NULL?
64	KTOCK	Reference Account Group for One-Time Account (Vendor)	nvarchar	4	0	Allow NULL?
65	PFORT	PO Box city	nvarchar	35	0	Allow NULL?
66	WERKS	Plant (Own or External)	nvarchar	4	0	Allow NULL?
67	LTSNA	Indicator: vendor sub-range relevant	char	1	0	Allow NULL?
68	WERKR	Indicator: plant level relevant	char	1	0	Allow NULL?
69	PLKAL	Factory calendar key	nvarchar	2	0	Allow NULL?
70	DUEFL	Status of Data Transfer into Subsequent Release	char	1	0	Allow NULL?
71	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
72	SPERZ	Payment Block	char	1	0	Allow NULL?
73	SCACD	Standard carrier access code	nvarchar	4	0	Allow NULL?
74	SFRGR	Forwarding agent freight group	nvarchar	4	0	Allow NULL?
75	LZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	0	Allow NULL?
76	XLFZA	Indicator: Alternative payee using account number	char	1	0	Allow NULL?
77	DLGRP	Service agent procedure group	nvarchar	4	0	Allow NULL?
78	FITYP	Tax type	nvarchar	2	0	Allow NULL?
79	STCDT	Tax Number Type	nvarchar	2	0	Allow NULL?
80	REGSS	Registered for Social Insurance	char	1	0	Allow NULL?
81	ACTSS	Activity Code for Social Insurance	nvarchar	3	0	Allow NULL?
82	STCD3	Tax Number 3	nvarchar	18	0	Allow NULL?
83	STCD4	Tax Number 4	nvarchar	18	0	Allow NULL?
84	STCD5	Tax Number 5	nvarchar	60	0	Allow NULL?
85	IPISP	Tax Split	char	1	0	Allow NULL?
86	TAXBS	Tax Base in Percentage	char	1	0	Allow NULL?
87	PROFS	Profession	nvarchar	30	0	Allow NULL?
88	STGDL	Shipment: statistics group, transportation service agent	nvarchar	2	0	Allow NULL?
89	EMNFR	External manufacturer code name or number	nvarchar	10	0	Allow NULL?
90	LFURL	Uniform Resource Locator	nvarchar	132	0	Allow NULL?
91	J_1KFREPRE	Name of Representative	nvarchar	10	0	Allow NULL?
92	J_1KFTBUS	Type of Business	nvarchar	30	0	Allow NULL?
93	J_1KFTIND	Type of Industry	nvarchar	30	0	Allow NULL?
94	CONFS	Status of Change Authorization (Central)	char	1	0	Allow NULL?
95	UPDAT	Date on Which the Changes Were Confirmed	nvarchar	8	0	Allow NULL?
96	UPTIM	Time of Last Change Confirmation	nvarchar	6	0	Allow NULL?
97	NODEL	Central deletion block for master record	char	1	0	Allow NULL?
98	QSSYSDAT	Validity date of certification	nvarchar	8	0	Allow NULL?
99	PODKZB	Vendor indicator relevant for proof of delivery	char	1	0	Allow NULL?
100	FISKU	Account Number of Master Record of Tax Office Responsible	nvarchar	10	0	Allow NULL?
101	STENR	Tax Number at Responsible Tax Authority	nvarchar	18	0	Allow NULL?
102	CARRIER_CONF	Carrier confirmation is expected	char	1	0	Allow NULL?
103	MIN_COMP	Micro company indicator	char	1	0	Allow NULL?
104	TERM_LI	Terms of Liability	char	1	0	Allow NULL?
105	CRC_NUM	CRC number	nvarchar	25	0	Allow NULL?
106	CVP_XBLCK	Business Purpose Completed Flag	char	1	0	Allow NULL?
107	RG	RG Number	nvarchar	11	0	Allow NULL?
108	EXP	Issued by	nvarchar	3	0	Allow NULL?
109	UF	State	nvarchar	2	0	Allow NULL?
110	RGDATE	RG Issue Date	nvarchar	8	0	Allow NULL?
111	RIC	RIC Number	nvarchar	11	0	Allow NULL?
112	RNE	Foreign National Registration	nvarchar	10	0	Allow NULL?
113	RNEDATE	RNE Issue Date	nvarchar	8	0	Allow NULL?
114	CNAE	CNAE	nvarchar	7	0	Allow NULL?
115	LEGALNAT	Legal Nature	nvarchar	4	0	Allow NULL?
116	CRTN	CRT Number	char	1	0	Allow NULL?
117	ICMSTAXPAY	ICMS Taxpayer	nvarchar	2	0	Allow NULL?
118	INDTYP	Industry Main Type	nvarchar	2	0	Allow NULL?
119	TDT	Tax Declaration Type	nvarchar	2	0	Allow NULL?
120	COMSIZE	Company Size	nvarchar	2	0	Allow NULL?
121	DECREGPC	Declaration Regimen for PIS/COFINS	nvarchar	2	0	Allow NULL?
122	J_SC_CAPITAL	Capital Amount	decimal	15	2
123	J_SC_CURRENCY	Currency	nvarchar	5	0	Allow NULL?
124	ALC	Agency Location Code	nvarchar	8	0	Allow NULL?
125	PMT_OFFICE	Payment Office	nvarchar	5	0	Allow NULL?
126	PPA_RELEVANT	Vendor is PPA relevant	char	1	0	Allow NULL?
127	PSOFG	Processor group	nvarchar	10	0	Allow NULL?
128	PSOIS	Subledger acct preprocessing procedure	nvarchar	20	0	Allow NULL?
129	PSON1	Name 1	nvarchar	35	0	Allow NULL?
130	PSON2	Name 2	nvarchar	35	0	Allow NULL?
131	PSON3	Name 3	nvarchar	35	0	Allow NULL?
132	PSOVN	First Name	nvarchar	35	0	Allow NULL?
133	PSOTL	Title	nvarchar	20	0	Allow NULL?
134	PSOHS	House number: is no longer used from Release 4.6B	nvarchar	6	0	Allow NULL?
135	PSOST	Street: No longer used from Release 4.6B	nvarchar	28	0	Allow NULL?
136	TRANSPORT_CHAIN	Transportation Chain	nvarchar	10	0	Allow NULL?
137	STAGING_TIME	Staging Time in Days	decimal	3	0
138	SCHEDULING_TYPE	Scheduling Procedure	char	1	0	Allow NULL?
139	SUBMI_RELEVANT	Cross Docking: Relevant for Collective Numbering	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
LFA1~0	Yes	Yes	CLUSTERED	LIFNR, MANDT
LFA1~001	No	No	NONCLUSTERED	CONFS, MANDT
LFA1~E	No	No	NONCLUSTERED	SORTL, MANDT
LFA1~MC3	No	No	NONCLUSTERED	MCOD3, MANDT
LFA1~MCD	No	No	NONCLUSTERED	MCOD3, MCOD2, MCOD1, MANDT
LFA1~PLZ	No	No	NONCLUSTERED	PSTLZ, MANDT
LFA1~R	No	No	NONCLUSTERED	ESRNR, MANDT
LFA1~Z	No	No	NONCLUSTERED	LAND1, 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

139 COLUMNS | 8 INDEXES | ERP 6.0 | LFA1 TABLE

TOP ERP 6.0 | LFA1 COLUMNS

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

139 COLUMNS | 8 INDEXES | ERP 6.0 | LFA1 TABLE

TOPERP 6.0 | LFA1 COLUMNS

TOPERP 6.0 | LFA1 INDEXES

TOP ERP 6.0 | LFA1 COLUMNS

TOP ERP 6.0 | LFA1 INDEXES