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

68 columns | Print definition?B1 9.3  | NUMPERMSR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBusiness Partners
1AOA1Blanket Agreement - Rows24NumPerMsrUoM ValueNum1960
2OAT1Blanket Agreement - Rows24NumPerMsrUoM ValueNum1960
TOPInventory and Production
3IGE1Goods Issue - Rows125NumPerMsrUoM ValueNum196
4IGE8Items in Package - Goods Issue9NumPerMsrUoM ValueNum1960
5IGN1Goods Receipt - Rows125NumPerMsrUoM ValueNum196
6IGN8Goods Receipt - Items in Package9NumPerMsrUoM ValueNum1960
7IPF1Landed Costs - Rows66NumPerMsrUoM ValueNum196
8WTQ1Inventory Transfer Request - Rows125NumPerMsrUoM ValueNum196
9WTQ8Inventory Transfer Request - Items in Package9NumPerMsrUoM ValueNum1960
10WTR1Inventory Transfer - Rows125NumPerMsrUoM ValueNum196
11WTR8Inventory Transfer - Items in Package9NumPerMsrUoM ValueNum1960
TOPMarketing Documents
12ADO1A/R Invoice (Rows) - History125NumPerMsrUoM ValueNum196
13ADO8Items in Package - History9NumPerMsrUoM ValueNum1960
14CIN1Correction Invoice - Rows125NumPerMsrUoM ValueNum196
15CIN8Items in Package - Correction Invoice9NumPerMsrUoM ValueNum1960
16CPI1A/P Correction Invoice - Rows125NumPerMsrUoM ValueNum196
17CPI8A/P Correction Invoice - Items in Package9NumPerMsrUoM ValueNum1960
18CPV1A/P Correction Invoice Reversal - Rows125NumPerMsrUoM ValueNum196
19CPV8A/P Correction Invoice Reversal - Items in Package9NumPerMsrUoM ValueNum1960
20CSI1A/R Correction Invoice - Rows125NumPerMsrUoM ValueNum196
21CSI8A/R Corr. Inv. - Items in Pkg9NumPerMsrUoM ValueNum1960
22CSV1A/R Correction Invoice Reversal - Rows125NumPerMsrUoM ValueNum196
23CSV8A/R Correction Invoice Reversal - Items in Package9NumPerMsrUoM ValueNum1960
24DLN1Delivery - Rows125NumPerMsrUoM ValueNum196
25DLN8Items in Package - Delivery9NumPerMsrUoM ValueNum1960
26DPI1A/R Down Payment - Rows125NumPerMsrUoM ValueNum196
27DPI8Items in Package - A/R Down Pmt.9NumPerMsrUoM ValueNum1960
28DPO1A/P Down Payment - Rows125NumPerMsrUoM ValueNum196
29DPO8Items in Package - A/P Down Pmt.9NumPerMsrUoM ValueNum1960
30DRF1Draft - Rows125NumPerMsrUoM ValueNum196
31DRF8Items in Package - Draft9NumPerMsrUoM ValueNum1960
32IEI1Incoming Excise Invoice - Rows125NumPerMsrUoM ValueNum196
33IEI8Incoming Excise Invoice - Items in Package9NumPerMsrUoM ValueNum1960
34INV1A/R Invoice - Rows125NumPerMsrUoM ValueNum196
35INV8A/R Invoice - Items in Package9NumPerMsrUoM ValueNum1960
36OEI1Outgoing Excise Invoice - Rows125NumPerMsrUoM ValueNum196
37OEI8Outgoing Excise Invoice - Items in Package9NumPerMsrUoM ValueNum1960
38PCH1A/P Invoice - Rows125NumPerMsrUoM ValueNum196
39PCH8A/P Invoice - Items in Package9NumPerMsrUoM ValueNum1960
40PDN1Goods Receipt PO - Rows125NumPerMsrUoM ValueNum196
41PDN8Goods Receipt PO - Items in Package9NumPerMsrUoM ValueNum1960
42POR1Purchase Order - Rows125NumPerMsrUoM ValueNum196
43POR8Items in Package - Purchase Order9NumPerMsrUoM ValueNum1960
44PQT1Purchase Quotation - Rows125NumPerMsrUoM ValueNum196
45PQT8Items in Package - Purchase Quotation9NumPerMsrUoM ValueNum1960
46PRQ1Purchase Request - Rows125NumPerMsrUoM ValueNum196
47PRQ8Items in Package - Purchase Request9NumPerMsrUoM ValueNum1960
48PRR1A/P Return Request - Rows125NumPerMsrUoM ValueNum196
49PRR8A/P Return Request - Items in Package9NumPerMsrUoM ValueNum1960
50QUT1Sales Quotation - Rows125NumPerMsrUoM ValueNum196
51QUT8Sales Quotation - Items in Package9NumPerMsrUoM ValueNum1960
52RDN1Returns - Rows125NumPerMsrUoM ValueNum196
53RDN8Returns - Items in Package9NumPerMsrUoM ValueNum1960
54RDR1Sales Order - Rows125NumPerMsrUoM ValueNum196
55RDR8Sales Order - Items in Package9NumPerMsrUoM ValueNum1960
56RIN1A/R Credit Memo - Rows125NumPerMsrUoM ValueNum196
57RIN8Items in Package - A/R Credit Memo9NumPerMsrUoM ValueNum1960
58RPC1A/P Credit Memo - Rows125NumPerMsrUoM ValueNum196
59RPC8Items in Package - A/P Credit Memo9NumPerMsrUoM ValueNum1960
60RPD1Goods Return - Rows125NumPerMsrUoM ValueNum196
61RPD8Goods Return - Items in Package9NumPerMsrUoM ValueNum1960
62RRR1A/R Return Request - Rows125NumPerMsrUoM ValueNum196
63RRR8A/R Return Request - Items in Package9NumPerMsrUoM ValueNum1960
64SFC1Self Credit Memo - Rows125NumPerMsrUoM ValueNum196
65SFC8Self Credit Memo - Items in Package9NumPerMsrUoM ValueNum1960
66SFI1Self Invoice - Rows125NumPerMsrUoM ValueNum196
67SFI8Self Invoice - Items in Package9NumPerMsrUoM ValueNum1960
TOPMRP
68ORCMRecommendation Data26NumPerMsrUoM ValueNum196