	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

	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

	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

95 columns | ERP 6.0 | PERSNUMBER

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CADMC/00000410	ADCP	6	PERSNUMBER		nvarchar	10	0
2	/1CADMC/00000412	ADR2	6	PERSNUMBER		nvarchar	10	0
3	/1CADMC/00000413	ADR3	6	PERSNUMBER		nvarchar	10	0
4	/1CADMC/00000414	ADR6	6	PERSNUMBER		nvarchar	10	0
5	/1CADMC/00000416	ADRP	5	PERSNUMBER		nvarchar	10	0
6	/FLDQ/AD_ERRLOCK	Table to store errors during locking AD_MTCCODE records	3	PERSNUMBER	Person number	nvarchar	10	0
7	/FLDQ/AD_ERRQTR	Table to store address errors generated during RSADRQU2	3	PERSNUMBER	Person number	nvarchar	10	0
8	/FLDQ/AD_INI_ERR	Record records which encounter an error in RSADRINI	3	PERSNUMBER	Person number	nvarchar	10	0
9	/FLDQ/AD_INI_IDX	Copy of Shadow Table /fldq/ad_mtc_sh	3	PERSNUMBER	Person number	nvarchar	10	0
10	/FLDQ/AD_MTCCODE	FirstLogic Match Code Index Table	3	PERSNUMBER	Person number	nvarchar	10	0
11	/FLDQ/AD_MTCRSLT	Match Results table to store results from RSADRINI program	2	PERSNUMBER	Person number	nvarchar	10	0
12	/FLDQ/AD_MTC_SH	FirstLogic Shadow table for /FLDQ/AD_MTCCODE	3	PERSNUMBER	Person number	nvarchar	10	0
13	/FLDQ/AD_MTC_SH2	FirstLogic Shadow table for /FLDQ/AD_MTCCODE	3	PERSNUMBER	Person number	nvarchar	10	0
14	/FLDQ/AD_PUPDATE	Matchcode Records pending to be updated	3	PERSNUMBER	Person number	nvarchar	10	0
15	/FLDQ/AD_QTRRVW	Cleansed addresses from RSADRQU2 to review before comitting	16	PERSNUMBER	Person number	nvarchar	10	0
16	/FLDQ/AD_QU_INDX	QU2 Index Table	10	PERSNUMBER	Person number	nvarchar	10	0
17	/FLDQ/HNA_BM_IN	HANA task Batch Match Input Records	3	PERSNUMBER	Person number	nvarchar	10	0
18	/FLDQ/HNA_BM_OUT	HANA task Batch Match Result Records	2	PERSNUMBER	Person number	nvarchar	10	0
19	/FLDQ/HNA_PREQU2	staging table for RSADRQU2 report	10	PERSNUMBER	Person number	nvarchar	10	0
20	/FLDQ/HNA_PSTQU2	Result Table for RSADRQU2 report	10	PERSNUMBER	Person number	nvarchar	10	0
21	CNVTDMS_05_PERN	Personal number table-Not Used. Go to CNVTDMS_05_PERNS	3	PERSNUMBER	Character 10	nvarchar	10	0
22	CNVTDMS_05_PERNS	Personal number table	3	PERSNUMBER	Character 10	nvarchar	10	0
23	NWS_EXT_ADR2	Texts for Communication Data (Central Address Management)	2	PERSNUMBER	Person number	nvarchar	10	0
24	NWS_EXT_ADRT	Texts for Communication Data (Central Address Management)	2	PERSNUMBER	Person number	nvarchar	10	0
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
25	CD0F4TEST	Tabelle mit Feldern mit verschiedenen Eingabehilfen	17	PERSNUMBER	Personennummer	nvarchar	10	0
TOPAddress ManagementBusiness Address
26	ADCP	Person/Address Assignment (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
27	ADCPS	Shadow Table: Assignment Person/Addr. (Bus. Addr. Services)	4	PERSNUMBER	Person number	nvarchar	10	0
28	ADCP_UUID_INDEX	Index Table for ADCP-ADCP_UUID	6	PERSNUMBER	Person number	nvarchar	10	0
29	ADR10	Printer (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
30	ADR10S	Shadow Table: Printer (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
31	ADR11	SSF (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
32	ADR11S	Shadow Table: SSF (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
33	ADR12	FTP and URL (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
34	ADR12S	Shadow Table: FTP and URL (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
35	ADR13	Pager (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
36	ADR13S	Shadow Table: Pager (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
37	ADR14	Reserve Communication Method (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
38	ADR15	Reserve Communication Method (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
39	ADR16	Reserve Communication Method (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
40	ADR2	Telephone Numbers (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
41	ADR2S	Shadow Table: Telephone Numbers (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
42	ADR3	Fax Numbers (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
43	ADR3S	Shadow table: Fax numbers (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
44	ADR4	Teletex Numbers (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
45	ADR4S	Shadow Table: Teletex Numbers (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
46	ADR5	Telex Numbers (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
47	ADR5S	Shadow Table: Fax Numbers (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
48	ADR6	E-Mail Addresses (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
49	ADR6S	Shadow Table: SMTP Numbers (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
50	ADR7	Remote Mail Addresses (SAP - SAP - Communication; BAS)	3	PERSNUMBER	Person number	nvarchar	10	0
51	ADR7S	Shadow Table: RML Addresses (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
52	ADR8	X.400 Numbers (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
53	ADR8S	Shadow Table: X.400 Numbers (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
54	ADR9	RFC Destinations (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
55	ADR9S	Shadow Table: RFC Destinations (Business Address Services)	4	PERSNUMBER	Person number	nvarchar	10	0
56	ADRCOMC	Comm. Data Serial Number Counter (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
57	ADRCOMCS	Shadow table: Counter for current numbers for comm. data	4	PERSNUMBER	Person number	nvarchar	10	0
58	ADRGP	Assignment of Persons to Further Person Groups (BAS)	2	PERSNUMBER	Person number	nvarchar	10	0
59	ADRGPS	Shadow table: Assignment of persons to other person groups	3	PERSNUMBER	Person number	nvarchar	10	0
60	ADRP	Persons (Business Address Services)	2	PERSNUMBER	Person number	nvarchar	10	0
61	ADRPS	Shadow Table: Persons (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
62	ADRP_UUID_INDEX	Index Table for ADRP-ADRP_UUID	5	PERSNUMBER	Person number	nvarchar	10	0
63	ADRT	Communication Data Text (Business Address Services)	3	PERSNUMBER	Person number	nvarchar	10	0
64	ADRTS	Shadow Table: Texts for Communications Data (BAS)	4	PERSNUMBER	Person number	nvarchar	10	0
65	ADRU	Table for Communication Usages	3	PERSNUMBER	Person number	nvarchar	10	0
66	ADRUS	Shadow Table: Communication Usages (BAS)	4	PERSNUMBER	Person number	nvarchar	10	0
67	ADRVP	Person Where-Used List (Business Address Services)	2	PERSNUMBER	Person number	nvarchar	10	0
68	ADRVPS	Shadow Table: Where-Used List for Persons (BAS)	3	PERSNUMBER	Person number	nvarchar	10	0
TOPAppointment Calendar
69	SCOWNER	Owner of an appointment calendar	3	PERSNUMBER	Person number	nvarchar	10	0
70	SCPARTICIP	Group appointment participants table	13	PERSNUMBER	Person number	nvarchar	10	0
TOPBusiness Partner Enhancements for Financial Services
71	BP000	Business Partner Master (General Data)	5	PERSNUMBER	Person number	nvarchar	10	0
TOPCommunication Services Mail, Fax, SMS, Telephony
72	BCST_CAM	Persistence of a BAS Address	4	PERSNUMBER	Person number	nvarchar	10	0
73	BCST_IBND	BCS: Rules for Inbound Distribution	4	PERSNUMBER	Person number	nvarchar	10	0
74	BCST_RETE	BCS: Status of Technical Recipients	5	PERSNUMBER	Person number	nvarchar	10	0
75	SPH_USNOLI	SAPphone: Telephone number list for each user	10	PERSNUMBER	Person number	nvarchar	10	0
TOPContract Accounts Receivable and Payable
76	DFKKCFDUNTEL	Telephone List for Dunning	18	PERSNUMBER	Person number	nvarchar	10	0
TOPCorrespondence Tool
77	DFKKCOH	Correspondence - Correspondence Header	49	PERSNUMBER	Person number	nvarchar	10	0
TOPEmployee Interaction Center
78	THREIC_CONTACT	EIC Contact	23	PERSNUMBER	Person number	nvarchar	10	0
79	THREIC_EXT_GUID	EIC: Linkage of Addrnumber, Persnumber & GUID	4	PERSNUMBER	Person number	nvarchar	10	0
TOPFinancial Accounting
80	TICRC3	Contact Person in Trading Partner	5	PERSNUMBER	Person number	nvarchar	10	0
TOPIncentive and Commission Management ICM
81	CACSCS_DFKKCOH	Aggregation Container	18	PERSNUMBER	Person number	nvarchar	10	0
TOPMaster Data
82	JGTSADR	IS-M: Extended Address Management	112	PERSNUMBER	Person number	nvarchar	10	0
TOPReusable Components of Business Suite Foundation
83	/BOFU/ADCPUUID	Table for ADCP-UUID (Downport 7.10 to 7.0)	6	PERSNUMBER	Person number	nvarchar	10	0
84	/BOFU/ADRPUUID	Table for ADRP-UUID (Downport 7.10 to 7.0)	5	PERSNUMBER	Person number	nvarchar	10	0
TOPSAP Business Partner
85	BUP_ADDR3_CD	BP Relationship: Index Table for Change Document Access	2	PERSNUMBER	Person number	nvarchar	10	0
86	BUT000_BCS	Persistence of a BAS Address	4	PERSNUMBER	Person number	nvarchar	10	0
TOPSAP NetWeaver Mobile - Use subcomponents
87	MEREP_ADDRESS	Address (Sample Application)	2	PERSNUMBER	Person Number (Sample Application)	nvarchar	10	0
88	MEREP_E_MAIL	E-mail Addressa (Sample Application)	2	PERSNUMBER	Person Number (Sample Application)	nvarchar	10	0
89	MEREP_PERSON	Person (Sample Application)	2	PERSNUMBER	Person Number (Sample Application)	nvarchar	10	0
90	MEREP_P_HISTORY	History Table of MEREP_PERSON	2	PERSNUMBER	Person Number (Sample Application)	nvarchar	10	0
TOPUse AP-MD-BP Components
91	BUT000	BP: General data I	62	PERSNUMBER	Person number	nvarchar	10	0
92	BUT000_TD	BP: General Data I, Shadow Table Time Dependency	63	PERSNUMBER	Person number	nvarchar	10	0
93	BUT000_TDS	BP: General Data I, Shadow Table Time Dependency	64	PERSNUMBER	Person number	nvarchar	10	0
TOPUser and Authorization Management
94	USR21	User Name/Address Key Assignment	3	PERSNUMBER	Person number	nvarchar	10	0
95	USR21S	Shadow table: Assignment of user name to address key	4	PERSNUMBER	Person number	nvarchar	10	0

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

95 columns | ERP 6.0 | PERSNUMBER