	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

139 columns | B1 9.2 | CARDCODE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value
TOPAdministration
1	DAR1	Data Archive - Transaction Log	25	CardCode	Card Code	nVarChar	15	0
2	DAR2	Data Archive - Transaction Log	7	CardCode	Customer/Vendor Code	nVarChar	15	0
3	DGP1	Customer List	2	CardCode	Customer Code	nVarChar	15	0
4	GPC1	Authority Assignment	4	CardCode	Vendor Code	nVarChar	15	0
5	NFN4	Manual Nota Fiscal Number	9	CardCode	Customer/Vendor Code	nVarChar	15	0	-
6	OSRL	Serial Numbers	3	CardCode	Customer Code	nVarChar	15	0
TOPBanking
7	ABOE	Bill of Exchange for Payment - History	17	CardCode	BP Code	nVarChar	15	0
8	ARCT	Incoming Payment - History	9	CardCode	BP Code	nVarChar	15	0
9	OBCG	Bank Charge for Bank Transfers	1	CardCode	BP Code	nVarChar	15	0
10	OBNK	External Bank Statement Received	17	CardCode	BP Code	nVarChar	15	0
11	OBOE	Bill of Exchange for Payment	17	CardCode	BP Code	nVarChar	15	0
12	OCHH	Check Register	8	CardCode	BP/Account Code	nVarChar	15	0
13	OCRH	Credit Card Management	25	CardCode	BP/Account Code	nVarChar	15	0
14	OCRV	Credit Payments	19	CardCode	BP/Account Code	nVarChar	15	0
15	OPDF	Payment Draft	9	CardCode	Customer/Vendor Code	nVarChar	15	0
16	OPWB	PWZ - Bank Account	2	CardCode	BP Code	nVarChar	15	0
17	ORCT	Incoming Payment	9	CardCode	Customer/Vendor Code	nVarChar	15	0
18	OVPM	Outgoing Payments	9	CardCode	Customer/Vendor Code	nVarChar	15	0
19	PWZ1	Payment Wizard - Rows 1	2	CardCode	BP Code	nVarChar	15	0
20	PWZ3	Payment Wizard - Rows 3	3	CardCode	Vendor Code	nVarChar	15	0
21	PWZ4	Payment Wizard - Rows 4	3	CardCode	Vendor's Card code	nVarChar	15	0
22	PWZ5	Payment Wizard - Rows 5	4	CardCode	Card Code	nVarChar	15	0
23	RTW1	Boleto Retorno Wizard: Import Table	43	CardCode	BoE BP Code	nVarChar	15	0
TOPBusiness Partners
24	ACPR	Contact Persons - History	2	CardCode	BP Code	nVarChar	15	0
25	ACR1	Business Partner Addresses - History	2	CardCode	BP Code	nVarChar	15	0
26	ACR2	Bussiness Partners - Payment Methods-History	1	CardCode	BP Code	nVarChar	15	0
27	ACR3	Business Partner Control Accounts - History	1	CardCode	BP Code	nVarChar	15	0
28	ACR4	Allowed WTax Codes for BP - History	1	CardCode	BP Code	nVarChar	15	0
29	ACR5	BP Payment Dates	1	CardCode	BP Code	nVarChar	15	0
30	ACR7	Fiscal IDs for BP Master Data	1	CardCode	BP Code	nVarChar	25	0
31	ACRB	Business Partner Bank Accounts - History	2	CardCode	BP Code	nVarChar	15	0
32	ACRD	Business Partners - History	1	CardCode	BP Code	nVarChar	15	0
33	CRD1	Business Partners - Addresses	2	CardCode	BP Code	nVarChar	15	0
34	CRD2	Bussiness Partners - Payment Methods	1	CardCode	BP Code	nVarChar	15	0
35	CRD3	BP Control Account	1	CardCode	BP Code	nVarChar	15	0
36	CRD4	Allowed WTax Codes for BP	1	CardCode	BP Code	nVarChar	15	0
37	CRD5	BP Payment Dates	1	CardCode	BP Code	nVarChar	15	0
38	CRD6	BP's Payer Name	1	CardCode	BP Code	nVarChar	15	0
39	CRD7	Fiscal IDs for BP Master Data	1	CardCode	BP Code	nVarChar	25	0
40	CRD8	BP Branch Assignment	1	CardCode	BP Code	nVarChar	15	0
41	CRD9	OCRD Extension	1	CardCode	BP Code	nVarChar	25	0
42	OCLG	Activities	2	CardCode	BP Code	nVarChar	15	0
43	OCPR	Contact Persons	2	CardCode	BP Code	nVarChar	15	0
44	OCRB	BP - Bank Account	2	CardCode	BP Code	nVarChar	15	0
45	OCRD	Business Partner	1	CardCode	BP Code	nVarChar	15	0
46	ODDT	Withholding Tax Deduction Hierarchy	2	CardCode	BP Code	nVarChar	15	0
47	OSCN	Customer/Vendor Cat. No.	2	CardCode	BP Code	nVarChar	15	0
48	OTBP	Target Group Business Partner	1	CardCode	BP Code	nVarChar	15	0
49	TGG1	Target Group Details	2	CardCode	BP Code	nVarChar	15	0
TOPFinance
50	AGAR	G/L Account Advanced Rules - History	81	CardCode	Customer/Vendor Code	nVarChar	15	0
51	ISW1	Reported Business Partners	2	CardCode	Business Partner Code	nVarChar	15	0
52	ISW3	Declaration Rows	5	CardCode	Business Partner Code	nVarChar	15	0
53	OACM	Accumulation	2	CardCode	Customer/Vendor Code	nVarChar	15	0
54	OGAR	G/L Account Advanced Rules	81	CardCode	Customer/Vendor Code	nVarChar	15	0
55	RTM2	Rate Differences - SC Adjustment Rows	3	CardCode	BP Code	nVarChar	15	0
56	VRW3	VAT Reposting Wizard - Rows 3	2	CardCode	Customer/Vendor Code	nVarChar	15	0
TOPGeneral
57	AGRS	G/L Account Advanced Rules for Resources - History	54	CardCode	Customer/Vendor Code	nVarChar	15	0
58	ARSC	Resource Master Data - Log	14	CardCode	Preferred Vendor	nVarChar	15	0
59	CRDC	BP - Commnunication Mean	1	CardCode	BP Code	nVarChar	15	0
60	OGRS	G/L Account Advanced Rules for Resources	54	CardCode	Customer/Vendor Code	nVarChar	15	0
61	ORSC	Resources	14	CardCode	Preferred Vendor	nVarChar	15	0
62	OSWA	Specific Withholding Amounts	2	CardCode	BP Code	nVarChar	15	0
63	TCN2	Tracking Note - Brokers	3	CardCode	BP Code	nVarChar	15	0
TOPInventory and Production
64	AITM	Items - History	19	CardCode	Preferred Vendor	nVarChar	15	0
65	AMRV	Inventory Revaluation - History	30	CardCode	Customer/Vendor Code	nVarChar	15	0
66	AQI1	Inventory Opening Balance - Rows	30	CardCode	Preferred Vendor	nVarChar	15	0
67	AQR1	Inventory Posting - Rows	29	CardCode	Preferred Vendor	nVarChar	15	0
68	ASP1	Special Prices - Data Areas	2	CardCode	BP Code	nVarChar	15	0
69	ASP2	Special Prices - Quantity Areas	2	CardCode	BP Code	nVarChar	15	0
70	ASPP	Special Prices	2	CardCode	BP Code	nVarChar	15	0
71	AWOR	Production Order - History	19	CardCode	Customer Code	nVarChar	15	0
72	IOD1	Inventory Opening Balance Draft - Rows	30	CardCode	Preferred Vendor	nVarChar	15	0
73	IPD1	Inventory Posting Draft - Rows	29	CardCode	Preferred Vendor	nVarChar	15	0
74	IPF1	Landed Costs - Rows	25	CardCode	Vendor Code	nVarChar	15	0
75	IQI1	Inventory Opening Balance - Rows	30	CardCode	Preferred Vendor	nVarChar	15	0
76	IQR1	Inventory Posting - Rows	29	CardCode	Preferred Vendor	nVarChar	15	0
77	OENT	Shipping Types	8	CardCode	BP Code	nVarChar	15	0
78	OIGE	Goods Issue	13	CardCode	Expense Account	nVarChar	15	0
79	OIGN	Goods Receipt	13	CardCode	Revenue Account	nVarChar	15	0
80	OIPF	Landed Costs	5	CardCode	Vendor Code	nVarChar	15	0
81	OITL	Inventory Transactions Log	17	CardCode	BP Code	nVarChar	15	0
82	OITM	Items	19	CardCode	Preferred Vendor	nVarChar	15	0
83	OMRV	Inventory Revaluation	30	CardCode	Customer/Vendor Code	nVarChar	15	0
84	OSPG	Special Prices for Groups	1	CardCode	BP Code	nVarChar	15	0
85	OSPP	Special Prices	2	CardCode	BP Code	nVarChar	15	0
86	OWKO	Production Instructions	9	CardCode	Sold-to Party Code	nVarChar	15	0
87	OWOR	Production Order	19	CardCode	Customer Code	nVarChar	15	0
88	OWTQ	Inventory Transfer Request	13	CardCode	Customer/Vendor Code	nVarChar	15	0
89	OWTR	Inventory Transfer	13	CardCode	Customer/Vendor Code	nVarChar	15	0
90	SITM	Items	19	CardCode	Preferred Vendor	nVarChar	15	0
91	SPP1	Special Prices - Data Areas	2	CardCode	BP Code	nVarChar	15	0
92	SPP2	Special Prices - Quantity Areas	2	CardCode	BP Code	nVarChar	15	0
93	UITM	Items	19	CardCode	Preferred Vendor	nVarChar	15	0
94	UWKO	Production Instructions	9	CardCode	Sold-To-Party Code	nVarChar	15	0
95	UWOR	Production Order	19	CardCode	Customer Code	nVarChar	15	0
96	WOR2V	Production Order - Base	4	CardCode	Customer Code	nVarChar	15	0
TOPMarketing Documents
97	ADOC	Invoice - History	13	CardCode	BP Code	nVarChar	15	0
98	ATXI	Tax Invoice - History	10	CardCode	Customer Code	nVarChar	15	0
99	DWZ1	Dunning Wizard Array1 - BP Filter	2	CardCode	BP Card Code	nVarChar	15	0
100	DWZ2	Dunning Wizard Array 2-Invoice Filter	2	CardCode	BP Card Code	nVarChar	15	0
101	DWZ3	Dunning Wizard Array 3 - Recommended Service Invoice	2	CardCode	BP Card Code	nVarChar	15	0
102	DWZ4	Dunning Wizard Array 4-Paging Grid	5	CardCode	BP Card Code	nVarChar	15	0
103	OCIN	A/R Correction Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
104	OCPI	A/P Correction Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
105	OCPV	A/P Correction Invoice Reversal	13	CardCode	Customer/Vendor Code	nVarChar	15	0
106	OCSI	A/R Correction Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
107	OCSV	A/R Correction Invoice Reversal	13	CardCode	Customer/Vendor Code	nVarChar	15	0
108	ODLN	Delivery	13	CardCode	Customer/Vendor Code	nVarChar	15	0
109	ODPI	A/R Down Payment	13	CardCode	Customer/Vendor Code	nVarChar	15	0
110	ODPO	A/P Down Payment	13	CardCode	Customer/Vendor Code	nVarChar	15	0
111	ODRF	Drafts	13	CardCode	BP Code	nVarChar	15	0
112	OIEI	Incoming Excise Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
113	OINV	A/R Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
114	OOEI	Outgoing Excise Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
115	OPCH	A/P Invoice	13	CardCode	Customer/Vendor Code	nVarChar	15	0
116	OPDN	Goods Receipt PO	13	CardCode	Customer/Vendor Code	nVarChar	15	0
117	OPOR	Purchase Order	13	CardCode	Customer/Vendor Code	nVarChar	15	0
118	OPQT	Purchase Quotation	13	CardCode	Customer/Vendor Code	nVarChar	15	0
119	OPRQ	Purchase Request	13	CardCode	Customer/Vendor Code	nVarChar	15	0
120	OQUT	Sales Quotation	13	CardCode	Customer/Vendor Code	nVarChar	15	0
121	ORDN	Returns	13	CardCode	Customer/Vendor Code	nVarChar	15	0
122	ORDR	Sales Order	13	CardCode	Customer/Vendor Code	nVarChar	15	0
123	ORIN	A/R Credit Memo	13	CardCode	Customer/Vendor Code	nVarChar	15	0
124	ORPC	A/P Credit Memo	13	CardCode	Customer/Vendor Code	nVarChar	15	0
125	ORPD	Goods Return	13	CardCode	Customer/Vendor Code	nVarChar	15	0
126	OSAL	Outgoing	8	CardCode	BP Code	nVarChar	15	0
127	OTPI	Purchase Tax Invoice	10	CardCode	Customer Code	nVarChar	15	0
128	OTRA	Transition	8	CardCode	BP Code	nVarChar	15	0
129	OTSI	Sales Tax Invoice	10	CardCode	Customer Code	nVarChar	15	0
130	OTXD	Tax Invoice Draft	10	CardCode	Customer Code	nVarChar	15	0
131	OVRT	Tax Invoice Report	4	CardCode	Receipt BP Code	nVarChar	15	0
TOPMRP
132	ORCM	Recommendation Data	9	CardCode	Preferred Vendor	nVarChar	15	0
TOPReports
133	AMD1	Amout Differences Report Lines	5	CardCode	BP Code	nVarChar	15	0
134	OAMD	Amount Differences Report	4	CardCode	BP Code	nVarChar	15	0
135	RDFL	Document Standards	4	CardCode	BP Code	nVarChar	15	0	-1
136	SRT2	Korean Summary Report - Rows2	4	CardCode	BP Code on OCRD	nVarChar	15	0
137	TRB5	Tax Report Wizard Reported Tax Sums	3	CardCode	Vendor Code	nVarChar	15	0
TOPSales Opportunities
138	AOPR	Opportunity	2	CardCode	BP Code	nVarChar	15	0
139	OOPR	Opportunity	2	CardCode	BP Code	nVarChar	15	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

139 columns | B1 9.2 | CARDCODE