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
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
6OSRN20Serial Numbers Master Data
7ORCT154Incoming Payment
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

111 tablesB1 8.8 

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