	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

95 columns | ERP 6.0 | CONSNUMBER

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CADMC/00000412	ADR2	8	CONSNUMBER		nvarchar	3	0
2	/1CADMC/00000413	ADR3	8	CONSNUMBER		nvarchar	3	0
3	/1CADMC/00000414	ADR6	8	CONSNUMBER		nvarchar	3	0
4	BBP_SUS_STG_FAX	Staging address table	3	CONSNUMBER	Sequence Number	nvarchar	3	0
5	BBP_SUS_STG_MAIL	staging mail table	3	CONSNUMBER	Sequence Number	nvarchar	3	0
6	BBP_SUS_STG_TEL	Staging table for telephone	3	CONSNUMBER	Sequence Number	nvarchar	3	0
7	NWS_EXT_ADFA2	Transfer structure for fax numbers (central address admin.)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
8	NWS_EXT_ADFAX	Transfer structure for fax numbers (central address admin.)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
9	NWS_EXT_ADPA2	Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
10	NWS_EXT_ADPAG	Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
11	NWS_EXT_ADPR2	Transfer Structure for PRT Addresses (Centr. Address Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
12	NWS_EXT_ADPRT	Transfer Structure for PRT Addresses (Centr. Address Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
13	NWS_EXT_ADR2	Texts for Communication Data (Central Address Management)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
14	NWS_EXT_ADRF2	Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
15	NWS_EXT_ADRFC	Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
16	NWS_EXT_ADRM2	Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
17	NWS_EXT_ADRML	Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
18	NWS_EXT_ADRT	Texts for Communication Data (Central Address Management)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
19	NWS_EXT_ADSM2	Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
20	NWS_EXT_ADSMT	Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
21	NWS_EXT_ADSS2	Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
22	NWS_EXT_ADSSF	Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
23	NWS_EXT_ADTE2	Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
24	NWS_EXT_ADTEL	Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
25	NWS_EXT_ADTL2	Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
26	NWS_EXT_ADTLX	Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
27	NWS_EXT_ADTT2	Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
28	NWS_EXT_ADTTX	Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
29	NWS_EXT_ADUR2	URI address transfer structure (central address management)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
30	NWS_EXT_ADURI	URI address transfer structure (central address management)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
31	NWS_EXT_ADX40	Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
32	NWS_EXT_ADX42	Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)	2	CONSNUMBER	Sequence Number	nvarchar	3	0
TOPAddress ManagementBusiness Address
33	ADR10	Printer (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
34	ADR10S	Shadow Table: Printer (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
35	ADR10S2	Shadow Table 2: Printer (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
36	ADR11	SSF (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
37	ADR11S	Shadow Table: SSF (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
38	ADR11S2	Shadow Table 2: SSF (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
39	ADR12	FTP and URL (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
40	ADR12S	Shadow Table: FTP and URL (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
41	ADR12S2	Shadow Table 2: FTP and URL (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
42	ADR13	Pager (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
43	ADR13S	Shadow Table: Pager (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
44	ADR13S2	Shadow Table 2: Pager (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
45	ADR14	Reserve Communication Method (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
46	ADR15	Reserve Communication Method (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
47	ADR16	Reserve Communication Method (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
48	ADR2	Telephone Numbers (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
49	ADR2S	Shadow Table: Telephone Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
50	ADR2S2	Shadow Table 2: Telephone Nos (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
51	ADR3	Fax Numbers (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
52	ADR3S	Shadow table: Fax numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
53	ADR3S2	Shadow Table 2: Fax Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
54	ADR4	Teletex Numbers (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
55	ADR4S	Shadow Table: Teletex Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
56	ADR4S2	Shadow Table 2: Teletex Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
57	ADR5	Telex Numbers (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
58	ADR5S	Shadow Table: Fax Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
59	ADR5S2	Shadow Table 2: Telex Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
60	ADR6	E-Mail Addresses (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
61	ADR6S	Shadow Table: SMTP Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
62	ADR6S2	Shadow Table 2: SMTP Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
63	ADR7	Remote Mail Addresses (SAP - SAP - Communication; BAS)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
64	ADR7S	Shadow Table: RML Addresses (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
65	ADR7S2	Shadow Table 2: RML Addresses (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
66	ADR8	X.400 Numbers (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
67	ADR8S	Shadow Table: X.400 Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
68	ADR8S2	Shadow Table 2: X.400 Numbers (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
69	ADR9	RFC Destinations (Business Address Services)	5	CONSNUMBER	Sequence Number	nvarchar	3	0
70	ADR9S	Shadow Table: RFC Destinations (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
71	ADR9S2	Shadow Table 2: RFC Destination (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
72	ADRDIFINFO	Control Table for Quarterly Adjustment Difference Tables	2	CONSNUMBER	Unique Sequential Number for Creating Difference Data	nvarchar	10	0
73	ADRDIF_CP	District Difference Table for Quarterly Adjustment	2	CONSNUMBER	Unique Sequential Number for Creating Difference Data	nvarchar	10	0
74	ADRDIF_CT	City Difference Table for Quarterly Adjustment	2	CONSNUMBER	Unique Sequential Number for Creating Difference Data	nvarchar	10	0
75	ADRDIF_PC	Postal Code Difference Table for Quarterly Adjustment	2	CONSNUMBER	Unique Sequential Number for Creating Difference Data	nvarchar	10	0
76	ADRDIF_PO	PO Box Difference Table for Quarterly Adjustment	2	CONSNUMBER	Unique Sequential Number for Creating Difference Data	nvarchar	10	0
77	ADRDIF_ST	Street Difference Table for Quarterly Adjustment	2	CONSNUMBER	Unique Sequential Number for Creating Difference Data	nvarchar	10	0
78	ADRT	Communication Data Text (Business Address Services)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
79	ADRTS	Shadow Table: Texts for Communications Data (BAS)	7	CONSNUMBER	Sequence Number	nvarchar	3	0
80	ADRTS2	Shadow Table 2: Communication Data Texts (BAS)	7	CONSNUMBER	Sequence Number	nvarchar	3	0
81	ADRU	Table for Communication Usages	5	CONSNUMBER	Sequence Number	nvarchar	3	0
82	ADRUS	Shadow Table: Communication Usages (BAS)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
83	ADRUS2	Shadow Table_2: Communication Usages (BAS)	6	CONSNUMBER	Sequence Number	nvarchar	3	0
84	ADRV	Address Where-Used List (Business Address Services)	3	CONSNUMBER	Where-used list serial number	nvarchar	10	0
85	ADRVP	Person Where-Used List (Business Address Services)	3	CONSNUMBER	Where-used list serial number	nvarchar	10	0
86	ADRVPS	Shadow Table: Where-Used List for Persons (BAS)	4	CONSNUMBER	Where-used list serial number	nvarchar	10	0
87	ADRVS	Shadow Table: Where-Used List for Addresses (BAS)	4	CONSNUMBER	Where-used list serial number	nvarchar	10	0
TOPAppointment Calendar
88	SCPARTICIP	Group appointment participants table	15	CONSNUMBER	Sequence Number	nvarchar	3	0
TOPCommunication Services Mail, Fax, SMS, Telephony
89	BCST_CAM	Persistence of a BAS Address	6	CONSNUMBER	Addresses: Sequence Number of Address	nvarchar	3	0
90	BCST_IBND	BCS: Rules for Inbound Distribution	5	CONSNUMBER	Sequence Number	nvarchar	3	0
91	BCST_RETE	BCS: Status of Technical Recipients	6	CONSNUMBER	Sequence Number	nvarchar	3	0
TOPMove-InOut
92	ECAMIOPREMAIL	IS-U: Parked Document: E-Mail Addresses	4	CONSNUMBER	Sequence Number	nvarchar	3	0
93	ECAMIOPRTEL	IS-U: Pre-entry Document: Telephone Numbers	4	CONSNUMBER	Sequence Number	nvarchar	3	0
TOPSAP Business Partner
94	BUT000_BCS	Persistence of a BAS Address	6	CONSNUMBER	Addresses: Sequence Number of Address	nvarchar	3	0
95	TB200	BP Addresses: Seq. Numbers for Planned Commun. Data	6	CONSNUMBER	Sequence Number	nvarchar	3	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 | CONSNUMBER