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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

128 tablesB1 9.2 

Banking
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.2ABO161External Bank Operation Code - Rows - LogBanking
2Business One9.2ABOC61External Bank Operation Code - LogBanking
3Business One9.2ABOE885Bill of Exchange for Payment - HistoryBanking
4Business One9.2ABT1111Internal Bank Operation Codes - Accounts - LogBanking
5Business One9.2ABTC171Internal Bank Operation Codes - LogBanking
6Business One9.2ACH1201Checks for Payment - Rows - HistoryBanking
7Business One9.2ACHO521Checks for Payment - HistoryBanking
8Business One9.2ADS1751House Bank AccountsBanking
9Business One9.2ARC1191Incoming Payment - Checks - HistoryBanking
10Business One9.2ARC2611Incoming Payment - Invoices - HistoryBanking
11Business One9.2ARC3261Credit Vouchers HistoryBanking
12Business One9.2ARC4351Incoming Payment - Account List - HistoryBanking
13Business One9.2ARC5261Reciept log vat adjustment-HistoryBanking
14Business One9.2ARC6421Incoming Payments - WTax Rows - HistoryBanking
15Business One9.2ARC7131Incoming Payments - Tax Amount per Document - HistoryBanking
16Business One9.2ARC872Incoming Payment - TDS Entries - HistoryBanking
17Business One9.2ARCT1736Incoming Payment - HistoryBanking
18Business One9.2BNK171Bank Statement - Documents ListBanking
19Business One9.2BNK2291Bank Statement - Recommendation ListBanking
20Business One9.2BOC162External Bank Operation Code - RowsBanking
21Business One9.2BOE1131Bill of Exchange for Payment - RowsBanking
22Business One9.2BOT1101Bill of Exchange TransactionsBanking
23Business One9.2BTC1111Internal Bank Operation Codes - AccountsBanking
24Business One9.2CHD1201Checks for Payment Drafts - RowsBanking
25Business One9.2CHO1201Checks for Payment - RowsBanking
26Business One9.2CHO251Checks for Payment - Print StatusBanking
27Business One9.2CTG152Installment LayoutBanking
28Business One9.2DPS131Deposit - RowsBanking
29Business One9.2DSC1752House Bank AccountsBanking
30Business One9.2ITR1243Internal Reconciliation - RowsBanking
31Business One9.2MTH1V181Journal Entries of External ReconciliationBanking
32Business One9.2MTH2V92Bank Statements of External ReconciliationBanking
33Business One9.2MTH3V111Filter for Query MTHBanking
34Business One9.2OBCA21Bank Charges Allocation CodesBanking
35Business One9.2OBCG51Bank Charge for Bank TransfersBanking
36Business One9.2OBNH152Bank Statement HeaderBanking
37Business One9.2OBNK682External Bank Statement ReceivedBanking
38Business One9.2OBOC62External Bank Operation Code CategoryBanking
39Business One9.2OBOE885Bill of Exchange for PaymentBanking
40Business One9.2OBOT101Bill Of Exchang TransactionBanking
41Business One9.2OBST32BoE Stamp TaxBanking
42Business One9.2OBTC172Internal Bank Operation CodesBanking
43Business One9.2OCBI21Central Bank Ind.Banking
44Business One9.2OCHD523Checks for Payment DraftsBanking
45Business One9.2OCHH315Check RegisterBanking
46Business One9.2OCHO523Checks for PaymentBanking
47Business One9.2OCRH398Credit Card ManagementBanking
48Business One9.2OCRV299Credit PaymentsBanking
49Business One9.2OCTG242Payment TermsBanking
50Business One9.2ODPS643DepositBanking
51Business One9.2ODPT361Postdated DepositBanking
52Business One9.2ODSC202Bank CodesBanking
53Business One9.2ODTY32BoE Document TypeBanking
54Business One9.2OIPO21Internal Payment Order NumberBanking
55Business One9.2OIST42BoE InstructionBanking
56Business One9.2OITR261Internal ReconciliationBanking
57Business One9.2OMTC82Bank Statement - Matching CriteriaBanking
58Business One9.2OMTH121Reconciliation HistoryBanking
59Business One9.2OPBD31Document TypeBanking
60Business One9.2OPBU21Budget IDBanking
61Business One9.2OPDF1736Payment DraftBanking
62Business One9.2OPEX1321Payment Results TableBanking
63Business One9.2OPFT31Portfolio DefinitionsBanking
64Business One9.2OPOI31Incoming Payment OrderBanking
65Business One9.2OPOO31Outgoing Payment OrderBanking
66Business One9.2OPPT31Payment TypeBanking
67Business One9.2OPRS31Tax Payer StatusBanking
68Business One9.2OPTF52BoE PortfolioBanking
69Business One9.2OPWB432PWZ - Bank AccountBanking
70Business One9.2OPWZ672Payment WizardBanking
71Business One9.2OPYB22Payment BlockBanking
72Business One9.2OPYD81Payment RunBanking
73Business One9.2OPYM601Payment Methods for Payment WizardBanking
74Business One9.2OPYR31Payment ReasonBanking
75Business One9.2ORCT1736Incoming PaymentBanking
76Business One9.2OROC81Retorno Operation CodesBanking
77Business One9.2ORTW131Boleto Retorno Wizard: Parameter SetsBanking
78Business One9.2OSVR61Saved ReconciliationsBanking
79Business One9.2OTPW172Tax Payment WizardBanking
80Business One9.2OUBR42BranchesBanking
81Business One9.2OUDP52DepartmentsBanking
82Business One9.2OVPM1736Outgoing PaymentsBanking
83Business One9.2PDF1191Payment Draft - ChecksBanking
84Business One9.2PDF2612Payment Draft - InvoicesBanking
85Business One9.2PDF3261Payment Draft - Credit VouchersBanking
86Business One9.2PDF4351Payment Draft - Account ListBanking
87Business One9.2PDF5261PaymentDraft - vat adjustmentBanking
88Business One9.2PDF6421Payment Drafts - Withholding Tax - RowsBanking
89Business One9.2PDF7131Payment Draft - Tax Amount per DocumentBanking
90Business One9.2PDF872Payment Draft - TDS EntriesBanking
91Business One9.2PEX1311Payment Results Table - RowsBanking
92Business One9.2PMN5261Payment - VAT AdjustmentBanking
93Business One9.2PMV872Incoming Payment - TDS EntriesBanking
94Business One9.2PWZ171Payment Wizard - Rows 1Banking
95Business One9.2PWZ2241Payment Wizard - Rows 2Banking
96Business One9.2PWZ31521Payment Wizard - Rows 3Banking
97Business One9.2PWZ4341Payment Wizard - Rows 4Banking
98Business One9.2PWZ5191Payment Wizard - Rows 5Banking
99Business One9.2PWZ6131Payment Wizard Rows - 6Banking
100Business One9.2PYD121Payment Terms Allowed in Payment RunBanking
101Business One9.2PYM141Currency SelectionBanking
102Business One9.2RCC4351Incoming Payment - Credit VouchersBanking
103Business One9.2RCT1191Incoming Payment - ChecksBanking
104Business One9.2RCT2612Incoming Payments - InvoicesBanking
105Business One9.2RCT3261Incoming Pmt - Credit VouchersBanking
106Business One9.2RCT4351Incoming Payment - Account ListBanking
107Business One9.2RCT5261Reciept vat adjustmentBanking
108Business One9.2RCT6421Incoming Payments - WTax RowsBanking
109Business One9.2RCT7131Incoming Pmt - Tax Amount per DocumentBanking
110Business One9.2RCT872Incoming Payment - TDS EntriesBanking
111Business One9.2RTW1441Boleto Retorno Wizard: Import TableBanking
112Business One9.2RTW2111Boleto Retorno Wizard: Import ArchiveBanking
113Business One9.2SVR131Saved Reconciliations - Transaction ListBanking
114Business One9.2TMP872Incoming Payment - TDS EntriesBanking
115Business One9.2TPW171Selection CriteriaBanking
116Business One9.2TPW2101Payable InformationBanking
117Business One9.2TPW3121Utilization and PaymentBanking
118Business One9.2TPW451VAT RefundBanking
119Business One9.2TPW551Challan InformationBanking
120Business One9.2TPW631Journal Entry InformationBanking
121Business One9.2VPM1191Outgoing Payments - Check RowsBanking
122Business One9.2VPM2612Outgoing Payments - InvoicesBanking
123Business One9.2VPM3261Outgoing Payments - Credit VouchersBanking
124Business One9.2VPM4351Outgoing Payments - AccountsBanking
125Business One9.2VPM5261Outgoing Payments - Vat AdjustmentBanking
126Business One9.2VPM6421Outgoing Payments - WTax RowsBanking
127Business One9.2VPM7131Outgoing Payments - Tax Amount per DocumentBanking
128Business One9.2VPM872Outgoing Payment - TDS EntriesBanking