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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

214 columns | Print definition?ERP 6.0  | BANKS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/DQQ9Clearing Rules3BANKSBank country keynvarchar30
2/ATL/KPFI00003cashier system - checks concentration2BANKSBank country keynvarchar30
3/ATL/KPFI00003DLcashier system - checks concentration deleted2BANKSBank country keynvarchar30
4/ATL/KPFI00003KPCashier system - checks concentration - Temporary2BANKSBank country keynvarchar30
5/ATL/KPRCPTDetail of receipt24BANKSBank country keynvarchar30
6/ATL/KPRCPTKPDetail of temporary receipt24BANKSBank country keynvarchar30
7/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)48BANKSCountry Keynvarchar30
8/OPT/WT_3S_PYMNTSupplier Self Service Payment Information22BANKSBank country keynvarchar30
9/SAPF15/TAZVF15 Kontonummern der Korrespondenzbanken2BANKSLänderschlüssel der Banknvarchar30
10/SMD/MD_____00EXSID-Tabelle fuer Instruction key3BANKSBank country keynvarchar30
11BSECOne-Time Account Data Document Segment19BANKSBank country keynvarchar30
12COPC_ACCOUNTCash Account15BANKSBank country keynvarchar30
13FIAPSAD_ORDR_HDOrder Number Header KSA30BANKSBank country keynvarchar30
14FIEB_MAPP_X_CUSTDiffering mapping formats for bank statement formats3BANKSBank country keynvarchar30
15FIPDCKW_CHECKREPCheck repository (Kuwait)5BANKSBank country keynvarchar30
16FIPYXXD_INSTMTBank Statement File Identification Table3BANKSBank country keynvarchar30
17FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document19BANKSBank country keynvarchar30
18FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)19BANKSBank country keynvarchar30
19J1IEX_BANKACCEXIM: Bank charges accounts3BANKSBank country keynvarchar30
20J1IEX_LCDOCLetter of Credit Documet IDs2BANKSBank country keynvarchar30
21J1IEX_LCDOC_TLetter of Credit Documet IDs3BANKSBank country keynvarchar30
22J_1ILOCBANKAEXIM : Documentary Payment Guarantee: LoC - Bank Data12BANKSBank country keynvarchar30
23P2RB_I0125Garnishment payroll Belgium26BANKSCountry Keynvarchar30
24P2RF_SARPayroll Results: Garnishment16BANKSBank country keynvarchar30
25P2RG_COURTTypes of Court Order (GB)26BANKSBank country keynvarchar30
26P2RX_BTPayroll Results: Bank Transfers12BANKSCountry Keynvarchar30
27P2RX_BT_PERSONPayment-Related Information (Person)14BANKSCountry Keynvarchar30
28P2VE_SENHRMS-VE: Information on Length of Service15BANKSCountry Keynvarchar30
29PA0906HR Master Record: Infotype 090639BANKSCountry Keynvarchar30
30T015WInstruction keys2BANKSBank country keynvarchar30
31T536C_BANKBank Details for Public Sector Employer7BANKSBank country keynvarchar30
32T77PAYKZBTBank Transfer Table Image (BTKZ)29BANKSCountry Keynvarchar30
33TBKK01BAssign Business Partner To Bank Key2BANKSBank country keynvarchar30
34WBRDAgency Business: Bank Data Suspense Account10BANKSBank country keynvarchar30
TOPAdvertising Management
35JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order47BANKSBank country keynvarchar30
36JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header11BANKSBank country keynvarchar30
37JHTFXIS-M/AM: Billing Index - Order Billing21BANKSBank country keynvarchar30
38JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet54BANKSBank country keynvarchar30
39JJTBSIS-M/AM: Barred List for Bank Details5BANKSBank country keynvarchar30
TOPArgentina
40T7AR02BBank description for Social insurance payments2BANKSBank country keynvarchar30
41T7AR02DHistorical Additional data by company8BANKSBank country keynvarchar30
TOPAustria
42PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)44BANKSCountry key of banknvarchar30
TOPAutomatic Payments
43TBKFKFactory Calendar Identification Using Currency3BANKSBank country keynvarchar30
44TBKPVTime Between Payment Run and Value Date at House Bank3BANKSBank country keynvarchar30
TOPBank
45BNKABank master record2BANKSBank country keynvarchar30
46BNKAINBank Master (Additional Fields for BNKA)2BANKSBank country keynvarchar30
47T005BUTable for Transferring Bank Data1BANKSBank country keynvarchar30
48T005BUTTable for Transferring Bank Data2BANKSBank country keynvarchar30
49TIBANIBAN2BANKSBank country keynvarchar30
50TSWIFSWIFT Codes4BANKSBank country keynvarchar30
TOPBank Accounting
51DFPAYGPayment date: Grouping8BANKSBank country keynvarchar30
52DFPAYVPayment Medium: Selection Variants4BANKSBank country keynvarchar30
53REGUTTemSe - Administration Data3BANKSBank country keynvarchar30
54REGUTAPaying Company Codes for DME Files2BANKSBank country keynvarchar30
TOPBank Customer Accounts
55BCA_US_BKK_TDBCA: Time deposit account data16BANKSBank country keynvarchar30
56BKKCORRITEMAuxiliary Table: Payment Items for Adjustments6BANKSBank country keynvarchar30
57TBKK01Bank Area Table3BANKSBank country keynvarchar30
TOPBasic Functions
58AKKBDocumentary Payment Guarantee: Financial Doc. - Bank Data3BANKSBank country keynvarchar30
59FEBVWElectronic Banking Management Records5BANKSBank country keynvarchar30
60T028RTRANSRepetitive Transfer Transactions21BANKSBank country keynvarchar30
TOPBelgium
61PA0125HR Master Record: Infotype 0125 (Garnishment B)32BANKSCountry Keynvarchar30
TOPBrazil
62PA0736Alimony order for Brazil47BANKSBank country keynvarchar30
TOPBusiness Partner
63BP001FS-Specific Attributes; Organization21BANKSBank country keynvarchar30
64BUT0BANKBusiness Partner: Bank Data4BANKSBank country keynvarchar30
TOPBusiness Partner Enhancements for Financial Services
65BP000Business Partner Master (General Data)85BANKSBank country keynvarchar30
TOPChile
66PA3235HR Master Record: Infotype 323529BANKSBank country keynvarchar30
TOPCollectionsDisbursements
67ITAGCYPM_BANKPayment Methods: Bank4BANKSBank country keynvarchar30
68ITAGCYPM_CHECKPayment Methods: Check6BANKSBank country keynvarchar30
TOPCompany Pension Scheme Germany
69P01CBTTransfer Records for Reimbursement of Contributions CPS20BANKSCountry Keynvarchar30
TOPCondition
70BKK97Acct Balancing: Posting Data (Temporary Data)(for Deletion)10BANKSBank country keynvarchar30
TOPConstruction Industry
71PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records36BANKSBank Country Keynvarchar30
TOPContract Accounts Receivable and Payable
72DFK006ENote to Payee - Accounts2BANKSBank country keynvarchar30
73DFKKBRLEVYCODEBrazil: Levy Code for Barcode Payment Method2BANKSBank country keynvarchar30
74DFKKBRLEVYTXTBrazil : Barcode Levy Code Description for Different Banks.3BANKSBank country keynvarchar30
75DFKKEXC_PAYINFOInformation for Payment Medium30BANKSBank country keynvarchar30
76DFKKUREUpdate Run: Defective Data Records24BANKSBank country keynvarchar30
77DFKKZARepayment Request11BANKSBank country keynvarchar30
78DFKKZPPayment lot: Data for payment44BANKSBank country keynvarchar30
79FKKBRINSEQBrazil : Storing Sequence Number of Incoming Files2BANKSBank country keynvarchar30
80FKK_GPSHADData Extract: Business Partner Data (Faster Access)29BANKSBank country keynvarchar30
81TFK006XException Accounts for Clarification Proposal2BANKSBank country keynvarchar30
82TFK006XSException Accounts for Clarification Proposal2BANKSBank country keynvarchar30
83TFK006XTException Accounts for Clarification Proposal3BANKSBank country keynvarchar30
84TFK042LPayment Program: Allowed Destinat. Countries for Pmt Method4BANKSBank country keynvarchar30
85TFK053CChange Payment Data: Processing Variants12BANKSBank country keynvarchar30
TOPCross-Application Objects in HR
86HRP5584DB Table for Infotype 558419BANKSBank country keynvarchar30
TOPElectronic Bank Statement
87FEBKO_TRANSFERTransferred Bank Statements5BANKSBank country keynvarchar30
88FEB_IMP_TRANPATHTransfer Paths for Logical Bank Statement Files2BANKSBank country keynvarchar30
89FEB_IMP_TRANSTransfer of Logical Bank Statement Files2BANKSBank country keynvarchar30
TOPFinancial Accounting
90/CCEE/FISIFP_HALPodatki za HALCOM6BANKSBank country keynvarchar30
91/OPT/VIM_1HEADDocument Header156BANKSBank country keynvarchar30
92J_3KBANKBank accounts in ZAP2BANKSBank country keynvarchar30
93KNBKCustomer Master (Bank Details)3BANKSBank country keynvarchar30
94LFBKVendor Master (Bank Details)3BANKSBank country keynvarchar30
95T012OORBIAN Details: Bank Accounts and Other Data6BANKSBank country keynvarchar30
96T076EFI-EDI: Assignment Pymt Method - External Pymt Method (Bank)6BANKSBank country keynvarchar30
97TIBAN_APARUnconfirmed IBANs and Their Correct Validity Start4BANKSBank country keynvarchar30
98VBSECDocument Parking One-Time Data Document Segment19BANKSBank country keynvarchar30
TOPFrance
99PA0272Infotype 0272 (Garnishment)35BANKSBank country keynvarchar30
TOPFunds Management
100FMLGD_H_VG_05_02Posting Type 05:Vendor Down Payment with General Request(02)4BANKSBank country keynvarchar30
TOPFunds Management-Specific Postings
101KNEAAssign Bank Details and Payment Methods to Revenue Type5BANKSBank country keynvarchar30
102PSO31Allocation of customer/objects4BANKSBank country keynvarchar30
103PSO32Allocation of customer/revenue types/objects5BANKSBank country keynvarchar30
104PSOSECRecurring Request Document Segment, One-Time Data21BANKSBank country keynvarchar30
TOPGermany
105PA0010HR Master Record: Infotype 0010 (Capital Formation)38BANKSBank country keynvarchar30
106PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)43BANKSCountry key of banknvarchar30
107PA0699Personnel Master Record Infotype 069933BANKSBank country keynvarchar30
108T5D1HSupplementary Insurance13BANKSBank country keynvarchar30
109T5D1KBranch Offices16BANKSBank country keynvarchar30
TOPGL Account Posting
110TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items20BANKSBank country keynvarchar30
TOPGreat Britain
111PA0070HR Master Record: Infotype 0070 (Court Orders - GB)41BANKSBank country keynvarchar30
TOPHong Kong
112T7HK2HProvider Attributes16BANKSBank country keynvarchar30
TOPInformation System
113DKKOSBalance Audit Trail27BANKSBank country keynvarchar30
114DKOKSOpen Item Account Balance Audit Trail Master Record30BANKSBank country keynvarchar30
TOPIntercompany Data Exchange
115TINV_INV_BANKBank Data for Bill or Payment Advice Note3BANKSBank country keynvarchar30
TOPInvoice Verification
116RBKPDocument Header: Invoice Receipt94BANKSBank country keynvarchar30
TOPLoans Management
117VDAUSZDrawings on Disbursement31BANKSBank country keynvarchar30
118VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)14BANKSBank country keynvarchar30
119VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity45BANKSBank country keynvarchar30
120VZFZE_VDAUSZCentral Entry Table for Release Procedure33BANKSBank country keynvarchar30
121VZFZE_VDNBZECentral Entry Table for Release Procedure65BANKSBank country keynvarchar30
TOPLocalization
122ISJPHIERARCHYCustomer Hierarchy For Invoice Summary13BANKSBank country keynvarchar30
123ISJPINVSUMHDInvoice Summary Header32BANKSBank country keynvarchar30
124ISJPVIRTACCTVirtual accounts2BANKSBank country keynvarchar30
125J_1BNFCPDNota Fiscal one-time accounts17BANKSBank country keynvarchar30
TOPMaster Data
126BKK610Account Hierarchy: Assignment of Root Account to Tree Number7BANKSBank country keynvarchar30
127BKK625Assign. of Int. No. to Ext. Root Acct. for Change Document3BANKSBank country keynvarchar30
128JGTBKEZIS-M: Additional Data on Collection Authorization for Banks3BANKSBank country keynvarchar30
129JGTBKVWIS-M: Note to Payee for Banks9BANKSBank country keynvarchar30
130T012House Banks4BANKSBank country keynvarchar30
131TDLOANREPLACEGeneral Data for Discharging Loan3BANKSBank country keynvarchar30
132VDDISBTEMPDisbursements That Were Not Released16BANKSBank country keynvarchar30
TOPMexico
133PA0426Garnishment45BANKSBank country keynvarchar30
TOPMove-InOut
134ECAMIOPRBANKIS-U: Pre-entry Document: Bank Details5BANKSBank country keynvarchar30
TOPPayment Item
135BKKITPayment Item6BANKSBank country keynvarchar30
136BKKITENQBlocked Payment Items6BANKSBank country keynvarchar30
137BKKITRELPayment Item6BANKSBank country keynvarchar30
138BKKITTMPPlanned Payment Items7BANKSBank country keynvarchar30
139BKKITTMP_DELPlanned Payment Items - Completed7BANKSBank country keynvarchar30
140BKKPAYMEX_ITEFT Management: Items in Outgoing Payment Transactions9BANKSBank country keynvarchar30
141BKKPAYMIN_ITTable of Imported Items6BANKSBank country keynvarchar30
142TBKK_CLEAR_RELAssignment: Bank Key to Clearing Center ID2BANKSBank country keynvarchar30
143TBKK_CTRY_ZEROCountrys with account numbers with leading zeros2BANKSBank country keynvarchar30
TOPPayment Order
144BKKPOITItem in Payment Order7BANKSBank country keynvarchar30
145BKKPOIT_TMPItems in Planned Payment Order8BANKSBank country keynvarchar30
146BKKPOIT_TMP_DELItems in Planned Payment Order8BANKSBank country keynvarchar30
TOPPayment Transactions
147BANKA_CUP_ITBank Account Number maintenance for CUP/CIG Number5BANKSBank country keynvarchar30
148FIBL_RPCODEMaster Data for Repetitive Code7BANKSBank country keynvarchar30
149T015WTExplanation of Instruction Key3BANKSBank country keynvarchar30
150T042RName of account holder (ref.specifications on bk.details)2BANKSBank country keynvarchar30
TOPPayments
151TFK015WTBoleto: Instruction Code - Description3BANKSBank country keynvarchar30
TOPPayroll
152PA0643Személyügyi törzsrekord 0643 infótípus28BANKSBank országkulcsanvarchar30
153T5T1JHealth insurance institutions14BANKSCountry Keynvarchar30
154T5T1KHealth insurance institutions16BANKSCountry Keynvarchar30
155T5T1LBank accounts of authorities (tax,insurance)8BANKSBank country keynvarchar30
156T5T1XLast foreign Health insurance - name13BANKSCountry Keynvarchar30
157T5TA1External transfers30BANKSCountry Keynvarchar30
158T5TPS1LBank accounts of authorities (tax,insurance)10BANKSBank country keynvarchar30
159T7BGA1Bank transfer - interface table23BANKSBank country keynvarchar30
160T7ROA1Bank transfer - interface table11BANKSBank country keynvarchar30
161T7ROE4Postal fees2BANKSBank country keynvarchar30
162T7SI1LBank accounts of authorities (tax,insurance)6BANKSBank country keynvarchar30
163T7SIA6Bank transfer - interface table11BANKSBank country keynvarchar30
164T7SIBTVirman configuration (WT->Accounts)10BANKSBank country keynvarchar30
165T7SIBUBank Units Slovenia2BANKSKljuc države za bankonvarchar30
166T7SK1KHealth insurance institutions17BANKSCountry Keynvarchar30
167T7SK1LBank accounts of authorities (tax,insurance)11BANKSBank country keynvarchar30
168T7SKA1External transfers30BANKSCountry Keynvarchar30
169T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000937BANKSKlúc štátu bankynvarchar30
170T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001142BANKSKlúc štátunvarchar30
171T7SKVDPAux table for HSKLVDP045BANKSCountry Keynvarchar30
TOPPension Fund Switzerland
172PA3230Personnel Master Record for Infotype 323039BANKSBank country keynvarchar30
TOPPeriodical Sales and Distribution
173JFDFSIS-M/SD: Billing/Settlement Index22BANKSBank country keynvarchar30
174JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS30BANKSBank country keynvarchar30
175JKPASales Order: Partner18BANKSBank country keynvarchar30
176JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet80BANKSBank country keynvarchar30
177JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change6BANKSBank country keynvarchar30
178JNTRECHIS-M/SD: Research36BANKSBank country keynvarchar30
TOPPersonnel Administration
179PA0009HR Master Record: Infotype 0009 (Bank Details)34BANKSBank country keynvarchar30
180PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)39BANKSCountry Keynvarchar30
181PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)42BANKSLänderschlüsselnvarchar30
182T521BPayee Keys8BANKSBank country keynvarchar30
183T7CO17Bank code equivalences ACH2BANKSBank country keynvarchar30
184T7PL01Tax offices11BANKSBank country keynvarchar30
TOPPersonnel Management
185T7HRA1Bank transfer - interface table11BANKSBank country keynvarchar30
186T7HRBAPay slip layouts for banks Croatia2BANKSBank country keynvarchar30
187T7HRBPControl codes for banks Croatia2BANKSBank country keynvarchar30
188T7HRBPXConversion IT 9 to T521B proposal2BANKSBank country keynvarchar30
189T7HRDOStatutory deductions Croatia13BANKSCountry Keynvarchar30
190T7HRDSControl codes for stat. deductions and company codes Croatia10BANKSCountry Keynvarchar30
191T7HRMUMunicipality codes (Croatia)11BANKSCountry Keynvarchar30
192T7HRMWControl numbers - municipalities and company codes (Croatia)9BANKSCountry Keynvarchar30
193T7HRPGControl codes for payees Croatia10BANKSCountry Keynvarchar30
TOPProcess Controls -Automated Controls
194GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)32BANKSCountry Keynvarchar30
TOPPublic Sector
195T5D8S_BANKBank Details for Payroll Numbers6BANKSBank country keynvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
196DFMCA_BRF800BRF: Create/Update Bank Details ID8BANKSBRF: Expressionnvarchar200
TOPReal Estate Management
197VIAKBSEGDocument Line Item from SCS for Interface86BANKSCountry Keynvarchar30
TOPReceivablesPayment Management
198TZB50Internal Bank Numbers for Returned Direct Debit Charges2BANKSBank country keynvarchar30
TOPRecruitment
199PB0009HR Master Record: Infotype 0009 (Bank Details)34BANKSBank country keynvarchar30
TOPRussia
200PA0296HR Master Record Infotype 0296 (Garnishment Document)57BANKSBank country keynvarchar30
201T7RU1BPayee Keys of receiving orders (Russia standard)11BANKSBank country keynvarchar30
TOPSocial Insurance
202T5D31Professionals Pension Organization (PPO)14BANKSBank country keynvarchar30
TOPSouth Africa
203T5W1KPension Funds and Medical Aid Schemes (RSA)19BANKSCountry Keynvarchar30
204T5W1MSocial insurance companies11BANKSBank country keynvarchar30
205T5W5ABank check digit verification table for South Africa2BANKSBank country keynvarchar30
206T5W5BAccount Type Recognition for ZA2BANKSBank country keynvarchar30
207T5W5CSouth African Bank Names2BANKSBank country keynvarchar30
TOPSpain
208PA0887HR master record, infotype 088737BANKSBank country keynvarchar30
TOPThird Party ManagementCOA
209VIMMHBACCHouse Bank Account7BANKSBank country keynvarchar30
TOPTreasury
210SPBB1Partner-Bank relationship3BANKSBank country keynvarchar30
TOPUse AP-MD-BP Components
211BUT0BKBP: Bank Details4BANKSBank Country Keynvarchar30
TOPVenezuela
212PA0401HRMS-VE: Table for Benefits Infotype (IT401)31BANKSCountry Keynvarchar30
213T7VE03SUDEBAN financial codes2BANKSBank country keynvarchar30
214T7VE04Company financial operators3BANKSBank country keynvarchar30