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

118 tablesB1 8.8 

Finance
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.8AACP1361Periods Category-LogFinance
2Business One8.8AACT921G/L Account - HistoryFinance
3Business One8.8AFPR251Posting Period-LogFinance
4Business One8.8AJD11108Journal Entry - History - RowsFinance
5Business One8.8AJDT814Journal Entry - HistoryFinance
6Business One8.8AVT181Tax DefinitionFinance
7Business One8.8AVTG352Tax DefinitionFinance
8Business One8.8AWH1101Tax DefinitionFinance
9Business One8.8AWH2101WTax Definition - Rows2Finance
10Business One8.8AWH3101Value RangeFinance
11Business One8.8AWHT341Withholding TaxFinance
12Business One8.8BGT1231Budget - RowsFinance
13Business One8.8BOX161Box Definition - RowsFinance
14Business One8.8BOX241Box Definition - AccountsFinance
15Business One8.8BOX341Box Definition - ChoiceFinance
16Business One8.8BTF11106Journal Voucher Finance
17Business One8.8CASE51Internal Recon. Upgrade 2007AFinance
18Business One8.8CASE1361Internal Recon. Upgrade 2007AFinance
19Business One8.8CCAL31China Chart of Account Level DefinitionFinance
20Business One8.8CCPD171Period-End ClosingFinance
21Business One8.8CDC161Cash Discount - RowsFinance
22Business One8.8CFH181Cash Flow Statement Report - History - RowsFinance
23Business One8.8FRC1102Extend Cat. f. Financial Rep.Finance
24Business One8.8GBI1121GBI Row 1 - Electronic Account BookFinance
25Business One8.8GBI1051GBI Row 10 - Enterprise's Cash Flow StatementFinance
26Business One8.8GBI1171GBI Row 11 - Devalue Provision of Enterprise AssetsFinance
27Business One8.8GBI1281GBI Row 12 - Shareholder's Rights and Interests Changing ReportFinance
28Business One8.8GBI1361GBI Row 13 - Enterprise's Profit Distribution ReportFinance
29Business One8.8GBI1461GBI Row 14 - Small Enterprise's Cash Flow StatementFinance
30Business One8.8GBI1561GBI Row 15 - Enterprise's VAT Payable Detail ReportFinance
31Business One8.8GBI1641GBI Row 16 - EmployeesFinance
32Business One8.8GBI2101GBI Row 2 - G/L Account Master RecordsFinance
33Business One8.8GBI341GBI Row 3 - DepartmentsFinance
34Business One8.8GBI491GBI Row 4 - Business PartnersFinance
35Business One8.8GBI541GBI Row 5 - ProjectsFinance
36Business One8.8GBI6181GBI Row 6 - G/L Account BalanceFinance
37Business One8.8GBI7291GBI Row 7 - Accounting VouchersFinance
38Business One8.8GBI871GBI Row 8 - Enterprise's Balance SheetFinance
39Business One8.8GBI961GBI Row 9 - Enterprise's Profit and Loss StatementFinance
40Business One8.8IWZ1111Accounts Revaluation HistoryFinance
41Business One8.8IWZ221Inflation Warehouse FilterFinance
42Business One8.8IWZ3162Items Last Revaluation DataFinance
43Business One8.8JDT111010Journal Entry - RowsFinance
44Business One8.8JST1523TDS Adjustment - RowsFinance
45Business One8.8MDR172Manual Distribution Rule - RowsFinance
46Business One8.8OACG62Account CategoryFinance
47Business One8.8OACK52Acknowledge NumberFinance
48Business One8.8OACM52AccumulationFinance
49Business One8.8OACP1362Periods CategoryFinance
50Business One8.8OACT925G/L AccountsFinance
51Business One8.8OASC51Account Segmentation CategoriesFinance
52Business One8.8OASG51Account SegmentationFinance
53Business One8.8OBGD172Budget Cost Assess. MthdFinance
54Business One8.8OBGS103Budget ScenarioFinance
55Business One8.8OBGT253BudgetFinance
56Business One8.8OBOX91Box DefinitionFinance
57Business One8.8OBTD102Journal Vouchers ListFinance
58Business One8.8OBTF814Journal Voucher EntryFinance
59Business One8.8OCDC61Cash DiscountFinance
60Business One8.8OCFH71Cash Flow Statement HistoryFinance
61Business One8.8OCFL81Cash Flow Additional Trans.Finance
62Business One8.8OCFT201Cash Flow Transactions - RowsFinance
63Business One8.8OCFW112Cash Flow Line ItemFinance
64Business One8.8ODDG62Withholding Tax Deduction GroupsFinance
65Business One8.8ODGL31Deduction Group ListFinance
66Business One8.8ODIM41Cost Accounting DimensionFinance
67Business One8.8OFPR253Posting PeriodFinance
68Business One8.8OFRC691Financial Report CategoriesFinance
69Business One8.8OFRT152Financial Report TemplatesFinance
70Business One8.8OFYM63Financial Year MasterFinance
71Business One8.8OGBI91GB Interface: Common InfoFinance
72Business One8.8OHSV151Hasavsevet Journal EntryFinance
73Business One8.8OIDC31IndicatorFinance
74Business One8.8OIWZ351Inflation WizardFinance
75Business One8.8OJDT816Journal EntryFinance
76Business One8.8OJST111TDS AdjustmentFinance
77Business One8.8OKRT52Tax Report TypeFinance
78Business One8.8OMDR91Manual Distribution RuleFinance
79Business One8.8OPRJ51Project CodesFinance
80Business One8.8ORCR232Recurring PostingsFinance
81Business One8.8ORTM152Rate DifferencesFinance
82Business One8.8ORTS52CPI and FC Rates for ReportsFinance
83Business One8.8ORTT52CPI and FC RatesFinance
84Business One8.8OSCM111Special Ledger - Analytical Accounting Configuration Rules: MaterialFinance
85Business One8.8OSCR111Special Ledger - Analytical Accounting Configuration Rules: Revenues & ExpensesFinance
86Business One8.8OSHR81Shareholder's Rights and Interests Report HistoryFinance
87Business One8.8OSLM151Special Ledger - Analytical Accounting Report: MaterialFinance
88Business One8.8OSLR151Special Ledger - Analytical Accounting Report: Revenues & ExpensesFinance
89Business One8.8OSVT42Define Summary VAT Report TypeFinance
90Business One8.8OTAX52VAT TransactionsFinance
91Business One8.8OTRC62Journal Entry CodesFinance
92Business One8.8OTRT101Posting TemplatesFinance
93Business One8.8OUTX52Unreported VAT TransactionsFinance
94Business One8.8OVTG352Tax DefinitionFinance
95Business One8.8OVTR732Tax ReportFinance
96Business One8.8OWHT342Withholding TaxFinance
97Business One8.8OWTT22Withholding Tax TypeFinance
98Business One8.8RCR1261Recurring Postings - RowsFinance
99Business One8.8RTM1142Rate Differences - RowsFinance
100Business One8.8SCM1151Special Ledger - Analytical Accounting Configuration Rule Conditions: MaterialFinance
101Business One8.8SCM2221Special Ledger - Analytical Accounting Configuration Rule Goals: MaterialFinance
102Business One8.8SCM3111Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: MaterialFinance
103Business One8.8SCR1151Special Ledger - Analytical Accounting Configuration Rule Conditions: Revenues & ExpensesFinance
104Business One8.8SCR2221Special Ledger - Analytical Accounting Configuration Rule Goals: Revenues & ExpensesFinance
105Business One8.8SCR3111Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: Revenues & ExpensesFinance
106Business One8.8SHR1101Shareholder's Rights and Interests Report History - RowsFinance
107Business One8.8SLM1341Special Ledger - Analytical Accounting Report Lines: MaterialFinance
108Business One8.8SLR1341Special Ledger - Analytical Accounting Report Lines: Revenues & ExpensesFinance
109Business One8.8TAX1701VAT Transactions - RowsFinance
110Business One8.8TRT1241Posting Templates - RowsFinance
111Business One8.8UTX1701Unreported VAT Transactions - RowsFinance
112Business One8.8VTG181Tax DefinitionFinance
113Business One8.8VTR1101Tax GroupsFinance
114Business One8.8VTR251Doc. Type FilterFinance
115Business One8.8VTR331Series FilterFinance
116Business One8.8WHT1101Withholding Tax DefinitionFinance
117Business One8.8WHT2101Withholding Tax Definition - Rows2Finance
118Business One8.8WHT3101Value RangeFinance