SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

214 columns | Print definition?ERP 6.0  | BANKL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/DQQ9Clearing Rules4BANKLBank Keysnvarchar150
2/ATL/KPRCPTDetail of receipt23BANKLBank Keysnvarchar150
3/ATL/KPRCPTKPDetail of temporary receipt23BANKLBank Keysnvarchar150
4/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)49BANKLBank Keysnvarchar150
5/OPT/WT_3S_PYMNTSupplier Self Service Payment Information18BANKLBank numbernvarchar150
6/SAPF15/TAZVF15 Kontonummern der Korrespondenzbanken3BANKLBankschlüsselnvarchar150
7BSECOne-Time Account Data Document Segment18BANKLBank Keysnvarchar150
8COPC_ACCOUNTCash Account16BANKLBank Keysnvarchar150
9FIAPPTD_KUKEYID administration3BANKLBank numbernvarchar150
10FIAPSAD_ORDR_HDOrder Number Header KSA31BANKLBank Keysnvarchar150
11FIPDCKW_CHECKREPCheck repository (Kuwait)6BANKLBank numbernvarchar150
12FIPDCOMC_PRDEVMaintain printers for users to Oman PDC3BANKLBank Keysnvarchar150
13FIPDCOMC_PRPARParameters for Oman PDC printing5BANKLBank Keysnvarchar150
14FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document18BANKLBank Keysnvarchar150
15FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)18BANKLBank Keysnvarchar150
16J1IEX_BANKACCEXIM: Bank charges accounts4BANKLBank Keysnvarchar150
17J_1ILOCBANKAEXIM : Documentary Payment Guarantee: LoC - Bank Data15BANKLBank Keysnvarchar150
18P2RB_I0125Garnishment payroll Belgium27BANKLBank numbernvarchar150
19P2RF_SARPayroll Results: Garnishment17BANKLBank numbernvarchar150
20P2RG_COURTTypes of Court Order (GB)27BANKLBank numbernvarchar150
21P2RM_MGARGarnishments DK16BANKLBank Keysnvarchar150
22P2RM_MPACPrior Pension Accumulations after PBS Splits12BANKLBank numbernvarchar150
23P2RM_MPENSPrivate Pension (DK)25BANKLBank numbernvarchar150
24P2RX_BTPayroll Results: Bank Transfers13BANKLBank numbernvarchar150
25P2RX_BT_PERSONPayment-Related Information (Person)15BANKLBank numbernvarchar150
26P2VE_SENHRMS-VE: Information on Length of Service16BANKLBank Keysnvarchar150
27PA0906HR Master Record: Infotype 090640BANKLBank Keysnvarchar150
28T018PPost office bank branches4BANKLBank numbernvarchar150
29T028BTransaction Type of Sender Bank2BANKLBank key (usually bank number)nvarchar150
30T042LBank transaction code names4BANKLBank numbernvarchar150
31T042MUser Numbers At The Bank4BANKLBank numbernvarchar150
32T042NBank transaction codes4BANKLBank numbernvarchar150
33T049EControl Data for Swiss ISR Procedure14BANKLBank No.for Billing Document and Dunning Printout with ISRnvarchar150
34T049FCashed Checks Control Table2BANKLBank Number of Our Banknvarchar80
35T536C_BANKBank Details for Public Sector Employer8BANKLBank Keysnvarchar150
36T77PAYKZBTBank Transfer Table Image (BTKZ)30BANKLBank numbernvarchar150
37T7QA84Qatar Statutory Social Insurance Fund Type14BANKLBank Keysnvarchar150
38TBKK01AAdditional Bank Keys for Bank Area3BANKLBank Keysnvarchar150
39TBKK01BAssign Business Partner To Bank Key3BANKLBank Keysnvarchar150
40WBRDAgency Business: Bank Data Suspense Account9BANKLBank Keysnvarchar150
TOPAdvertising Management
41JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order48BANKLBank Keysnvarchar150
42JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header13BANKLBank numbernvarchar150
43JHTFXIS-M/AM: Billing Index - Order Billing22BANKLBank Keysnvarchar150
44JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet55BANKLBank Keysnvarchar150
45JJTBSIS-M/AM: Barred List for Bank Details6BANKLBank Keysnvarchar150
TOPArgentina
46T7AR02BBank description for Social insurance payments3BANKLBank Keysnvarchar150
47T7AR02DHistorical Additional data by company9BANKLBank Keysnvarchar150
TOPAustria
48PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)45BANKLBank keynvarchar150
TOPBank
49BNKABank master record3BANKLBank Keysnvarchar150
50BNKAINBank Master (Additional Fields for BNKA)3BANKLBank Keysnvarchar150
51TIBANIBAN3BANKLBank Keysnvarchar150
TOPBank Accounting
52DFPAYGPayment date: Grouping9BANKLBank Keysnvarchar150
53DFPAYVPayment Medium: Selection Variants5BANKLBank Keysnvarchar150
TOPBank Customer Accounts
54BCA_US_BKK_TDBCA: Time deposit account data17BANKLBank Keysnvarchar150
55BKKCORRITEMAuxiliary Table: Payment Items for Adjustments7BANKLBank Keysnvarchar150
56TBKK01Bank Area Table4BANKLBank Keysnvarchar150
57TBKKIHB6Dispatcher per Account Number2BANKLBank numbernvarchar150
TOPBasic Functions
58AKKBDocumentary Payment Guarantee: Financial Doc. - Bank Data4BANKLBank Keysnvarchar150
59FEBPIPolling Statement Line Item Information4BANKLBank numbernvarchar150
60FEBVWElectronic Banking Management Records6BANKLBank key (usually bank number)nvarchar150
61T028LEB: Sender Bank - CM Data2BANKLBank key (usually bank number)nvarchar150
62T028QMapping Table4BANKLBank key (usually bank number)nvarchar150
63T028XReturns Reasons3BANKLBank key (usually bank number)nvarchar150
TOPBelgium
64PA0125HR Master Record: Infotype 0125 (Garnishment B)33BANKLBank numbernvarchar150
TOPBrazil
65PA0736Alimony order for Brazil48BANKLBank Keysnvarchar150
TOPBusiness Partner
66BP001FS-Specific Attributes; Organization20BANKLBank Keysnvarchar150
67BUT0BANKBusiness Partner: Bank Data3BANKLBank Keysnvarchar150
TOPBusiness Partner Enhancements for Financial Services
68BP000Business Partner Master (General Data)84BANKLBank Keysnvarchar150
TOPChile
69PA3235HR Master Record: Infotype 323532BANKLBank Keysnvarchar150
TOPCollectionsDisbursements
70ITAGCYPM_BANKPayment Methods: Bank5BANKLBank Keysnvarchar150
71ITAGCYPM_CHECKPayment Methods: Check7BANKLBank Keysnvarchar150
TOPCompany Pension Scheme Germany
72P01CBTTransfer Records for Reimbursement of Contributions CPS21BANKLBank Keysnvarchar150
TOPCondition
73BKK97Acct Balancing: Posting Data (Temporary Data)(for Deletion)11BANKLBank Keysnvarchar150
TOPConstruction Industry
74PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records33BANKLBank Numbernvarchar80
TOPContract Accounts Receivable and Payable
75DFK006ENote to Payee - Accounts3BANKLBank numbernvarchar150
76DFKKBRLEVYCODEBrazil: Levy Code for Barcode Payment Method3BANKLBank Keysnvarchar150
77DFKKBRLEVYTXTBrazil : Barcode Levy Code Description for Different Banks.4BANKLBank Keysnvarchar150
78DFKKEXC_PAYINFOInformation for Payment Medium29BANKLBank numbernvarchar150
79DFKKRHReturns History24BANKLBanking Country of Business Partnernvarchar30
80DFKKRKReturns lot: Header data39BANKLBank country keynvarchar30
81DFKKRPReturns lot: Data for payment43BANKLBanking Country of Business Partnernvarchar30
82DFKKUREUpdate Run: Defective Data Records25BANKLBank Keysnvarchar150
83DFKKZARepayment Request12BANKLBank Number of Other Bank Keynvarchar150
84DFKKZPPayment lot: Data for payment45BANKLBank Number of Other Bank Keynvarchar150
85FKKBRINSEQBrazil : Storing Sequence Number of Incoming Files3BANKLBank Keysnvarchar150
86FKK_GPSHADData Extract: Business Partner Data (Faster Access)30BANKLBank Keysnvarchar150
87TFK006XException Accounts for Clarification Proposal3BANKLBank numbernvarchar150
88TFK006XSException Accounts for Clarification Proposal3BANKLBank numbernvarchar150
89TFK006XTException Accounts for Clarification Proposal4BANKLBank numbernvarchar150
TOPCross-Application Objects in HR
90HRP5584DB Table for Infotype 558420BANKLBank Keysnvarchar150
TOPDenmark
91PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)70BANKLBank Keysnvarchar150
92PA0200HR Master Record, Infotype 0200 (Garnishments DK)49BANKLBank Keysnvarchar150
TOPFinancial Accounting
93/CCEE/FISIFP_HALPodatki za HALCOM7BANKLBank numbernvarchar150
94/CCEE/YUFI_CCTABDRQ Serbia: Bank account number2BANKLBank Keysnvarchar150
95/OPT/VIM_1HEADDocument Header152BANKLBank numbernvarchar150
96J_3K_INTPayment order numeric range2BANKLBank numbernvarchar150
97KNBKCustomer Master (Bank Details)4BANKLBank Keysnvarchar150
98LFBKVendor Master (Bank Details)4BANKLBank Keysnvarchar150
99T012OORBIAN Details: Bank Accounts and Other Data7BANKLBank Keysnvarchar150
100TIBAN_APARUnconfirmed IBANs and Their Correct Validity Start5BANKLBank Keysnvarchar150
101VBSECDocument Parking One-Time Data Document Segment18BANKLBank Keysnvarchar150
TOPFrance
102PA0272Infotype 0272 (Garnishment)36BANKLBank numbernvarchar150
TOPFunds Management
103FMLGD_H_VG_05_02Posting Type 05:Vendor Down Payment with General Request(02)5BANKLBank Keysnvarchar150
TOPFunds Management-Specific Postings
104KNEAAssign Bank Details and Payment Methods to Revenue Type6BANKLBank Keysnvarchar150
105PSO31Allocation of customer/objects5BANKLBank Keysnvarchar150
106PSO32Allocation of customer/revenue types/objects6BANKLBank Keysnvarchar150
107PSOSECRecurring Request Document Segment, One-Time Data20BANKLBank Keysnvarchar150
TOPGermany
108P01Y15PAISY: Management Table Subrecord Type 1522BANKLBank Keysnvarchar150
109PA0010HR Master Record: Infotype 0010 (Capital Formation)39BANKLBank numbernvarchar150
110PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)44BANKLBank keynvarchar150
111PA0699Personnel Master Record Infotype 069934BANKLBank Keysnvarchar150
TOPGL Account Posting
112TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items19BANKLBank numbernvarchar150
TOPGreat Britain
113PA0070HR Master Record: Infotype 0070 (Court Orders - GB)42BANKLBank numbernvarchar150
TOPHong Kong
114T7HK2HProvider Attributes17BANKLBank Keysnvarchar150
TOPInformation System
115DKKOSBalance Audit Trail26BANKLBank Keysnvarchar150
116DKOKSOpen Item Account Balance Audit Trail Master Record29BANKLBank Keysnvarchar150
TOPIntercompany Data Exchange
117TINV_INV_BANKBank Data for Bill or Payment Advice Note4BANKLBank Keysnvarchar150
TOPInvoice Verification
118RBKPDocument Header: Invoice Receipt93BANKLBank numbernvarchar150
TOPJapan
119PA0144HR Master Record: Infotype 0144 (Property Accum. JP)25BANKLBank Keysnvarchar150
120PA0268HR Master Record Infortype view 0045 and 0268 (Loan JPN)32BANKLBank Keysnvarchar150
121T5J98HR Conversion IT0144 to IT0169 JP3BANKLBank Keysnvarchar150
122T5JBKHR Bank key for Property accumulation savings JP2BANKLBank Keysnvarchar150
TOPLoans Management
123VDAUSZDrawings on Disbursement30BANKLBank numbernvarchar150
124VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)15BANKLBank Keysnvarchar150
125VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity44BANKLBank Keysnvarchar150
126VZFZE_VDAUSZCentral Entry Table for Release Procedure32BANKLBank numbernvarchar150
127VZFZE_VDNBZECentral Entry Table for Release Procedure64BANKLBank numbernvarchar150
TOPLocalization
128IDSL_GUCAccounts for Deferred Tax (Slovakia)6BANKLBank numbernvarchar150
129ISJPINVSUMHDInvoice Summary Header33BANKLBank Keysnvarchar150
130ISJPVIRTACCTVirtual accounts3BANKLBank Keysnvarchar150
131J_1BNFCPDNota Fiscal one-time accounts16BANKLBank Keysnvarchar150
132J_1IEWTCHLNTable for Internal and external Challan nos-EWT India.9BANKLShort Key for a House Banknvarchar50
TOPMaster Data
133BKK610Account Hierarchy: Assignment of Root Account to Tree Number8BANKLBank Keysnvarchar150
134BKK625Assign. of Int. No. to Ext. Root Acct. for Change Document4BANKLBank Keysnvarchar150
135JGTBKEZIS-M: Additional Data on Collection Authorization for Banks4BANKLBank numbernvarchar150
136JGTBKVWIS-M: Note to Payee for Banks10BANKLBank numbernvarchar150
137T012House Banks5BANKLBank Keysnvarchar150
138TDLOANREPLACEGeneral Data for Discharging Loan5BANKLBank numbernvarchar150
139VDDISBTEMPDisbursements That Were Not Released17BANKLBank numbernvarchar150
TOPMexico
140PA0426Garnishment46BANKLBank Keysnvarchar150
TOPMove-InOut
141ECAMIOPRBANKIS-U: Pre-entry Document: Bank Details6BANKLBank Keysnvarchar150
TOPPayment Item
142BKKITPayment Item7BANKLBank Keysnvarchar150
143BKKITENQBlocked Payment Items7BANKLBank Keysnvarchar150
144BKKITRELPayment Item7BANKLBank Keysnvarchar150
145BKKITTMPPlanned Payment Items8BANKLBank Keysnvarchar150
146BKKITTMP_DELPlanned Payment Items - Completed8BANKLBank Keysnvarchar150
147BKKPAYMEX_ITEFT Management: Items in Outgoing Payment Transactions8BANKLBank Keysnvarchar150
148BKKPAYMIN_ITTable of Imported Items7BANKLBank Keysnvarchar150
149TBKK_CLEAR_RELAssignment: Bank Key to Clearing Center ID3BANKLBank numbernvarchar150
TOPPayment Order
150BKKPOITItem in Payment Order8BANKLBank Keysnvarchar150
151BKKPOIT_TMPItems in Planned Payment Order9BANKLBank Keysnvarchar150
152BKKPOIT_TMP_DELItems in Planned Payment Order9BANKLBank Keysnvarchar150
TOPPayment Transactions
153BANKA_CUP_ITBank Account Number maintenance for CUP/CIG Number6BANKLBank Keysnvarchar150
154FIBL_RPCODEMaster Data for Repetitive Code8BANKLBank Keysnvarchar150
155T042RName of account holder (ref.specifications on bk.details)3BANKLBank Keysnvarchar150
TOPPayroll
156PA0643Személyügyi törzsrekord 0643 infótípus29BANKLBankkulcsnvarchar150
157T5H4ZData of SI paying offices9BANKLBank Keysnvarchar150
158T5T1LBank accounts of authorities (tax,insurance)9BANKLBank numbernvarchar150
159T5TA1External transfers31BANKLBank numbernvarchar150
160T5TPS1LBank accounts of authorities (tax,insurance)11BANKLBank numbernvarchar150
161T5TSPOTable for convert bank accounts (Ceska Sporitelna)3BANKLBank Keysnvarchar150
162T7BGA1Bank transfer - interface table24BANKLBank numbernvarchar150
163T7ROA1Bank transfer - interface table12BANKLBank numbernvarchar150
164T7SI1LBank accounts of authorities (tax,insurance)7BANKLBank numbernvarchar150
165T7SIA1Annual tax - Master data14BANKLBank Keysnvarchar150
166T7SIA6Bank transfer - interface table12BANKLBank numbernvarchar150
167T7SIBTVirman configuration (WT->Accounts)11BANKLBank numbernvarchar150
168T7SIBUBank Units Slovenia3BANKLKljuc bankenvarchar150
169T7SK1LBank accounts of authorities (tax,insurance)12BANKLBank numbernvarchar150
170T7SKA1External transfers31BANKLBank numbernvarchar150
171T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000938BANKLKód bankynvarchar150
172T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001143BANKLKód bankynvarchar150
173T7SKVDPAux table for HSKLVDP046BANKLBank numbernvarchar150
174T7TRG01General information about company.13BANKLBank numbernvarchar150
TOPPension Fund Switzerland
175PA3230Personnel Master Record for Infotype 323040BANKLBank Keysnvarchar150
TOPPeriodical Sales and Distribution
176JFDFSIS-M/SD: Billing/Settlement Index23BANKLBank Keysnvarchar150
177JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS31BANKLBank Keysnvarchar150
178JKPASales Order: Partner19BANKLBank Keysnvarchar150
179JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet81BANKLBank Keysnvarchar150
180JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change7BANKLBank Keysnvarchar150
181JNTRECHIS-M/SD: Research37BANKLBank Keysnvarchar150
TOPPersonnel Administration
182PA0009HR Master Record: Infotype 0009 (Bank Details)35BANKLBank Keysnvarchar150
183PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)40BANKLBank Keysnvarchar150
184PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)43BANKLBankschlüsselnvarchar150
185T521BPayee Keys9BANKLBank Keysnvarchar150
186T7CO17Bank code equivalences ACH3BANKLBank Keysnvarchar150
187T7PL01Tax offices12BANKLBank Keysnvarchar150
TOPPersonnel Management
188/BKC/S21_ANONSol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON8BANKLBankleitzahlnvarchar150
189T7HRA1Bank transfer - interface table12BANKLBank numbernvarchar150
190T7HRBPControl codes for banks Croatia3BANKLBank Keysnvarchar150
191T7HRBPXConversion IT 9 to T521B proposal3BANKLBank numbernvarchar150
192T7HRDOStatutory deductions Croatia14BANKLBank Keysnvarchar150
193T7HRDSControl codes for stat. deductions and company codes Croatia11BANKLBank Keysnvarchar150
194T7HRMUMunicipality codes (Croatia)12BANKLBank Keysnvarchar150
195T7HRMWControl numbers - municipalities and company codes (Croatia)10BANKLBank Keysnvarchar150
196T7HRPGControl codes for payees Croatia11BANKLBank Keysnvarchar150
TOPPublic Sector
197T5D8S_BANKBank Details for Payroll Numbers7BANKLBank Keysnvarchar150
TOPPublic Sector Contract Accounts Receivable and Payable
198DFMCA_BRF800BRF: Create/Update Bank Details ID9BANKLBRF: Expressionnvarchar200
TOPReal Estate Management
199VIAKBSEGDocument Line Item from SCS for Interface88BANKLBank numbernvarchar150
TOPReceivablesPayment Management
200TZB50Internal Bank Numbers for Returned Direct Debit Charges3BANKLBank Keysnvarchar150
TOPRecruitment
201PB0009HR Master Record: Infotype 0009 (Bank Details)35BANKLBank Keysnvarchar150
TOPRemaining Beverage - Obsolete Objects
202/BEV3/CHBLEISTAgreement Performance12BANKLBank numbernvarchar150
TOPRussia
203PA0296HR Master Record Infotype 0296 (Garnishment Document)58BANKLBank Keysnvarchar150
204T7RU1BPayee Keys of receiving orders (Russia standard)12BANKLBank Keysnvarchar150
TOPSingapore
205T5R1AInstitution of Soc. Provident Funds SG14BANKLBank numbernvarchar150
TOPSocial Insurance
206T5D31Professionals Pension Organization (PPO)15BANKLBank numbernvarchar150
TOPSouth Africa
207T5W5ABank check digit verification table for South Africa3BANKLBank numbernvarchar150
TOPSpain
208PA0887HR master record, infotype 088740BANKLBank Keysnvarchar150
TOPThird Party ManagementCOA
209VIMMHBACCHouse Bank Account8BANKLBank numbernvarchar150
TOPTreasury
210SPBB1Partner-Bank relationship4BANKLBank numbernvarchar150
TOPUse AP-MD-BP Components
211BUT0BKBP: Bank Details5BANKLBank Keynvarchar150
TOPVenezuela
212PA0401HRMS-VE: Table for Benefits Infotype (IT401)32BANKLBank Keysnvarchar150
213T7VE03SUDEBAN financial codes3BANKLBank Keysnvarchar150
214T7VE04Company financial operators4BANKLBank Keysnvarchar150