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
2FMARCPAR4Parallelization of FMARC_BATCH
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OUSR101Users
10OWTR386Inventory Transfer

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6ORCT154Incoming Payment
7OVPM154Outgoing Payments
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

230 tablesB1 8.82 

Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82AAD1491Administration Extension-LogAdministration
2Business One8.82AADM3771Administration - LogAdministration
3Business One8.82AADP331Print PreferencesAdministration
4Business One8.82ABP141Business Place Tax IDsAdministration
5Business One8.82ACFP102CFOP for Nota FiscalAdministration
6Business One8.82ACRC122Credit CardsAdministration
7Business One8.82ADM1491Administration ExtensionAdministration
8Business One8.82ADM2291Administration Electronic ReportAdministration
9Business One8.82ADP1382Object Settings - HistoryAdministration
10Business One8.82AEXD351Freight SetupAdministration
11Business One8.82AFM171Tax Formula Parameter DeclarationAdministration
12Business One8.82AFML82Tax Formula Master TableAdministration
13Business One8.82AINF1941Company InfoAdministration
14Business One8.82ALR1102Queue of messages to be sentAdministration
15Business One8.82ALR241Dynamic message data rowAdministration
16Business One8.82ALR361Dynamic message data cellsAdministration
17Business One8.82ALT161Alerts - UsersAdministration
18Business One8.82ANCM62NCM CodeAdministration
19Business One8.82AOB1233Sent Messages - User HistoryAdministration
20Business One8.82ARI141Add-OnAdministration
21Business One8.82AST1111Sales Tax Codes - RowsAdministration
22Business One8.82ASTC161Sales Tax CodesAdministration
23Business One8.82ATC1101Attachments - RowsAdministration
24Business One8.82ATSC122CST Code for Nota FiscalAdministration
25Business One8.82AUSR901Archive Users - HistoryAdministration
26Business One8.82BPL141Business Place Tax IDsAdministration
27Business One8.82CDIC31DictionaryAdministration
28Business One8.82CDPM91Dynamic PermissionAdministration
29Business One8.82CDRO51Drag & Relate - Output FieldsAdministration
30Business One8.82CDRU41Drag & Relate User SettingsAdministration
31Business One8.82CFN151Default Common FunctionsAdministration
32Business One8.82CFUS51Functionality Usage StatisticsAdministration
33Business One8.82CHEN31Caching Update NotificationAdministration
34Business One8.82CHFL91Choose from List FormatAdministration
35Business One8.82CINF1941Company InfoAdministration
36Business One8.82CPRF141Column PreferencesAdministration
37Business One8.82CPT181Cockpit SubtableAdministration
38Business One8.82CSHS102User-Defined ValuesAdministration
39Business One8.82CSN161Certificate Series - SeriesAdministration
40Business One8.82CSPI71Solution Packager InformationAdministration
41Business One8.82CSTN22Workstation IDAdministration
42Business One8.82CTBR81ToolbarsAdministration
43Business One8.82CTNS32Transaction Notification SettingAdministration
44Business One8.82CUDC42User Display Cat.Administration
45Business One8.82CUFD172User Fields - DescriptionAdministration
46Business One8.82CULG101Company Upgrade LogAdministration
47Business One8.82CUMF51FolderAdministration
48Business One8.82CUMI121My Menu ItemsAdministration
49Business One8.82CUPC41Upgrade ControlAdministration
50Business One8.82CUVV31User ValidationsAdministration
51Business One8.82DAB131Dashboard QueriesAdministration
52Business One8.82DADB41Data Archive DSA BalanceAdministration
53Business One8.82DAR1241Data Archive - Transaction LogAdministration
54Business One8.82DAR2201Data Archive - Transaction LogAdministration
55Business One8.82DAR372Data Archive - Handwritten DocumentsAdministration
56Business One8.82DATB91Data Archive Tax BalanceAdministration
57Business One8.82DBADM21Read-Only DB UserAdministration
58Business One8.82DGP151Customer ListAdministration
59Business One8.82DGP2111Expanded Selection CriteriaAdministration
60Business One8.82DGP341Expanded Consolidation OptionsAdministration
61Business One8.82DGP451Business Place ListAdministration
62Business One8.82DGP541Sort By ListAdministration
63Business One8.82DMW131Query ListAdministration
64Business One8.82EOY111End of Year UDOsAdministration
65Business One8.82ERX171Excise Registering Number-RowsAdministration
66Business One8.82FML171Tax Formula Parameter DeclarationAdministration
67Business One8.82GFL181Grid Filter RulesAdministration
68Business One8.82GFL251Grid Filter NameAdministration
69Business One8.82MAP181Input and Output of MappingAdministration
70Business One8.82MAP251Mapping Input and Output RelationAdministration
71Business One8.82MLS181Distribution Lists - RecipientsAdministration
72Business One8.82MLT131Translations in user languageAdministration
73Business One8.82NFN1212Not a Fiscal SequenceAdministration
74Business One8.82NFN242NFSeq User DefaultAdministration
75Business One8.82NFN332Assigned Nota Fiscal SeriesAdministration
76Business One8.82NFN491Manual Nota Fiscal NumberAdministration
77Business One8.82NNM1232Documents Numbering - SeriesAdministration
78Business One8.82NNM242Series DefaultAdministration
79Business One8.82NNM332Documents Numbering -Belgium SeriesAdministration
80Business One8.82NNM4101Electronic SeriesAdministration
81Business One8.82NNM542Document Numbering - Removed Serial NumbersAdministration
82Business One8.82NNM661Documents Numbering - Supplementary CodeAdministration
83Business One8.82OADF41Address FormatsAdministration
84Business One8.82OADM3771AdministrationAdministration
85Business One8.82OADP331Print PreferencesAdministration
86Business One8.82OAIB74Received AlertsAdministration
87Business One8.82OALC72Loading ExpensesAdministration
88Business One8.82OALR132AlertsAdministration
89Business One8.82OALT242Alerts TemplateAdministration
90Business One8.82OAOB52Message SentAdministration
91Business One8.82OARI41Add-On - Company DefinitionsAdministration
92Business One8.82OATC11AttachmentsAdministration
93Business One8.82OBDC161B1i DI ConfigurationAdministration
94Business One8.82OBSI52Brazil String IndexerAdministration
95Business One8.82OCCD91Cargo Customs Declaration NumbersAdministration
96Business One8.82OCDP62Closing Date ProcedureAdministration
97Business One8.82OCDT231Credit Card PaymentAdministration
98Business One8.82OCFN21Common Functions WidgetAdministration
99Business One8.82OCFP102CFOP for Nota FiscalAdministration
100Business One8.82OCHF31312Administration
101Business One8.82OCMN102Customized MenuAdministration
102Business One8.82OCNA32CNAE CodeAdministration
103Business One8.82OCNT82CountiesAdministration
104Business One8.82OCPT172Cockpit Main TableAdministration
105Business One8.82OCRC122Credit CardsAdministration
106Business One8.82OCRN272Currency CodesAdministration
107Business One8.82OCRP114Payment MethodsAdministration
108Business One8.82OCRY151CountriesAdministration
109Business One8.82OCSN54Certificate SeriesAdministration
110Business One8.82OCSQ61Column SequencesAdministration
111Business One8.82OCST51StatesAdministration
112Business One8.82ODAB72DashboardAdministration
113Business One8.82ODAR311Data ArchivingAdministration
114Business One8.82ODGP502Document Generation Parameter SetsAdministration
115Business One8.82ODLL32Barcode Algorithm FileAdministration
116Business One8.82ODMW112Data MigrationAdministration
117Business One8.82ODOW101Data Ownership - ObjectsAdministration
118Business One8.82ODOX91Data Ownership - ExceptionsAdministration
119Business One8.82ODW121Default Open DocumentsAdministration
120Business One8.82OENC21Encryption TypesAdministration
121Business One8.82OEOY1221End-of-Year TransferAdministration
122Business One8.82OERN71Excise Register NumberingAdministration
123Business One8.82OERT52Excise Register Numbering TypeAdministration
124Business One8.82OERX32Excise Register Numbering ExtAdministration
125Business One8.82OEXD352Freight SetupAdministration
126Business One8.82OFML82Tax Formula Master TableAdministration
127Business One8.82OFRM91File FormatAdministration
128Business One8.82OGFL51Grid FilterAdministration
129Business One8.82OGSP31Goods ShipmentAdministration
130Business One8.82OIDX51CPI CodesAdministration
131Business One8.82OIND31Triangular DealAdministration
132Business One8.82OJPE31Local Era CalendarAdministration
133Business One8.82OLLF141Legal List FormatAdministration
134Business One8.82OLNG72User Language TableAdministration
135Business One8.82OLTB62Location-based Tax Bal TableAdministration
136Business One8.82OMAO51Mobile Add-On SettingAdministration
137Business One8.82OMAP31Mapping ElementsAdministration
138Business One8.82OMLS42Distribution ListAdministration
139Business One8.82OMLT62Multi-Language TranslationAdministration
140Business One8.82OMPS32Map ServicesAdministration
141Business One8.82OMSG41Messaging Service SettingsAdministration
142Business One8.82OMTP31Material TypeAdministration
143Business One8.82ONCM62NCM CodeAdministration
144Business One8.82ONFN61Nota Fiscal NumberingAdministration
145Business One8.82ONFT32Nota Fiscal Tax Category (Brazil)Administration
146Business One8.82ONNM81Document NumberingAdministration
147Business One8.82ONOA42Nature of AssesseeAdministration
148Business One8.82OODW21Open Documents WidgetAdministration
149Business One8.82OPID11Period IndicatorAdministration
150Business One8.82OPPA111Password AdministrationAdministration
151Business One8.82OPQW92Purchase Quotation Generation: Parameter SetsAdministration
152Business One8.82OPRF171PreferencesAdministration
153Business One8.82OPRO92Property ObjectAdministration
154Business One8.82OPVL52Lender - PelecardAdministration
155Business One8.82ORIT51Dunning Interest RateAdministration
156Business One8.82ORLD42Reference Links DefinitionAdministration
157Business One8.82OSEC43SectionsAdministration
158Business One8.82OSHP52Delivery TypesAdministration
159Business One8.82OSRL53Serial NumbersAdministration
160Business One8.82OSSP31Service SupplyAdministration
161Business One8.82OSTA241Sales Tax AuthoritiesAdministration
162Business One8.82OSTC161Sales Tax CodesAdministration
163Business One8.82OSTT82Sales Tax Authorities TypeAdministration
164Business One8.82OTCD42Tax Code DeterminationAdministration
165Business One8.82OTCX381Tax Code DeterminationAdministration
166Business One8.82OTFC32Tax Type CombinationAdministration
167Business One8.82OTIZ51Company Time ZoneAdministration
168Business One8.82OTNC32Transaction CategoryAdministration
169Business One8.82OTNN421099 FormsAdministration
170Business One8.82OTOB611099 Opening BalanceAdministration
171Business One8.82OTPA62Tax Parameter AttributesAdministration
172Business One8.82OTPL31Import TemplateAdministration
173Business One8.82OTPR72Tax Return ValuesAdministration
174Business One8.82OTPS32Tax ParameterAdministration
175Business One8.82OTRN72Multilingual Service TableAdministration
176Business One8.82OTSC122CST Code for Nota FiscalAdministration
177Business One8.82OUDG331User DefaultsAdministration
178Business One8.82OUDO272User-Defined ObjectAdministration
179Business One8.82OUKD51User Key DescriptionAdministration
180Business One8.82OULA151EULAAdministration
181Business One8.82OUPT91User Autorization TreeAdministration
182Business One8.82OUSG131Usage of Nota FiscalAdministration
183Business One8.82OUSR904UsersAdministration
184Business One8.82OUTB81User TablesAdministration
185Business One8.82OVNM71VAT Report NumberingAdministration
186Business One8.82OWDT41Widget TableAdministration
187Business One8.82OWPK102Dashboard PackagesAdministration
188Business One8.82OWST52Confirmation LevelAdministration
189Business One8.82OWTM72Approval TemplatesAdministration
190Business One8.82PQW1121Purchase Quotation Generation: Line ItemsAdministration
191Business One8.82RIT161Interest RatesAdministration
192Business One8.82RLD161Reference Links DefinitionAdministration
193Business One8.82SDEX81Dynamic ExtensionsAdministration
194Business One8.82SDIS81Dynamic Interface (Strings)Administration
195Business One8.82SPRG81Application StartAdministration
196Business One8.82STA141Valid PeriodAdministration
197Business One8.82STC1111Sales Tax Codes - RowsAdministration
198Business One8.82TCD182Key Fields for DeterminationAdministration
199Business One8.82TCD272Key Field ValuesAdministration
200Business One8.82TCD352Tax Code DeterminationAdministration
201Business One8.82TCD441Withholding Tax Code DeterminationAdministration
202Business One8.82TCD561Tax Code by UsageAdministration
203Business One8.82TDR1121Can Be ArchiveAdministration
204Business One8.82TFC141Tax Type Combination - RowsAdministration
205Business One8.82TNN1611099 BoxesAdministration
206Business One8.82TPL131Template - RecordsAdministration
207Business One8.82TPS142Tax Parameter AttributesAdministration
208Business One8.82TPS232Tax Parameter - Return ValuesAdministration
209Business One8.82TRN182Subtable of OTRNAdministration
210Business One8.82TRN252Subtable of OTRNAdministration
211Business One8.82UDG1131User Defaults - DocumentsAdministration
212Business One8.82UDG231User Defaults - Credit CardsAdministration
213Business One8.82UDO151User-Defined Objects - ChildAdministration
214Business One8.82UDO241User-Defined Objects - Find ColumnsAdministration
215Business One8.82UDO361User-Defined Objects - Found ColumnsAdministration
216Business One8.82UDO471User-Defined Objects - Child Table ColumnsAdministration
217Business One8.82UFD161User Fields - Values DefinitionsAdministration
218Business One8.82UKD142User Sub-Keys DescriptionAdministration
219Business One8.82UPT132User Authorization Tree - Extended PermissionAdministration
220Business One8.82USR1431Short CutAdministration
221Business One8.82USR2111Run External ApplicationAdministration
222Business One8.82USR331User AuthorizationAdministration
223Business One8.82USR591User Access LogAdministration
224Business One8.82VIEWS31SQL Company ViewsAdministration
225Business One8.82WST121Confirmation Level - RowsAdministration
226Business One8.82WTM121Approval Templates - ProducersAdministration
227Business One8.82WTM241Confirmation Templates - StagesAdministration
228Business One8.82WTM321Approval Templates - DocumentsAdministration
229Business One8.82WTM441Approval Templates - TermsAdministration
230Business One8.82WTM521Approval Templates - QueriesAdministration