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
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

132 columns | Print definition?B1 8.8  | CREATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AUSRArchive Users - History69createDateCreation DateDate80
2ODARData Archiving4CreateDateArchive DateDate80
3ODGPDocument Generation Parameter Sets4CreateDateCreation DateDate80
4ODOWData Ownership - Objects7CreateDateCreation DateDate80
5ODOXData Ownership - Exceptions6CreateDateCreation DateDate80
6OUSRUsers69createDateCreation Date - HistoryDate80
TOPBanking
7ABOEBill of Exchange for Payment - History29CreateDateCreation DateDate80
8ACHOChecks for Payment - History32CreateDateCreation DateDate80
9ARCTIncoming Payment - History59CreateDateCreation DateDate80
10OBOEBill of Exchange for Payment29CreateDateCreation DateDate80
11OCHDChecks for Payment Drafts32CreateDateCreation DateDate80
12OCHOChecks for Payment32CreateDateCreation DateDate80
13OCRHCredit Card Management36CreateDateCreation DateDate80
14ODPSDeposit28CreateDateCreation DateDate80
15OITRInternal Reconciliation12CreateDateCreation DateDate80
16OMTHReconciliation History12createDateCreation DateDate80
17OPDFPayment Draft59CreateDateCreation DateDate80
18OPYMPayment Methods for Payment Wizard17CreateDateCreation DateDate80
19ORCTIncoming Payment59CreateDateCreation DateDate80
20OSVRSaved Reconciliations6createDateCreation DateDate80
21OTPWTax Payment Wizard5CreateDateWizard Creation DateDate80
22OVPMOutgoing Payments59CreateDateCreation DateDate80
TOPBusiness Partners
23ACRDBusiness Partners - History132CreateDateCreation DateDate80
24OCRDBusiness Partner132CreateDateCreation DateDate80
TOPFinance
25AACTG/L Account - History38CreateDateCreation DateDate80
26AJDTJournal Entry - History26CreateDateCreation DateDate80
27CASEInternal Recon. Upgrade 2007A2CreateDateCreation DateDate80
28OACTG/L Accounts38CreateDateCreation DateDate80
29OBTFJournal Voucher Entry26CreateDateRecording DateDate80
30OCFHCash Flow Statement History5CreateDateRecording DateDate80
31OGBIGB Interface: Common Info7CreateDateReport Creation DatenVarChar80
32OIWZInflation Wizard31CreateDateCreate DateDate80
33OJDTJournal Entry26CreateDateRecording DateDate80
34OJSTTDS Adjustment8CreateDateCreation DateDate80
35OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material7CreateDateDate of Rule GenerationDate80
36OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses7CreateDateDate of Rule GenerationDate80
37OSHRShareholder's Rights and Interests Report History5CreateDateReport Created onDate80
TOPInventory and Production
38AITBItem Groups - History49createDateCreation Date - HistoryDate80
39AITMItems - History166CreateDateProduction DateDate80
40AITTProduct Tree - History6CreateDateCreation DateDate80
41AITWItems - Warehouse - History50createDateCreation Date - HistoryDate80
42AMRVInventory Revaluation - History12CreateDateCreation DateDate80
43APKLPick List - History14CreateDateCreation DateDate80
44AWHSWarehouses - History56createDateCreation Date - HistoryDate80
45AWORProduction Order - History26CreateDateCreation DateDate80
46LIVI1IVI Log Array File3CreateDateCreate DateDate80
47OAIMArchive Inventory Message24CreateDateCreation DateDate80
48OBTNBatch Numbers Master Data11CreateDateCreation DateDate80
49ODBNBat. Nos - Draft - Master Data11CreateDateCreation DateDate80
50ODSNSNs - Draft - Master Data11CreateDateCreation DateDate80
51OENTShipping Types33CreateDateCreation DateDate80
52OIBTBatch No. for Item19CreateDateCreation DateDate80
53OIGEGoods Issue65CreateDateCreation DateDate80
54OIGNGoods Receipt65CreateDateCreation DateDate80
55OILMInventory Log Message34CreateDateCreation DateDate80
56OINMWhse Journal54CreateDateCreation DateDate80
57OIPFLanded Costs39CreateDateCreation DateDate80
58OIQIInventory Initial Quantity2CreateDateCreation DateDate80
59OIQRInventory Stock Posting (Reconcile)2CreateDateCreation DateDate80
60OITBItem Groups49createDateCreation Date - HistoryDate80
61OITLInventory Transactions Log23CreateDateCreation DateDate80
62OITMItems166CreateDateProduction DateDate80
63OITTProduct Tree6CreateDateCreation DateDate80
64OITWItems - Warehouse50createDateCreation Date - HistoryDate80
65OIVLWhse Journal22CreateDateCreation DateDate80
66OMRLAdvanced Inventory Revaluation19CreateDateCreation DateDate80
67OMRVInventory Revaluation12CreateDateCreation DateDate80
68OPKLPick List14CreateDateCreation DateDate80
69OSRISerial Numbers for Items19CreateDateCreation DateDate80
70OSRNSerial Numbers Master Data11CreateDateCreation DateDate80
71OWHSWarehouses56createDateCreation Date - HistoryDate80
72OWKOProduction Instructions19CreateDateCreation DateDate80
73OWORProduction Order26CreateDateCreation DateDate80
74OWTRInventory Transfer65CreateDateCreation DateDate80
75UILMIVI Inventory Log Message34CreateDateCreation DateDate80
76UITMItems166CreateDateProduction DateDate80
77UITWItems - Warehouse50createDateCreation Date - HistoryDate80
78UIVLWhse Journal22CreateDateCreation DateDate80
79UWKOProduction Instructions19CreateDateCreation DateDate80
80UWORProduction Order26CreateDateCreation DateDate80
TOPMarketing Documents
81ADOCInvoice - History65CreateDateCreation DateDate80
82ATXITax Invoice - History11CreateDateCreation DateDate80
83OCINA/R Correction Invoice65CreateDateCreation DateDate80
84OCPIA/P Correction Invoice65CreateDateCreation DateDate80
85OCPVA/P Correction Invoice Reversal65CreateDateCreation DateDate80
86OCSIA/R Correction Invoice65CreateDateCreation DateDate80
87OCSVA/R Correction Invoice Reversal65CreateDateCreation DateDate80
88ODLNDelivery65CreateDateCreation DateDate80
89ODPIA/R Down Payment65CreateDateCreation DateDate80
90ODPOA/P Down Payment65CreateDateCreation DateDate80
91ODRFDrafts65CreateDateCreation DateDate80
92ODWZDunning Wizard4CreateDateCreation DateDate80
93OIEIIncoming Excise Invoice65CreateDateCreation DateDate80
94OINVA/R Invoice65CreateDateCreation DateDate80
95OOEIOutgoing Excise Invoice65CreateDateCreation DateDate80
96OPCHA/P Invoice65CreateDateCreation DateDate80
97OPDNGoods Receipt PO65CreateDateCreation DateDate80
98OPORPurchase Order65CreateDateCreation DateDate80
99OQUTSales Quotation65CreateDateCreation DateDate80
100ORDNReturns65CreateDateCreation DateDate80
101ORDRSales Order65CreateDateCreation DateDate80
102ORINA/R Credit Memo65CreateDateCreation DateDate80
103ORPCA/P Credit Memo65CreateDateCreation DateDate80
104ORPDGoods Return65CreateDateCreation DateDate80
105OSALOutgoing33CreateDateCreation DateDate80
106OTPIPurchase Tax Invoice11CreateDateCreation DateDate80
107OTRATransition33CreateDateCreation DateDate80
108OTSISales Tax Invoice11CreateDateCreation DateDate80
109OTXDTax Invoice Draft11CreateDateCreation DateDate80
110OWDDDocs. for Confirmation11CreateDateProduction DateDate80
111WDD1Documents for Approval - Authorizers7CreateDateRequest DateDate80
TOPReports
112OLLRElectronic Report Generation Result3CreateDateCreation DateDate80
113RDOCDocument52CreateDateCreation DateDate80
114XROBJXLR Company Report Objects5CreateDateCreation DateDate80
TOPService
115AINSCustomer Equipment Card - History39createDateCreation DateDate80
116ASC1Service Call Solutions - History7createDateCreation Date - HistoryDate80
117ASC2Service Call Inventory Expenses - History15CreateDateCreation Date - HistoryDate80
118ASC3Service Call Travel/Labor Expenses - History15CreateDateCreation DateDate80
119ASC4Service Call Travel/Labor Expenses - History10CreateDateCreation DateDate80
120ASC5Service Call Activities - History7CreateDateCreation DateDate80
121ASCLHistory27createDateCreation DateDate80
122OCTRService Contracts45CreateDateCreation DateDate80
123OCTTContract Template37CreateDateCreation DateDate80
124OINSCustomer Equipment Card39createDateCreation DateDate80
125OREQExternal System Call Request4CreateDateRequest Creation DateDate80
126OSCLService Calls27createDateCreation DateDate80
127QUE2Queue Elements6createDateCreation DateDate80
128SCL1Service Call Solutions - Rows7createDateCreation DateDate80
129SCL2Service Call Inventory Expenses15CreateDateCreation DateDate80
130SCL3Service Call Travel/Labor Expenses15CreateDateCreation DateDate80
131SCL4Expense Documents10CreateDateCreation DateDate80
132SCL5Service Call Activities7CreateDateCreation DateDate80