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
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
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

214 tablesB1 9.2 

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