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

113 tablesB1 8.82 

Banking
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82ABO161External Bank Operation Code - Rows - LogBanking
2Business One8.82ABOC61External Bank Operation Code - LogBanking
3Business One8.82ABOE775Bill of Exchange for Payment - HistoryBanking
4Business One8.82ABT1111Internal Bank Operation Codes - Accounts - LogBanking
5Business One8.82ABTC171Internal Bank Operation Codes - Banking
6Business One8.82ACH1201Checks for Payment - Rows - HistoryBanking
7Business One8.82ACHO491Checks for Payment - HistoryBanking
8Business One8.82ADS1641House Bank AccountsBanking
9Business One8.82ARC1191Incoming Payment - Checks - HistoryBanking
10Business One8.82ARC2611Incoming Payment - Invoices - HistoryBanking
11Business One8.82ARC3261Credit Vouchers HistoryBanking
12Business One8.82ARC4351Incoming Payment - Account List - HistoryBanking
13Business One8.82ARC5261Reciept log Banking
14Business One8.82ARC6421Incoming Payments - WTax Rows - HistoryBanking
15Business One8.82ARC7131Incoming Payments - Tax Amount per Document - HistoryBanking
16Business One8.82ARC872Incoming Payment - TDS Entries - HistoryBanking
17Business One8.82ARCT1686Incoming Payment - HistoryBanking
18Business One8.82BNK171Bank Statement - Documents ListBanking
19Business One8.82BNK2261Bank Statement - Recommendation ListBanking
20Business One8.82BOC162External Bank Operation Code - RowsBanking
21Business One8.82BOE1131Bill of Exchange for Payment - RowsBanking
22Business One8.82BOT1101Bill of Exchange TransactionsBanking
23Business One8.82BTC1111Internal Bank Operation Codes - AccountsBanking
24Business One8.82CHD1201Checks for Payment Drafts - RowsBanking
25Business One8.82CHO1201Checks for Payment - RowsBanking
26Business One8.82CHO251Checks for Payment - Print StatusBanking
27Business One8.82CTG152Installment LayoutBanking
28Business One8.82DPS121Deposit - RowsBanking
29Business One8.82DSC1642House Bank AccountsBanking
30Business One8.82ITR1243Internal Reconciliation - RowsBanking
31Business One8.82OBCA21Bank Charges Allocation CodesBanking
32Business One8.82OBCG51Bank Charge for Bank TransfersBanking
33Business One8.82OBNH152Bank Statement HeaderBanking
34Business One8.82OBNK602External Bank Statement ReceivedBanking
35Business One8.82OBOC62External Bank Operation Code CategoryBanking
36Business One8.82OBOE775Bill of Exchange for PaymentBanking
37Business One8.82OBOT101Bill Of Exchang TransactionBanking
38Business One8.82OBST32BoE Stamp TaxBanking
39Business One8.82OBTC172Internal Bank Operation CodesBanking
40Business One8.82OCBI21Central Bank Ind.Banking
41Business One8.82OCHD493Checks for Payment DraftsBanking
42Business One8.82OCHH295Check RegisterBanking
43Business One8.82OCHO493Checks for PaymentBanking
44Business One8.82OCRH388Credit Card ManagementBanking
45Business One8.82OCRV289Credit PaymentsBanking
46Business One8.82OCTG242Payment TermsBanking
47Business One8.82ODPS623DepositBanking
48Business One8.82ODPT361Postdated DepositBanking
49Business One8.82ODSC202Bank CodesBanking
50Business One8.82ODTY32BoE Document TypeBanking
51Business One8.82OIPO21Internal Payment Order NumberBanking
52Business One8.82OIST32BoE InstructionBanking
53Business One8.82OITR261Internal ReconciliationBanking
54Business One8.82OMTC82Bank Statement - Matching CriteriaBanking
55Business One8.82OMTH121Reconciliation HistoryBanking
56Business One8.82OPDF1686Payment DraftBanking
57Business One8.82OPEX971Payment Results TableBanking
58Business One8.82OPFT31Portfolio DefinitionsBanking
59Business One8.82OPTF52BoE PortfolioBanking
60Business One8.82OPWB382PWZ - Bank AccountBanking
61Business One8.82OPWZ572Payment WizardBanking
62Business One8.82OPYB21Payment BlockBanking
63Business One8.82OPYD81Payment RunBanking
64Business One8.82OPYM521Payment Methods for Payment WizardBanking
65Business One8.82ORCT1686Incoming PaymentBanking
66Business One8.82OSVR61Saved ReconciliationsBanking
67Business One8.82OTPW172Tax Payment WizardBanking
68Business One8.82OUBR42BranchesBanking
69Business One8.82OUDP42DepartmentsBanking
70Business One8.82OVPM1686Outgoing PaymentsBanking
71Business One8.82PDF1191Payment Draft - ChecksBanking
72Business One8.82PDF2612Payment Draft - InvoicesBanking
73Business One8.82PDF3261Payment Draft - Credit VouchersBanking
74Business One8.82PDF4351Payment Draft - Account ListBanking
75Business One8.82PDF5261PaymentDraft - Banking
76Business One8.82PDF6421Payment Drafts - Withholding Tax - RowsBanking
77Business One8.82PDF7131Payment Draft - Tax Amount per DocumentBanking
78Business One8.82PDF872Payment Draft - TDS EntriesBanking
79Business One8.82PEX1311Payment Results Table - RowsBanking
80Business One8.82PMN5261Payment - VAT AdjustmentBanking
81Business One8.82PMV872Incoming Payment - TDS EntriesBanking
82Business One8.82PWZ171Payment Wizard - Rows 1Banking
83Business One8.82PWZ2171Payment Wizard - Rows 2Banking
84Business One8.82PWZ31031Payment Wizard - Rows 3Banking
85Business One8.82PWZ4231Payment Wizard - Rows 4Banking
86Business One8.82PWZ5181Payment Wizard - Rows 5Banking
87Business One8.82PYD121Payment Terms Allowed in Payment RunBanking
88Business One8.82PYM141Currency SelectionBanking
89Business One8.82RCC4351Incoming Payment - Credit VouchersBanking
90Business One8.82RCT1191Incoming Payment - ChecksBanking
91Business One8.82RCT2612Incoming Payments - InvoicesBanking
92Business One8.82RCT3261Incoming Pmt - Credit VouchersBanking
93Business One8.82RCT4351Incoming Payment - Account ListBanking
94Business One8.82RCT5261Reciept vat adjustmentBanking
95Business One8.82RCT6421Incoming Payments - WTax RowsBanking
96Business One8.82RCT7131Incoming Pmt - Tax Amount per DocumentBanking
97Business One8.82RCT872Incoming Payment - TDS EntriesBanking
98Business One8.82SVR131Saved Reconciliations - Transaction ListBanking
99Business One8.82TMP872Incoming Payment - TDS EntriesBanking
100Business One8.82TPW171Selection CriteriaBanking
101Business One8.82TPW2101Payable InformationBanking
102Business One8.82TPW3121Utilization and PaymentBanking
103Business One8.82TPW451VAT RefundBanking
104Business One8.82TPW551Challan InformationBanking
105Business One8.82TPW631Journal Entry InformationBanking
106Business One8.82VPM1191Outgoing Payments - Check RowsBanking
107Business One8.82VPM2612Outgoing Payments - InvoicesBanking
108Business One8.82VPM3261Outgoing Payments - Credit VouchersBanking
109Business One8.82VPM4351Outgoing Payments - AccountsBanking
110Business One8.82VPM5261Outgoing Payments - Vat AdjustmentBanking
111Business One8.82VPM6421Outgoing Payments - WTax Banking
112Business One8.82VPM7131Outgoing Payments - Tax Amount per DocumentBanking
113Business One8.82VPM872Outgoing Payment - TDS EntriesBanking