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

280 tablesB1 9.2 

General
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.2ACPA151Periods Category - WIP Mapping - LogGeneral
2Business One9.2ADRC91G/L Account Determination Criteria - Resources - HistoryGeneral
3Business One9.2AGRS551G/L Account Advanced Rules for Resources - HistoryGeneral
4Business One9.2AHF1171Hide Functions Configuration - Rows HistoryGeneral
5Business One9.2AHF2131Hide Function Configuration - Rows HistoryGeneral
6Business One9.2AHFC121Hide Functions Configuration - HistoryGeneral
7Business One9.2AMR3171Inventory Revaluation SNBGeneral
8Business One9.2ARPA72Routing Permission AreasGeneral
9Business One9.2ARPR72Routing PermissionsGeneral
10Business One9.2ARSB322Resource Groups - HistoryGeneral
11Business One9.2ARSC1195Resource Master Data - LogGeneral
12Business One9.2ARSC152Resources - Warehouses - LogGeneral
13Business One9.2ARSC2144Resources - Prices - LogGeneral
14Business One9.2ARSC332Resouces - Fixed Assets - LogGeneral
15Business One9.2ARSC431Resources - Employees - LogGeneral
16Business One9.2ARSC541Resources - Preferred Vendors - LogGeneral
17Business One9.2ARSC691Resources - Daily Capacities - LogGeneral
18Business One9.2ARST152Route Stages - HistoryGeneral
19Business One9.2CCFG91Company ConfigurationGeneral
20Business One9.2CDIC31DictionaryGeneral
21Business One9.2CFN151Default Common FunctionsGeneral
22Business One9.2CFUS51Functionality Usage StatisticsGeneral
23Business One9.2CIN11601Correction Invoice - Drawn Dpm DetailGeneral
24Business One9.2COLM642COLM resourceGeneral
25Business One9.2CPA151Periods Category - WIP MappingGeneral
26Business One9.2CPRC31Contact Persons - Communication MeanGeneral
27Business One9.2CPT181Cockpit SubtableGeneral
28Business One9.2CRDC31BP - Commnunication MeanGeneral
29Business One9.2CTNS52Transaction Notification SettingGeneral
30Business One9.2CUL131Customer Usage Statistics LogGeneral
31Business One9.2DAB131Dashboard QueriesGeneral
32Business One9.2DAL181Mapping between form item and dashboard columnGeneral
33Business One9.2DOCR604DOCRGeneral
34Business One9.2EBCFG41EBCFGGeneral
35Business One9.2EBUSR41EBUSRGeneral
36Business One9.2ECLGF41ECLGFGeneral
37Business One9.2ECLGT61ECLGTGeneral
38Business One9.2ECLOG21ECLOGGeneral
39Business One9.2EESUB71EESUBGeneral
40Business One9.2ELCFG41ELCFGGeneral
41Business One9.2EMERR91EMERRGeneral
42Business One9.2EMIDS31EMIDSGeneral
43Business One9.2EMMSG101EMMSGGeneral
44Business One9.2EMSTT41EMSTTGeneral
45Business One9.2EPASM31EPASMGeneral
46Business One9.2EPOPR71EPOPRGeneral
47Business One9.2EPPKG31EPPKGGeneral
48Business One9.2EPPRC51EPPRCGeneral
49Business One9.2EPSRV63EPSRVGeneral
50Business One9.2FND121Folio Numbering - Document SeriesGeneral
51Business One9.2FNS142Folio Numbering - Voided SeriesGeneral
52Business One9.2FORM182FORM resourceGeneral
53Business One9.2HFC1171Hide Functions Configuration - RowsGeneral
54Business One9.2HFC2131Hide Function Configuration - RowsGeneral
55Business One9.2HMM172Child Table of OHMMGeneral
56Business One9.2HMM241Child Table of OHHMGeneral
57Business One9.2HMM341OHMM Child TableGeneral
58Business One9.2ITEM713Item ResourceGeneral
59Business One9.2ITMR1025ITMRGeneral
60Business One9.2KPI171Key Performance Indicator FieldGeneral
61Business One9.2KPI261Key Performance Indicator ScopeGeneral
62Business One9.2KPI3141Key Performance Indicator Parameter or FilterGeneral
63Business One9.2KPI441Key Performance Indicator Discrete ValueGeneral
64Business One9.2KPI541Key Performance Indicator Formula's VariableGeneral
65Business One9.2KPS1332KPI Set Array 1General
66Business One9.2LCL121Localization languagesGeneral
67Business One9.2LGL161Legal Data - RowsGeneral
68Business One9.2LOCL72Localizations TableGeneral
69Business One9.2MDKY101MetaData Tables DKeysGeneral
70Business One9.2MFLD271MetaData Tables FieldsGeneral
71Business One9.2MHKY111MetaData Tables HKeysGeneral
72Business One9.2MRV3171Inventory Revaluation SNBGeneral
73Business One9.2MSG121MSG1General
74Business One9.2MTBL121MetaData TablesGeneral
75Business One9.2MVAL121MetaData Tables Fields ValsGeneral
76Business One9.2NCP171New Cockpit TileGeneral
77Business One9.2NCP241New Cockpit TileGeneral
78Business One9.2NFN5141NF Skipped NumbersGeneral
79Business One9.2OAGM41Arguments for Integration FrameworkGeneral
80Business One9.2OBBI52Brazil Beverage IndexerGeneral
81Business One9.2OBFI51Brazil Fuel IndexerGeneral
82Business One9.2OBNI52Brazil Numeric IndexerGeneral
83Business One9.2OBOB61Business Object BriefGeneral
84Business One9.2OBOD62BIOD Master DataGeneral
85Business One9.2OBOL31Business Object LinkGeneral
86Business One9.2OBTA482Brazil - Tax AdjustmentGeneral
87Business One9.2OBVL351Serial Numbers and Batch Valuation LogGeneral
88Business One9.2OCFN21Common Functions WidgetGeneral
89Business One9.2OCIP52Configuration of Integration PackagesGeneral
90Business One9.2OCMF42Common Functions of Fiori-Style CockpitGeneral
91Business One9.2OCMM32Communication MediaGeneral
92Business One9.2OCPT182Cockpit Main TableGeneral
93Business One9.2OCUC41CUS ConfigurationGeneral
94Business One9.2OCUL41Customer Usage Statistics LogGeneral
95Business One9.2ODAB142DashboardGeneral
96Business One9.2ODAL41Link between dashboard and formGeneral
97Business One9.2ODCC51Dashboard Cache ConfigurationGeneral
98Business One9.2ODRC91G/L Account Determination Criteria - ResourcesGeneral
99Business One9.2ODSL113Schedule Row DetailGeneral
100Business One9.2ODW121Default Open DocumentsGeneral
101Business One9.2OFND32Folio Numbering DocumentsGeneral
102Business One9.2OFNS112Folio Numbering - SeriesGeneral
103Business One9.2OGPA131Gross Profit AdjustmentGeneral
104Business One9.2OGRS551G/L Account Advanced Rules for ResourcesGeneral
105Business One9.2OHFC121Hide Functions ConfigurationGeneral
106Business One9.2OHMM171SAP HANA Model ManagementGeneral
107Business One9.2OKPI231Key Performance Indicator PackageGeneral
108Business One9.2OKPS61KPI SetGeneral
109Business One9.2OLNK41Help LinksGeneral
110Business One9.2ONCP61New Cockpit PageGeneral
111Business One9.2OODW21Open Documents WidgetGeneral
112Business One9.2OPAC51PAC CompaniesGeneral
113Business One9.2OPST32Service Call Problem SubtypeGeneral
114Business One9.2OPTI81Point of IssueGeneral
115Business One9.2ORCJ214Resource Capacity LogGeneral
116Business One9.2ORPA72Routing Permission AreasGeneral
117Business One9.2ORPR72Routing PermissionsGeneral
118Business One9.2ORSB322Resource GroupsGeneral
119Business One9.2ORSC1196ResourcesGeneral
120Business One9.2ORSG32Resource PropertiesGeneral
121Business One9.2ORST152Route StagesGeneral
122Business One9.2OSAB31SocialGeneral
123Business One9.2OSES21OSESGeneral
124Business One9.2OSLD113Schedule Row DetailGeneral
125Business One9.2OSTB31TemplateGeneral
126Business One9.2OSWA251Specific Withholding AmountsGeneral
127Business One9.2OTCN51Tracking NoteGeneral
128Business One9.2OTOF21Tax OfficesGeneral
129Business One9.2OUAL73User Action LogGeneral
130Business One9.2OUGR52Authorization GroupGeneral
131Business One9.2OWDT41Widget TableGeneral
132Business One9.2OWPK192Dashboard PackagesGeneral
133Business One9.2OWWT41WorkbenchGeneral
134Business One9.2OXAP31XAPP Master DataGeneral
135Business One9.2PACT61Pervasive's Insight to ActionGeneral
136Business One9.2PACT161Pervasive's Insight to Actions' SubitemGeneral
137Business One9.2PACT351Pervasive's Insight to Action's Table FieldGeneral
138Business One9.2PUTR51Pre-Upgrade Test ResultGeneral
139Business One9.2PUTR171Pre-Upgrade Test Result LineGeneral
140Business One9.2RADM211Resource AdministrationGeneral
141Business One9.2RAMI245RAMIGeneral
142Business One9.2RCOD61RCODGeneral
143Business One9.2RCON91Connection Map for CR TemplatesGeneral
144Business One9.2RCTR21Update CountersGeneral
145Business One9.2RDCT53DictionaryGeneral
146Business One9.2RDGP1210Development GroupsGeneral
147Business One9.2RDMS72Dictionary MasterGeneral
148Business One9.2RFRM404FORM resourceGeneral
149Business One9.2RFTL724FITL resourceGeneral
150Business One9.2RGRP32users groupsGeneral
151Business One9.2RHKY52HotkeysGeneral
152Business One9.2RINF21Resource InfoGeneral
153Business One9.2RLCK71resource locks tableGeneral
154Business One9.2RLNG143RLNGGeneral
155Business One9.2RLOG113Resource Edit LogGeneral
156Business One9.2RMSG83EditMode MessagesGeneral
157Business One9.2RMTL703MITL resourceGeneral
158Business One9.2RMTX164MATX resourceGeneral
159Business One9.2ROBJ82TM Import/Export ObjGeneral
160Business One9.2ROBL41Resource Object I/E LogGeneral
161Business One9.2RSC152Resources - WarehousesGeneral
162Business One9.2RSC2144Resources - PricesGeneral
163Business One9.2RSC332Resouces - Fixed AssetsGeneral
164Business One9.2RSC431Resources - EmployeesGeneral
165Business One9.2RSC541Resources - Preferred VendorsGeneral
166Business One9.2RSC691Resources - Daily CapacitiesGeneral
167Business One9.2RSDB82Resource DB ListGeneral
168Business One9.2RSLG51Resource Merge LogGeneral
169Business One9.2RSLM21SLIMGeneral
170Business One9.2RSMS42Resource Merged Snapshots ListGeneral
171Business One9.2RSTI83STRI resourceGeneral
172Business One9.2RSTR64STRL resourceGeneral
173Business One9.2RSYS42System StringsGeneral
174Business One9.2RTPL101Translation Problems LogGeneral
175Business One9.2RUSR53Resource UsersGeneral
176Business One9.2SARI411add-ons tableGeneral
177Business One9.2SCAB81Appl CABsGeneral
178Business One9.2SCFG61SCFGGeneral
179Business One9.2SCLC91SCLCGeneral
180Business One9.2SCSP51Stored Procs (Company)General
181Business One9.2SCUC41SCUCGeneral
182Business One9.2SDRC41Drag&Relate - CategoriesGeneral
183Business One9.2SDRF51Drag&Relate - FilesGeneral
184Business One9.2SDRO41Drag&Relate - Output fieldsGeneral
185Business One9.2SDRQ51Drag&Relate - QueriesGeneral
186Business One9.2SDRR31Drag&Relate - ReportsGeneral
187Business One9.2SEULA51SEULAGeneral
188Business One9.2SEVT122SEVTGeneral
189Business One9.2SEWAD72SEWADGeneral
190Business One9.2SEWBU131SEWBUGeneral
191Business One9.2SEWCS421SEWCSGeneral
192Business One9.2SEWDB131SEWDBGeneral
193Business One9.2SEWDQ61SEWDQGeneral
194Business One9.2SEWDV591SEWDVGeneral
195Business One9.2SEWH181SEWH1General
196Business One9.2SEWHW231SEWHWGeneral
197Business One9.2SEWIC411SEWICGeneral
198Business One9.2SEWLA21SEWLAGeneral
199Business One9.2SEWSN51SEWSNGeneral
200Business One9.2SEWST81SEWSTGeneral
201Business One9.2SEWSY61SEWSYGeneral
202Business One9.2SEWU21SEWUGeneral
203Business One9.2SEWU141SEWU1General
204Business One9.2SEWU231SEWU2General
205Business One9.2SEWUA61SEWUAGeneral
206Business One9.2SEWUS91SEWUSGeneral
207Business One9.2SEWUT41SEWUTGeneral
208Business One9.2SFDK141SFDKGeneral
209Business One9.2SFMD41SFMDGeneral
210Business One9.2SHLP41Server HelpGeneral
211Business One9.2SHQR61Upgrade queries historyGeneral
212Business One9.2SINF111Server InfoGeneral
213Business One9.2SINP41SINPGeneral
214Business One9.2SLIC21SLICGeneral
215Business One9.2SLOG81SLOGGeneral
216Business One9.2SLOGR71SLOGRGeneral
217Business One9.2SLSC61Local Settings Components CABsGeneral
218Business One9.2SLSD31Local SettingsGeneral
219Business One9.2SLSP41SLSPGeneral
220Business One9.2SLSPP41SLSPPGeneral
221Business One9.2SOUT122SOUTGeneral
222Business One9.2SPAR31SPARGeneral
223Business One9.2SPRM51SPRMGeneral
224Business One9.2SRGC51Registred companiesGeneral
225Business One9.2SSEN101SSENGeneral
226Business One9.2STRI112String list item resourceGeneral
227Business One9.2STRL92String List resourceGeneral
228Business One9.2SWDP31SWDPGeneral
229Business One9.2SWEI71SWEIGeneral
230Business One9.2SWFQ121SWFQGeneral
231Business One9.2SWID41SWIDGeneral
232Business One9.2SWPD111SWPDGeneral
233Business One9.2SWRS51SWRSGeneral
234Business One9.2SXRCD51XLR Class DefinitionsGeneral
235Business One9.2SXRCO121XLR ContextGeneral
236Business One9.2SXRDB41XLR DatabasesGeneral
237Business One9.2SXRDF62XLR DefinitionGeneral
238Business One9.2SXREL41XLR Event LogGeneral
239Business One9.2SXRET31XLR Enum TypesGeneral
240Business One9.2SXREV41XLR Enum ValuesGeneral
241Business One9.2SXRFU21XLR FunctionsGeneral
242Business One9.2SXRIN31XLR InstancesGeneral
243Business One9.2SXRME72XLR MembersGeneral
244Business One9.2SXRNO41XLR NotesGeneral
245Business One9.2SXROA51XLR Object AccessGeneral
246Business One9.2SXROB81XLR ObjectsGeneral
247Business One9.2SXRPD111XLR Property DefinitionsGeneral
248Business One9.2SXRPR61XLR PropertiesGeneral
249Business One9.2SXRRE52XLR RelationsGeneral
250Business One9.2SXRRO52XLR RelationsGeneral
251Business One9.2SXRSS62XLR Security SettingsGeneral
252Business One9.2SXRTE41XLR TermsGeneral
253Business One9.2TABL182Table resourceGeneral
254Business One9.2TCN151Tracking Note - Line DataGeneral
255Business One9.2TCN241Tracking Note - BrokersGeneral
256Business One9.2TSCD72SchedulesGeneral
257Business One9.2TYPR92TYPRGeneral
258Business One9.2TZLI31TZLIGeneral
259Business One9.2UBVL351Serial Numbers and Batch Valuation LogGeneral
260Business One9.2UIC141Customized Forms in TemplatesGeneral
261Business One9.2UIC2141Customized Forms in TemplateGeneral
262Business One9.2UIC331Template User CustomizationGeneral
263Business One9.2UIC431Forms in Assigned TemplatesGeneral
264Business One9.2UICU62Customized TemplateGeneral
265Business One9.2USR721Group User AssociationGeneral
266Business One9.2USR821Point of Issue User AssociationGeneral
267Business One9.2WMNU191WMNUGeneral
268Business One9.2WOBJ442Object WizardGeneral
269Business One9.2WOFL61Object Wizard FieldsGeneral
270Business One9.2WORF163Object Wizard Related FilesGeneral
271Business One9.2WPK1141Dashboard Packages' Parameter or FilterGeneral
272Business One9.2WPK241Dashboard Packages' Discrete ValueGeneral
273Business One9.2XAP141Page of XAPPGeneral
274Business One9.2XAP271XAPP WidgetGeneral
275Business One9.2XAP361XAP FilterGeneral
276Business One9.2XAP461Widget ItemGeneral
277Business One9.2XSCMP31XApp Company AssignmentGeneral
278Business One9.2XSSE41XS SessionGeneral
279Business One9.2XSUSR31XApp User AuthorizationGeneral
280Business One9.2XSXA43XS XApp Registration InfoGeneral