	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

140 columns | ERP 6.0 | BANKN

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/KPRCPT	Detail of receipt	22	BANKN	Bank account number	nvarchar	18	0
2	/ATL/KPRCPTKP	Detail of temporary receipt	22	BANKN	Bank account number	nvarchar	18	0
3	/GSINS/INH_EXTDE	External Transfers (in HCM infotype 0011)	50	BANKN	Bank account number	nvarchar	18	0
4	/OPT/WT_3S_PYMNT	Supplier Self Service Payment Information	20	BANKN	Bank account number	nvarchar	18	0
5	BOE_DIS_ITEM	Discount item data table	28	BANKN	Bank account number	nvarchar	35	0
6	BSEC	One-Time Account Data Document Segment	17	BANKN	Bank account number	nvarchar	18	0
7	FIAPPTD_KUKEY	ID administration	4	BANKN	Bank account number	nvarchar	35	0
8	FIAPSAD_ORDR_HD	Order Number Header KSA	48	BANKN	Bank account number	nvarchar	18	0
9	FUDT_VDOCBSEC	One-Time Account Data Segment of Verification Document	17	BANKN	Bank account number	nvarchar	18	0
10	FUDT_VDOCBSECH	One-Time Account Data Segment of Verification Doc(History)	17	BANKN	Bank account number	nvarchar	18	0
11	P05EIR_ADM_UNIT	Electronic Illness Reporting: Administrative Unit Data	5	BANKN	Bank account number	nvarchar	18	0
12	P05EIR_PERSOON	Electronic Illness Reporting: Natural Person Data	10	BANKN	Bank account number	nvarchar	18	0
13	P2RB_I0125	Garnishment payroll Belgium	28	BANKN	Bank account number	nvarchar	18	0
14	P2RF_SAR	Payroll Results: Garnishment	18	BANKN	Bank account number	nvarchar	18	0
15	P2RG_COURT	Types of Court Order (GB)	28	BANKN	Bank account number	nvarchar	18	0
16	P2RX_BT	Payroll Results: Bank Transfers	14	BANKN	Bank account number	nvarchar	18	0
17	P2RX_BT_PERSON	Payment-Related Information (Person)	16	BANKN	Bank account number	nvarchar	18	0
18	P2VE_SEN	HRMS-VE: Information on Length of Service	17	BANKN	Bank account number	nvarchar	18	0
19	T77PAYKZBT	Bank Transfer Table Image (BTKZ)	31	BANKN	Bank account number	nvarchar	18	0
20	T7QA84	Qatar Statutory Social Insurance Fund Type	15	BANKN	Bank account number	nvarchar	18	0
21	WBRD	Agency Business: Bank Data Suspense Account	8	BANKN	Bank account number	nvarchar	18	0
TOPAdvertising Management
22	JHAISZ	IS-M/AM: Assignment Table of Advertisers for OPM Order	49	BANKN	Bank account number	nvarchar	18	0
23	JHTFK	IS-M/AM: Settlement Documents (Billing, Commission) - Header	12	BANKN	Bank account number	nvarchar	18	0
24	JHTFX	IS-M/AM: Billing Index - Order Billing	23	BANKN	Bank account number	nvarchar	18	0
25	JHWWWTEMP_ORDER	IS-M/AM: Temporary Table for Order Data from the Internet	56	BANKN	Bank account number	nvarchar	18	0
26	JJTBS	IS-M/AM: Barred List for Bank Details	7	BANKN	Bank account number	nvarchar	18	0
TOPAustria
27	PA0136	HR Master Record: Infotype 0136 (Garn. Transfer A)	46	BANKN	Bank account number	nvarchar	18	0
TOPBank
28	TIBAN	IBAN	4	BANKN	Bank account number	nvarchar	35	0
TOPBasic Functions
29	FEBPI	Polling Statement Line Item Information	5	BANKN	Bank account number	nvarchar	18	0
TOPBelgium
30	PA0125	HR Master Record: Infotype 0125 (Garnishment B)	34	BANKN	Bank account number	nvarchar	18	0
31	T5B1S	Companies	9	BANKN	Bank account number	nvarchar	18	0
32	T5B9A	Institutions (B)	13	BANKN	Bank account number	nvarchar	18	0
TOPBrazil
33	PA0736	Alimony order for Brazil	49	BANKN	Bank account number	nvarchar	18	0
TOPChile
34	PA3235	HR Master Record: Infotype 3235	34	BANKN	Bank account number	nvarchar	18	0
TOPCollectionsDisbursements
35	ITAGCYPM_BANK	Payment Methods: Bank	6	BANKN	Bank account number	nvarchar	18	0
36	ITAGCYPM_CHECK	Payment Methods: Check	9	BANKN	Bank account number	nvarchar	18	0
TOPCompany Pension Scheme Germany
37	P01CBT	Transfer Records for Reimbursement of Contributions CPS	22	BANKN	Bank account number	nvarchar	18	0
TOPConstruction Industry
38	PDBKAN	Construction Industry Social Fund Proced: ANMEL Data Records	34	BANKN	Bank Account Number	nvarchar	10	0
TOPContract Accounts Receivable and Payable
39	DFK006B	Note to Payee - Texts	2	BANKN	Bank account number	nvarchar	18	0
40	DFK006E	Note to Payee - Accounts	4	BANKN	Bank account number	nvarchar	18	0
41	DFKKEXC_PAYINFO	Information for Payment Medium	32	BANKN	Bank account number	nvarchar	18	0
42	DFKKRH	Returns History	26	BANKN	Account Number of Business Partner	nvarchar	18	0
43	DFKKRK	Returns lot: Header data	41	BANKN	Bank account number	nvarchar	18	0
44	DFKKRP	Returns lot: Data for payment	45	BANKN	Account Number of Business Partner	nvarchar	18	0
45	DFKKURE	Update Run: Defective Data Records	26	BANKN	Bank account number	nvarchar	18	0
46	DFKKZA	Repayment Request	13	BANKN	Bank account number	nvarchar	18	0
47	DFKKZP	Payment lot: Data for payment	46	BANKN	Bank account number	nvarchar	18	0
48	FKKBRINSEQ	Brazil : Storing Sequence Number of Incoming Files	4	BANKN	Bank account number	nvarchar	18	0
49	FKK_GPSHAD	Data Extract: Business Partner Data (Faster Access)	31	BANKN	Bank account number	nvarchar	18	0
50	TFK006X	Exception Accounts for Clarification Proposal	4	BANKN	Bank account number	nvarchar	18	0
51	TFK006XS	Exception Accounts for Clarification Proposal	4	BANKN	Bank account number	nvarchar	18	0
52	TFK006XT	Exception Accounts for Clarification Proposal	5	BANKN	Bank account number	nvarchar	18	0
TOPCross-Application Objects in HR
53	HRP5584	DB Table for Infotype 5584	18	BANKN	Bank account number	nvarchar	18	0
TOPFinancial Accounting
54	/CCEE/YUFI_CCTAB	DRQ Serbia: Bank account number	3	BANKN	Bank account number	nvarchar	18	0
55	/OPT/VIM_1HEAD	Document Header	154	BANKN	Bank account number	nvarchar	18	0
56	KNBK	Customer Master (Bank Details)	5	BANKN	Bank account number	nvarchar	18	0
57	LFBK	Vendor Master (Bank Details)	5	BANKN	Bank account number	nvarchar	18	0
58	T012O	ORBIAN Details: Bank Accounts and Other Data	8	BANKN	Bank account number	nvarchar	18	0
59	TIBAN_APAR	Unconfirmed IBANs and Their Correct Validity Start	6	BANKN	Bank account number	nvarchar	35	0
60	VBSEC	Document Parking One-Time Data Document Segment	17	BANKN	Bank account number	nvarchar	18	0
TOPFrance
61	PA0272	Infotype 0272 (Garnishment)	37	BANKN	Bank account number	nvarchar	18	0
TOPFunds Management
62	FMLGD_H_VG_05_02	Posting Type 05:Vendor Down Payment with General Request(02)	6	BANKN	Bank account number	nvarchar	18	0
63	TBKBC	Bank Chain from Corresponding Banks	6	BANKN	Bank account number	nvarchar	18	0
TOPFunds Management-Specific Postings
64	KNEA	Assign Bank Details and Payment Methods to Revenue Type	7	BANKN	Bank account number	nvarchar	18	0
65	PSO31	Allocation of customer/objects	6	BANKN	Bank account number	nvarchar	18	0
66	PSO32	Allocation of customer/revenue types/objects	7	BANKN	Bank account number	nvarchar	18	0
67	PSOSEC	Recurring Request Document Segment, One-Time Data	19	BANKN	Bank account number	nvarchar	18	0
TOPGermany
68	P01Y15	PAISY: Management Table Subrecord Type 15	23	BANKN	Bank account number	nvarchar	18	0
69	PA0010	HR Master Record: Infotype 0010 (Capital Formation)	40	BANKN	Bank account number	nvarchar	18	0
70	PA0116	HR Master Record: Infotype 0116 (Garn. Transfer D)	45	BANKN	Bank account number	nvarchar	18	0
71	PA0699	Personnel Master Record Infotype 0699	35	BANKN	Bank account number	nvarchar	18	0
TOPGL Account Posting
72	TCJ_CPD	FBCJ: One-Time Account Data of Cash Journal Document Items	18	BANKN	Bank account number	nvarchar	18	0
TOPGreat Britain
73	PA0070	HR Master Record: Infotype 0070 (Court Orders - GB)	43	BANKN	Bank account number	nvarchar	18	0
TOPHong Kong
74	T7HK2H	Provider Attributes	18	BANKN	Bank account number	nvarchar	18	0
TOPInformation System
75	DKKOS	Balance Audit Trail	25	BANKN	Bank account number	nvarchar	18	0
76	DKOKS	Open Item Account Balance Audit Trail Master Record	28	BANKN	Bank account number	nvarchar	18	0
TOPIntercompany Data Exchange
77	TINV_INV_BANK	Bank Data for Bill or Payment Advice Note	5	BANKN	Bank account number	nvarchar	18	0
TOPInvoice Verification
78	RBKP	Document Header: Invoice Receipt	92	BANKN	Bank account number	nvarchar	18	0
TOPLoans Management
79	VDAUSZ	Drawings on Disbursement	29	BANKN	Bank account number	nvarchar	18	0
80	VDZNB_USAGE	Payment Postprocessing: Usage of a Payment Postpr. Activity	43	BANKN	Bank account number	nvarchar	18	0
81	VZFZE_VDAUSZ	Central Entry Table for Release Procedure	31	BANKN	Bank account number	nvarchar	18	0
82	VZFZE_VDNBZE	Central Entry Table for Release Procedure	63	BANKN	Bank account number	nvarchar	18	0
TOPLocalization
83	J_1BNFCPD	Nota Fiscal one-time accounts	15	BANKN	Bank account number	nvarchar	18	0
TOPMaster Data
84	JGTBKEZ	IS-M: Additional Data on Collection Authorization for Banks	5	BANKN	Bank account number	nvarchar	18	0
85	JGTBKVW	IS-M: Note to Payee for Banks	11	BANKN	Bank account number	nvarchar	18	0
86	T012K	House Bank Accounts	5	BANKN	Bank account number	nvarchar	18	0
87	VDDISBTEMP	Disbursements That Were Not Released	18	BANKN	Bank account number	nvarchar	18	0
TOPMexico
88	PA0426	Garnishment	47	BANKN	Bank account number	nvarchar	18	0
TOPMove-InOut
89	ECAMIOPRBANK	IS-U: Pre-entry Document: Bank Details	7	BANKN	Bank account number	nvarchar	18	0
TOPNorway
90	T5V2G	Connection org. numbers and rep. org. number	19	BANKN	Bank account number	nvarchar	18	0
TOPPayment Transactions
91	BANKA_CUP_IT	Bank Account Number maintenance for CUP/CIG Number	7	BANKN	Bank account number	nvarchar	18	0
92	FIBL_RPCODE	Master Data for Repetitive Code	9	BANKN	Bank account number	nvarchar	18	0
93	T042R	Name of account holder (ref.specifications on bk.details)	4	BANKN	Bank account number	nvarchar	18	0
TOPPayroll
94	T5T1L	Bank accounts of authorities (tax,insurance)	10	BANKN	Bank account number	nvarchar	18	0
95	T5TA1	External transfers	32	BANKN	Bank account number	nvarchar	18	0
96	T5TPS1L	Bank accounts of authorities (tax,insurance)	12	BANKN	Bank account number	nvarchar	18	0
97	T5TSPO	Table for convert bank accounts (Ceska Sporitelna)	4	BANKN	Bank account number	nvarchar	18	0
98	T7BGA1	Bank transfer - interface table	25	BANKN	Bank account number	nvarchar	18	0
99	T7ROA1	Bank transfer - interface table	13	BANKN	Bank account number	nvarchar	18	0
100	T7SI1L	Bank accounts of authorities (tax,insurance)	8	BANKN	Bank account number	nvarchar	18	0
101	T7SIA1	Annual tax - Master data	15	BANKN	Bank account number	nvarchar	18	0
102	T7SIA6	Bank transfer - interface table	13	BANKN	Bank account number	nvarchar	18	0
103	T7SIBT	Virman configuration (WT->Accounts)	12	BANKN	Bank account number	nvarchar	18	0
104	T7SK1L	Bank accounts of authorities (tax,insurance)	13	BANKN	Bank account number	nvarchar	18	0
105	T7SKA1	External transfers	32	BANKN	Bank account number	nvarchar	18	0
106	T7SKEC0009	Logovacia tabulka pre EURO konverziu - IT 0009	39	BANKN	Císlo bankového úctu	nvarchar	18	0
107	T7SKEC0011	Logovacia tabulka pre EURO konverziu - IT 0011	44	BANKN	Císlo bankového úctu	nvarchar	18	0
108	T7SKVDP	Aux table for HSKLVDP0	47	BANKN	Bank account number/IBAN	nvarchar	34	0
109	T7TRG01	General information about company.	14	BANKN	Bank account number	nvarchar	18	0
TOPPension fund Netherlands
110	T5NH5	Werkgeversdata van de aan het pensioenfonds verbonden deeln.	15	BANKN	Bankrekeningnummer	nvarchar	30	0
TOPPeriodical Sales and Distribution
111	JFDFS	IS-M/SD: Billing/Settlement Index	24	BANKN	Bank account number	nvarchar	18	0
112	JFXBPOSDL	IS-M: Backup Transfer Internal Table XBPOS	32	BANKN	Bank account number	nvarchar	18	0
113	JKPA	Sales Order: Partner	20	BANKN	Bank account number	nvarchar	18	0
114	JKWWWTEMP_ORDER	IS-M/SD: WWW Temporary Table for Order Data from Internet	82	BANKN	Bank account number	nvarchar	18	0
115	JKWWWTEMP_PAY	IS-M: Temporary Internet Table: Payment Data Change	8	BANKN	Bank account number	nvarchar	18	0
116	JNTRECH	IS-M/SD: Research	38	BANKN	Bank account number	nvarchar	18	0
TOPPersonnel Administration
117	HRP1656	DB Table for Infotype 1656	43	BANKN	Bank Name	nvarchar	132	0
118	PA0009	HR Master Record: Infotype 0009 (Bank Details)	36	BANKN	Bank account number	nvarchar	18	0
119	PA0011	HR Master Record: Infotype 0011 (Ext.Bank Transfers)	41	BANKN	Bank account number	nvarchar	18	0
120	PA0226	Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)	44	BANKN	Bankkontonummer	nvarchar	18	0
121	T7PL01	Tax offices	13	BANKN	Bank account number	nvarchar	18	0
TOPPersonnel Management
122	/BKC/S21_ANON	Sol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON	9	BANKN	Bankkontonummer	nvarchar	18	0
123	T7HRA1	Bank transfer - interface table	13	BANKN	Bank account number	nvarchar	18	0
124	T7HRBP	Control codes for banks Croatia	4	BANKN	Bank account number	nvarchar	18	0
125	T7HRBPX	Conversion IT 9 to T521B proposal	4	BANKN	Bank account number	nvarchar	18	0
126	T7HRDO	Statutory deductions Croatia	15	BANKN	Bank account number	nvarchar	18	0
127	T7HRDS	Control codes for stat. deductions and company codes Croatia	12	BANKN	Bank account number	nvarchar	18	0
128	T7HRMU	Municipality codes (Croatia)	13	BANKN	Bank account number	nvarchar	18	0
129	T7HRMW	Control numbers - municipalities and company codes (Croatia)	11	BANKN	Bank account number	nvarchar	18	0
130	T7HRPG	Control codes for payees Croatia	12	BANKN	Bank account number	nvarchar	18	0
TOPPublic Sector Contract Accounts Receivable and Payable
131	DFMCA_BRF800	BRF: Create/Update Bank Details ID	10	BANKN	BRF: Expression	nvarchar	20	0
TOPReal Estate Management
132	VIAKBSEG	Document Line Item from SCS for Interface	87	BANKN	Bank account number	nvarchar	18	0
TOPRecruitment
133	PB0009	HR Master Record: Infotype 0009 (Bank Details)	36	BANKN	Bank account number	nvarchar	18	0
TOPRemaining Beverage - Obsolete Objects
134	/BEV3/CHBLEIST	Agreement Performance	13	BANKN	Bank account number	nvarchar	18	0
TOPRussia
135	PA0296	HR Master Record Infotype 0296 (Garnishment Document)	59	BANKN	Bank account number	nvarchar	18	0
TOPSpain
136	PA0887	HR master record, infotype 0887	42	BANKN	Bank account number	nvarchar	18	0
TOPThird Party ManagementCOA
137	VIMMHBACC	House Bank Account	6	BANKN	Bank account number	nvarchar	18	0
TOPTreasury
138	SPBB1	Partner-Bank relationship	5	BANKN	Bank account number	nvarchar	18	0
TOPUse AP-MD-BP Components
139	BUT0BK	BP: Bank Details	6	BANKN	Bank Account Number	nvarchar	18	0
TOPVenezuela
140	PA0401	HRMS-VE: Table for Benefits Infotype (IT401)	33	BANKN	Bank account number	nvarchar	18	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

140 columns | ERP 6.0 | BANKN