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
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
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

77 columns | Print definition?B1 8.82  | INSTANCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log23InstanceInstanceInt600
TOPBanking
2ABOEBill of Exchange for Payment - History40InstanceInstanceInt600
3ACHOChecks for Payment - History41InstanceInstanceInt600
4OBOEBill of Exchange for Payment40InstanceInstanceInt600
5OCHDChecks for Payment Drafts41InstanceInstanceInt600
6OCHHCheck Register25InstanceInstanceInt600
7OCHOChecks for Payment41InstanceInstanceInt600
8OCRHCredit Card Management33InstanceInstanceInt600
9OCRVCredit Payments25InstanceInstanceInt600
TOPBusiness Partners
10ACPNCampaign21InstanceInstanceInt600
11OCLGActivities40InstanceInstanceInt600
12OCPNCampaign21InstanceInstanceInt600
TOPFinance
13BGT1Budget - Rows21InstanceInstanceInt1101
14BGT2Budget - Cost Accounting4InstanceInstanceInt1101
15BGT3Budget - Cost Accounting Rows4InstanceInstanceInt1101
16OBGTBudget23InstanceInstanceInt1101
17ORCRRecurring Postings18InstanceInstanceInt600
18RCR1Recurring Postings - Rows8InstanceInstanceInt60
TOPInventory and Production
19ABTNBatch Numbers Master Data18InstanceInstanceInt600
20ABTWBatch Attributes in Location8InstanceInstanceInt600
21ASRNSerial Numbers Master Data18InstanceInstanceInt600
22OBTNBatch Numbers Master Data18InstanceInstanceInt600
23OBTWBatch Attributes in Location8InstanceInstanceInt600
24ODBNBat. Nos - Draft - Master Data18InstanceInstanceInt600
25ODBWBatch Draft Attribs in Locat.8InstanceInstanceInt600
26ODSNSNs - Draft - Master Data18InstanceInstanceInt600
27ODSWSN Draft Attribs in Location8InstanceInstanceInt600
28OIBTBatch No. for Item28InstanceInstanceInt600
29OIGEGoods Issue49InstanceInstanceInt600
30OIGNGoods Receipt49InstanceInstanceInt600
31OINMWhse Journal37InstanceInstanceInt1100
32OIPFLanded Costs41InstanceInstanceInt600
33OITLInventory Transactions Log29InstanceINSTANCEInt600
34OIVKIVL Vs OINM Keys5InstanceInstanceInt1100
35OMRLAdvanced Inventory Revaluation17InstanceInstanceInt600
36OSRISerial Numbers for Items28InstanceInstanceInt600
37OSRNSerial Numbers Master Data18InstanceInstanceInt600
38OSRWSerial No. Attribs in Location8InstanceInstanceInt600
39OWKOProduction Instructions21InstanceInstanceInt600
40OWTQInventory Transfer Request49InstanceInstanceInt600
41OWTRInventory Transfer49InstanceInstanceInt600
42SIVKIVL Vs OINM Keys5InstanceInstanceInt1100
43UIVKIVL Vs OINM Keys5InstanceInstanceInt1100
44UWKOProduction Instructions21InstanceInstanceInt600
TOPMarketing Documents
45ADOCInvoice - History49InstanceInstanceInt600
46OCINA/R Correction Invoice49InstanceInstanceInt600
47OCPIA/P Correction Invoice49InstanceInstanceInt600
48OCPVA/P Correction Invoice Reversal49InstanceInstanceInt600
49OCSIA/R Correction Invoice49InstanceInstanceInt600
50OCSVA/R Correction Invoice Reversal49InstanceInstanceInt600
51ODLNDelivery49InstanceInstanceInt600
52ODPIA/R Down Payment49InstanceInstanceInt600
53ODPOA/P Down Payment49InstanceInstanceInt600
54ODRFDrafts49InstanceInstanceInt60
55OIEIIncoming Excise Invoice49InstanceInstanceInt600
56OINVA/R Invoice49InstanceInstanceInt600
57OOEIOutgoing Excise Invoice49InstanceInstanceInt600
58OPCHA/P Invoice49InstanceInstanceInt600
59OPDNGoods Receipt PO49InstanceInstanceInt600
60OPORPurchase Order49InstanceInstanceInt600
61OPQTPurchase Quotation49InstanceInstanceInt600
62OQUTSales Quotation49InstanceInstanceInt600
63ORCLRecurring Transaction Instances3InstanceRecurrence InstanceInt1100
64ORDNReturns49InstanceInstanceInt600
65ORDRSales Order49InstanceInstanceInt600
66ORINA/R Credit Memo49InstanceInstanceInt600
67ORPCA/P Credit Memo49InstanceInstanceInt600
68ORPDGoods Return49InstanceInstanceInt600
TOPSales Opportunities
69OOPRSales Opportunity32InstanceInstanceInt600
TOPService
70AINSCustomer Equipment Card - History51InstanceInstanceInt600
71ASC4Service Call Travel/Labor Expenses - History17InstanceInstanceInt600
72ASCLHistory58InstanceInstanceInt600
73OCTRService Contracts60InstanceInstanceInt600
74OINSCustomer Equipment Card51InstanceInstanceInt600
75OSCLService Calls58InstanceInstanceInt600
76OSLTService Call Solutions16InstanceInstanceInt600
77SCL4Expense Documents17InstanceInstanceInt600