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

96 columns | Print definition?B1 9.2  | INSTANCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CPL1Quick Copy - Instance Log4InstanceInstance KeynVarChar2540
2DAR1Data Archive - Transaction Log23InstanceInstanceInt600
TOPBanking
3ABOEBill of Exchange for Payment - History40InstanceInstanceInt600
4ACHOChecks for Payment - History41InstanceInstanceInt600
5OBOEBill of Exchange for Payment40InstanceInstanceInt600
6OCHDChecks for Payment Drafts41InstanceInstanceInt600
7OCHHCheck Register25InstanceInstanceInt600
8OCHOChecks for Payment41InstanceInstanceInt600
9OCRHCredit Card Management33InstanceInstanceInt600
10OCRVCredit Payments25InstanceInstanceInt600
TOPBusiness Partners
11ACPNCampaign21InstanceInstanceInt600
12AOATBlanket Agreement42InstanceInstanceInt600
13OCLGActivities40InstanceInstanceInt600
14OCPNCampaign21InstanceInstanceInt600
15OOATBlanket Agreement42InstanceInstanceInt600
TOPFinance
16BGT1Budget - Rows21InstanceInstanceInt1101
17BGT2Budget - Cost Accounting4InstanceInstanceInt1101
18BGT3Budget - Cost Accounting Rows4InstanceInstanceInt1101
19OBGTBudget23InstanceInstanceInt1101
20ORCRRecurring Postings18InstanceInstanceInt600
21RCR1Recurring Postings - Rows8InstanceInstanceInt60
TOPGeneral
22AHF1Hide Functions Configuration - Rows History13InstanceInstanceInt600
23AHF2Hide Function Configuration - Rows History9InstanceInstanceInt600
24AHFCHide Functions Configuration - History8InstanceInstanceInt600
25HFC1Hide Functions Configuration - Rows13InstanceInstanceInt600
26HFC2Hide Function Configuration - Rows9InstanceInstanceInt600
27OHFCHide Functions Configuration8InstanceInstanceInt600
28SHQRUpgrade queries history3InstanceQuery instanceInt60
TOPInventory and Production
29ABATAttribute - History7InstanceInstanceInt600
30ABFCBin Field Configuration - History9InstanceInstanceInt600
31ABINBin Location - History47InstanceInstanceInt600
32ABSLWarehouse Sublevel - History8InstanceInstanceInt600
33ABTNBatch Numbers Master Data18InstanceInstanceInt600
34ABTWBatch Attributes in Location8InstanceInstanceInt600
35ASRNSerial Numbers Master Data18InstanceInstanceInt600
36OBATBin Location Attribute7InstanceInstanceInt600
37OBFCBin Field Configuration9InstanceInstanceInt600
38OBINBin Location47InstanceInstanceInt600
39OBSLWarehouse Sublevel8InstanceInstanceInt600
40OBTNBatch Numbers Master Data18InstanceInstanceInt600
41OBTWBatch Attributes in Location8InstanceInstanceInt600
42ODBNBat. Nos - Draft - Master Data18InstanceInstanceInt600
43ODBWBatch Draft Attribs in Locat.8InstanceInstanceInt600
44ODSNSNs - Draft - Master Data18InstanceInstanceInt600
45ODSWSN Draft Attribs in Location8InstanceInstanceInt600
46OIGEGoods Issue49InstanceInstanceInt600
47OIGNGoods Receipt49InstanceInstanceInt600
48OIPFLanded Costs41InstanceInstanceInt600
49OITLInventory Transactions Log29InstanceINSTANCEInt600
50OIVKIVL Vs OINM Keys5InstanceInstanceInt1100
51OMRLAdvanced Inventory Revaluation17InstanceInstanceInt600
52OSRNSerial Numbers Master Data18InstanceInstanceInt600
53OSRWSerial No. Attribs in Location8InstanceInstanceInt600
54OWKOProduction Instructions21InstanceInstanceInt600
55OWTQInventory Transfer Request49InstanceInstanceInt600
56OWTRInventory Transfer49InstanceInstanceInt600
57SIVKIVL Vs OINM Keys5InstanceInstanceInt1100
58UBTNBatch Numbers Master Data18InstanceInstanceInt600
59UIVKIVL Vs OINM Keys5InstanceInstanceInt1100
60USRNSerial Numbers Master Data18InstanceInstanceInt600
61UWKOProduction Instructions21InstanceInstanceInt600
TOPMarketing Documents
62ADOCInvoice - History49InstanceInstanceInt600
63OCINA/R Correction Invoice49InstanceInstanceInt600
64OCPIA/P Correction Invoice49InstanceInstanceInt600
65OCPVA/P Correction Invoice Reversal49InstanceInstanceInt600
66OCSIA/R Correction Invoice49InstanceInstanceInt600
67OCSVA/R Correction Invoice Reversal49InstanceInstanceInt600
68ODLNDelivery49InstanceInstanceInt600
69ODPIA/R Down Payment49InstanceInstanceInt600
70ODPOA/P Down Payment49InstanceInstanceInt600
71ODRFDrafts49InstanceInstanceInt60
72OIEIIncoming Excise Invoice49InstanceInstanceInt600
73OINVA/R Invoice49InstanceInstanceInt600
74OOEIOutgoing Excise Invoice49InstanceInstanceInt600
75OPCHA/P Invoice49InstanceInstanceInt600
76OPDNGoods Receipt PO49InstanceInstanceInt600
77OPORPurchase Order49InstanceInstanceInt600
78OPQTPurchase Quotation49InstanceInstanceInt600
79OPRQPurchase Request49InstanceInstanceInt600
80OQUTSales Quotation49InstanceInstanceInt600
81ORCLRecurring Transaction Instances3InstanceRecurrence InstanceInt1100
82ORDNReturns49InstanceInstanceInt600
83ORDRSales Order49InstanceInstanceInt600
84ORINA/R Credit Memo49InstanceInstanceInt600
85ORPCA/P Credit Memo49InstanceInstanceInt600
86ORPDGoods Return49InstanceInstanceInt600
TOPSales Opportunities
87AOPROpportunity32InstanceInstanceInt600
88OOPROpportunity32InstanceInstanceInt600
TOPService
89AINSCustomer Equipment Card - History51InstanceInstanceInt600
90ASC4Service Call Travel/Labor Expenses - History17InstanceInstanceInt600
91ASCLHistory58InstanceInstanceInt600
92OCTRService Contracts60InstanceInstanceInt600
93OINSCustomer Equipment Card51InstanceInstanceInt600
94OSCLService Calls58InstanceInstanceInt600
95OSLTService Call Solutions16InstanceInstanceInt600
96SCL4Expense Documents17InstanceInstanceInt600