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

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