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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	SOORT	Organization Type	nvarchar	2	Allow NULL?
3	JUPER	Legal Person	nvarchar	4	Allow NULL?
4	INSTL	Data Type	nvarchar	3	Allow NULL?
5	OTYPE	Object Type	nvarchar	2	Allow NULL?
6	OBJID	Object ID	nvarchar	8	Allow NULL?
7	ENDDA	End Date	nvarchar	8	Allow NULL?
8	BEGDA	Start Date	nvarchar	8	Allow NULL?
9	KNAAM	Organization Short Name	nvarchar	22	Allow NULL?
10	LNAAM	Company Name	nvarchar	120	Allow NULL?
11	STRAS	Street and House Number	nvarchar	60	Allow NULL?
12	HSNMR	House Number	nvarchar	10	Allow NULL?
13	POSTA	Identification of an apartment in a building	nvarchar	10	Allow NULL?
14	BLDNG	Building (Number or Code)	nvarchar	20	Allow NULL?
15	LOCAT	2nd Address Line	nvarchar	40	Allow NULL?
16	PSTLZ	Postal Code	nvarchar	10	Allow NULL?
17	ORT01	City	nvarchar	40	Allow NULL?
18	LAND1	Country Key	nvarchar	3	Allow NULL?
19	STATE	Region (State, Province, County)	nvarchar	3	Allow NULL?
20	COUNC	County Code	nvarchar	3	Allow NULL?
21	TELNR	Telephone Number	nvarchar	14	Allow NULL?
22	FAXNR	Fax Number	nvarchar	25	Allow NULL?
23	KPERS	Contact Person	nvarchar	25	Allow NULL?
24	ANSNR	Organization Tax Number (INN)	nvarchar	20	Allow NULL?
25	REKNR	Bank Account or Giro Account Number	nvarchar	20	Allow NULL?
26	AFDLG	Department	nvarchar	25	Allow NULL?
27	KPP00	KPP Number	nvarchar	9	Allow NULL?
28	KDVID	Work	nvarchar	30	Allow NULL?
29	KDOKP	OKPO Code	nvarchar	10	Allow NULL?
30	KDOKD	OKDP Code	nvarchar	135	Allow NULL?
31	KDOKH	OKVED Code	nvarchar	23	Allow NULL?
32	KOKFS	OKFS Code	nvarchar	2	Allow NULL?
33	REGNO	Registration Number	nvarchar	14	Allow NULL?
34	REGDT	Registration Date	nvarchar	8	Allow NULL?
35	REGOR	Tax Authority Name	nvarchar	150	Allow NULL?
36	REGCD	Tax Authority Code	nvarchar	4	Allow NULL?
37	OKATO	OKATO Code	nvarchar	12	Allow NULL?
38	OKTMO	OKTMO Code	nvarchar	12	Allow NULL?
39	OKOPF	OKOPF Code	nvarchar	5	Allow NULL?
40	KOGRN	Main State Registration Number (OGRN)	nvarchar	13	Allow NULL?
41	FSSRN	Registration Number of Employer in FSS	nvarchar	10	Allow NULL?
42	TAXRG	Taxation Regime of Organization (Social Ins. Payments)	nvarchar	3	Allow NULL?
43	FSSCD	Subordinate Code of FSS	nvarchar	5	Allow NULL?
44	EGRUL	EGRUL Code	nvarchar	13	Allow NULL?
45	ORPRF	Legal Form of Organization	nvarchar	40	Allow NULL?
46	TFOMS	TFOMS	nvarchar	15	Allow NULL?
47	TXSRG	Special Tax Regime Code	nvarchar	2	Allow NULL?
48	TXBRG	Tax Regime Code For Budget Organization	nvarchar	2	Allow NULL?
49	SHFSN	Short Name of Organization Registred in FSS	nvarchar	29	Allow NULL?
50	LOFSN	Long Name of Organization Registred in FSS	nvarchar	50	Allow NULL?
51	FSSNM	FSS Authority Name	nvarchar	150	Allow NULL?
52	FSSCC	Company Code	nvarchar	4	Allow NULL?
53	FSSHB	Short Key for a House Bank	nvarchar	5	Allow NULL?
54	FSSKT	ID for account details	nvarchar	5	Allow NULL?
55	EMAIL	Organization E-Mail Address	nvarchar	30	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

55 COLUMNS | 1 INDEXES | ERP 6.0 | T7RU9A TABLE

TOP ERP 6.0 | T7RU9A COLUMNS

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

55 COLUMNS | 1 INDEXES | ERP 6.0 | T7RU9A TABLE

TOPERP 6.0 | T7RU9A COLUMNS

TOPERP 6.0 | T7RU9A INDEXES

TOP ERP 6.0 | T7RU9A COLUMNS

TOP ERP 6.0 | T7RU9A INDEXES