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

221 columns | Print definition?B1 9.2  | CREATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1APJTProject Plan7CreateDateProduction DateDate80
2AUSRArchive Users - History69createDateCreation DateDate80
3ODARData Archiving4CreateDateArchive DateDate80
4ODGPDocument Generation Parameter Sets4CreateDateCreation DateDate80
5ODOWData Ownership - Objects7CreateDateCreation DateDate80
6ODOXData Ownership - Exceptions6CreateDateCreation DateDate80
7OMDCMaster Data Cleanup3CreateDateCreate DateDate80
8OPJTProject Plan7CreateDateProduction DateDate80
9OPQWPurchase Quotation Generation: Parameter Sets4CreateDateCreation DateDate80
10OTRNMultilingual Service Table6CreateDateCreate DateDate80
11OUSRUsers69createDateCreation Date - HistoryDate80
12OWFERWorkflow Error Message4CreateDateCreate Date - HistoryDate80
13OWINWorkflow Engine Information9CreateDateCreate DateDate80
TOPBanking
14ABOEBill of Exchange for Payment - History29CreateDateCreation DateDate80
15ACHOChecks for Payment - History32CreateDateCreation DateDate80
16ARCTIncoming Payment - History59CreateDateCreation DateDate80
17OBOEBill of Exchange for Payment29CreateDateCreation DateDate80
18OCHDChecks for Payment Drafts32CreateDateCreation DateDate80
19OCHOChecks for Payment32CreateDateCreation DateDate80
20OCRHCredit Card Management36CreateDateCreation DateDate80
21ODPSDeposit28CreateDateCreation DateDate80
22OITRInternal Reconciliation12CreateDateCreation DateDate80
23OMTHReconciliation History12createDateCreation DateDate80
24OPDFPayment Draft59CreateDateCreation DateDate80
25OPYMPayment Methods for Payment Wizard17CreateDateCreation DateDate80
26ORCTIncoming Payment59CreateDateCreation DateDate80
27OSVRSaved Reconciliations6createDateCreation DateDate80
28OTPWTax Payment Wizard5CreateDateWizard Creation DateDate80
29OVPMOutgoing Payments59CreateDateCreation DateDate80
TOPBusiness Partners
30ACPNCampaign18CreateDateCreate DateDate80
31ACRDBusiness Partners - History132CreateDateCreation DateDate80
32AOATBlanket Agreement22CreateDateCreate DateDate80
33OCPNCampaign18CreateDateCreate DateDate80
34OCRDBusiness Partner132CreateDateCreation DateDate80
35OOATBlanket Agreement22CreateDateCreate DateDate80
TOPFinance
36AACSAsset Classes - History9CreateDateCreate DateDate80
37AACTG/L Account - History38CreateDateCreation DateDate80
38AADTFixed Assets Account Determination - History22CreateDateCreation DateDate80
39ADPAFixed Asset Depreciation Areas - History10CreateDateCreation DateDate80
40ADTPFixed Assets Depreciation Types - History33CreateDateCreate DateDate80
41AFADAsset Document - History23CreateDateCreate DateDate80
42AGARG/L Account Advanced Rules - History26CreateDateCreation DateDate80
43AJDTJournal Entry - History26CreateDateCreation DateDate80
44CASEInternal Recon. Upgrade 2007A2CreateDateCreation DateDate80
45OACDCredit Memo23CreateDateCreate DateDate80
46OACQCapitalization23CreateDateCreate DateDate80
47OACSAsset Classes9CreateDateCreate DateDate80
48OACTG/L Accounts38CreateDateCreation DateDate80
49OADTFixed Assets Account Determination22CreateDateCreation DateDate80
50OBTFJournal Voucher Entry26CreateDateRecording DateDate80
51OCFHCash Flow Statement History5CreateDateRecording DateDate80
52ODPAFixed Asset Depreciation Areas10CreateDateCreation DateDate80
53ODTPFixed Assets Depreciation Types33CreateDateCreate DateDate80
54OFAAAsset Attributes6CreateDateCreation DateDate80
55OFACFixed Asset Parameter Change5CreateDateCreate DateDate80
56OFAMFixed Asset Data Migration3CreateDateMigration Run DateDate80
57OFTRTransfer23CreateDateCreate DateDate80
58OGARG/L Account Advanced Rules26CreateDateCreation DateDate80
59OGBIGB Interface: Common Info7CreateDateReport Creation DatenVarChar80
60OIWZInflation Wizard31CreateDateCreate DateDate80
61OJDTJournal Entry26CreateDateRecording DateDate80
62OJSTTDS Adjustment8CreateDateCreation DateDate80
63OMDPManual Depreciation23CreateDateCreate DateDate80
64ORTIRetirement23CreateDateCreate DateDate80
65OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material7CreateDateDate of Rule GenerationDate80
66OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses7CreateDateDate of Rule GenerationDate80
67OSHRShareholder's Rights and Interests Report History5CreateDateReport Created onDate80
TOPGeneral
68AGRSG/L Account Advanced Rules for Resources - History26CreateDateCreation DateDate80
69AHF1Hide Functions Configuration - Rows History15CreateDateCreation DateDate80
70AHF2Hide Function Configuration - Rows History11CreateDateCreation DateDate80
71AHFCHide Functions Configuration - History10CreateDateCreation DateDate80
72ARSBResource Groups - History8createDateCreation Date - HistoryDate80
73ARSCResource Master Data - Log101CreateDateDate of CreationDate80
74HFC1Hide Functions Configuration - Rows15CreateDateCreation DateDate80
75HFC2Hide Function Configuration - Rows11CreateDateCreation DateDate80
76NFN5NF Skipped Numbers9CreateDateCreation DateDate80
77OBTABrazil - Tax Adjustment45CreateDateCreation DateDate80
78OBVLSerial Numbers and Batch Valuation Log9CreateDateGeneration DateDate80
79OGPAGross Profit Adjustment3CreateDateCreate DateDate80
80OGRSG/L Account Advanced Rules for Resources26CreateDateCreation DateDate80
81OHFCHide Functions Configuration10CreateDateCreation DateDate80
82OHMMSAP HANA Model Management10CreateDateCreated at DatenVarChar1000
83OKPIKey Performance Indicator Package20CreateDateCreate DateDate80
84OKPSKPI Set5CreateDateCreate Date - HistoryDate80
85ONCPNew Cockpit Page5CreateDateCreate DateDate80
86ORSBResource Groups8createDateCreation Date - HistoryDate80
87ORSCResources101CreateDateDate of CreationDate80
88OWPKDashboard Packages8CreateDateCreate DateDate80
89RADMResource Administration11CreateDateCreation Date of DBDate80
90RAMIRAMI15CreateDateCreation dateDate80
91UBVLSerial Numbers and Batch Valuation Log9CreateDateGeneration DateDate80
92WOBJObject Wizard41CreateDateCreation dateDate80
93WORFObject Wizard Related Files11CreateDateCreation dateDate80
TOPInventory and Production
94ABATAttribute - History9CreateDateCreate DateDate80
95ABFCBin Field Configuration - History11CreateDateCreation DateDate80
96ABINBin Location - History49CreateDateCreate DateDate80
97ABSLWarehouse Sublevel - History10CreateDateCreation DateDate80
98ABTNBatch Numbers Master Data11CreateDateCreation DateDate80
99AEDGDiscount Groups13CreateDateCreation DateDate80
100AIGWItem Group - Warehouse - History9CreateDateCreate DateDate80
101AINCInventory Counting18CreateDateCreate Date - HistoryDate80
102AIQIInventory Opening Balance2CreateDateCreation DateDate80
103AIQRInventory Posting2CreateDateCreation DateDate80
104AITBItem Groups - History49createDateCreation Date - HistoryDate80
105AITMItems - History166CreateDateProduction DateDate80
106AITTProduct Tree - History6CreateDateCreation DateDate80
107AITWItems - Warehouse - History50createDateCreation Date - HistoryDate80
108AMRVInventory Revaluation - History12CreateDateCreation DateDate80
109APKLPick List - History14CreateDateCreation DateDate80
110APLNPrice Lists17CreateDateCreation DateDate80
111ASPPSpecial Prices13CreateDateCreation DateDate80
112ASRNSerial Numbers Master Data11CreateDateCreation DateDate80
113AUGPUoM Group10CreateDateCreation DateDate80
114AUOMUoM Master Data10CreateDateCreation DateDate80
115AWHSWarehouses - History56createDateCreation Date - HistoryDate80
116AWORProduction Order - History26CreateDateCreation DateDate80
117LIVI1IVI Log Array File3CreateDateCreate DateDate80
118OAIMArchive Inventory Message24CreateDateCreation DateDate80
119OBATBin Location Attribute9CreateDateCreate DateDate80
120OBCDBar Code Master Data11CreateDateCreation DateDate80
121OBFCBin Field Configuration11CreateDateCreation DateDate80
122OBINBin Location49CreateDateCreate DateDate80
123OBSLWarehouse Sublevel10CreateDateCreation DateDate80
124OBTNBatch Numbers Master Data11CreateDateCreation DateDate80
125ODBNBat. Nos - Draft - Master Data11CreateDateCreation DateDate80
126ODSNSNs - Draft - Master Data11CreateDateCreation DateDate80
127OEDGDiscount Groups13CreateDateCreation DateDate80
128OENTShipping Types33CreateDateCreation DateDate80
129OICDInventory Counting Draft18CreateDateCreate Date - HistoryDate80
130OIGEGoods Issue65CreateDateCreation DateDate80
131OIGNGoods Receipt65CreateDateCreation DateDate80
132OIGWItem Group - Warehouse9CreateDateCreate DateDate80
133OILMInventory Log Message34CreateDateCreation DateDate80
134OINCInventory Counting18CreateDateCreate Date - HistoryDate80
135OIODInventory Opening Balance Draft2CreateDateCreation DateDate80
136OIPDInventory Posting Draft2CreateDateCreation DateDate80
137OIPFLanded Costs39CreateDateCreation DateDate80
138OIQIInventory Opening Balance2CreateDateCreation DateDate80
139OIQRInventory Posting2CreateDateCreation DateDate80
140OITBItem Groups49createDateCreation Date - HistoryDate80
141OITLInventory Transactions Log23CreateDateCreation DateDate80
142OITMItems166CreateDateProduction DateDate80
143OITTProduct Tree6CreateDateCreation DateDate80
144OITWItems - Warehouse50createDateCreation Date - HistoryDate80
145OIVLWhse Journal22CreateDateCreation DateDate80
146OMRLAdvanced Inventory Revaluation19CreateDateCreation DateDate80
147OMRVInventory Revaluation12CreateDateCreation DateDate80
148OPKLPick List14CreateDateCreation DateDate80
149OPLNPrice Lists17CreateDateCreation DateDate80
150ORTLResource Transaction Log14CreateDateCreation DateDate80
151OSPPSpecial Prices13CreateDateCreation DateDate80
152OSRNSerial Numbers Master Data11CreateDateCreation DateDate80
153OUGPUoM Group10CreateDateCreation DateDate80
154OUOMUoM Master Data10CreateDateCreation DateDate80
155OWHSWarehouses56createDateCreation Date - HistoryDate80
156OWKOProduction Instructions19CreateDateCreation DateDate80
157OWORProduction Order26CreateDateCreation DateDate80
158OWTQInventory Transfer Request65CreateDateCreation DateDate80
159OWTRInventory Transfer65CreateDateCreation DateDate80
160SITMItems166CreateDateProduction DateDate80
161SITWItems - Warehouse50createDateCreation Date - HistoryDate80
162SIVLWhse Journal22CreateDateCreation DateDate80
163UBTNBatch Numbers Master Data11CreateDateCreation DateDate80
164UILMIVI Inventory Log Message34CreateDateCreation DateDate80
165UITMItems166CreateDateProduction DateDate80
166UITWItems - Warehouse50createDateCreation Date - HistoryDate80
167UIVLWhse Journal22CreateDateCreation DateDate80
168USRNSerial Numbers Master Data11CreateDateCreation DateDate80
169UWKOProduction Instructions19CreateDateCreation DateDate80
170UWORProduction Order26CreateDateCreation DateDate80
TOPMarketing Documents
171ADOCInvoice - History65CreateDateCreation DateDate80
172ATXITax Invoice - History11CreateDateCreation DateDate80
173OCINA/R Correction Invoice65CreateDateCreation DateDate80
174OCPIA/P Correction Invoice65CreateDateCreation DateDate80
175OCPVA/P Correction Invoice Reversal65CreateDateCreation DateDate80
176OCSIA/R Correction Invoice65CreateDateCreation DateDate80
177OCSVA/R Correction Invoice Reversal65CreateDateCreation DateDate80
178ODLNDelivery65CreateDateCreation DateDate80
179ODPIA/R Down Payment65CreateDateCreation DateDate80
180ODPOA/P Down Payment65CreateDateCreation DateDate80
181ODRFDrafts65CreateDateCreation DateDate80
182ODWZDunning Wizard4CreateDateCreation DateDate80
183OGTIGTS Invoice2CreateDateCreate DateDate80
184OGTMGTS Mapping Object2CreateDateCreate DateDate80
185OIEIIncoming Excise Invoice65CreateDateCreation DateDate80
186OINVA/R Invoice65CreateDateCreation DateDate80
187OIVMGTS Invoice Mapping Object2CreateDateCreate DateDate80
188OOEIOutgoing Excise Invoice65CreateDateCreation DateDate80
189OPCHA/P Invoice65CreateDateCreation DateDate80
190OPDNGoods Receipt PO65CreateDateCreation DateDate80
191OPORPurchase Order65CreateDateCreation DateDate80
192OPQTPurchase Quotation65CreateDateCreation DateDate80
193OPRQPurchase Request65CreateDateCreation DateDate80
194OQUTSales Quotation65CreateDateCreation DateDate80
195ORCPRecurring Transaction Template13CreateDateCreation DateDate80
196ORDNReturns65CreateDateCreation DateDate80
197ORDRSales Order65CreateDateCreation DateDate80
198ORINA/R Credit Memo65CreateDateCreation DateDate80
199ORPCA/P Credit Memo65CreateDateCreation DateDate80
200ORPDGoods Return65CreateDateCreation DateDate80
201OSALOutgoing33CreateDateCreation DateDate80
202OTPIPurchase Tax Invoice11CreateDateCreation DateDate80
203OTRATransition33CreateDateCreation DateDate80
204OTSISales Tax Invoice11CreateDateCreation DateDate80
205OTXDTax Invoice Draft11CreateDateCreation DateDate80
206OWDDDocs. for Confirmation11CreateDateProduction DateDate80
207WDD1Documents for Approval - Authorizers7CreateDateRequest DateDate80
TOPReports
208AEC1Parameters for Various Types of Electronic Communication10CreateDateCreation DateDate80
209AEC2Electronic Transactions26CreateDateCreation DateDate80
210AEC3Statuses and Logs for Actions in Electronic Communication5CreateDateCreation DateDate80
211ATHLThresholds9CreateDateCreation DateDate80
212ECM1Parameters for Various Types of Electronic Communication10CreateDateCreation DateDate80
213ECM2Electronic Transactions26CreateDateCreation DateDate80
214ECM3Statuses and Logs for Actions in Electronic Communication5CreateDateCreation DateDate80
215OEBLE-Balance4CreateDateCreate DateDate80
216OLLRElectronic Report Generation Result3CreateDateCreation DateDate80
217OTHLThresholds9CreateDateCreation DateDate80
218OTRBTax Report Wizard for Brazil16CreateDateCreation DateDate80
219RDC1Multilingual Report6CreateDateCreate DateDate80
220RDOCDocument52CreateDateCreation DateDate80
221XROBJXLR Company Report Objects5CreateDateCreation DateDate80