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

98 columns | Print definition?ERP 6.0  | BKONT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt30BKONTBank Control Keynvarchar20
2/ATL/KPRCPTKPDetail of temporary receipt30BKONTBank Control Keynvarchar20
3/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)52BKONTBank Control Keynvarchar20
4/OPT/WT_3S_PYMNTSupplier Self Service Payment Information23BKONTBank Control Keynvarchar20
5BSECOne-Time Account Data Document Segment25BKONTBank Control Keynvarchar20
6FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document25BKONTBank Control Keynvarchar20
7FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)25BKONTBank Control Keynvarchar20
8P2RF_SARPayroll Results: Garnishment19BKONTBank Control Keynvarchar20
9P2RX_BTPayroll Results: Bank Transfers25BKONTBank Control Keynvarchar20
10P2RX_BT_PERSONPayment-Related Information (Person)27BKONTBank Control Keynvarchar20
11P2VE_SENHRMS-VE: Information on Length of Service19BKONTBank Control Keynvarchar20
12T071FI Document Archiving - Account Lives5BKONTTo Accountnvarchar100
13T536C_BANKBank Details for Public Sector Employer11BKONTBank Control Keynvarchar20
14T77PAYKZBTBank Transfer Table Image (BTKZ)42BKONTBank Control Keynvarchar20
15WBRDAgency Business: Bank Data Suspense Account11BKONTBank Control Keynvarchar20
TOPAdvertising Management
16JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order50BKONTBank Control Keynvarchar20
17JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header14BKONTBank Control Keynvarchar20
18JHTFXIS-M/AM: Billing Index - Order Billing24BKONTBank Control Keynvarchar20
19JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet63BKONTBank Control Keynvarchar20
TOPBank
20TIBANIBAN5BKONTBank Control Keynvarchar20
TOPBasic Functions
21T001CValid Posting Periods for Global Companies5BKONTTo Accountnvarchar100
TOPBelgium
22PA0125HR Master Record: Infotype 0125 (Garnishment B)35BKONTBank Control Keynvarchar20
TOPBrazil
23PA0736Alimony order for Brazil51BKONTBank Control Keynvarchar20
TOPChile
24PA3235HR Master Record: Infotype 323535BKONTBank Control Keynvarchar20
TOPCollectionsDisbursements
25ITAGCYPM_BANKPayment Methods: Bank7BKONTBank Control Keynvarchar20
26ITAGCYPM_CHECKPayment Methods: Check8BKONTBank Control Keynvarchar20
TOPCompany Pension Scheme Germany
27P01CBTTransfer Records for Reimbursement of Contributions CPS23BKONTBank Control Keynvarchar20
TOPContract Accounts Receivable and Payable
28DFKKEXC_PAYINFOInformation for Payment Medium33BKONTBank Control Keynvarchar20
29DFKKPNBKAPrenotification data (latest)13BKONTBank Control Keynvarchar20
30DFKKPNBKHPrenotification data (history)13BKONTBank Control Keynvarchar20
31DFKKUREUpdate Run: Defective Data Records27BKONTBank Control Keynvarchar20
32DFKKZARepayment Request14BKONTBank Control Keynvarchar20
33DFKKZPPayment lot: Data for payment47BKONTBank Control Keynvarchar20
34FKK_GPSHADData Extract: Business Partner Data (Faster Access)32BKONTBank Control Keynvarchar20
TOPCross-Application Objects in HR
35HRP5584DB Table for Infotype 558421BKONTBank Control Keynvarchar20
TOPFinancial Accounting
36/OPT/VIM_1HEADDocument Header157BKONTBank Control Keynvarchar20
37KNBKCustomer Master (Bank Details)6BKONTBank Control Keynvarchar20
38LFBKVendor Master (Bank Details)6BKONTBank Control Keynvarchar20
39T001BPermitted Posting Periods5BKONTTo Accountnvarchar100
40T012OORBIAN Details: Bank Accounts and Other Data10BKONTBank Control Keynvarchar20
41T045WBank Subaccounts for Bill of Exchange Usage3BKONTG/L Account Number of the Bank Accountnvarchar100
42TIBAN_APARUnconfirmed IBANs and Their Correct Validity Start7BKONTBank Control Keynvarchar20
43VBSECDocument Parking One-Time Data Document Segment25BKONTBank Control Keynvarchar20
TOPFrance
44PA0272Infotype 0272 (Garnishment)38BKONTBank Control Keynvarchar20
TOPFund Accounting
45T001B_PS_PERPermitted Posting Periods for Account Assignment Objects5BKONTTo Account Assignmentnvarchar300
TOPFunds Management-Specific Postings
46KNEAAssign Bank Details and Payment Methods to Revenue Type8BKONTBank Control Keynvarchar20
47PSO31Allocation of customer/objects7BKONTBank Control Keynvarchar20
48PSO32Allocation of customer/revenue types/objects8BKONTBank Control Keynvarchar20
49PSOSECRecurring Request Document Segment, One-Time Data27BKONTBank Control Keynvarchar20
TOPGeneral Ledger Reorganization
50FAGL_R_PER_TRACKReorganization: Log of Changed Posting Periods7BKONTTo Accountnvarchar100
TOPGL Account Posting
51TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items26BKONTBank Control Keynvarchar20
TOPInformation System
52DKKOSBalance Audit Trail30BKONTBank Control Keynvarchar20
53DKOKSOpen Item Account Balance Audit Trail Master Record33BKONTBank Control Keynvarchar20
TOPIntercompany Data Exchange
54TINV_INV_BANKBank Data for Bill or Payment Advice Note6BKONTBank Control Keynvarchar20
TOPInvoice Verification
55RBKPDocument Header: Invoice Receipt100BKONTBank Control Keynvarchar20
TOPLoans Management
56VDAUSZDrawings on Disbursement38BKONTBank Control Keynvarchar20
57VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity51BKONTBank Control Keynvarchar20
58VZFZE_VDAUSZCentral Entry Table for Release Procedure40BKONTBank Control Keynvarchar20
59VZFZE_VDNBZECentral Entry Table for Release Procedure71BKONTBank Control Keynvarchar20
TOPLocalization
60J_1BNFCPDNota Fiscal one-time accounts23BKONTBank Control Keynvarchar20
TOPMaster Data
61T012KHouse Bank Accounts6BKONTBank Control Keynvarchar20
TOPMexico
62PA0426Garnishment48BKONTBank Control Keynvarchar20
TOPMove-InOut
63ECAMIOPRBANKIS-U: Pre-entry Document: Bank Details8BKONTBank Control Keynvarchar20
TOPPayment Transactions
64FIBL_RPCODEMaster Data for Repetitive Code10BKONTBank Control Keynvarchar20
65PNBKPrenotification: New bank data from master records5BKONTBank Control Keynvarchar20
TOPPayroll
66T5TA1External transfers29BKONTBank Control Keynvarchar20
67T7BGA1Bank transfer - interface table26BKONTBank Control Keynvarchar20
68T7ROA1Bank transfer - interface table14BKONTBank Control Keynvarchar20
69T7SIA6Bank transfer - interface table19BKONTBank Control Keynvarchar20
70T7SIBTVirman configuration (WT->Accounts)15BKONTBank Control Keynvarchar20
71T7SKA1External transfers29BKONTBank Control Keynvarchar20
72T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000941BKONTKontrolný kód bankynvarchar20
73T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001146BKONTKontrolný kód bankynvarchar20
TOPPension Fund Switzerland
74PA3230Personnel Master Record for Infotype 323046BKONTBank Control Keynvarchar20
TOPPeriodical Sales and Distribution
75JFDFSIS-M/SD: Billing/Settlement Index25BKONTBank Control Keynvarchar20
76JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS33BKONTBank Control Keynvarchar20
77JKPASales Order: Partner21BKONTBank Control Keynvarchar20
78JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet89BKONTBank Control Keynvarchar20
79JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change15BKONTBank Control Keynvarchar20
80JNTRECHIS-M/SD: Research39BKONTBank Control Keynvarchar20
TOPPersonnel Administration
81PA0009HR Master Record: Infotype 0009 (Bank Details)38BKONTBank Control Keynvarchar20
82PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)43BKONTBank Control Keynvarchar20
83T521BPayee Keys20BKONTBank Control Keynvarchar20
TOPPersonnel Management
84T7HRA1Bank transfer - interface table27BKONTBank Control Keynvarchar20
85T7HRBPXConversion IT 9 to T521B proposal6BKONTBank Control Keynvarchar20
TOPPublic Sector
86T5D8S_BANKBank Details for Payroll Numbers10BKONTBank Control Keynvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
87DFMCA_BRF800BRF: Create/Update Bank Details ID12BKONTBRF: Expressionnvarchar200
TOPReal Estate Management
88VIAKBSEGDocument Line Item from SCS for Interface85BKONTBank Control Keynvarchar20
TOPRecruitment
89PB0009HR Master Record: Infotype 0009 (Bank Details)38BKONTBank Control Keynvarchar20
TOPRussia
90T7RU1BPayee Keys of receiving orders (Russia standard)24BKONTBank Control Keynvarchar20
TOPSouth Africa
91T5W5ABank check digit verification table for South Africa4BKONTBank Control Keynvarchar20
92T5W5BAccount Type Recognition for ZA4BKONTBank Control Keynvarchar20
93T5WAElectronic fund transfer codes2BKONTBank Control Keynvarchar20
94T5WATElctronic fund transfer texts3BKONTBank Control Keynvarchar20
TOPSpain
95PA0887HR master record, infotype 088743BKONTBank Control Keynvarchar20
TOPTreasury
96SPBB1Partner-Bank relationship6BKONTBank Control Keynvarchar20
TOPUse AP-MD-BP Components
97BUT0BKBP: Bank Details7BKONTBank Control Keynvarchar20
TOPVenezuela
98PA0401HRMS-VE: Table for Benefits Infotype (IT401)35BKONTBank Control Keynvarchar20