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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

60 columns | Print definition?B1 9.2  | 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 - Rows125NumPerMsrUnit Num Per MeasureNum196
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
48QUT1Sales Quotation - Rows125NumPerMsrUoM ValueNum196
49QUT8Sales Quotation - Items in Package9NumPerMsrUoM ValueNum1960
50RDN1Returns - Rows125NumPerMsrUoM ValueNum196
51RDN8Returns - Items in Package9NumPerMsrUoM ValueNum1960
52RDR1Sales Order - Rows125NumPerMsrUoM ValueNum196
53RDR8Sales Order - Items in Package9NumPerMsrUoM ValueNum1960
54RIN1A/R Credit Memo - Rows125NumPerMsrUoM ValueNum196
55RIN8Items in Package - A/R Credit Memo9NumPerMsrUoM ValueNum1960
56RPC1A/P Credit Memo - Rows125NumPerMsrUoM ValueNum196
57RPC8Items in Package - A/P Credit Memo9NumPerMsrUoM ValueNum1960
58RPD1Goods Return - Rows125NumPerMsrUoM ValueNum196
59RPD8Goods Return - Items in Package9NumPerMsrUoM ValueNum1960
TOPMRP
60ORCMRecommendation Data26NumPerMsrUoM ValueNum196