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
Public Sector Management :: Functions for U.S. Federal Government
1	ERP EHP7	6.0	FMCCRVENDOR_HDR	47	1	PSM-FG: CCR Vendor Table	Functions for U.S. Federal Government

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	DUNS	DUNS Number	nvarchar	9	Allow NULL?
3	DUNS4	DUNS+4	nvarchar	4	Allow NULL?
4	CAGE	CAGE Code	nvarchar	5	Allow NULL?
5	BUSNAME	Legal Business Name	nvarchar	120	Allow NULL?
6	DBANAME	Doing Business As	nvarchar	60	Allow NULL?
7	TAXID	CCR TaxID	nvarchar	9	Allow NULL?
8	SSN	Social Security Number	nvarchar	9	Allow NULL?
9	REGSTAT	Current Registration Status	nvarchar	10	Allow NULL?
10	EXPDATE	Registration Expiration Date	nvarchar	8	Allow NULL?
11	DIVNAME	Division Name	nvarchar	60	Allow NULL?
12	DIVNUM	Division Number	nvarchar	10	Allow NULL?
13	URL	Uniform Resource Locator	nvarchar	200	Allow NULL?
14	BUSSTART	Business start date	nvarchar	8	Allow NULL?
15	EMPLNUM	Number of employees	nvarchar	15	Allow NULL?
16	LOCEMPLNUM	Location Employee Number	nvarchar	15	Allow NULL?
17	FISCEND	Fiscal Year End Close Date (MMDD)	nvarchar	4	Allow NULL?
18	REVENUE	Revenue	nvarchar	15	Allow NULL?
19	LOCREVENUE	Location Revenue	nvarchar	15	Allow NULL?
20	COSECLVL	Company Security Level	nvarchar	2	Allow NULL?
21	EMSECLVL	Highest Employee Security Level	nvarchar	2	Allow NULL?
22	ORGTYP	Organization Type Code	nvarchar	2	Allow NULL?
23	DELFEDDEBT	Obsolete field (do not use) - Delinquent Federal Debt	char	1	Allow NULL?
24	NOPUBDISPLAY	Obsolete field (do not use) - No Public Display Flag	char	1	Allow NULL?
25	XUSNAM	User name	nvarchar	12	Allow NULL?
26	XDATE	Last CCR Extract Date	nvarchar	8	Allow NULL?
27	XTIME	Last CCR Extract Time	nvarchar	6	Allow NULL?
28	MPIN	Marketing Partner Identification Number	nvarchar	9	Allow NULL?
29	FININST	Financial Institution	nvarchar	30	Allow NULL?
30	ABAROUTE	American Bankers Association Routing Number	nvarchar	9	Allow NULL?
31	ACCNTNO	Account Number	nvarchar	30	Allow NULL?
32	ACCNTYP	Account Type	char	1	Allow NULL?
33	LOCKBOX	Lock Box	nvarchar	20	Allow NULL?
34	AUTHDATE	Authorization Date	nvarchar	8	Allow NULL?
35	EDIVAN	Value Added Network	nvarchar	60	Allow NULL?
36	EDIISAQ	ISA Qualifier	nvarchar	2	Allow NULL?
37	EDIISASQ	ISA Sender Qualifier	nvarchar	15	Allow NULL?
38	EDIGS02	GS02 Identifier	nvarchar	15	Allow NULL?
39	EDIREC820	Receive 820	char	1	Allow NULL?
40	DBUPDATE	Last Update Date from Dun and Bradstreet	nvarchar	8	Allow NULL?
41	DBBUSNAME	D&B Monitoring: Legal Business Name	nvarchar	120	Allow NULL?
42	DBDBANAME	D&B Monitoring: Doing Business As	nvarchar	60	Allow NULL?
43	DBMONST	Dun and Bradstreet Monitoring Status	nvarchar	20	Allow NULL?
44	DBBUSST	Dun and Bradstreet Current Business Status	char	1	Allow NULL?
45	REGDATE	Registration date	nvarchar	8	Allow NULL?
46	STATEINC	State of Incorporation	nvarchar	2	Allow NULL?
47	COUNTRYINC	Country of Incorporation	nvarchar	3	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

47 COLUMNS | 1 INDEXES | ERP 6.0 | FMCCRVENDOR_HDR TABLE

TOP ERP 6.0 | FMCCRVENDOR_HDR COLUMNS

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

47 COLUMNS | 1 INDEXES | ERP 6.0 | FMCCRVENDOR_HDR TABLE

TOPERP 6.0 | FMCCRVENDOR_HDR COLUMNS

TOPERP 6.0 | FMCCRVENDOR_HDR INDEXES

TOP ERP 6.0 | FMCCRVENDOR_HDR COLUMNS

TOP ERP 6.0 | FMCCRVENDOR_HDR INDEXES