	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

102 columns | ERP 6.0 | PARTNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	CNVTDMSBW_REQOBJ	Requests and objects between tdms ERP and BI	6	PARTNR	PARTNR	nvarchar	10	0
2	VDARC_RET	Retention table for Loans Management	4	PARTNR	Business Partner Number	nvarchar	10	0
3	VDSEPA_MND_USG	Overview of mandates used in Loans Management	5	PARTNR	Business Partner Number	nvarchar	10	0
TOPBank Components
4	JBDSERV	SAP Banking: Master Table for Service Transactions	6	PARTNR	Business Partner Number	nvarchar	10	0
5	JBKLOBJ1	Segment Table for Financial Transactions, CL Part	17	PARTNR	Business Partner Number	nvarchar	10	0
TOPBasic Functions
6	T028RTRANS	Repetitive Transfer Transactions	20	PARTNR	Business partner	nvarchar	10	0
TOPBusiness Partner
7	BP011	Employment Data	2	PARTNR	Business Partner Number	nvarchar	10	0
8	BP021	Fiscal Year Information	2	PARTNR	Business Partner Number	nvarchar	10	0
9	BP1010	Creditworthiness Data	2	PARTNR	Business Partner Number	nvarchar	10	0
10	BP1030	BP: Business partner - reporting data	2	PARTNR	Business Partner Number	nvarchar	10	0
11	BPTRGP_ADRE	Conversion: TR Addresses - PDC Addresses	5	PARTNR	Business Partner Number	nvarchar	10	0
12	TP017	Value Table for Liability Risks	3	PARTNR	Business Partner Number	nvarchar	10	0
13	VTBSTA1	Allocation of Payment Details as Standing Instructions	2	PARTNR	Business Partner Number	nvarchar	10	0
14	VTBSTA2	Standing Instructions for Correspondence	2	PARTNR	Business Partner Number	nvarchar	10	0
15	VTBSTA3	SI for Business Partner: Transaction Authorizations	3	PARTNR	Business Partner Number	nvarchar	10	0
16	VTBSTA4	SI for Business Partner: Derived Flows	3	PARTNR	Business Partner Number	nvarchar	10	0
17	VTBSTC1	Components of Payment Details for Standing Instruction	2	PARTNR	Business Partner Number	nvarchar	10	0
TOPBusiness Partner Enhancements for Financial Services
18	BP000	Business Partner Master (General Data)	2	PARTNR	Business Partner Number	nvarchar	10	0
19	BP030	BP: Business partner - address	2	PARTNR	Business Partner Number	nvarchar	10	0
20	BP1000	BP: Business Partner - Role	2	PARTNR	Business Partner Number	nvarchar	10	0
21	BP1020	BP: Business Partner - Fiscal Data	2	PARTNR	Business Partner Number	nvarchar	10	0
22	BP1040	Business partner: Reporting data in company code	2	PARTNR	Business Partner Number	nvarchar	10	0
23	BP1050	Business Partner: General Control Data	2	PARTNR	Business Partner Number	nvarchar	10	0
24	BP1060	OBSOLETE: Business Partner: Company Code Control Data	2	PARTNR	Business Partner Number	nvarchar	10	0
25	BP3000	BP: Additional Data (from Darwin-BP)	2	PARTNR	Business Partner Number	nvarchar	10	0
26	UBBP000	TR-EDT: Transfer Business Partners	2	PARTNR	Business Partner Number	nvarchar	10	0
TOPData Staging
27	RSDELPART	Aggregation management of the IC for the Monitor	5	PARTNR	Master data ID	int	10	0
28	RSSTATMANPART	Store for G_T_PART of Request Display in DTA Administration	4	PARTNR	Numeric Character Field, Length 10	nvarchar	10	0
29	RSSTATMANPARTT	Store for G_T_PART of Request Display in DTA Administration	5	PARTNR	Numeric Character Field, Length 10	nvarchar	10	0
30	RSSTATMANPSA	Store for G_T_PART of Request Display in DTA Administration	3	PARTNR	10 digit number	nvarchar	10	0
31	RSSTATMANPSAT	Store for G_T_PART of Request Display in DTA Administration	4	PARTNR	10 digit number	nvarchar	10	0
32	RSSTATMANT_SAVE2	Store for G_T_PART of Request Display in DTA Administration	5	PARTNR	Numeric Character Field, Length 10	nvarchar	10	0
33	RSSTATMAN_SAVE2	Store for G_T_PART of Request Display in DTA Administration	4	PARTNR	Numeric Character Field, Length 10	nvarchar	10	0
TOPDB2 for OS39
34	DB2DB02EXTENTS	Tx DB02: Data for DB02's Extent Monitor	3	PARTNR	Number of partition	int	10	0
35	DB2IXBACK	List of indexes that need a backup	25	PARTNR	Partition number	smallint	5	0
36	DB2TSBACK	List of tablespaces that need a backup	27	PARTNR	Partition number	smallint	5	0
TOPDefault Risk and Limit System
37	BCKKLFAZ01	Backup for Facilities	9	PARTNR	Primary Business Partner	nvarchar	10	0
38	KLARP	Default Risk Line Items	5	PARTNR	Business Partner Number	nvarchar	10	0
39	KLCMMAPPING	Mapping Table for CM and Business Partner	6	PARTNR	Business Partner Number	nvarchar	10	0
40	KLFAZ01	Facilities (Header)	9	PARTNR	Primary Business Partner	nvarchar	10	0
41	KLNT01	Definition of Netting Group	4	PARTNR	Business Partner Number	nvarchar	10	0
42	KLREP	Risk Line Items	4	PARTNR	Business Partner Number	nvarchar	10	0
43	KLSDCPROT3	Log Gen. for Single Transaction Check: Result in ALV Format	10	PARTNR	Business Partner Number	nvarchar	10	0
44	KLSI06	Global Collateral (Assignment)	4	PARTNR	Business Partner Number	nvarchar	10	0
45	KLSI06_BAK	Backup for Euro Changeover for Global Collateral (Assignmt)	4	PARTNR	Business Partner Number	nvarchar	10	0
46	VTBLID	Limit: Details of Utilizations (Single Records)	9	PARTNR	Business Partner Number	nvarchar	10	0
47	VTBLRH	Reservations for Limit Amounts (Header)	7	PARTNR	Business Partner Number	nvarchar	10	0
48	VTBLS	Limits: Mapping Logical - Physical Keys	6	PARTNR	Business Partner Number	nvarchar	10	0
49	VTBLSD	Global Collateral: Utilizations - Details	9	PARTNR	Business Partner Number	nvarchar	10	0
TOPFlexible Real Estate Management
50	VIFEIGENT	LUM: Flurstück - Eigentümer	4	PARTNR	Geschäftspartnernummer Eigentümer	nvarchar	10	0
51	VIGBOOK	LUM: Grundbuch	3	PARTNR	Geschäftspartnernummer	nvarchar	10	0
52	VIVNACHW	LUM: Veränderungsnachweis - Allgemeine Daten	4	PARTNR	Geschäftspartnernummer Katasteramt	nvarchar	10	0
TOPInformation System
53	FTI_BUT000_T	Temporary Text Tables for Business Partners (Performance)	3	PARTNR	Business Partner Number	nvarchar	10	0
TOPLoans Management
54	VDAUSZ	Drawings on Disbursement	48	PARTNR	Business Partner Number	nvarchar	10	0
55	VDCBR_HIST	History of Data Supplied to Credit Bureau	8	PARTNR	Business Partner Number	nvarchar	10	0
56	VDGPO	Loan: Relationship Partner/Role Object	4	PARTNR	Business Partner Number	nvarchar	10	0
57	VDINSURE_PARTNE0	Do Not Use: Link Partner <-> Insurance	3	PARTNR	Business Partner Number	nvarchar	10	0
58	VDORDER	Borrower's note loan order data	52	PARTNR	Business Partner Number	nvarchar	10	0
59	VDREPAYMENT	Payoff Master Data	66	PARTNR	Payer of Payoff	nvarchar	10	0
60	VDSONSI	Special Arrangements for Collateral	5	PARTNR	Business Partner Number	nvarchar	10	0
61	VDZKP	Assign Partner / Correspondence Class not Required	2	PARTNR	Business Partner Number	nvarchar	10	0
62	VDZNB_USAGE	Payment Postprocessing: Usage of a Payment Postpr. Activity	11	PARTNR	Business Partner Number	nvarchar	10	0
63	VZFZE_VDAUSZ	Central Entry Table for Release Procedure	50	PARTNR	Business Partner Number	nvarchar	10	0
TOPProfitability Analysis
64	CE1E_B1	Model Bank	59	PARTNR	Business Partner Number	nvarchar	10	0
65	CE2E_B1	Model Bank	43	PARTNR	Business Partner Number	nvarchar	10	0
66	CE4E_B1	Model Bank	26	PARTNR	Business Partner Number	nvarchar	10	0
67	CE4E_B1_ACCT	Model Bank	27	PARTNR	Business Partner Number	nvarchar	10	0
68	CE4E_B1_FLAG	Model Bank	23	PARTNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
69	CE4E_B1_KENC	Model Bank	25	PARTNR	Business Partner Number	nvarchar	10	0
TOPReal Estate Management
70	S401	RE standard analysis partner	11	PARTNR	Business Partner Number	nvarchar	10	0
71	S408	Land registers	45	PARTNR	Business Partner Number	nvarchar	10	0
72	VIAR02	RE: REse@rch - RE Requests	83	PARTNR	Business Partner Number	nvarchar	10	0
73	VICNSCSRH	Real Estate Contract: Service Charge Settlement Header	4	PARTNR	Business Partner Number	nvarchar	10	0
74	VIEA06	Management information: Owner for owner settlement	10	PARTNR	Partner number	nvarchar	10	0
75	VIGBUCH	Land register	3	PARTNR	Business Partner Number	nvarchar	10	0
76	VIMI32	Other collateral	12	PARTNR	Partner number	nvarchar	10	0
77	VIMIIH	Invoice Header	5	PARTNR	Business Partner Number	nvarchar	10	0
78	VIMIWB	Accomm.entitlement certif. for application and LO	2	PARTNR	Business Partner Number	nvarchar	10	0
TOPRisk Analysis
79	JBRDBKO	RM: DB Table Header Information Extended Risk Object	12	PARTNR	Business Partner Number	nvarchar	10	0
80	JBRHKO	RM: Version Table: Header Information: Extended Risk Object	13	PARTNR	Business Partner Number	nvarchar	10	0
81	JBRSVKO	RM: Header Table of SDTFT for Saved Datasets	7	PARTNR	Business Partner Number	nvarchar	10	0
TOPTraders and Schedulers Workbench
82	OIJNOMC	OIL-TSW: Nomination copy table	25	PARTNR	Location Partner	nvarchar	10	0
83	OIJNOMI	Nomination Item	25	PARTNR	Location Partner	nvarchar	10	0
84	OIJNOMIVERS	Nomination Item Version Table	27	PARTNR	Location Partner	nvarchar	10	0
85	OIJ_EL_DOC_I_REF	Document item reference to nomination	38	PARTNR	Location Partner	nvarchar	10	0
86	OIJ_SCHED	Planned Schedule Lines	76	PARTNR	Location Partner	nvarchar	10	0
87	S430	SIS: (OIL-TSW) Sales document statistics by TSW object	37	PARTNR	Location Partner	nvarchar	10	0
88	S431	PURCHIS: (OIL-TSW) Purchasing document stats by TSW object	42	PARTNR	Location Partner	nvarchar	10	0
TOPTransaction Management
89	AT81M1	Assignment Table: SWIFT Code of Sender -> Business Partner	3	PARTNR	Business Partner Number	nvarchar	10	0
90	TCHT_HD_SFGDT	SFGDT Representation of Instruments	26	PARTNR	Business Partner Number	nvarchar	10	0
TOPTransaction Manager
91	TCORT_BP_ASSIGN	(Obsolete) TCOR: Assignment of Profile & BP Group to BP	3	PARTNR	Business Partner Number	nvarchar	10	0
92	TCORT_CO	Correspondence Administrative Data	17	PARTNR	Business Partner Number	nvarchar	10	0
93	TCORT_EXT_ASSIGN	Assignments of Profiles & BP groups to external recipients	2	PARTNR	Business Partner Number	nvarchar	10	0
94	TCORT_INB_ASSIGN	BP group assignment for Inbound Correspondence	2	PARTNR	Business Partner Number	nvarchar	10	0
95	TCORT_INB_FUNC	Inbound CO function assignment	3	PARTNR	Business Partner Number	nvarchar	10	0
96	VTBMAPA	Master Agreement: Permitted Bus. Partners	3	PARTNR	Business Partner Number	nvarchar	10	0
TOPTreasury
97	SPBB1	Partner-Bank relationship	2	PARTNR	Partner number	nvarchar	10	0
98	SPKR1	Partner-Vendor relationship	2	PARTNR	Partner number	nvarchar	10	0
99	VZGPO	Partner/role object relationship	4	PARTNR	Business Partner Number	nvarchar	10	0
100	VZPARZA	Partner addit. data (general part)	2	PARTNR	Partner number	nvarchar	10	0
101	VZROLLE	Partner / role list	2	PARTNR	Partner number	nvarchar	10	0
102	VZZPARO	Partner / Role / Object relationship	7	PARTNR	Partner 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

102 columns | ERP 6.0 | PARTNR