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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

280 tablesB1 9.2 

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