SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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