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

307 tablesB1 9.3 

Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3AAD11181Administration Extension-LogAdministration
2Business One9.3AADM5221Administration - LogAdministration
3Business One9.3AADP401Print PreferencesAdministration
4Business One9.3ABP141Business Place Tax IDsAdministration
5Business One9.3ABP2101Branch Tributary Info. LogAdministration
6Business One9.3ACFP102CFOP for Nota FiscalAdministration
7Business One9.3ACRC132Credit CardsAdministration
8Business One9.3ADM11181Administration ExtensionAdministration
9Business One9.3ADM2671Administration Electronic ReportAdministration
10Business One9.3ADP1582Object Settings - HistoryAdministration
11Business One9.3ADP242Report Settings - HistoryAdministration
12Business One9.3AEXD391Freight SetupAdministration
13Business One9.3AFM171Tax Formula Parameter DeclarationAdministration
14Business One9.3AFML102Tax Formula Master TableAdministration
15Business One9.3AINF2191Company InfoAdministration
16Business One9.3ALR1102Queue of messages to be sentAdministration
17Business One9.3ALR241Dynamic message data rowAdministration
18Business One9.3ALR361Dynamic message data cellsAdministration
19Business One9.3ALT161Alerts - UsersAdministration
20Business One9.3ANCM82NCM CodeAdministration
21Business One9.3AOB1233Sent Messages - User HistoryAdministration
22Business One9.3APFS152Personal Fields Setup - HistoryAdministration
23Business One9.3APJ1201Project Plan StepsAdministration
24Business One9.3APJ2101Project Plan Steps Time RecordAdministration
25Business One9.3APJT91Project PlanAdministration
26Business One9.3ARI141Add-OnAdministration
27Business One9.3ARST92Route Stages - HistoryAdministration
28Business One9.3AST1111Sales Tax Codes - RowsAdministration
29Business One9.3ASTC181Sales Tax CodesAdministration
30Business One9.3ASTT122Sales Tax Authorities TypeAdministration
31Business One9.3ASVM31Systems for Value MappingAdministration
32Business One9.3ATC1121Attachments - RowsAdministration
33Business One9.3ATSC122CST Code for Nota FiscalAdministration
34Business One9.3AUSR1131Users - HistoryAdministration
35Business One9.3AVM151Systems for Value Mapping PropertiesAdministration
36Business One9.3AVM231Systems for Value Mapping PropertiesAdministration
37Business One9.3AWEX131Workflow Engine Execution EntityAdministration
38Business One9.3AWFQ151SWFQ History TableAdministration
39Business One9.3AWL171Potential Processor of TasksAdministration
40Business One9.3AWL291Input data for tasksAdministration
41Business One9.3AWL381Task NotesAdministration
42Business One9.3AWL481Task Output DataAdministration
43Business One9.3AWL571Task Field Mapping InformationAdministration
44Business One9.3AWLS341Workflow - Task DetailsAdministration
45Business One9.3AWMG111Workflow ManagerAdministration
46Business One9.3AWTS171Workflow Engine Task TableAdministration
47Business One9.3BPL141Branch I.E. NumbersAdministration
48Business One9.3BPL2101Branch Tributary Info.Administration
49Business One9.3CDPM92Dynamic PermissionAdministration
50Business One9.3CDRO51Drag & Relate - Output FieldsAdministration
51Business One9.3CDRU41Drag & Relate User SettingsAdministration
52Business One9.3CHEN31Caching Update NotificationAdministration
53Business One9.3CHFL91Choose from List FormatAdministration
54Business One9.3CIF171Country Specific InformationAdministration
55Business One9.3CINF2191Company InfoAdministration
56Business One9.3CPL181Quick Copy - Instance LogAdministration
57Business One9.3CPRF161Column PreferencesAdministration
58Business One9.3CRY131Country Combination SettingsAdministration
59Business One9.3CSHS102User-Defined ValuesAdministration
60Business One9.3CSN161Certificate Series - SeriesAdministration
61Business One9.3CSPI71Solution Packager InformationAdministration
62Business One9.3CSTN22Workstation IDAdministration
63Business One9.3CTBR81ToolbarsAdministration
64Business One9.3CUDC42User Display Cat.Administration
65Business One9.3CUFD212User Fields - DescriptionAdministration
66Business One9.3CULG101Company Upgrade LogAdministration
67Business One9.3CUMF51FolderAdministration
68Business One9.3CUMI122My Menu ItemsAdministration
69Business One9.3CUPC41Upgrade ControlAdministration
70Business One9.3CUVV31User ValidationsAdministration
71Business One9.3DADB41Data Archive DSA BalanceAdministration
72Business One9.3DAR1251Data Archive - Transaction LogAdministration
73Business One9.3DAR2201Data Archive - Transaction LogAdministration
74Business One9.3DAR372Data Archive - Handwritten DocumentsAdministration
75Business One9.3DATB91Data Archive Tax BalanceAdministration
76Business One9.3DBADM21Read-Only DB UserAdministration
77Business One9.3DGP151Customer ListAdministration
78Business One9.3DGP2111Expanded Selection CriteriaAdministration
79Business One9.3DGP341Expanded Consolidation OptionsAdministration
80Business One9.3DGP451Business Place ListAdministration
81Business One9.3DGP541Sort By ListAdministration
82Business One9.3DMW131Query ListAdministration
83Business One9.3EOY111End of Year UDOsAdministration
84Business One9.3ERX171Excise Registering Number-RowsAdministration
85Business One9.3FML171Tax Formula Parameter DeclarationAdministration
86Business One9.3FTT191Financial Template Import - FilesAdministration
87Business One9.3GFL181Grid Filter RulesAdministration
88Business One9.3GFL251Grid Filter NameAdministration
89Business One9.3GPC142Authority AssignmentAdministration
90Business One9.3MAB131Menu AbbreviationAdministration
91Business One9.3MABV52Menu AbbreviationAdministration
92Business One9.3MAP181Input and Output of MappingAdministration
93Business One9.3MAP251Mapping Input and Output RelationAdministration
94Business One9.3MDC1151Master Data Cleanup - LogAdministration
95Business One9.3MDC241Master Data Cleanup - MD LogAdministration
96Business One9.3MLS181Distribution Lists - RecipientsAdministration
97Business One9.3MLT131Translations in user languageAdministration
98Business One9.3MPO141Value Mapping DataAdministration
99Business One9.3MVLD62MVLDAdministration
100Business One9.3NFN1232Not a Fiscal SequenceAdministration
101Business One9.3NFN242NFSeq User DefaultAdministration
102Business One9.3NFN332Assigned Nota Fiscal SeriesAdministration
103Business One9.3NFN4121Manual Nota Fiscal NumberAdministration
104Business One9.3NNM1282Documents Numbering - SeriesAdministration
105Business One9.3NNM242Series DefaultAdministration
106Business One9.3NNM332Documents Numbering -Belgium SeriesAdministration
107Business One9.3NNM4101Electronic SeriesAdministration
108Business One9.3NNM542Document Numbering - Removed Serial NumbersAdministration
109Business One9.3NNM661Documents Numbering - Supplementary CodeAdministration
110Business One9.3OADF42Address FormatsAdministration
111Business One9.3OADM5221AdministrationAdministration
112Business One9.3OADP401Print PreferencesAdministration
113Business One9.3OAIB84Received AlertsAdministration
114Business One9.3OALC82Loading ExpensesAdministration
115Business One9.3OALR142AlertsAdministration
116Business One9.3OALT243Alerts TemplateAdministration
117Business One9.3OAOB52Message SentAdministration
118Business One9.3OARI61Add-On - Company DefinitionsAdministration
119Business One9.3OATC11AttachmentsAdministration
120Business One9.3OBDC161B1i DI ConfigurationAdministration
121Business One9.3OBMI82Brazilian Multi-IndexerAdministration
122Business One9.3OBOI72Count WidgetAdministration
123Business One9.3OBPD153Blocked Personal DataAdministration
124Business One9.3OBRW82Browser WidgetAdministration
125Business One9.3OBSI72Brazil String IndexerAdministration
126Business One9.3OCCD91Cargo Customs Declaration NumbersAdministration
127Business One9.3OCDP62Closing Date ProcedureAdministration
128Business One9.3OCDT231Credit Card PaymentAdministration
129Business One9.3OCFP102CFOP for Nota FiscalAdministration
130Business One9.3OCFX41Cash Flow Forecast Object TypesAdministration
131Business One9.3OCHF31312Administration
132Business One9.3OCIF61Configuration of Intrastat FieldsAdministration
133Business One9.3OCMN102Customized MenuAdministration
134Business One9.3OCNA32CNAE CodeAdministration
135Business One9.3OCNT82CountiesAdministration
136Business One9.3OCPC31Quick Copy Config.Administration
137Business One9.3OCPL151Quick Copy Log ManagerAdministration
138Business One9.3OCRC132Credit CardsAdministration
139Business One9.3OCRN282Currency CodesAdministration
140Business One9.3OCRP114Payment MethodsAdministration
141Business One9.3OCRY191CountriesAdministration
142Business One9.3OCSC71Crystal Server ConfigurationAdministration
143Business One9.3OCSN54Certificate SeriesAdministration
144Business One9.3OCSQ61Column SequencesAdministration
145Business One9.3OCST92StatesAdministration
146Business One9.3ODAR321Data ArchivingAdministration
147Business One9.3ODCI132Intrastat ConfigurationAdministration
148Business One9.3ODCR161Checking RuleAdministration
149Business One9.3ODGP572Document Generation Parameter SetsAdministration
150Business One9.3ODLL32Bar Code Algorithm FileAdministration
151Business One9.3ODMW112Data MigrationAdministration
152Business One9.3ODOW111Data Ownership - ObjectsAdministration
153Business One9.3ODOX101Data Ownership - ExceptionsAdministration
154Business One9.3OENC21Encryption TypesAdministration
155Business One9.3OEOY1241End-of-Year TransferAdministration
156Business One9.3OERN71Excise Register NumberingAdministration
157Business One9.3OERT52Excise Register Numbering TypeAdministration
158Business One9.3OERX32Excise Register Numbering ExtAdministration
159Business One9.3OEXD392Freight SetupAdministration
160Business One9.3OFML102Tax Formula Master TableAdministration
161Business One9.3OFRM92File FormatAdministration
162Business One9.3OFTT21Financial Template ImportAdministration
163Business One9.3OGFL51Grid FilterAdministration
164Business One9.3OGPC62Government Payment CodeAdministration
165Business One9.3OGSP31Goods ShipmentAdministration
166Business One9.3OIDX51CPI CodesAdministration
167Business One9.3OIND31Triangular DealAdministration
168Business One9.3OJPE31Local Era CalendarAdministration
169Business One9.3OLLF152Legal List FormatAdministration
170Business One9.3OLNG72User Language TableAdministration
171Business One9.3OLTB62Location-based Tax Bal TableAdministration
172Business One9.3OMAO121Mobile Add-On SettingAdministration
173Business One9.3OMAP31Mapping ElementsAdministration
174Business One9.3OMDC61Master Data CleanupAdministration
175Business One9.3OMLS42Distribution ListAdministration
176Business One9.3OMLT62Multi-Language TranslationAdministration
177Business One9.3OMPF41Message PreferencesAdministration
178Business One9.3OMPO32Value Mapping ObjectAdministration
179Business One9.3OMPS32Map ServicesAdministration
180Business One9.3OMSG41Messaging Service SettingsAdministration
181Business One9.3OMTP31Material TypeAdministration
182Business One9.3ONCG32State GroupsAdministration
183Business One9.3ONCM82NCM CodeAdministration
184Business One9.3ONFN61Nota Fiscal NumberingAdministration
185Business One9.3ONFT42Nota Fiscal Tax Category (Brazil)Administration
186Business One9.3ONNM81Document NumberingAdministration
187Business One9.3ONOA42Nature of AssesseeAdministration
188Business One9.3OOCC62BoE Occurrence CodeAdministration
189Business One9.3OPCI121Process Checklist InstanceAdministration
190Business One9.3OPCT42Process Checklist TemplateAdministration
191Business One9.3OPFS152Personal Fields SetupAdministration
192Business One9.3OPID11Period IndicatorAdministration
193Business One9.3OPJT92Project PlanAdministration
194Business One9.3OPOS51POS Master DataAdministration
195Business One9.3OPPA111Password AdministrationAdministration
196Business One9.3OPQW122Purchase Quotation Generation: Parameter SetsAdministration
197Business One9.3OPRF171PreferencesAdministration
198Business One9.3OPRO92Property ObjectAdministration
199Business One9.3OPSG32Product Source Code GroupsAdministration
200Business One9.3OPVL52Lender - PelecardAdministration
201Business One9.3ORIT51Dunning Interest RateAdministration
202Business One9.3ORLD42Reference Links DefinitionAdministration
203Business One9.3ORLS21Reference Links SourcesAdministration
204Business One9.3ORMK32Remark 1Administration
205Business One9.3ORST92Route StagesAdministration
206Business One9.3OSEC43SectionsAdministration
207Business One9.3OSHP52Delivery TypesAdministration
208Business One9.3OSRL53Serial NumbersAdministration
209Business One9.3OSSP31Service SupplyAdministration
210Business One9.3OSTA331Sales Tax AuthoritiesAdministration
211Business One9.3OSTC181Sales Tax CodesAdministration
212Business One9.3OSTG32State GroupsAdministration
213Business One9.3OSTT122Sales Tax Authorities TypeAdministration
214Business One9.3OSUL111Support User Login RecordAdministration
215Business One9.3OSUS61Support Usage StatisticsAdministration
216Business One9.3OSVM31Systems for Value MappingAdministration
217Business One9.3OTCD42Tax Code DeterminationAdministration
218Business One9.3OTCX381Tax Code DeterminationAdministration
219Business One9.3OTFC32Tax Type CombinationAdministration
220Business One9.3OTIZ51Company Time ZoneAdministration
221Business One9.3OTNC32Transaction CategoryAdministration
222Business One9.3OTNN421099 FormsAdministration
223Business One9.3OTOB611099 Opening BalanceAdministration
224Business One9.3OTPA62Tax Parameter AttributesAdministration
225Business One9.3OTPL42Import TemplateAdministration
226Business One9.3OTPR72Tax Return ValuesAdministration
227Business One9.3OTPS32Tax ParameterAdministration
228Business One9.3OTRN72Multilingual Service TableAdministration
229Business One9.3OTSC122CST Code for Nota FiscalAdministration
230Business One9.3OUDG491User DefaultsAdministration
231Business One9.3OUDO292User-Defined ObjectAdministration
232Business One9.3OUKD51User Key DescriptionAdministration
233Business One9.3OULA151EULAAdministration
234Business One9.3OUPT91User Autorization TreeAdministration
235Business One9.3OUSG161Usage of Nota FiscalAdministration
236Business One9.3OUSR1134UsersAdministration
237Business One9.3OUTB81User TablesAdministration
238Business One9.3OVMC101Value Mapping Communication ObjectAdministration
239Business One9.3OVNM71VAT Report NumberingAdministration
240Business One9.3OWEX111Workflow Engine Execution EntityAdministration
241Business One9.3OWFER121Workflow Error MessageAdministration
242Business One9.3OWFI101Workflow - InstancesAdministration
243Business One9.3OWIN111Workflow Engine InformationAdministration
244Business One9.3OWJB81Workflow Job EntityAdministration
245Business One9.3OWLS341Workflow - Task DetailsAdministration
246Business One9.3OWMG111Workflow ManagerAdministration
247Business One9.3OWST62Confirmation LevelAdministration
248Business One9.3OWTI151Workflow Timer DefinitionAdministration
249Business One9.3OWTJ91Workflow Timer JobAdministration
250Business One9.3OWTM82Approval TemplatesAdministration
251Business One9.3OWTS171Workflow Engine Task TableAdministration
252Business One9.3PCI171Process Checklist Element Extended DataAdministration
253Business One9.3PJT1201Project Plan StepsAdministration
254Business One9.3PJT2101Project Plan Steps Time RecordAdministration
255Business One9.3PQW1241Purchase Quotation Generation: Line ItemsAdministration
256Business One9.3RIT161Interest RatesAdministration
257Business One9.3RLD161Reference Links DefinitionAdministration
258Business One9.3RLS152Reference Links Sources DefinitionAdministration
259Business One9.3SDEX81Dynamic ExtensionsAdministration
260Business One9.3SDIS81Dynamic Interface (Strings)Administration
261Business One9.3SMSG21SMSGAdministration
262Business One9.3SPRG81Application StartAdministration
263Business One9.3STA151Valid PeriodAdministration
264Business One9.3STC1112Sales Tax Codes - RowsAdministration
265Business One9.3SVM151Systems for Value Mapping PropertiesAdministration
266Business One9.3SVM231Systems for Value Mapping PropertiesAdministration
267Business One9.3TCD1192Key Fields for DeterminationAdministration
268Business One9.3TCD282Key Field ValuesAdministration
269Business One9.3TCD352Tax Code DeterminationAdministration
270Business One9.3TCD441Withholding Tax Code DeterminationAdministration
271Business One9.3TCD571Tax Code by UsageAdministration
272Business One9.3TDR1121Can Be ArchiveAdministration
273Business One9.3TFC142Tax Type Combination - RowsAdministration
274Business One9.3TNN1611099 BoxesAdministration
275Business One9.3TPL151Template - RecordsAdministration
276Business One9.3TPS142Tax Parameter AttributesAdministration
277Business One9.3TPS232Tax Parameter - Return ValuesAdministration
278Business One9.3TRN182Subtable of OTRNAdministration
279Business One9.3TRN252Subtable of OTRNAdministration
280Business One9.3UDG1151User Defaults - DocumentsAdministration
281Business One9.3UDG231User Defaults - Credit CardsAdministration
282Business One9.3UDG321User Defaults - POS/Cash RegisterAdministration
283Business One9.3UDG451User Defaults - Default POI for Folio Numbering DocumentsAdministration
284Business One9.3UDO151User-Defined Objects - ChildAdministration
285Business One9.3UDO241User-Defined Objects - Find ColumnsAdministration
286Business One9.3UDO361User-Defined Objects - Found ColumnsAdministration
287Business One9.3UDO471User-Defined Objects - Child Table ColumnsAdministration
288Business One9.3UFD161User Fields - Values DefinitionsAdministration
289Business One9.3UGR131Group AuthorizationAdministration
290Business One9.3UKD142User Sub-Keys DescriptionAdministration
291Business One9.3UPT132User Authorization Tree - Extended PermissionAdministration
292Business One9.3USR1431Short CutAdministration
293Business One9.3USR2111Run External ApplicationAdministration
294Business One9.3USR331User AuthorizationAdministration
295Business One9.3USR5171User Access LogAdministration
296Business One9.3VIEWS31SQL Company ViewsAdministration
297Business One9.3WLS171Potential Processor of TasksAdministration
298Business One9.3WLS291Input data for tasksAdministration
299Business One9.3WLS381Notes of TasksAdministration
300Business One9.3WLS481Task Output DataAdministration
301Business One9.3WLS571Task Field Mapping InformationAdministration
302Business One9.3WST121Confirmation Level - RowsAdministration
303Business One9.3WTM121Approval Templates - ProducersAdministration
304Business One9.3WTM241Confirmation Templates - StagesAdministration
305Business One9.3WTM321Approval Templates - DocumentsAdministration
306Business One9.3WTM441Approval Templates - TermsAdministration
307Business One9.3WTM521Approval Templates - QueriesAdministration