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

131 tablesB1 8.82 

Finance
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82AACP1431Periods Category-LogFinance
2Business One8.82AACT1081G/L Account - HistoryFinance
3Business One8.82AFPR251Posting Period-LogFinance
4Business One8.82AJD11208Journal Entry - History - RowsFinance
5Business One8.82AJD2822Withholding Tax - HistoryFinance
6Business One8.82AJDT904Journal Entry - HistoryFinance
7Business One8.82AMDR131Manual Distribution RuleFinance
8Business One8.82AMDR1112Manual Distribution Rule - RowsFinance
9Business One8.82AVT191Tax DefinitionFinance
10Business One8.82AVTG382Tax DefinitionFinance
11Business One8.82AWH1101Tax DefinitionFinance
12Business One8.82AWH2101WTax Definition - Rows2Finance
13Business One8.82AWH3101Value RangeFinance
14Business One8.82AWHT381Withholding TaxFinance
15Business One8.82BGT1231Budget - RowsFinance
16Business One8.82BGT291Budget - Cost AccountingFinance
17Business One8.82BGT3101Budget - Cost Accounting RowsFinance
18Business One8.82BOX181Box Definition - RowsFinance
19Business One8.82BOX251Box Definition - AccountsFinance
20Business One8.82BOX351Box Definition - ChoiceFinance
21Business One8.82BTF11206Journal Voucher Finance
22Business One8.82BTF2822Journal Voucher Withholding Tax - HistoryFinance
23Business One8.82CASE51Internal Recon. Upgrade 2007AFinance
24Business One8.82CASE1361Internal Recon. Upgrade 2007AFinance
25Business One8.82CCAL31Chinese Chart of Account Level DefinitionFinance
26Business One8.82CCPD171Period-End ClosingFinance
27Business One8.82CDC161Cash Discount - RowsFinance
28Business One8.82CFH181Cash Flow Statement Report - History - RowsFinance
29Business One8.82FRC1122Extend Cat. f. Financial Rep.Finance
30Business One8.82GBI1121GBI Row 1 - Electronic Account BookFinance
31Business One8.82GBI1051GBI Row 10 - Enterprise's Cash Flow StatementFinance
32Business One8.82GBI1171GBI Row 11 - Devalue Provision of Enterprise AssetsFinance
33Business One8.82GBI1281GBI Row 12 - Shareholder's Rights and Interests Changing ReportFinance
34Business One8.82GBI1361GBI Row 13 - Enterprise's Profit Distribution ReportFinance
35Business One8.82GBI1461GBI Row 14 - Small Enterprise's Cash Flow StatementFinance
36Business One8.82GBI1561GBI Row 15 - Enterprise's VAT Payable Detail ReportFinance
37Business One8.82GBI1641GBI Row 16 - EmployeesFinance
38Business One8.82GBI2101GBI Row 2 - G/L Account Master RecordsFinance
39Business One8.82GBI341GBI Row 3 - DepartmentsFinance
40Business One8.82GBI491GBI Row 4 - Business PartnersFinance
41Business One8.82GBI541GBI Row 5 - ProjectsFinance
42Business One8.82GBI6181GBI Row 6 - G/L Account BalanceFinance
43Business One8.82GBI7291GBI Row 7 - Accounting VouchersFinance
44Business One8.82GBI871GBI Row 8 - Enterprise's Balance SheetFinance
45Business One8.82GBI961GBI Row 9 - Enterprise's Profit and Loss StatementFinance
46Business One8.82IWZ1111Accounts Revaluation HistoryFinance
47Business One8.82IWZ221Inflation Warehouse FilterFinance
48Business One8.82IWZ3162Items Last Revaluation DataFinance
49Business One8.82JDT112011Journal Entry - RowsFinance
50Business One8.82JDT2822Withholding Tax - HistoryFinance
51Business One8.82JST1523TDS Adjustment - RowsFinance
52Business One8.82MDR1112Manual Distribution Rule - RowsFinance
53Business One8.82OACG62Account CategoryFinance
54Business One8.82OACK52Acknowledge NumberFinance
55Business One8.82OACM52AccumulationFinance
56Business One8.82OACP1432Periods CategoryFinance
57Business One8.82OACR81Accrual TypeFinance
58Business One8.82OACT1085G/L AccountsFinance
59Business One8.82OASC51Account Segmentation CategoriesFinance
60Business One8.82OASG51Account SegmentationFinance
61Business One8.82OBGD172Budget Cost Assess. MthdFinance
62Business One8.82OBGS163Budget ScenarioFinance
63Business One8.82OBGT253BudgetFinance
64Business One8.82OBOX121Box DefinitionFinance
65Business One8.82OBTD102Journal Vouchers ListFinance
66Business One8.82OBTF904Journal Voucher EntryFinance
67Business One8.82OCCT41Cost Center TypeFinance
68Business One8.82OCDC71Cash DiscountFinance
69Business One8.82OCFH71Cash Flow Statement HistoryFinance
70Business One8.82OCFL81Cash Flow Additional Trans.Finance
71Business One8.82OCFT201Cash Flow Transactions - RowsFinance
72Business One8.82OCFW112Cash Flow Line ItemFinance
73Business One8.82OCIG21CIG CodesFinance
74Business One8.82OCUP21CUP CodesFinance
75Business One8.82ODDG62Withholding Tax Deduction GroupsFinance
76Business One8.82ODGL31Deduction Group ListFinance
77Business One8.82ODIM41Cost Accounting DimensionFinance
78Business One8.82OFPR253Posting PeriodFinance
79Business One8.82OFRC701Financial Report CategoriesFinance
80Business One8.82OFRT152Financial Report TemplatesFinance
81Business One8.82OFYM63Financial Year MasterFinance
82Business One8.82OGBI91GB Interface: Common InfoFinance
83Business One8.82OHSV151Hasavsevet Journal EntryFinance
84Business One8.82OIDC31IndicatorFinance
85Business One8.82OIWZ351Inflation WizardFinance
86Business One8.82OJDT906Journal EntryFinance
87Business One8.82OJET61JE Docment TypeFinance
88Business One8.82OJST111TDS AdjustmentFinance
89Business One8.82OKRT52Tax Report TypeFinance
90Business One8.82OMDR131Manual Distribution RuleFinance
91Business One8.82ONFM71Nota Fiscal ModelFinance
92Business One8.82OPRJ81Project CodesFinance
93Business One8.82ORCR242Recurring PostingsFinance
94Business One8.82ORTM152Rate DifferencesFinance
95Business One8.82ORTS52CPI and FC Rates for ReportsFinance
96Business One8.82ORTT52CPI and FC RatesFinance
97Business One8.82OSCM111Special Ledger - Analytical Accounting Configuration Rules: MaterialFinance
98Business One8.82OSCR111Special Ledger - Analytical Accounting Configuration Rules: Revenues & ExpensesFinance
99Business One8.82OSHR81Shareholder's Rights and Interests Report HistoryFinance
100Business One8.82OSLM151Special Ledger - Analytical Accounting Report: MaterialFinance
101Business One8.82OSLR151Special Ledger - Analytical Accounting Report: Revenues & ExpensesFinance
102Business One8.82OSVT42Define Summary VAT Report TypeFinance
103Business One8.82OTAX52VAT TransactionsFinance
104Business One8.82OTRC62Journal Entry CodesFinance
105Business One8.82OTRT101Posting TemplatesFinance
106Business One8.82OUTX52Unreported VAT TransactionsFinance
107Business One8.82OVTG382Tax DefinitionFinance
108Business One8.82OVTR742Tax ReportFinance
109Business One8.82OWHT382Withholding TaxFinance
110Business One8.82OWTT22Withholding Tax TypeFinance
111Business One8.82RCR1271Recurring Postings - RowsFinance
112Business One8.82RTM1172Rate Differences - RowsFinance
113Business One8.82SCM1151Special Ledger - Analytical Accounting Configuration Rule Conditions: MaterialFinance
114Business One8.82SCM2221Special Ledger - Analytical Accounting Configuration Rule Goals: MaterialFinance
115Business One8.82SCM3111Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: MaterialFinance
116Business One8.82SCR1151Special Ledger - Analytical Accounting Configuration Rule Conditions: Revenues & ExpensesFinance
117Business One8.82SCR2221Special Ledger - Analytical Accounting Configuration Rule Goals: Revenues & ExpensesFinance
118Business One8.82SCR3111Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: Revenues & ExpensesFinance
119Business One8.82SHR1101Shareholder's Rights and Interests Report History - RowsFinance
120Business One8.82SLM1341Special Ledger - Analytical Accounting Report Lines: MaterialFinance
121Business One8.82SLR1341Special Ledger - Analytical Accounting Report Lines: Revenues & ExpensesFinance
122Business One8.82TAX1701VAT Transactions - RowsFinance
123Business One8.82TRT1251Posting Templates - RowsFinance
124Business One8.82UTX1701Unreported VAT Transactions - RowsFinance
125Business One8.82VTG191Tax DefinitionFinance
126Business One8.82VTR1101Tax GroupsFinance
127Business One8.82VTR251Doc. Type FilterFinance
128Business One8.82VTR331Series FilterFinance
129Business One8.82WHT1101Withholding Tax DefinitionFinance
130Business One8.82WHT2101Withholding Tax Definition - Rows2Finance
131Business One8.82WHT3101Value RangeFinance