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

220 tablesB1 9.3 

Finance
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3AAC192Asset Classes - Depreciation Areas - HistoryFinance
2Business One9.3AACP1801Periods Category-LogFinance
3Business One9.3AACS141Asset Classes - HistoryFinance
4Business One9.3AACT1231G/L Account - HistoryFinance
5Business One9.3AADT271Fixed Assets Account Determination - HistoryFinance
6Business One9.3ACD1231Credit Memo - RowsFinance
7Business One9.3ACD291Credit Memo - Area Journal TransactionsFinance
8Business One9.3ACD391Credit Memo - Item AreasFinance
9Business One9.3ACQ1231Capitalization - RowsFinance
10Business One9.3ACQ291Capitalization - Area Journal TransactionsFinance
11Business One9.3ACQ391Capitalization - Item AreasFinance
12Business One9.3ACS192Asset Classes - Depreciation AreasFinance
13Business One9.3ADMC101G/L Account Determination Criteria - Inventory - HistoryFinance
14Business One9.3ADPA201Fixed Asset Depreciation Areas - HistoryFinance
15Business One9.3ADT181Depreciation Types - Rows - HistoryFinance
16Business One9.3ADTP501Fixed Assets Depreciation Types - HistoryFinance
17Business One9.3AEXT91Expense TypesFinance
18Business One9.3AFA1231Asset Document - RowsFinance
19Business One9.3AFA291Asset Document - Area Journal TransactionsFinance
20Business One9.3AFAD442Asset Document - HistoryFinance
21Business One9.3AFPR251Posting Period-LogFinance
22Business One9.3AGAR891G/L Account Advanced Rules - HistoryFinance
23Business One9.3AJD11368Journal Entry - History - RowsFinance
24Business One9.3AJD21482Withholding Tax - HistoryFinance
25Business One9.3AJDT1094Journal Entry - HistoryFinance
26Business One9.3AMDR141Manual Distribution RuleFinance
27Business One9.3AMDR1112Manual Distribution Rule - RowsFinance
28Business One9.3APRJ111Project CodesFinance
29Business One9.3AVT191Tax DefinitionFinance
30Business One9.3AVTG622Tax DefinitionFinance
31Business One9.3AWD151Withholding Tax DatesFinance
32Business One9.3AWD281Value RangesFinance
33Business One9.3AWH1151Tax DefinitionFinance
34Business One9.3AWH2101WTax Definition - Rows2Finance
35Business One9.3AWH3101Value RangeFinance
36Business One9.3AWHT511Withholding TaxFinance
37Business One9.3AWTD191Withholding Tax DefinitionFinance
38Business One9.3AWTT62Withholding Tax TypeFinance
39Business One9.3BGT1231Budget - RowsFinance
40Business One9.3BGT291Budget - Cost AccountingFinance
41Business One9.3BGT3101Budget - Cost Accounting RowsFinance
42Business One9.3BOX191Box Definition - RowsFinance
43Business One9.3BOX261Box Definition - AccountsFinance
44Business One9.3BOX371Box Definition - ChoiceFinance
45Business One9.3BOX471Box Definition - Contra Accounts of AccountsFinance
46Business One9.3BTF11366Journal Voucher - RowsFinance
47Business One9.3BTF21482Journal Voucher Withholding Tax - HistoryFinance
48Business One9.3CASE51Internal Recon. Upgrade 2007AFinance
49Business One9.3CASE1361Internal Recon. Upgrade 2007AFinance
50Business One9.3CCAL31Chinese Chart of Account Level DefinitionFinance
51Business One9.3CCPD201Period-End ClosingFinance
52Business One9.3CDC161Cash Discount - RowsFinance
53Business One9.3CFH181Cash Flow Statement Report - History - RowsFinance
54Business One9.3DRN1141Depreciation Run - PostingFinance
55Business One9.3DRN271Depreciation Run - Posting - AssetFinance
56Business One9.3DTP181Depreciation Types - RowsFinance
57Business One9.3FAA182Asset Attributes - RowsFinance
58Business One9.3FAC1141Fixed Asset Parameter Change - RowsFinance
59Business One9.3FAC292Fixed Asset Parameter Change - Period Control ChangeFinance
60Business One9.3FAM171Fixed Asset Data Migration - RowsFinance
61Business One9.3FAR171Fixed Asset Revaluation - RowsFinance
62Business One9.3FIX1342Fixed Asset Transaction - RowsFinance
63Business One9.3FRC1122Extend Cat. f. Financial Rep.Finance
64Business One9.3FTR1231Transfer - RowsFinance
65Business One9.3FTR291Transfer - Area Journal TransactionsFinance
66Business One9.3FTR391Transfer - Item AreasFinance
67Business One9.3GBI1121GBI Row 1 - Electronic Account BookFinance
68Business One9.3GBI1051GBI Row 10 - Enterprise's Cash Flow StatementFinance
69Business One9.3GBI1171GBI Row 11 - Devalue Provision of Enterprise AssetsFinance
70Business One9.3GBI1281GBI Row 12 - Shareholder's Rights and Interests Changing ReportFinance
71Business One9.3GBI1361GBI Row 13 - Enterprise's Profit Distribution ReportFinance
72Business One9.3GBI1461GBI Row 14 - Small Enterprise's Cash Flow StatementFinance
73Business One9.3GBI1561GBI Row 15 - Enterprise's VAT Payable Detail ReportFinance
74Business One9.3GBI1641GBI Row 16 - EmployeesFinance
75Business One9.3GBI2101GBI Row 2 - G/L Account Master RecordsFinance
76Business One9.3GBI341GBI Row 3 - DepartmentsFinance
77Business One9.3GBI491GBI Row 4 - Business PartnersFinance
78Business One9.3GBI541GBI Row 5 - ProjectsFinance
79Business One9.3GBI6181GBI Row 6 - G/L Account BalanceFinance
80Business One9.3GBI7291GBI Row 7 - Accounting VouchersFinance
81Business One9.3GBI871GBI Row 8 - Enterprise's Balance SheetFinance
82Business One9.3GBI961GBI Row 9 - Enterprise's Profit and Loss StatementFinance
83Business One9.3ISW1141Reported Business PartnersFinance
84Business One9.3ISW2191Intrastat Reported ItemsFinance
85Business One9.3ISW3751Declaration RowsFinance
86Business One9.3IWZ1111Accounts Revaluation HistoryFinance
87Business One9.3IWZ221Inflation Warehouse FilterFinance
88Business One9.3IWZ3162Items Last Revaluation DataFinance
89Business One9.3JDT113611Journal Entry - RowsFinance
90Business One9.3JDT21482Withholding Tax - HistoryFinance
91Business One9.3JST1523TDS Adjustment - RowsFinance
92Business One9.3MDP1231Manual Depreciation - RowsFinance
93Business One9.3MDP291Manual Depreciation - Area Journal TransactionsFinance
94Business One9.3MDP391Manual Depreciation - Item AreasFinance
95Business One9.3MDR1112Manual Distribution Rule - RowsFinance
96Business One9.3OACD443Credit MemoFinance
97Business One9.3OACG62Account CategoryFinance
98Business One9.3OACK52Acknowledge NumberFinance
99Business One9.3OACM52AccumulationFinance
100Business One9.3OACP1802Periods CategoryFinance
101Business One9.3OACQ443CapitalizationFinance
102Business One9.3OACR81Accrual TypeFinance
103Business One9.3OACS141Asset ClassesFinance
104Business One9.3OACT1236G/L AccountsFinance
105Business One9.3OADG31Depreciation GroupsFinance
106Business One9.3OADT271Fixed Assets Account DeterminationFinance
107Business One9.3OAGS21Asset GroupsFinance
108Business One9.3OASC51Account Segmentation CategoriesFinance
109Business One9.3OASG51Account SegmentationFinance
110Business One9.3OBGD172Budget Cost Assess. MthdFinance
111Business One9.3OBGS163Budget ScenarioFinance
112Business One9.3OBGT253BudgetFinance
113Business One9.3OBOS63Box Set DefinitionFinance
114Business One9.3OBOX161Box DefinitionFinance
115Business One9.3OBTD102Journal Vouchers ListFinance
116Business One9.3OBTF1094Journal Voucher EntryFinance
117Business One9.3OCCT41Cost Center TypeFinance
118Business One9.3OCDC71Cash DiscountFinance
119Business One9.3OCFH71Cash Flow Statement HistoryFinance
120Business One9.3OCFL181Cash Flow Additional Trans.Finance
121Business One9.3OCFT201Cash Flow Transactions - RowsFinance
122Business One9.3OCFW143Cash Flow Line ItemFinance
123Business One9.3OCIG21CIG CodesFinance
124Business One9.3OCUP21CUP CodesFinance
125Business One9.3ODDG62Withholding Tax Deduction GroupsFinance
126Business One9.3ODGL31Deduction Group ListFinance
127Business One9.3ODIM42Cost Accounting DimensionFinance
128Business One9.3ODMC101G/L Account Determination Criteria - InventoryFinance
129Business One9.3ODPA201Fixed Asset Depreciation AreasFinance
130Business One9.3ODPP21Depreciation Type PoolsFinance
131Business One9.3ODPV172Fixed Assets Depreciation ValueFinance
132Business One9.3ODRN171Depreciation RunFinance
133Business One9.3ODTP501Fixed Assets Depreciation TypesFinance
134Business One9.3OEXT91Expense TypesFinance
135Business One9.3OFAA102Asset AttributesFinance
136Business One9.3OFAC71Fixed Asset Parameter ChangeFinance
137Business One9.3OFAM131Fixed Asset Data MigrationFinance
138Business One9.3OFAR172Fixed Asset RevaluationFinance
139Business One9.3OFIX52Fixed Asset TransactionsFinance
140Business One9.3OFPC31Fixed Assets Fiscal Year ChangeFinance
141Business One9.3OFPR253Posting PeriodFinance
142Business One9.3OFRC871Financial Report CategoriesFinance
143Business One9.3OFRT152Financial Report TemplatesFinance
144Business One9.3OFTR443TransferFinance
145Business One9.3OFYM63Financial Year MasterFinance
146Business One9.3OGAR891G/L Account Advanced RulesFinance
147Business One9.3OGBI91GB Interface: Common InfoFinance
148Business One9.3OHSV151Hasavsevet Journal EntryFinance
149Business One9.3OIDC31IndicatorFinance
150Business One9.3OISW721Intrastat WizardFinance
151Business One9.3OIWZ351Inflation WizardFinance
152Business One9.3OJDT1096Journal EntryFinance
153Business One9.3OJET61JE Document TypeFinance
154Business One9.3OJST111TDS AdjustmentFinance
155Business One9.3OKPF51KPI FactorFinance
156Business One9.3OKRT52Tax Report TypeFinance
157Business One9.3OMDP443Manual DepreciationFinance
158Business One9.3OMDR141Manual Distribution RuleFinance
159Business One9.3ONFM81Nota Fiscal ModelFinance
160Business One9.3OPRJ111Project CodesFinance
161Business One9.3ORCR252Recurring PostingsFinance
162Business One9.3ORTI443RetirementFinance
163Business One9.3ORTM202Rate DifferencesFinance
164Business One9.3ORTS62CPI and FC Rates for ReportsFinance
165Business One9.3ORTT52CPI and FC RatesFinance
166Business One9.3OSCM111Special Ledger - Analytical Accounting Configuration Rules: MaterialFinance
167Business One9.3OSCR111Special Ledger - Analytical Accounting Configuration Rules: Revenues & ExpensesFinance
168Business One9.3OSHR81Shareholder's Rights and Interests Report HistoryFinance
169Business One9.3OSLM151Special Ledger - Analytical Accounting Report: MaterialFinance
170Business One9.3OSLR151Special Ledger - Analytical Accounting Report: Revenues & ExpensesFinance
171Business One9.3OSVT42Define Summary VAT Report TypeFinance
172Business One9.3OTAX52VAT TransactionsFinance
173Business One9.3OTRC62Journal Entry CodesFinance
174Business One9.3OTRT111Posting TemplatesFinance
175Business One9.3OTTR41Remark Text TemplatesFinance
176Business One9.3OUTX52Unreported VAT TransactionsFinance
177Business One9.3OUWTX52Unreported WTax TransactionsFinance
178Business One9.3OVRW161VAT Reposting WizardFinance
179Business One9.3OVTG622Tax DefinitionFinance
180Business One9.3OVTR782Tax ReportFinance
181Business One9.3OWHT512Withholding TaxFinance
182Business One9.3OWTA82Withholding Tax AccumulationFinance
183Business One9.3OWTD193Withholding Tax DefinitionFinance
184Business One9.3OWTT62Withholding Tax TypeFinance
185Business One9.3OWTX52WTax TransactionsFinance
186Business One9.3OZRD101POS Daily SummaryFinance
187Business One9.3RCI141Recipient List - RowsFinance
188Business One9.3RCR1291Recurring Postings - RowsFinance
189Business One9.3RTI1231Retirement - RowsFinance
190Business One9.3RTI291Retirement - Area Journal TransactionsFinance
191Business One9.3RTI391Retirement - Item AreasFinance
192Business One9.3RTM1192Rate Differences - RowsFinance
193Business One9.3RTM262Rate Differences - SC Adjustment RowsFinance
194Business One9.3SCM1151Special Ledger - Analytical Accounting Configuration Rule Conditions: MaterialFinance
195Business One9.3SCM2221Special Ledger - Analytical Accounting Configuration Rule Goals: MaterialFinance
196Business One9.3SCM3111Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: MaterialFinance
197Business One9.3SCR1151Special Ledger - Analytical Accounting Configuration Rule Conditions: Revenues & ExpensesFinance
198Business One9.3SCR2221Special Ledger - Analytical Accounting Configuration Rule Goals: Revenues & ExpensesFinance
199Business One9.3SCR3111Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: Revenues & ExpensesFinance
200Business One9.3SHR1101Shareholder's Rights and Interests Report History - RowsFinance
201Business One9.3SLM1341Special Ledger - Analytical Accounting Report Lines: MaterialFinance
202Business One9.3SLR1341Special Ledger - Analytical Accounting Report Lines: Revenues & ExpensesFinance
203Business One9.3TAX1861VAT Transactions - RowsFinance
204Business One9.3TRT1261Posting Templates - RowsFinance
205Business One9.3UTX1861Unreported VAT Transactions - RowsFinance
206Business One9.3UWTX1541WTax Transactions - RowsFinance
207Business One9.3VRW121VAT Reposting Wizard - Rows 1Finance
208Business One9.3VRW2351VAT Reposting Wizard - Rows 2Finance
209Business One9.3VRW321VAT Reposting Wizard - Rows 3Finance
210Business One9.3VTG191Tax DefinitionFinance
211Business One9.3VTR1101Tax GroupsFinance
212Business One9.3VTR251Doc. Type FilterFinance
213Business One9.3VTR331Series FilterFinance
214Business One9.3WHT1151Withholding Tax DefinitionFinance
215Business One9.3WHT2101Withholding Tax Definition - Rows2Finance
216Business One9.3WHT3101Value RangeFinance
217Business One9.3WTD151Withholding Tax DatesFinance
218Business One9.3WTD281Value RangesFinance
219Business One9.3WTX1541WTax Transactions - RowsFinance
220Business One9.3ZRD162POS Daily Summary - TotalsFinance