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

60 columns | Print definition?B1 9.2  | PAIDDPM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC2Incoming Payment - Invoices - History41PaidDpmPaid Down PaymentVarChar10NN=No, Y=Yes
2PDF2Payment Draft - Invoices41PaidDpmPaid Down PaymentVarChar10NN=No, Y=Yes
3RCT2Incoming Payments - Invoices41PaidDpmPaid Down PaymentVarChar10NN=No, Y=Yes
4VPM2Outgoing Payments - Invoices41PaidDpmPaid Down PaymentVarChar10NN=No, Y=Yes
TOPInventory and Production
5IGE6Goods Issue - Installments62PaidDpmPaid by Down PaymentNum196
6IGN6Goods Receipt- Installments62PaidDpmPaid by Down PaymentNum196
7OIGEGoods Issue341PaidDpmPaid by Down PaymentNum196
8OIGNGoods Receipt341PaidDpmPaid by Down PaymentNum196
9OWTQInventory Transfer Request341PaidDpmPaid by Down PaymentNum196
10OWTRInventory Transfer341PaidDpmPaid by Down PaymentNum196
11WTQ6Inventory Transfer Request - Installments62PaidDpmPaid by Down PaymentNum196
12WTR6Inventory Transfer - Installments62PaidDpmPaid by Down PaymentNum196
TOPMarketing Documents
13ADO6Documents History - Installments62PaidDpmPaid by Down PaymentNum196
14ADOCInvoice - History341PaidDpmPaid by Down PaymentNum196
15CIN6Correction Invoice - Installments62PaidDpmPaid by Down PaymentNum196
16CPI6Documents History - Installments62PaidDpmPaid by Down PaymentNum196
17CPV6A/P Correction Invoice Reversal - Installments62PaidDpmPaid by Down PaymentNum196
18CSI6A/R Corr. Inv. - Installments62PaidDpmPaid by Down PaymentNum196
19CSV6A/R Correction Invoice Reversal - Installments62PaidDpmPaid by Down PaymentNum196
20DLN6Delivery - Installments62PaidDpmPaid by Down PaymentNum196
21DPI6A/R Down Payment - Installments62PaidDpmPaid by Down PaymentNum196
22DPO6Down Payment Out - Installments62PaidDpmPaid by Down PaymentNum196
23DRF6Document Drafts - Installments62PaidDpmPaid by Down PaymentNum196
24IEI6IEI - Installments62PaidDpmPaid by Down PaymentNum196
25INV6A/R Invoice - Installments62PaidDpmPaid by Down PaymentNum196
26OCINA/R Correction Invoice341PaidDpmPaid by Down PaymentNum196
27OCPIA/P Correction Invoice341PaidDpmPaid by Down PaymentNum196
28OCPVA/P Correction Invoice Reversal341PaidDpmPaid by Down PaymentNum196
29OCSIA/R Correction Invoice341PaidDpmPaid by Down PaymentNum196
30OCSVA/R Correction Invoice Reversal341PaidDpmPaid by Down PaymentNum196
31ODLNDelivery341PaidDpmPaid by Down PaymentNum196
32ODPIA/R Down Payment341PaidDpmPaid by Down PaymentNum196
33ODPOA/P Down Payment341PaidDpmPaid by Down PaymentNum196
34ODRFDrafts341PaidDpmPaid by Down PaymentNum196
35OEI6Outgoing Excise Invoice - Installments62PaidDpmPaid by Down PaymentNum196
36OIEIIncoming Excise Invoice341PaidDpmPaid by Down PaymentNum196
37OINVA/R Invoice341PaidDpmPaid by Down PaymentNum196
38OOEIOutgoing Excise Invoice341PaidDpmPaid by Down PaymentNum196
39OPCHA/P Invoice341PaidDpmPaid by Down PaymentNum196
40OPDNGoods Receipt PO341PaidDpmPaid by Down PaymentNum196
41OPORPurchase Order341PaidDpmPaid by Down PaymentNum196
42OPQTPurchase Quotation341PaidDpmPaid by Down PaymentNum196
43OPRQPurchase Request341PaidDpmPaid by Down PaymentNum196
44OQUTSales Quotation341PaidDpmPaid by Down PaymentNum196
45ORDNReturns341PaidDpmPaid by Down PaymentNum196
46ORDRSales Order341PaidDpmPaid by Down PaymentNum196
47ORINA/R Credit Memo341PaidDpmPaid by Down PaymentNum196
48ORPCA/P Credit Memo341PaidDpmPaid by Down PaymentNum196
49ORPDGoods Return341PaidDpmPaid by Down PaymentNum196
50PCH6A/P Invoice - Installments62PaidDpmPaid by Down PaymentNum196
51PDN6Goods Receipt PO - Installments62PaidDpmPaid by Down PaymentNum196
52POR6Purchase Order - Installments62PaidDpmPaid by Down PaymentNum196
53PQT6Purchase Quotation - Installments62PaidDpmPaid by Down PaymentNum196
54PRQ6Purchase Request - Installments62PaidDpmPaid by Down PaymentNum196
55QUT6Sales Quotation - Installments62PaidDpmPaid by Down PaymentNum196
56RDN6Returns - Installments62PaidDpmPaid by Down PaymentNum196
57RDR6Sales Order - Installments62PaidDpmPaid by Down PaymentNum196
58RIN6A/R Credit Memo - Installments62PaidDpmPaid by Down PaymentNum196
59RPC6A/P Credit Memo - Installments62PaidDpmPaid by Down PaymentNum196
60RPD6Goods Return - Installments62PaidDpmPaid by Down PaymentNum196