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

64 columns | Print definition?B1 9.3  | TOTALEXPNS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1IGE6Goods Issue - Installments20TotalExpnsTotal Freight ChargesNum196
2IGN6Goods Receipt- Installments20TotalExpnsTotal Freight ChargesNum196
3OIGEGoods Issue85TotalExpnsTotal ExpensesNum196
4OIGNGoods Receipt85TotalExpnsTotal ExpensesNum196
5OWTQInventory Transfer Request85TotalExpnsTotal Freight ChargesNum196
6OWTRInventory Transfer85TotalExpnsTotal Freight ChargesNum196
7WTQ6Inventory Transfer Request - Installments20TotalExpnsTotal Freight ChargesNum196
8WTR6Inventory Transfer - Installments20TotalExpnsTotal Freight ChargesNum196
TOPMarketing Documents
9ADO6Documents History - Installments20TotalExpnsTotal Freight ChargesNum196
10ADOCInvoice - History85TotalExpnsTotal ExpensesNum196
11CIN6Correction Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
12CPI6Documents History - Installments20TotalExpnsTotal Freight ChargesNum196
13CPV6A/P Correction Invoice Reversal - Installments20TotalExpnsTotal Freight ChargesNum196
14CSI6A/R Corr. Inv. - Installments20TotalExpnsTotal Freight ChargesNum196
15CSV6A/R Correction Invoice Reversal - Installments20TotalExpnsTotal Freight ChargesNum196
16DLN6Delivery - Installments20TotalExpnsTotal Freight ChargesNum196
17DPI6A/R Down Payment - Installments20TotalExpnsTotal Freight ChargesNum196
18DPO6Down Payment Out - Installments20TotalExpnsTotal Freight ChargesNum196
19DRF6Document Drafts - Installments20TotalExpnsTotal Freight ChargesNum196
20IEI6IEI - Installments20TotalExpnsTotal Freight ChargesNum196
21INV6A/R Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
22OCINA/R Correction Invoice85TotalExpnsTotal FreightNum196
23OCPIA/P Correction Invoice85TotalExpnsTotal ExpensesNum196
24OCPVA/P Correction Invoice Reversal85TotalExpnsTotal ExpensesNum196
25OCSIA/R Correction Invoice85TotalExpnsTotal ExpensesNum196
26OCSVA/R Correction Invoice Reversal85TotalExpnsTotal ExpensesNum196
27ODLNDelivery85TotalExpnsTotal ExpensesNum196
28ODPIA/R Down Payment85TotalExpnsTotal ExpensesNum196
29ODPOA/P Down Payment85TotalExpnsTotal ExpensesNum196
30ODRFDrafts85TotalExpnsTotal FreightNum196
31OEI6Outgoing Excise Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
32OIEIIncoming Excise Invoice85TotalExpnsTotal Freight ChargesNum196
33OINVA/R Invoice85TotalExpnsTotal Freight ChargesNum196
34OOEIOutgoing Excise Invoice85TotalExpnsTotal Freight ChargesNum196
35OPCHA/P Invoice85TotalExpnsTotal Freight ChargesNum196
36OPDNGoods Receipt PO85TotalExpnsTotal Freight ChargesNum196
37OPORPurchase Order85TotalExpnsTotal ExpensesNum196
38OPQTPurchase Quotation85TotalExpnsTotal ExpensesNum196
39OPRQPurchase Request85TotalExpnsTotal ExpensesNum196
40OPRRGoods Return Request85TotalExpnsTotal Freight ChargesNum196
41OQUTSales Quotation85TotalExpnsTotal Freight ChargesNum196
42ORDNReturns85TotalExpnsTotal FreightNum196
43ORDRSales Order85TotalExpnsTotal Freight ChargesNum196
44ORINA/R Credit Memo85TotalExpnsTotal ExpensesNum196
45ORPCA/P Credit Memo85TotalExpnsTotal Freight ChargesNum196
46ORPDGoods Return85TotalExpnsTotal FreightNum196
47ORRRReturn Request85TotalExpnsTotal Freight ChargesNum196
48OSFCSelf Credit Memo85TotalExpnsTotal Freight ChargesNum196
49OSFISelf Invoice85TotalExpnsTotal Freight ChargesNum196
50PCH6A/P Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
51PDN6Goods Receipt PO - Installments20TotalExpnsTotal Freight ChargesNum196
52POR6Purchase Order - Installments20TotalExpnsTotal Freight ChargesNum196
53PQT6Purchase Quotation - Installments20TotalExpnsTotal Freight ChargesNum196
54PRQ6Purchase Request - Installments20TotalExpnsTotal Freight ChargesNum196
55PRR6A/P Return Request - Installments20TotalExpnsTotal Freight ChargesNum196
56QUT6Sales Quotation - Installments20TotalExpnsTotal Freight ChargesNum196
57RDN6Returns - Installments20TotalExpnsTotal Freight ChargesNum196
58RDR6Sales Order - Installments20TotalExpnsTotal Freight ChargesNum196
59RIN6A/R Credit Memo - Installments20TotalExpnsTotal Freight ChargesNum196
60RPC6A/P Credit Memo - Installments20TotalExpnsTotal Freight ChargesNum196
61RPD6Goods Return - Installments20TotalExpnsTotal Freight ChargesNum196
62RRR6A/R Return Request - Installments20TotalExpnsTotal Freight ChargesNum196
63SFC6Self Credit Memo - Installments20TotalExpnsTotal Freight ChargesNum196
64SFI6Self Invoice - Installments20TotalExpnsTotal Freight ChargesNum196