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

39 columns | Print definition?ERP 6.0  | OPBUK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TFKBOL_BANKID2Boleto: Bank ID Determination Customizing II-payment method2OPBUKCompany Codenvarchar40
TOPCollectionsDisbursements
2VVKKCFCSTELInsurance Dunning: Telephone Collections8OPBUKCompany Code Groupnvarchar40
3VVKKFAPOSInvoicing Items in FS-CD12OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
4VVKKFKODoc Header Posting Data Interface17OPBUKCompany Codenvarchar40
5VVKKFKOTTable for FS-CD Test Data of Structure vkkkfko13OPBUKCompany Codenvarchar40
TOPContract Accounts Receivable and Payable
6DFKKCFDUNTELTelephone List for Dunning11OPBUKCompany Code Groupnvarchar40
7DFKKCFNRClarification Cases from NOC Returns Lot4OPBUKCompany Codenvarchar40
8DFKKDDADebit Memo Notification24OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
9DFKKNRKNOC Returns Lot: Header Data18OPBUKCompany Codenvarchar40
10DFKKPNBKAPrenotification data (latest)18OPBUKCompany Code Groupnvarchar40
11DFKKPNBKHPrenotification data (history)18OPBUKCompany Code Groupnvarchar40
12DPAYGPayment program - payment group7OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
13DPAYVPayment program: Variants for payment medium and list6OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
14FKKMAKODunning History Header28OPBUKCompany Code Groupnvarchar40
15FKKVKPContract Account Partner-Specific23OPBUKCompany Code Groupnvarchar40
16TE045EFIS-U Returns Correspondence Form2OPBUKCompany Codenvarchar40
17TFK001BCompany Codes in Contract Accounts Receivable and Payable3OPBUKField Hiddennvarchar40
18TFK001GCompany Code Groups2OPBUKCompany Code Groupnvarchar40
19TFK001GBCompany Codes for Company Code Groups2OPBUKCompany Code Groupnvarchar40
20TFK001GTName of Company Code Groups3OPBUKCompany Code Groupnvarchar40
21TFK042APayment Program: Bank Selection2OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
22TFK042AXLPayment Program: Bank Selection - ID (Values)3OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
23TFK042BPayment Program: Specifications for Paying Company Code2OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
24TFK042CPayments/Dunning/Interest: Alternative Currency3OPBUKCompany Code Groupnvarchar40
25TFK042EPayment program: company code payment method specifications2OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
26TFK042FEPayment program: company code format specifications2OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
27TFK042VPayment Program: Determination of Value Date2OPBUKCompany Code for Automatic Payment Transactionsnvarchar40
28TFK045EReturns Activities (Returns Lot)2OPBUKCompany Codenvarchar40
29TFK045ETTexts on returns activities2OPBUKCompany Codenvarchar40
30TFK053BChange Payment Data: Company Code Group-Specific Settings2OPBUKCompany Code Groupnvarchar40
31TFK054BAssignment of Sender Institution Error Reason -> Internal2OPBUKCompany Codenvarchar40
32TFK054CNOC Returns: Activities per OPBUK and INSID2OPBUKCompany Codenvarchar40
33TFK054CTNOC Returns: Activity Texts2OPBUKCompany Codenvarchar40
34TFK058ARules for Additional Receivables (Attributes)3OPBUKCompany Code Groupnvarchar40
TOPPayments
35DFKKBOL_BANKIDBoleto: Bank ID Determination Results2OPBUKCompany Codenvarchar40
36TFKBOL_BANKIDBoleto: Bank ID Determination Customizing2OPBUKCompany Codenvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
37DFMCAINVInvoice in IS-PS-CA: Header Data6OPBUKCompany Code Groupnvarchar40
38DFMCA_BRF550BRF: Parameters for Processing Contract Account21OPBUKBRF: Expressionnvarchar200
39TFICA_DEFSamples for Contract Account Types7OPBUKCompany Code Groupnvarchar40