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

128 tablesB1 9.3 

Banking
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3ABO161External Bank Operation Code - Rows - LogBanking
2Business One9.3ABOC61External Bank Operation Code - LogBanking
3Business One9.3ABOE925Bill of Exchange for Payment - HistoryBanking
4Business One9.3ABT1111Internal Bank Operation Codes - Accounts - LogBanking
5Business One9.3ABTC171Internal Bank Operation Codes - LogBanking
6Business One9.3ACH1221Checks for Payment - Rows - HistoryBanking
7Business One9.3ACHO563Checks for Payment - HistoryBanking
8Business One9.3ADS1791House Bank AccountsBanking
9Business One9.3ARC1251Incoming Payment - Checks - HistoryBanking
10Business One9.3ARC2631Incoming Payment - Invoices - HistoryBanking
11Business One9.3ARC3261Credit Vouchers HistoryBanking
12Business One9.3ARC4351Incoming Payment - Account List - HistoryBanking
13Business One9.3ARC5261Reciept log vat adjustment-HistoryBanking
14Business One9.3ARC6771Incoming Payments - WTax Rows - HistoryBanking
15Business One9.3ARC7131Incoming Payments - Tax Amount per Document - HistoryBanking
16Business One9.3ARC893Incoming Payment - TDS Entries - HistoryBanking
17Business One9.3ARCT1836Incoming Payment - HistoryBanking
18Business One9.3BNK171Bank Statement - Documents ListBanking
19Business One9.3BNK2291Bank Statement - Recommendation ListBanking
20Business One9.3BOC162External Bank Operation Code - RowsBanking
21Business One9.3BOE1131Bill of Exchange for Payment - RowsBanking
22Business One9.3BOT1141Bill of Exchange TransactionsBanking
23Business One9.3BTC1111Internal Bank Operation Codes - AccountsBanking
24Business One9.3CHD1221Checks for Payment Drafts - RowsBanking
25Business One9.3CHO1221Checks for Payment - RowsBanking
26Business One9.3CHO251Checks for Payment - Print StatusBanking
27Business One9.3CTG152Installment LayoutBanking
28Business One9.3DPS131Deposit - RowsBanking
29Business One9.3DSC1792House Bank AccountsBanking
30Business One9.3ITR1253Internal Reconciliation - RowsBanking
31Business One9.3MTH1V181Journal Entries of External ReconciliationBanking
32Business One9.3MTH2V92Bank Statements of External ReconciliationBanking
33Business One9.3MTH3V111Filter for Query MTHBanking
34Business One9.3OBCA21Bank Charges Allocation CodesBanking
35Business One9.3OBCG51Bank Charge for Bank TransfersBanking
36Business One9.3OBNH162Bank Statement HeaderBanking
37Business One9.3OBNK732External Bank Statement ReceivedBanking
38Business One9.3OBOC62External Bank Operation Code CategoryBanking
39Business One9.3OBOE925Bill of Exchange for PaymentBanking
40Business One9.3OBOT101Bill Of Exchang TransactionBanking
41Business One9.3OBST32BoE Stamp TaxBanking
42Business One9.3OBTC172Internal Bank Operation CodesBanking
43Business One9.3OCBI21Central Bank Ind.Banking
44Business One9.3OCHD563Checks for Payment DraftsBanking
45Business One9.3OCHH375Check RegisterBanking
46Business One9.3OCHO563Checks for PaymentBanking
47Business One9.3OCRH398Credit Card ManagementBanking
48Business One9.3OCRV299Credit PaymentsBanking
49Business One9.3OCTG252Payment TermsBanking
50Business One9.3ODPS643DepositBanking
51Business One9.3ODPT361Postdated DepositBanking
52Business One9.3ODSC202Bank CodesBanking
53Business One9.3ODTY32BoE Document TypeBanking
54Business One9.3OIPO21Internal Payment Order NumberBanking
55Business One9.3OIST42BoE InstructionBanking
56Business One9.3OITR301Internal ReconciliationBanking
57Business One9.3OMTC82Bank Statement - Matching CriteriaBanking
58Business One9.3OMTH121Reconciliation HistoryBanking
59Business One9.3OPBD31Document TypeBanking
60Business One9.3OPBU21Budget IDBanking
61Business One9.3OPDF1836Payment DraftBanking
62Business One9.3OPEX1391Payment Results TableBanking
63Business One9.3OPFT31Portfolio DefinitionsBanking
64Business One9.3OPOI31Incoming Payment OrderBanking
65Business One9.3OPOO31Outgoing Payment OrderBanking
66Business One9.3OPPT31Payment TypeBanking
67Business One9.3OPRS31Tax Payer StatusBanking
68Business One9.3OPTF52BoE PortfolioBanking
69Business One9.3OPWB462PWZ - Bank AccountBanking
70Business One9.3OPWZ752Payment WizardBanking
71Business One9.3OPYB22Payment BlockBanking
72Business One9.3OPYD81Payment RunBanking
73Business One9.3OPYM631Payment Methods for Payment WizardBanking
74Business One9.3OPYR31Payment ReasonBanking
75Business One9.3ORCT1836Incoming PaymentBanking
76Business One9.3OROC81Retorno Operation CodesBanking
77Business One9.3ORTW131Boleto Retorno Wizard: Parameter SetsBanking
78Business One9.3OSVR61Saved ReconciliationsBanking
79Business One9.3OTPW172Tax Payment WizardBanking
80Business One9.3OUBR42BranchesBanking
81Business One9.3OUDP52DepartmentsBanking
82Business One9.3OVPM1836Outgoing PaymentsBanking
83Business One9.3PDF1251Payment Draft - ChecksBanking
84Business One9.3PDF2632Payment Draft - InvoicesBanking
85Business One9.3PDF3261Payment Draft - Credit VouchersBanking
86Business One9.3PDF4351Payment Draft - Account ListBanking
87Business One9.3PDF5261PaymentDraft - vat adjustmentBanking
88Business One9.3PDF6771Payment Drafts - Withholding Tax - RowsBanking
89Business One9.3PDF7131Payment Draft - Tax Amount per DocumentBanking
90Business One9.3PDF893Payment Draft - TDS EntriesBanking
91Business One9.3PEX1321Payment Results Table - RowsBanking
92Business One9.3PMN5261Payment - VAT AdjustmentBanking
93Business One9.3PMV893Incoming Payment - TDS EntriesBanking
94Business One9.3PWZ181Payment Wizard - Rows 1Banking
95Business One9.3PWZ2241Payment Wizard - Rows 2Banking
96Business One9.3PWZ31601Payment Wizard - Rows 3Banking
97Business One9.3PWZ4361Payment Wizard - Rows 4Banking
98Business One9.3PWZ5201Payment Wizard - Rows 5Banking
99Business One9.3PWZ6131Payment Wizard Rows - 6Banking
100Business One9.3PYD121Payment Terms Allowed in Payment RunBanking
101Business One9.3PYM141Currency SelectionBanking
102Business One9.3RCC4351Incoming Payment - Credit VouchersBanking
103Business One9.3RCT1251Incoming Payment - ChecksBanking
104Business One9.3RCT2632Incoming Payments - InvoicesBanking
105Business One9.3RCT3261Incoming Pmt - Credit VouchersBanking
106Business One9.3RCT4351Incoming Payment - Account ListBanking
107Business One9.3RCT5261Reciept vat adjustmentBanking
108Business One9.3RCT6771Incoming Payments - WTax RowsBanking
109Business One9.3RCT7131Incoming Pmt - Tax Amount per DocumentBanking
110Business One9.3RCT893Incoming Payment - TDS EntriesBanking
111Business One9.3RTW1441Boleto Retorno Wizard: Import TableBanking
112Business One9.3RTW2111Boleto Retorno Wizard: Import ArchiveBanking
113Business One9.3SVR131Saved Reconciliations - Transaction ListBanking
114Business One9.3TMP893Incoming Payment - TDS EntriesBanking
115Business One9.3TPW171Selection CriteriaBanking
116Business One9.3TPW2101Payable InformationBanking
117Business One9.3TPW3121Utilization and PaymentBanking
118Business One9.3TPW451VAT RefundBanking
119Business One9.3TPW551Challan InformationBanking
120Business One9.3TPW631Journal Entry InformationBanking
121Business One9.3VPM1251Outgoing Payments - Check RowsBanking
122Business One9.3VPM2632Outgoing Payments - InvoicesBanking
123Business One9.3VPM3261Outgoing Payments - Credit VouchersBanking
124Business One9.3VPM4351Outgoing Payments - AccountsBanking
125Business One9.3VPM5261Outgoing Payments - Vat AdjustmentBanking
126Business One9.3VPM6771Outgoing Payments - WTax RowsBanking
127Business One9.3VPM7131Outgoing Payments - Tax Amount per DocumentBanking
128Business One9.3VPM893Outgoing Payment - TDS EntriesBanking