SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

194 tablesB1 8.8 

Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.8AAD1351Administration Extension-LogAdministration
2Business One8.8AADM3281Administration - LogAdministration
3Business One8.8ACRC122Credit CardsAdministration
4Business One8.8ADM1351Administration ExtensionAdministration
5Business One8.8ADP1342Object Settings - HistoryAdministration
6Business One8.8AEXD341Freight SetupAdministration
7Business One8.8ALR1102Queue of messages to be sentAdministration
8Business One8.8ALR241Dynamic message data rowAdministration
9Business One8.8ALR361Dynamic message data cellsAdministration
10Business One8.8ALT161Alerts - UsersAdministration
11Business One8.8AOB1233Sent Messages - User HistoryAdministration
12Business One8.8ARI141Add-OnAdministration
13Business One8.8ATC1101Attachments - RowsAdministration
14Business One8.8AUSR821Archive Users - HistoryAdministration
15Business One8.8CDPM91Dynamic PermissionAdministration
16Business One8.8CDRO51Drag & Relate - Output FieldsAdministration
17Business One8.8CDRU41Drag & Relate User SettingsAdministration
18Business One8.8CFN151Default Common FunctionsAdministration
19Business One8.8CHEN31Caching Update NotificationAdministration
20Business One8.8CHFL91Choose from List FormatAdministration
21Business One8.8CINF1821Company InfoAdministration
22Business One8.8CPRF141Column PreferencesAdministration
23Business One8.8CPT181Cockpit SubtableAdministration
24Business One8.8CSHS102User-Defined ValuesAdministration
25Business One8.8CSN161Certificate Series - SeriesAdministration
26Business One8.8CSPI71Solution Packager InformationAdministration
27Business One8.8CSTN22Workstation IDAdministration
28Business One8.8CTBR81ToolbarsAdministration
29Business One8.8CTNS32Transaction Notification SettingAdministration
30Business One8.8CUDC42User Display Cat.Administration
31Business One8.8CUFD152User Fields - DescriptionAdministration
32Business One8.8CULG101Company Upgrade LogAdministration
33Business One8.8CUMF51FolderAdministration
34Business One8.8CUMI121My Menu ItemsAdministration
35Business One8.8CUPC41Upgrade ControlAdministration
36Business One8.8CUVV31User ValidationsAdministration
37Business One8.8DADB41Data Archive DSA BalanceAdministration
38Business One8.8DAR1241Data Archive - Transaction LogAdministration
39Business One8.8DAR2201Data Archive - Transaction LogAdministration
40Business One8.8DAR372Data Archive - Handwritten DocumentsAdministration
41Business One8.8DATB91Data Archive Tax BalanceAdministration
42Business One8.8DBADM21Read-Only DB UserAdministration
43Business One8.8DGP151Customer ListAdministration
44Business One8.8DGP2111Expanded Selection CriteriaAdministration
45Business One8.8DGP341Expanded Consolidation OptionsAdministration
46Business One8.8DGP451Business Place ListAdministration
47Business One8.8DGP541Sort By ListAdministration
48Business One8.8DMW131Query ListAdministration
49Business One8.8EOY111End of Year UDOsAdministration
50Business One8.8ERX171Excise Registering Number-RowsAdministration
51Business One8.8FML161Tax Formula Parameter DeclarationAdministration
52Business One8.8GFL181Grid Filter RulesAdministration
53Business One8.8GFL251Grid Filter NameAdministration
54Business One8.8MAP181Input and Output of MappingAdministration
55Business One8.8MAP251Mapping Input and Output RelationAdministration
56Business One8.8MLS181Distribution Lists - RecipientsAdministration
57Business One8.8MLT131Translations in user languageAdministration
58Business One8.8NFN1202Not a Fiscal SequenceAdministration
59Business One8.8NFN242NFSeq User DefaultAdministration
60Business One8.8NFN332Assigned Nota Fiscal SeriesAdministration
61Business One8.8NFN481Manual Nota Fiscal NumberAdministration
62Business One8.8NNM1182Documents Numbering - SeriesAdministration
63Business One8.8NNM242Series DefaultAdministration
64Business One8.8NNM332Documents Numbering -Belgium SeriesAdministration
65Business One8.8OADF41Address FormatsAdministration
66Business One8.8OADM3281AdministrationAdministration
67Business One8.8OADP251Print PreferencesAdministration
68Business One8.8OAIB74Received AlertsAdministration
69Business One8.8OALC72Loading ExpensesAdministration
70Business One8.8OALR132AlertsAdministration
71Business One8.8OALT242Alerts TemplateAdministration
72Business One8.8OAOB52Message SentAdministration
73Business One8.8OARI41Add-On - Company DefinitionsAdministration
74Business One8.8OATC11AttachmentsAdministration
75Business One8.8OBDC161B1i DI ConfigurationAdministration
76Business One8.8OCCD91Cargo Customs Declaration NumbersAdministration
77Business One8.8OCDP62Closing Date ProcedureAdministration
78Business One8.8OCDT231Credit Card PaymentAdministration
79Business One8.8OCFN21Common Functions WidgetAdministration
80Business One8.8OCFP72CFOP for Nota FiscalAdministration
81Business One8.8OCHF31312Administration
82Business One8.8OCMN102Customized MenuAdministration
83Business One8.8OCNA32CNAE CodeAdministration
84Business One8.8OCNT82CountiesAdministration
85Business One8.8OCPT172Cockpit Main TableAdministration
86Business One8.8OCRC122Credit CardsAdministration
87Business One8.8OCRN272Currency CodesAdministration
88Business One8.8OCRP114Payment MethodsAdministration
89Business One8.8OCRY131CountriesAdministration
90Business One8.8OCSN54Certificate SeriesAdministration
91Business One8.8OCSQ61Column SequencesAdministration
92Business One8.8OCST51StatesAdministration
93Business One8.8ODAR311Data ArchivingAdministration
94Business One8.8ODGP452Document Generation Parameter SetsAdministration
95Business One8.8ODLL32Barcode Algorithm FileAdministration
96Business One8.8ODMW112Data MigrationAdministration
97Business One8.8ODOW101Data Ownership - ObjectsAdministration
98Business One8.8ODOX91Data Ownership - ExceptionsAdministration
99Business One8.8OENC21Encryption TypesAdministration
100Business One8.8OEOY1181End-of-Year TransferAdministration
101Business One8.8OERN71Excise Register NumberingAdministration
102Business One8.8OERT52Excise Register Numbering TypeAdministration
103Business One8.8OERX32Excise Register Numbering ExtAdministration
104Business One8.8OEXD342Freight SetupAdministration
105Business One8.8OFML52Tax Formula Master TableAdministration
106Business One8.8OFRM81File FormatAdministration
107Business One8.8OGFL51Grid FilterAdministration
108Business One8.8OGSP31Goods ShipmentAdministration
109Business One8.8OIDX51CPI CodesAdministration
110Business One8.8OIND31Triangular DealAdministration
111Business One8.8OJPE31Local Era CalendarAdministration
112Business One8.8OLLF131Legal List FormatAdministration
113Business One8.8OLNG72User Language TableAdministration
114Business One8.8OLTB62Location-based Tax Bal TableAdministration
115Business One8.8OMAO51Mobile Addon SettingAdministration
116Business One8.8OMAP31Mapping ElementsAdministration
117Business One8.8OMLS42Distribution ListAdministration
118Business One8.8OMLT62Multi-Language TranslationAdministration
119Business One8.8OMSG41Messaging Service SettingsAdministration
120Business One8.8OMTP31Material TypeAdministration
121Business One8.8ONCM32NCM CodeAdministration
122Business One8.8ONFN61Nota Fiscal NumberingAdministration
123Business One8.8ONFT32Nota Fiscal Tax Category (Brazil)Administration
124Business One8.8ONNM71Document NumberingAdministration
125Business One8.8ONOA42Nature of AssesseeAdministration
126Business One8.8OPID11Period IndicatorAdministration
127Business One8.8OPPA111Password AdministrationAdministration
128Business One8.8OPRF171PreferencesAdministration
129Business One8.8OPRO92Property ObjectAdministration
130Business One8.8OPVL52Lender - PelecardAdministration
131Business One8.8ORIT51Dunning Interest RateAdministration
132Business One8.8OSEC43SectionsAdministration
133Business One8.8OSHP52Delivery TypesAdministration
134Business One8.8OSRL53Serial NumbersAdministration
135Business One8.8OSSP31Service SupplyAdministration
136Business One8.8OSTA241Sales Tax AuthoritiesAdministration
137Business One8.8OSTC131Sales Tax CodesAdministration
138Business One8.8OSTQ51Inventory Valuation Utility QueriesAdministration
139Business One8.8OSTT82Sales Tax Authorities TypeAdministration
140Business One8.8OTCD42Tax Code DeterminationAdministration
141Business One8.8OTFC32Tax Type CombinationAdministration
142Business One8.8OTIZ51Company Time ZoneAdministration
143Business One8.8OTNC32Transaction CategoryAdministration
144Business One8.8OTNN421099 FormsAdministration
145Business One8.8OTOB611099 Opening BalanceAdministration
146Business One8.8OTPA62Tax Parameter AttributesAdministration
147Business One8.8OTPR72Tax Return ValuesAdministration
148Business One8.8OTPS32Tax ParameterAdministration
149Business One8.8OTSC92CST Code for Nota FiscalAdministration
150Business One8.8OUDG291User DefaultsAdministration
151Business One8.8OUDO172User-Defined ObjectAdministration
152Business One8.8OUKD51User Key DescriptionAdministration
153Business One8.8OULA151EULAAdministration
154Business One8.8OUPT91User Autorization TreeAdministration
155Business One8.8OUSG71Usage of Nota FiscalAdministration
156Business One8.8OUSR824UsersAdministration
157Business One8.8OUTB61User TablesAdministration
158Business One8.8OVNM71VAT Report NumberingAdministration
159Business One8.8OWST52Confirmation LevelAdministration
160Business One8.8OWTM72Approval TemplatesAdministration
161Business One8.8RIT161Interest RatesAdministration
162Business One8.8SDEX81Dynamic ExtensionsAdministration
163Business One8.8SDIS81Dynamic Interface (Strings)Administration
164Business One8.8SPRG81Application StartAdministration
165Business One8.8STA141Valid PeriodAdministration
166Business One8.8STC1101Sales Tax Codes - RowsAdministration
167Business One8.8TCD172Key Fields for DeterminationAdministration
168Business One8.8TCD262Key Field ValuesAdministration
169Business One8.8TCD352Tax Code DeterminationAdministration
170Business One8.8TCD441Withholding Tax Code DeterminationAdministration
171Business One8.8TCD561Tax Code by UsageAdministration
172Business One8.8TDR1121Can Be ArchiveAdministration
173Business One8.8TFC141Tax Type Combination - RowsAdministration
174Business One8.8TNN1611099 BoxesAdministration
175Business One8.8TPS142Tax Parameter AttributesAdministration
176Business One8.8TPS232Tax Parameter - Return ValuesAdministration
177Business One8.8UDG1131User Defaults - DocumentsAdministration
178Business One8.8UDG231User Defaults - Credit CardsAdministration
179Business One8.8UDO151User-Defined Objects - ChildAdministration
180Business One8.8UDO241User-Defined Objects - Find ColumnsAdministration
181Business One8.8UDO351User-Defined Objects - Found ColumnsAdministration
182Business One8.8UFD151User Fields - Values DefinitionsAdministration
183Business One8.8UKD142User Sub-Keys DescriptionAdministration
184Business One8.8UPT132User Authorization Tree - Extended PermissionAdministration
185Business One8.8USR1431Short CutAdministration
186Business One8.8USR2111Run External ApplicationAdministration
187Business One8.8USR331User AuthorizationAdministration
188Business One8.8VIEWS31SQL Company ViewsAdministration
189Business One8.8WST121Confirmation Level - RowsAdministration
190Business One8.8WTM121Approval Templates - ProducersAdministration
191Business One8.8WTM241Confirmation Templates - StagesAdministration
192Business One8.8WTM321Approval Templates - DocumentsAdministration
193Business One8.8WTM441Approval Templates - TermsAdministration
194Business One8.8WTM521Approval Templates - QueriesAdministration