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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
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
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

127 columns | Print definition?B1 9.2  | GROUPNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC5Reciept log vat adjustment-History21GroupNumGroup NumberInt1100
2OCTGPayment Terms1GroupNumGroup NumberInt60
3PDF5PaymentDraft - vat adjustment21GroupNumGroup NumberInt1100
4PMN5Payment - VAT Adjustment21GroupNumGroup NumberInt1100
5RCT5Reciept vat adjustment21GroupNumGroup NumberInt1100
6VPM5Outgoing Payments - Vat Adjustment21GroupNumGroup NumberInt1100
TOPBusiness Partners
7ACRDBusiness Partners - History19GroupNumPayment Terms CodeInt60-1
8AOATBlanket Agreement32GroupNumPayment Terms CodeInt60
9OCRDBusiness Partner19GroupNumPayment Terms CodeInt60-1
10OOATBlanket Agreement32GroupNumPayment Terms CodeInt60
TOPGeneral
11MFLDMetaData Tables Fields15GroupNumGroup NumberInt6000=User, -1=System
TOPInventory and Production
12IGE13Goods Issue Rows - Distributed Expenses3GroupNumGroup NumberInt110
13IGE2Goods Issue - Freight - Rows3GroupNumGroup NumberInt110
14IGE4Goods Issue - Tax Amount per Document3GroupNumGroup NumberInt110-1
15IGN13Goods Receipt Rows - Distributed Expenses3GroupNumGroup NumberInt110
16IGN2Goods Receipt - Freight - Rows3GroupNumGroup NumberInt110
17IGN4Goods Receipt - Tax Amount per Document3GroupNumGroup NumberInt110-1
18OARGCustoms Groups3GroupNumNumbernVarChar200
19OENTShipping Types27GroupNumPayment Terms CodeInt60
20OIGEGoods Issue37GroupNumPrice ListInt60
21OIGNGoods Receipt37GroupNumPrice ListInt60
22OWTQInventory Transfer Request37GroupNumPayment Terms CodeInt60
23OWTRInventory Transfer37GroupNumPrice ListsInt60
24WTQ13Inventory Transfer Request Rows - Distributed Freights3GroupNumGroup NumberInt110
25WTQ2Inventory Transfer Request - Freight - Rows3GroupNumGroup No.Int110
26WTQ4Inventory Transfer Request - Tax Amount per Document3GroupNumGroup No.Int110-1
27WTR13Inventory Transfer Rows - Distributed Freights3GroupNumGroup NumberInt110
28WTR2Inventory Transfer - Freight - Rows3GroupNumGroup NumberInt110
29WTR4Inventory Transfer - Tax Amount per Document3GroupNumGroup NumberInt110-1
TOPMarketing Documents
30ADO13A/R Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
31ADO2A/R Invoice - Freight - Rows3GroupNumGroup No.Int110
32ADO4Documents - Tax - History3GroupNumGroup No.Int110-1
33ADOCInvoice - History37GroupNumPayment Terms CodeInt60
34CIN13Correction Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
35CIN2A/R Correction Invoice - Freight - Rows3GroupNumExpense GroupInt110
36CIN4Correction Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
37CPI13A/P Correction Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
38CPI2A/P Correction Invoice - Freight - Rows3GroupNumExpense GroupInt110
39CPI4A/P Correction Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
40CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses3GroupNumGroup NumberInt110
41CPV2A/P Correction Invoice Reversal - Freight - Rows3GroupNumExpense GroupInt110
42CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.3GroupNumGroup NumberInt110-1
43CSI13A/R Correction Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
44CSI2A/R Corr Inv - Freight - Rows3GroupNumExpense GroupInt110
45CSI4A/R Correction Invoice - Tax Amount Per Document3GroupNumGroup NumberInt110-1
46CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses3GroupNumGroup NumberInt110
47CSV2A/R Correction Invoice Reversal - Freight - Rows3GroupNumExpense GroupInt110
48CSV4A/R Correction Invoice Reversal - Tax Amount Per Document3GroupNumGroup NumberInt110-1
49DLN13Delivery Rows - Distributed Expenses3GroupNumGroup NumberInt110
50DLN2Delivery Notes - Freight - Rows3GroupNumGroup NumberInt110
51DLN4Delivery - Tax Amount per Document3GroupNumGroup NumberInt110-1
52DPI13A/R Down Payment Rows - Distributed Expenses3GroupNumGroup NumberInt110
53DPI2A/R Down Payment - Freight - Rows3GroupNumGroup NumberInt110
54DPI4A/R Down Payment - Tax Amount per Document3GroupNumGroup NumberInt110-1
55DPO13A/P Down Payment Rows - Distributed Expenses3GroupNumGroup NumberInt110
56DPO2A/P Down Payment - Freight - Rows3GroupNumGroup NumberInt110
57DPO4A/P Down Payment - Tax Amount per Document3GroupNumGroup NumberInt110-1
58DRF13Draft Rows - Distributed Expenses3GroupNumGroup NumberInt110
59DRF2Draft - Freight - Rows3GroupNumGroup NumberInt110
60DRF4Draft Documents - Tax3GroupNumGroup NumberInt110-1
61IEI13Incoming Excise Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
62IEI2Incoming Excise Invoice - Freight - History - Rows3GroupNumGroup NumberInt110
63IEI4Incoming Excise Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
64INV13A/R Invoice Rows - Distributed Freights3GroupNumGroup NumberInt110
65INV2A/R Invoice - Freight - Rows3GroupNumGroup NumberInt110
66INV4A/R Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
67OCINA/R Correction Invoice37GroupNumPayment Terms CodeInt60
68OCPIA/P Correction Invoice37GroupNumPayment Terms CodeInt60
69OCPVA/P Correction Invoice Reversal37GroupNumPayment Terms CodeInt60
70OCSIA/R Correction Invoice37GroupNumPayment Terms CodeInt60
71OCSVA/R Correction Invoice Reversal37GroupNumPayment Terms CodeInt60
72ODLNDelivery37GroupNumPayment Terms CodeInt60
73ODPIA/R Down Payment37GroupNumPayment Terms CodeInt60
74ODPOA/P Down Payment37GroupNumPayment Terms CodeInt60
75ODRFDrafts37GroupNumPayment Terms CodeInt60
76OEI13Outgoing Excise Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
77OEI2OEI - Freight Rows3GroupNumGroup NumberInt110
78OEI4Outgoing Excise Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
79OIEIIncoming Excise Invoice37GroupNumPayment Terms CodeInt60
80OINVA/R Invoice37GroupNumPayment Terms CodeInt60
81OOEIOutgoing Excise Invoice37GroupNumPayment Terms CodeInt60
82OPCHA/P Invoice37GroupNumPayment Terms CodeInt60
83OPDNGoods Receipt PO37GroupNumPayment Terms CodeInt60
84OPORPurchase Order37GroupNumPayment Terms CodeInt60
85OPQTPurchase Quotation37GroupNumPayment Terms CodeInt60
86OPRQPurchase Request37GroupNumPayment Terms CodeInt60
87OQUTSales Quotation37GroupNumPayment Terms CodeInt60
88ORDNReturns37GroupNumPayment Terms CodeInt60
89ORDRSales Order37GroupNumPayment Terms CodeInt60
90ORINA/R Credit Memo37GroupNumPayment Terms CodeInt60
91ORPCA/P Credit Memo37GroupNumPayment Terms CodeInt60
92ORPDGoods Return37GroupNumPayment Terms CodeInt60
93OSALOutgoing27GroupNumPayment Terms CodeInt60
94OTRATransition27GroupNumPayment Terms CodeInt60
95PCH13A/P Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
96PCH2A/P Invoice - Freight - Rows3GroupNumFreight GroupInt110
97PCH4A/P Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
98PDN13Goods Receipt PO Rows - Distributed Expenses3GroupNumGroup NumberInt110
99PDN2Goods Receipt PO - Freight - Rows3GroupNumFreight GroupInt110
100PDN4Goods Receipt PO - Tax Amount per Document3GroupNumGroup NumberInt110-1
101POR13Purchase Order Rows - Distributed Expenses3GroupNumGroup NumberInt110
102POR2Purchase Order - Freight - Rows3GroupNumGroup NumberInt110
103POR4Purchase Order - Tax Amount per Document3GroupNumGroup NumberInt110-1
104PQT13Purchase Quotation Rows - Distributed Expenses3GroupNumGroup NumberInt110
105PQT2Purchase Quotation - Freight - Rows3GroupNumGroup NumberInt110
106PQT4Purchase Quotation - Tax Amount per Document3GroupNumGroup NumberInt110-1
107PRQ13Purchase Request Rows - Distributed Expenses3GroupNumGroup NumberInt110
108PRQ2Purchase Request - Freight - Rows3GroupNumGroup NumberInt110
109PRQ4Purchase Request - Tax Amount per Document3GroupNumGroup NumberInt110-1
110QUT13Sales Quotation Rows - Distributed Expenses3GroupNumGroup NumberInt110
111QUT2Sales Quotation - Freight - Rows3GroupNumGroup NumberInt110
112QUT4Sales Quotation - Tax Amount per Document3GroupNumGroup NumberInt110-1
113RDN13Returns Rows - Distributed Expenses3GroupNumGroup NumberInt110
114RDN2Return - Freight - Rows3GroupNumFreight GroupInt110
115RDN4Returns - Tax Amount per Document3GroupNumGroup NumberInt110-1
116RDR13Sales Order Rows - Distributed Expenses3GroupNumGroup NumberInt110
117RDR2Sales Order - Freight - Rows3GroupNumGroup NumberInt110
118RDR4Sales Order - Tax Amount per Document3GroupNumGroup NumberInt110-1
119RIN13A/R Credit Memo Rows - Distributed Expenses3GroupNumGroup NumberInt110
120RIN2A/R Credit Memo - Freight - Rows3GroupNumGroup NumberInt110
121RIN4A/R Credit Memo - Tax Amount per Document3GroupNumGroup NumberInt110-1
122RPC13A/P Credit Memo Rows - Distributed Expenses3GroupNumGroup NumberInt110
123RPC2A/P Credit Memo Rows - Expenses3GroupNumGroup NumberInt110
124RPC4A/P Credit Memo - Tax Amount per Document3GroupNumGroup NumberInt110-1
125RPD13Goods Returns Rows - Distributed Expenses3GroupNumGroup NumberInt110
126RPD2Goods Return - Freight - Rows3GroupNumGroup NumberInt110
127RPD4Goods Return - Tax Amount per Document3GroupNumGroup NumberInt110-1