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

297 columns | Print definition?B1 9.3  | CREATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1APFSPersonal Fields Setup - History9CreateDateCreation DateDate80
2APJTProject Plan7CreateDateProduction DateDate80
3ARSTRoute Stages - History6CreateDateCreation DateDate80
4AUSRUsers - History69createDateCreation DateDate80
5OBPDBlocked Personal Data14CreateDateCreation DateDate80
6ODARData Archiving4CreateDateArchive DateDate80
7ODGPDocument Generation Parameter Sets4CreateDateCreation DateDate80
8ODOWData Ownership - Objects7CreateDateCreation DateDate80
9ODOXData Ownership - Exceptions6CreateDateCreation DateDate80
10OMDCMaster Data Cleanup3CreateDateCreate DateDate80
11OPFSPersonal Fields Setup9CreateDateCreation DateDate80
12OPJTProject Plan7CreateDateProduction DateDate80
13OPQWPurchase Quotation Generation: Parameter Sets4CreateDateCreation DateDate80
14ORSTRoute Stages6CreateDateCreation DateDate80
15OTRNMultilingual Service Table6CreateDateCreate DateDate80
16OUSRUsers69createDateCreation Date - HistoryDate80
17OWFERWorkflow Error Message4CreateDateCreate Date - HistoryDate80
18OWINWorkflow Engine Information9CreateDateCreate DateDate80
TOPBanking
19ABOEBill of Exchange for Payment - History29CreateDateCreation DateDate80
20ACHOChecks for Payment - History32CreateDateCreation DateDate80
21ARCTIncoming Payment - History59CreateDateCreation DateDate80
22OBNKExternal Bank Statement Received73CreateDateCreation DateDate80
23OBOEBill of Exchange for Payment29CreateDateCreation DateDate80
24OCHDChecks for Payment Drafts32CreateDateCreation DateDate80
25OCHOChecks for Payment32CreateDateCreation DateDate80
26OCRHCredit Card Management36CreateDateCreation DateDate80
27ODPSDeposit28CreateDateCreation DateDate80
28OITRInternal Reconciliation12CreateDateCreation DateDate80
29OMTHReconciliation History12createDateCreation DateDate80
30OPDFPayment Draft59CreateDateCreation DateDate80
31OPYMPayment Methods for Payment Wizard17CreateDateCreation DateDate80
32ORCTIncoming Payment59CreateDateCreation DateDate80
33OSVRSaved Reconciliations6createDateCreation DateDate80
34OTPWTax Payment Wizard5CreateDateWizard Creation DateDate80
35OVPMOutgoing Payments59CreateDateCreation DateDate80
TOPBusiness Partners
36ACLGActivities - History93CreateDateCreation DateDate80
37ACPNCampaign18CreateDateCreate DateDate80
38ACPRContact Persons - History49CreateDateCreation DateDate80
39ACR1Business Partner Addresses - History31CreateDateCreation DateDate80
40ACRDBusiness Partners - History132CreateDateCreation DateDate80
41AOATBlanket Agreement22CreateDateCreate DateDate80
42CRD1Business Partners - Addresses31CreateDateCreation DateDate80
43OCLGActivities93CreateDateCreation DateDate80
44OCPNCampaign18CreateDateCreate DateDate80
45OCPRContact Persons49CreateDateCreation DateDate80
46OCRDBusiness Partner132CreateDateCreation DateDate80
47OOATBlanket Agreement22CreateDateCreate DateDate80
TOPFinance
48AACSAsset Classes - History9CreateDateCreate DateDate80
49AACTG/L Account - History38CreateDateCreation DateDate80
50AADTFixed Assets Account Determination - History22CreateDateCreation DateDate80
51ADPAFixed Asset Depreciation Areas - History10CreateDateCreation DateDate80
52ADTPFixed Assets Depreciation Types - History33CreateDateCreate DateDate80
53AFADAsset Document - History23CreateDateCreate DateDate80
54AGARG/L Account Advanced Rules - History26CreateDateCreation DateDate80
55AJDTJournal Entry - History26CreateDateCreation DateDate80
56CASEInternal Recon. Upgrade 2007A2CreateDateCreation DateDate80
57OACDCredit Memo23CreateDateCreate DateDate80
58OACQCapitalization23CreateDateCreate DateDate80
59OACSAsset Classes9CreateDateCreate DateDate80
60OACTG/L Accounts38CreateDateCreation DateDate80
61OADTFixed Assets Account Determination22CreateDateCreation DateDate80
62OBTFJournal Voucher Entry26CreateDateRecording DateDate80
63OCFHCash Flow Statement History5CreateDateRecording DateDate80
64ODPAFixed Asset Depreciation Areas10CreateDateCreation DateDate80
65ODTPFixed Assets Depreciation Types33CreateDateCreate DateDate80
66OFAAAsset Attributes6CreateDateCreation DateDate80
67OFACFixed Asset Parameter Change5CreateDateCreate DateDate80
68OFAMFixed Asset Data Migration3CreateDateMigration Run DateDate80
69OFTRTransfer23CreateDateCreate DateDate80
70OGARG/L Account Advanced Rules26CreateDateCreation DateDate80
71OGBIGB Interface: Common Info7CreateDateReport Creation DatenVarChar80
72OIWZInflation Wizard31CreateDateCreate DateDate80
73OJDTJournal Entry26CreateDateRecording DateDate80
74OJSTTDS Adjustment8CreateDateCreation DateDate80
75OMDPManual Depreciation23CreateDateCreate DateDate80
76ORTIRetirement23CreateDateCreate DateDate80
77OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material7CreateDateDate of Rule GenerationDate80
78OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses7CreateDateDate of Rule GenerationDate80
79OSHRShareholder's Rights and Interests Report History5CreateDateReport Created onDate80
TOPGeneral
80AGRSG/L Account Advanced Rules for Resources - History26CreateDateCreation DateDate80
81AHF1Hide Functions Configuration - Rows History15CreateDateCreation DateDate80
82AHF2Hide Function Configuration - Rows History11CreateDateCreation DateDate80
83AHFCHide Functions Configuration - History10CreateDateCreation DateDate80
84AIRIInput Service Distribution - Recipient Invoice22CreateDateCreate DateDate80
85AIRRInput Service Distribution - Recipient Credit Memo22CreateDateCreate DateDate80
86AISCInput Service Distribution - Credit Memo24CreateDateCreate DateDate80
87AISDInput Service Distribution18CreateDateCreate DateDate80
88AISIInput Service Distribution - Invoice24CreateDateCreate DateDate80
89APHAProject Management Subproject - History21CreateDateProduction DateDate80
90APMGProject Management Document - History30CreateDateProduction DateDate80
91ARSBResource Groups - History8createDateCreation Date - HistoryDate80
92ARSCResource Master Data - Log101CreateDateDate of CreationDate80
93ATSHProject Management Time Sheet - Header - History15CreateDateProduction DateDate80
94HFC1Hide Function Configuration - Rows15CreateDateCreation DateDate80
95HFC2Hide Function Configuration - Rows11CreateDateCreation DateDate80
96NFN5NF Skipped Numbers9CreateDateCreation DateDate80
97OBTABrazil - Tax Adjustment45CreateDateCreation DateDate80
98OBVLSerial Numbers and Batch Valuation Log9CreateDateGeneration DateDate80
99OGPAGross Profit Adjustment3CreateDateCreate DateDate80
100OGRSG/L Account Advanced Rules for Resources26CreateDateCreation DateDate80
101OHFCHide Functions Configuration10CreateDateCreation DateDate80
102OHMMSAP HANA Model Management10CreateDateCreated at DatenVarChar1000
103OIRIInput Service Distribution - Recipient Invoice22CreateDateCreate DateDate80
104OIRRInput Service Distribution - Recipient Credit Memo22CreateDateCreate DateDate80
105OISCInput Service Distribution - Credit Memo24CreateDateCreate DateDate80
106OISDInput Service Distribution18CreateDateCreate DateDate80
107OISIInput Service Distribution - Invoice24CreateDateCreate DateDate80
108OKPIKey Performance Indicator Package20CreateDateCreate DateDate80
109OKPSKPI Set5CreateDateCreate Date - HistoryDate80
110ONCPNew Cockpit Table5CreateDateCreate DateDate80
111OPHAProject Management Subproject21CreateDateProduction DateDate80
112OPMGProject Management Document30CreateDateProduction DateDate80
113OPMXPayroll7CreateDateCreation DateDate80
114ORSBResource Groups8createDateCreation Date - HistoryDate80
115ORSCResources101CreateDateDate of CreationDate80
116OTSHProject Management Time Sheet - Header15CreateDateProduction DateDate80
117OWPKDashboard Packages8CreateDateCreate DateDate80
118RADMResource Administration11CreateDateCreation Date of DBDate80
119RAMIRAMI15CreateDateCreation dateDate80
120UBVLSerial Numbers and Batch Valuation Log9CreateDateGeneration DateDate80
121WOBJObject Wizard41CreateDateCreation dateDate80
122WORFObject Wizard Related Files11CreateDateCreation dateDate80
TOPHuman Resources
123AHEMEmployees - History131CreateDateCreation DateDate80
124OHEMEmployees131CreateDateCreation DateDate80
TOPInventory and Production
125ABATAttribute - History9CreateDateCreate DateDate80
126ABFCBin Field Configuration - History11CreateDateCreation DateDate80
127ABINBin Location - History49CreateDateCreate DateDate80
128ABSLWarehouse Sublevel - History10CreateDateCreation DateDate80
129ABTNBatch Numbers Master Data11CreateDateCreation DateDate80
130AEDGDiscount Groups13CreateDateCreation DateDate80
131AIGWItem Group - Warehouse - History9CreateDateCreate DateDate80
132AINCInventory Counting18CreateDateCreate Date - HistoryDate80
133AIQIInventory Opening Balance2CreateDateCreation DateDate80
134AIQRInventory Posting2CreateDateCreation DateDate80
135AITBItem Groups - History49createDateCreation Date - HistoryDate80
136AITMItems - History166CreateDateProduction DateDate80
137AITTProduct Tree - History5CreateDateCreation DateDate80
138AITWItems - Warehouse - History50createDateCreation Date - HistoryDate80
139AMRVInventory Revaluation - History12CreateDateCreation DateDate80
140APKLPick List - History14CreateDateCreation DateDate80
141APLNPrice Lists17CreateDateCreation DateDate80
142ASPPSpecial Prices13CreateDateCreation DateDate80
143ASRNSerial Numbers Master Data11CreateDateCreation DateDate80
144ATSPTransporters7CreateDateCreation DateDate80
145AUGPUoM Group10CreateDateCreation DateDate80
146AUOMUoM Master Data10CreateDateCreation DateDate80
147AWHSWarehouses - History56createDateCreation Date - HistoryDate80
148AWORProduction Order - History25CreateDateCreation DateDate80
149LIVI1IVI Log Array File3CreateDateCreate DateDate80
150OAIMArchive Inventory Message24CreateDateCreation DateDate80
151OBATBin Location Attribute9CreateDateCreate DateDate80
152OBCDBar Code Master Data11CreateDateCreation DateDate80
153OBFCBin Field Configuration11CreateDateCreation DateDate80
154OBINBin Location49CreateDateCreate DateDate80
155OBSLWarehouse Sublevel10CreateDateCreation DateDate80
156OBTNBatch Numbers Master Data11CreateDateCreation DateDate80
157ODBNBat. Nos - Draft - Master Data11CreateDateCreation DateDate80
158ODSNSNs - Draft - Master Data11CreateDateCreation DateDate80
159OEDGDiscount Groups13CreateDateCreation DateDate80
160OENTShipping Types33CreateDateCreation DateDate80
161OICDInventory Counting Draft18CreateDateCreate Date - HistoryDate80
162OIGEGoods Issue65CreateDateCreation DateDate80
163OIGNGoods Receipt65CreateDateCreation DateDate80
164OIGWItem Group - Warehouse9CreateDateCreate DateDate80
165OILMInventory Log Message34CreateDateCreation DateDate80
166OINCInventory Counting18CreateDateCreate Date - HistoryDate80
167OIODInventory Opening Balance Draft2CreateDateCreation DateDate80
168OIPDInventory Posting Draft2CreateDateCreation DateDate80
169OIPFLanded Costs39CreateDateCreation DateDate80
170OIQIInventory Opening Balance2CreateDateCreation DateDate80
171OIQRInventory Posting2CreateDateCreation DateDate80
172OITBItem Groups49createDateCreation Date - HistoryDate80
173OITLInventory Transactions Log23CreateDateCreation DateDate80
174OITMItems166CreateDateProduction DateDate80
175OITTProduct Tree5CreateDateCreation DateDate80
176OITWItems - Warehouse50createDateCreation Date - HistoryDate80
177OIVLWhse Journal22CreateDateCreation DateDate80
178OMRLAdvanced Inventory Revaluation19CreateDateCreation DateDate80
179OMRVInventory Revaluation12CreateDateCreation DateDate80
180OPKLPick List14CreateDateCreation DateDate80
181OPLNPrice Lists17CreateDateCreation DateDate80
182ORTLResource Transaction Log14CreateDateCreation DateDate80
183OSPPSpecial Prices13CreateDateCreation DateDate80
184OSRNSerial Numbers Master Data11CreateDateCreation DateDate80
185OTNLCCD Log22CreateDateCreation DateDate80
186OTSPTransporters7CreateDateCreation DateDate80
187OUGPUoM Group10CreateDateCreation DateDate80
188OUOMUoM Master Data10CreateDateCreation DateDate80
189OWHSWarehouses56createDateCreation Date - HistoryDate80
190OWKOProduction Instructions19CreateDateCreation DateDate80
191OWORProduction Order25CreateDateCreation DateDate80
192OWTQInventory Transfer Request65CreateDateCreation DateDate80
193OWTRInventory Transfer65CreateDateCreation DateDate80
194SITMItems166CreateDateProduction DateDate80
195SITWItems - Warehouse50createDateCreation Date - HistoryDate80
196SIVLWhse Journal22CreateDateCreation DateDate80
197UBTNBatch Numbers Master Data11CreateDateCreation DateDate80
198UILMIVI Inventory Log Message34CreateDateCreation DateDate80
199UITMItems166CreateDateProduction DateDate80
200UITWItems - Warehouse50createDateCreation Date - HistoryDate80
201UIVLWhse Journal22CreateDateCreation DateDate80
202USRNSerial Numbers Master Data11CreateDateCreation DateDate80
203UWKOProduction Instructions19CreateDateCreation DateDate80
204UWORProduction Order25CreateDateCreation DateDate80
TOPMarketing Documents
205ADOCInvoice - History65CreateDateCreation DateDate80
206ATROTransportation Document - History17CreateDateProduction DateDate80
207ATXITax Invoice - History11CreateDateCreation DateDate80
208BAL1Opening Balance Instances11CreateDateCreate DateDate80
209BAL2Period indicators for opening Balance5CreateDateCreate DateDate80
210OBALOpening Balances8CreateDateCreate DateDate80
211OCINA/R Correction Invoice65CreateDateCreation DateDate80
212OCPIA/P Correction Invoice65CreateDateCreation DateDate80
213OCPVA/P Correction Invoice Reversal65CreateDateCreation DateDate80
214OCSIA/R Correction Invoice65CreateDateCreation DateDate80
215OCSVA/R Correction Invoice Reversal65CreateDateCreation DateDate80
216ODLNDelivery65CreateDateCreation DateDate80
217ODPIA/R Down Payment65CreateDateCreation DateDate80
218ODPOA/P Down Payment65CreateDateCreation DateDate80
219ODRFDrafts65CreateDateCreation DateDate80
220ODWZDunning Wizard4CreateDateCreation DateDate80
221OGTIGTS Invoice2CreateDateCreate DateDate80
222OGTMGTS Mapping Object2CreateDateCreate DateDate80
223OIEIIncoming Excise Invoice65CreateDateCreation DateDate80
224OINVA/R Invoice65CreateDateCreation DateDate80
225OIVMGTS Invoice Mapping Object2CreateDateCreate DateDate80
226OOEIOutgoing Excise Invoice65CreateDateCreation DateDate80
227OPCHA/P Invoice65CreateDateCreation DateDate80
228OPDNGoods Receipt PO65CreateDateCreation DateDate80
229OPORPurchase Order65CreateDateCreation DateDate80
230OPQTPurchase Quotation65CreateDateCreation DateDate80
231OPRQPurchase Request65CreateDateCreation DateDate80
232OPRRGoods Return Request65CreateDateCreation DateDate80
233OQUTSales Quotation65CreateDateCreation DateDate80
234ORCPRecurring Transaction Template13CreateDateCreation DateDate80
235ORDNReturns65CreateDateCreation DateDate80
236ORDRSales Order65CreateDateCreation DateDate80
237ORINA/R Credit Memo65CreateDateCreation DateDate80
238ORPCA/P Credit Memo65CreateDateCreation DateDate80
239ORPDGoods Return65CreateDateCreation DateDate80
240ORRRReturn Request65CreateDateCreation DateDate80
241OSALOutgoing33CreateDateCreation DateDate80
242OSFCSelf Credit Memo65CreateDateCreation DateDate80
243OSFISelf Invoice65CreateDateCreation DateDate80
244OTPIPurchase Tax Invoice11CreateDateCreation DateDate80
245OTRATransition33CreateDateCreation DateDate80
246OTROTransportation Document17CreateDateProduction DateDate80
247OTSISales Tax Invoice11CreateDateCreation DateDate80
248OTXDTax Invoice Draft11CreateDateCreation DateDate80
249OWDDDocs. for Confirmation11CreateDateProduction DateDate80
250WDD1Documents for Approval - Authorizers7CreateDateRequest DateDate80
TOPReports
251AEC1Parameters for Various Types of Electronic Communication10CreateDateCreation DateDate80
252AEC2Electronic Transactions28CreateDateCreation DateDate80
253AEC3Statuses and Logs for Actions in Electronic Communication10CreateDateCreation DateDate80
254AEC4Import Mapping Determination10CreateDateCreation DateDate80
255AEC5List of Canceled Reconciliations for Actions in Electronic Communication8CreateDateCreation DateDate80
256AQAGQuery Authorization Groups - Log8CreateDateDate of CreateDate80
257ATHLThresholds9CreateDateCreation DateDate80
258ECM1Parameters for Various Types of Electronic Communication10CreateDateCreation DateDate80
259ECM2Electronic Transactions28CreateDateCreation DateDate80
260ECM3Statuses and Logs for Actions in Electronic Communication10CreateDateCreation DateDate80
261ECM4Import Mapping Determination10CreateDateCreation DateDate80
262ECM5List of Related Documents for Actions in Electronic Communication8CreateDateCreation DateDate80
263IRD1Report Definition - Rows5CreateDateCreation TimestampDate80
264OEBLE-Balance4CreateDateCreate DateDate80
265OGDPGeneral Data Protection Wizard7CreateDateCreation DateDate80
266OIRCInteractive Report Category8CreateDateCreation TimestampDate80
267OIRDReport Definition9CreateDateCreation TimestampDate80
268OLLRElectronic Report Generation Result3CreateDateCreation DateDate80
269OQAGQuery Authorization Groups8CreateDateDate of CreateDate80
270OTHLThresholds9CreateDateCreation DateDate80
271OTRBTax Report Wizard for Brazil16CreateDateCreation DateDate80
272RDC1Multilingual Report6CreateDateCreate DateDate80
273RDOCDocument52CreateDateCreation DateDate80
274XROBJXLR Company Report Objects5CreateDateCreation DateDate80
TOPSales Opportunities
275ACEMCost Element7CreateDateCreation DateDate80
276AOPROpportunity57CreateDateCreation DateDate80
277OCEMCost Element7CreateDateCreation DateDate80
278OOPROpportunity57CreateDateCreation DateDate80
TOPService
279ACTRService Contracts45CreateDateCreation DateDate80
280AINSCustomer Equipment Card - History39createDateCreation DateDate80
281ASC1Service Call Solutions - History7createDateCreation Date - HistoryDate80
282ASC2Service Call Inventory Expenses - History15CreateDateCreation Date - HistoryDate80
283ASC3Service Call Travel/Labor Expenses - History15CreateDateCreation DateDate80
284ASC4Service Call Travel/Labor Expenses - History10CreateDateCreation DateDate80
285ASC5Service Call Activities - History7CreateDateCreation DateDate80
286ASCLHistory27createDateCreation DateDate80
287OCTRService Contracts45CreateDateCreation DateDate80
288OCTTContract Template37CreateDateCreation DateDate80
289OINSCustomer Equipment Card39createDateCreation DateDate80
290OREQExternal System Call Request4CreateDateRequest Creation DateDate80
291OSCLService Calls27createDateCreation DateDate80
292QUE2Queue Elements6createDateCreation DateDate80
293SCL1Service Call Solutions - Rows7createDateCreation DateDate80
294SCL2Service Call Inventory Expenses15CreateDateCreation DateDate80
295SCL3Service Call Travel/Labor Expenses15CreateDateCreation DateDate80
296SCL4Expense Documents10CreateDateCreation DateDate80
297SCL5Service Call Activities7CreateDateCreation DateDate80