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

56 columns | Print definition?ERP 6.0  | BKREF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)65BKREFReference specifications for bank detailsnvarchar200
2/OPT/WT_3S_PYMNTSupplier Self Service Payment Information21BKREFReference specifications for bank detailsnvarchar200
3BSECOne-Time Account Data Document Segment36BKREFReference specifications for bank detailsnvarchar200
4FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document36BKREFReference specifications for bank detailsnvarchar200
5FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)36BKREFReference specifications for bank detailsnvarchar200
6P2RH_HU_MEMBP21MB33BKREFReference specifications for bank detailsnvarchar200
7P2RX_BTPayroll Results: Bank Transfers31BKREFReference specifications for bank detailsnvarchar200
8P2RX_BT_PERSONPayment-Related Information (Person)33BKREFReference specifications for bank detailsnvarchar200
9T536C_BANKBank Details for Public Sector Employer10BKREFReference specifications for bank detailsnvarchar200
10T77PAYKZBTBank Transfer Table Image (BTKZ)48BKREFReference specifications for bank detailsnvarchar200
11WBRDAgency Business: Bank Data Suspense Account12BKREFReference specifications for bank detailsnvarchar200
TOPAutomatic Payments
12PAYRQPayment Requests107BKREFReference specifications for bank detailsnvarchar200
TOPBasic Functions
13FEBKOElectronic Bank Statement Header Records52BKREFReference specifications for bank detailsnvarchar200
TOPChile
14PA3235HR Master Record: Infotype 323538BKREFReference specifications for bank detailsnvarchar200
TOPCollectionsDisbursements
15ITAGCYPM_BANKPayment Methods: Bank8BKREFReference specifications for bank detailsnvarchar200
TOPContract Accounts Receivable and Payable
16DFKKEXC_PAYINFOInformation for Payment Medium34BKREFReference specifications for bank detailsnvarchar200
17DFKKPNBKAPrenotification data (latest)14BKREFReference specifications for bank detailsnvarchar200
18DFKKPNBKHPrenotification data (history)14BKREFReference specifications for bank detailsnvarchar200
19DFKKUREUpdate Run: Defective Data Records28BKREFReference specifications for bank detailsnvarchar200
20DFKKZARepayment Request15BKREFReference specifications for bank detailsnvarchar200
21DFKKZPPayment lot: Data for payment61BKREFReference specifications for bank detailsnvarchar200
22FKK_GPSHADData Extract: Business Partner Data (Faster Access)33BKREFReference specifications for bank detailsnvarchar200
TOPFinancial Accounting
23/OPT/VIM_1HEADDocument Header155BKREFReference specifications for bank detailsnvarchar200
24KNBKCustomer Master (Bank Details)9BKREFReference specifications for bank detailsnvarchar200
25LFBKVendor Master (Bank Details)9BKREFReference specifications for bank detailsnvarchar200
26T012OORBIAN Details: Bank Accounts and Other Data11BKREFReference specifications for bank detailsnvarchar200
27VBSECDocument Parking One-Time Data Document Segment36BKREFReference specifications for bank detailsnvarchar200
TOPFunds Management-Specific Postings
28KNEAAssign Bank Details and Payment Methods to Revenue Type10BKREFReference specifications for bank detailsnvarchar200
29PSO31Allocation of customer/objects9BKREFReference specifications for bank detailsnvarchar200
30PSO32Allocation of customer/revenue types/objects10BKREFReference specifications for bank detailsnvarchar200
31PSOSECRecurring Request Document Segment, One-Time Data39BKREFReference specifications for bank detailsnvarchar200
TOPGL Account Posting
32TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items37BKREFReference specifications for bank detailsnvarchar200
TOPIntercompany Data Exchange
33TINV_INV_BANKBank Data for Bill or Payment Advice Note7BKREFReference specifications for bank detailsnvarchar200
TOPInvoice Verification
34RBKPDocument Header: Invoice Receipt111BKREFReference specifications for bank detailsnvarchar200
TOPLoans Management
35VDAUSZDrawings on Disbursement39BKREFReference Details for Bank Detailsnvarchar200
36VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity62BKREFReference specifications for bank detailsnvarchar200
37VZFZE_VDAUSZCentral Entry Table for Release Procedure41BKREFReference Details for Bank Detailsnvarchar200
TOPMexico
38PA0426Garnishment49BKREFReference specifications for bank detailsnvarchar200
TOPPayment Transactions
39FIBL_RPCODEMaster Data for Repetitive Code11BKREFReference specifications for bank detailsnvarchar200
40FPRL_ITEMItem Data133BKREFReference specifications for bank detailsnvarchar200
41PNBKPrenotification: New bank data from master records11BKREFStandard Entry Class Codenvarchar30
42REGUHSettlement data from payment program103BKREFReference specifications for bank detailsnvarchar200
TOPPayroll
43T7ROA1Bank transfer - interface table15BKREFReference specifications for bank detailsnvarchar200
44T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000958BKREFReferencný údaj k bank.spojeniunvarchar200
45T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001159BKREFReferencný údaj k bank.spojeniunvarchar200
TOPPension Fund Switzerland
46PA3230Personnel Master Record for Infotype 323047BKREFReference specifications for bank detailsnvarchar200
TOPPersonnel Administration
47PA0009HR Master Record: Infotype 0009 (Bank Details)55BKREFReference specifications for bank detailsnvarchar200
48PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)56BKREFReference specifications for bank detailsnvarchar200
49PA0057HR Master Record: Infotype 0057 (Membership Fees)50BKREFReference specifications for bank detailsnvarchar200
50T521BPayee Keys23BKREFReference specifications for bank detailsnvarchar200
51T7PL01Tax offices14BKREFReference specifications for bank detailsnvarchar200
TOPPublic Sector
52T5D8S_BANKBank Details for Payroll Numbers9BKREFReference specifications for bank detailsnvarchar200
TOPRecruitment
53PB0009HR Master Record: Infotype 0009 (Bank Details)55BKREFReference specifications for bank detailsnvarchar200
TOPSpain
54PA0887HR master record, infotype 088746BKREFReference specifications for bank detailsnvarchar200
TOPUse AP-MD-BP Components
55BUT0BKBP: Bank Details8BKREFReference Details for Bank Detailsnvarchar200
TOPVenezuela
56PA0401HRMS-VE: Table for Benefits Infotype (IT401)37BKREFReference specifications for bank detailsnvarchar200