SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

86 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