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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

68 columns | Print definition?B1 9.3  | 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
44OPRRGoods Return Request341PaidDpmPaid by Down PaymentNum196
45OQUTSales Quotation341PaidDpmPaid by Down PaymentNum196
46ORDNReturns341PaidDpmPaid by Down PaymentNum196
47ORDRSales Order341PaidDpmPaid by Down PaymentNum196
48ORINA/R Credit Memo341PaidDpmPaid by Down PaymentNum196
49ORPCA/P Credit Memo341PaidDpmPaid by Down PaymentNum196
50ORPDGoods Return341PaidDpmPaid by Down PaymentNum196
51ORRRReturn Request341PaidDpmPaid by Down PaymentNum196
52OSFCSelf Credit Memo341PaidDpmPaid by Down PaymentNum196
53OSFISelf Invoice341PaidDpmPaid by Down PaymentNum196
54PCH6A/P Invoice - Installments62PaidDpmPaid by Down PaymentNum196
55PDN6Goods Receipt PO - Installments62PaidDpmPaid by Down PaymentNum196
56POR6Purchase Order - Installments62PaidDpmPaid by Down PaymentNum196
57PQT6Purchase Quotation - Installments62PaidDpmPaid by Down PaymentNum196
58PRQ6Purchase Request - Installments62PaidDpmPaid by Down PaymentNum196
59PRR6A/P Return Request - Installments62PaidDpmPaid by Down PaymentNum196
60QUT6Sales Quotation - Installments62PaidDpmPaid by Down PaymentNum196
61RDN6Returns - Installments62PaidDpmPaid by Down PaymentNum196
62RDR6Sales Order - Installments62PaidDpmPaid by Down PaymentNum196
63RIN6A/R Credit Memo - Installments62PaidDpmPaid by Down PaymentNum196
64RPC6A/P Credit Memo - Installments62PaidDpmPaid by Down PaymentNum196
65RPD6Goods Return - Installments62PaidDpmPaid by Down PaymentNum196
66RRR6A/R Return Request - Installments62PaidDpmPaid by Down PaymentNum196
67SFC6Self Credit Memo - Installments62PaidDpmPaid by Down PaymentNum196
68SFI6Self Invoice - Installments62PaidDpmPaid by Down PaymentNum196