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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

103 columns | Print definition?B1 9.3  | 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
11ACLGActivities - History40InstanceInstanceInt600
12ACPNCampaign21InstanceInstanceInt600
13AOATBlanket Agreement42InstanceInstanceInt600
14OCLGActivities40InstanceInstanceInt600
15OCPNCampaign21InstanceInstanceInt600
16OOATBlanket Agreement42InstanceInstanceInt600
TOPFinance
17BGT1Budget - Rows21InstanceInstanceInt1101
18BGT2Budget - Cost Accounting4InstanceInstanceInt1101
19BGT3Budget - Cost Accounting Rows4InstanceInstanceInt1101
20OBGTBudget23InstanceInstanceInt1101
21ORCRRecurring Postings18InstanceInstanceInt600
22RCR1Recurring Postings - Rows8InstanceInstanceInt60
TOPGeneral
23AHF1Hide Functions Configuration - Rows History13InstanceInstanceInt600
24AHF2Hide Function Configuration - Rows History9InstanceInstanceInt600
25AHFCHide Functions Configuration - History8InstanceInstanceInt600
26HFC1Hide Function Configuration - Rows13InstanceInstanceInt600
27HFC2Hide Function Configuration - Rows9InstanceInstanceInt600
28OHFCHide Functions Configuration8InstanceInstanceInt600
29SHQRUpgrade queries history3InstanceQuery instanceInt60
TOPInventory and Production
30ABATAttribute - History7InstanceInstanceInt600
31ABFCBin Field Configuration - History9InstanceInstanceInt600
32ABINBin Location - History47InstanceInstanceInt600
33ABSLWarehouse Sublevel - History8InstanceInstanceInt600
34ABTNBatch Numbers Master Data18InstanceInstanceInt600
35ABTWBatch Attributes in Location8InstanceInstanceInt600
36ASRNSerial Numbers Master Data18InstanceInstanceInt600
37OBATBin Location Attribute7InstanceInstanceInt600
38OBFCBin Field Configuration9InstanceInstanceInt600
39OBINBin Location47InstanceInstanceInt600
40OBSLWarehouse Sublevel8InstanceInstanceInt600
41OBTNBatch Numbers Master Data18InstanceInstanceInt600
42OBTWBatch Attributes in Location8InstanceInstanceInt600
43ODBNBat. Nos - Draft - Master Data18InstanceInstanceInt600
44ODBWBatch Draft Attribs in Locat.8InstanceInstanceInt600
45ODSNSNs - Draft - Master Data18InstanceInstanceInt600
46ODSWSN Draft Attribs in Location8InstanceInstanceInt600
47OIGEGoods Issue49InstanceInstanceInt600
48OIGNGoods Receipt49InstanceInstanceInt600
49OIPFLanded Costs41InstanceInstanceInt600
50OITLInventory Transactions Log29InstanceINSTANCEInt600
51OIVKIVL Vs OINM Keys5InstanceInstanceInt1100
52OMRLAdvanced Inventory Revaluation17InstanceInstanceInt600
53OSRNSerial Numbers Master Data18InstanceInstanceInt600
54OSRWSerial No. Attribs in Location8InstanceInstanceInt600
55OWKOProduction Instructions21InstanceInstanceInt600
56OWTQInventory Transfer Request49InstanceInstanceInt600
57OWTRInventory Transfer49InstanceInstanceInt600
58SIVKIVL Vs OINM Keys5InstanceInstanceInt1100
59UBTNBatch Numbers Master Data18InstanceInstanceInt600
60UIVKIVL Vs OINM Keys5InstanceInstanceInt1100
61USRNSerial Numbers Master Data18InstanceInstanceInt600
62UWKOProduction Instructions21InstanceInstanceInt600
TOPMarketing Documents
63ADOCInvoice - History49InstanceInstanceInt600
64BAL1Opening Balance Instances2InstanceInstanceInt110
65OCINA/R Correction Invoice49InstanceInstanceInt600
66OCPIA/P Correction Invoice49InstanceInstanceInt600
67OCPVA/P Correction Invoice Reversal49InstanceInstanceInt600
68OCSIA/R Correction Invoice49InstanceInstanceInt600
69OCSVA/R Correction Invoice Reversal49InstanceInstanceInt600
70ODLNDelivery49InstanceInstanceInt600
71ODPIA/R Down Payment49InstanceInstanceInt600
72ODPOA/P Down Payment49InstanceInstanceInt600
73ODRFDrafts49InstanceInstanceInt60
74OIEIIncoming Excise Invoice49InstanceInstanceInt600
75OINVA/R Invoice49InstanceInstanceInt600
76OOEIOutgoing Excise Invoice49InstanceInstanceInt600
77OPCHA/P Invoice49InstanceInstanceInt600
78OPDNGoods Receipt PO49InstanceInstanceInt600
79OPORPurchase Order49InstanceInstanceInt600
80OPQTPurchase Quotation49InstanceInstanceInt600
81OPRQPurchase Request49InstanceInstanceInt600
82OPRRGoods Return Request49InstanceInstanceInt600
83OQUTSales Quotation49InstanceInstanceInt600
84ORCLRecurring Transaction Instances3InstanceRecurrence InstanceInt1100
85ORDNReturns49InstanceInstanceInt600
86ORDRSales Order49InstanceInstanceInt600
87ORINA/R Credit Memo49InstanceInstanceInt600
88ORPCA/P Credit Memo49InstanceInstanceInt600
89ORPDGoods Return49InstanceInstanceInt600
90ORRRReturn Request49InstanceInstanceInt600
91OSFCSelf Credit Memo49InstanceInstanceInt600
92OSFISelf Invoice49InstanceInstanceInt600
TOPSales Opportunities
93AOPROpportunity32InstanceInstanceInt600
94OOPROpportunity32InstanceInstanceInt600
TOPService
95ACTRService Contracts60InstanceInstanceInt600
96AINSCustomer Equipment Card - History51InstanceInstanceInt600
97ASC4Service Call Travel/Labor Expenses - History17InstanceInstanceInt600
98ASCLHistory58InstanceInstanceInt600
99OCTRService Contracts60InstanceInstanceInt600
100OINSCustomer Equipment Card51InstanceInstanceInt600
101OSCLService Calls58InstanceInstanceInt600
102OSLTService Call Solutions16InstanceInstanceInt600
103SCL4Expense Documents17InstanceInstanceInt600