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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

228 columns | Print definition?B1 9.3  | VATSUMSY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARCTIncoming Payment - History73VatSumSyTax Amount (SC)Num196
2OPDFPayment Draft73VatSumSyTax Amount (SC)Num196
3ORCTIncoming Payment73VatSumSyTax Amount (SC)Num196
4OVPMOutgoing Payments73VatSumSyTax Amount (SC)Num196
TOPInventory and Production
5IGE1Goods Issue - Rows77VatSumSyTax Amount (SC)Num196
6IGE13Goods Issue Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
7IGE2Goods Issue - Freight - Rows18VatSumSyTax Amount (SC)Num196
8IGE3Goods Issue - Freight18VatSumSyTax Amount (SC)Num196
9IGE6Goods Issue - Installments16VatSumSyTax Amount (SC)Num196
10IGN1Goods Receipt - Rows77VatSumSyTax Amount (SC)Num196
11IGN13Goods Receipt Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
12IGN2Goods Receipt - Freight - Rows18VatSumSyTax Amount (SC)Num196
13IGN3Goods Receipt - Freight18VatSumSyTax Amount (SC)Num196
14IGN6Goods Receipt- Installments16VatSumSyTax Amount (SC)Num196
15OIGEGoods Issue57VatSumSyTax Amount (SC)Num196
16OIGNGoods Receipt57VatSumSyTax Amount (SC)Num196
17OWTQInventory Transfer Request57VatSumSyTax Amount (SC)Num196
18OWTRInventory Transfer57VatSumSyTax Amount (SC)Num196
19WTQ1Inventory Transfer Request - Rows77VatSumSyTax Amount (SC)Num196
20WTQ13Inventory Transfer Request Rows - Distributed Freights18VatSumSyTax Amount (SC)Num196
21WTQ2Inventory Transfer Request - Freight - Rows18VatSumSyTax Amount (SC)Num196
22WTQ3Inventory Transfer Request - Freight18VatSumSyTax Amount (SC)Num196
23WTQ6Inventory Transfer Request - Installments16VatSumSyTax Amount (SC)Num196
24WTR1Inventory Transfer - Rows77VatSumSyTax Sum (SC)Num196
25WTR13Inventory Transfer Rows - Distributed Freights18VatSumSyTax Amount (SC)Num196
26WTR2Inventory Transfer - Freight - Rows18VatSumSyTax Amount (SC)Num196
27WTR3Inventory Transfer - Freight18VatSumSyTax Amount (SC)Num196
28WTR6Inventory Transfer - Installments16VatSumSyTax Amount (SC)Num196
TOPMarketing Documents
29ADO1A/R Invoice (Rows) - History77VatSumSyTax Amount (SC)Num196
30ADO13A/R Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
31ADO2A/R Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
32ADO25Mktg Docs - Amt Per VAT Grp - History9VatSumSyTax Amount (SC)Num196
33ADO3A/R Invoice - Freight - History18VatSumSyTax Amount (SC)Num196
34ADO6Documents History - Installments16VatSumSyTax Amount (SC)Num196
35ADOCInvoice - History57VatSumSyTax Amount (SC)Num196
36CIN1Correction Invoice - Rows77VatSumSyTax Amount (SC)Num196
37CIN13Correction Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
38CIN2A/R Correction Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
39CIN25Correction Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
40CIN3A/R Correction Invoice - Freight18VatSumSyTax Amount (SC)Num196
41CIN6Correction Invoice - Installments16VatSumSyTax Amount (SC)Num196
42CPI1A/P Correction Invoice - Rows77VatSumSyTax Amount (SC)Num196
43CPI13A/P Correction Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
44CPI2A/P Correction Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
45CPI25A/P Correction Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
46CPI3A/P Correction Invoice - Freight18VatSumSyTax Amount (SC)Num196
47CPI6Documents History - Installments16VatSumSyTax Amount (SC)Num196
48CPV1A/P Correction Invoice Reversal - Rows77VatSumSyTax Amount (SC)Num196
49CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
50CPV2A/P Correction Invoice Reversal - Freight - Rows18VatSumSyTax Amount (SC)Num196
51CPV25A/P Correction Invoice Reversal - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
52CPV3A/P Correction Invoice Reversal - Freight18VatSumSyTax Amount (SC)Num196
53CPV6A/P Correction Invoice Reversal - Installments16VatSumSyTax Amount (SC)Num196
54CSI1A/R Correction Invoice - Rows77VatSumSyTax Amount (SC)Num196
55CSI13A/R Correction Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
56CSI2A/R Corr Inv - Freight - Rows18VatSumSyTax Amount (SC)Num196
57CSI25A/R Correction Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
58CSI3A/R Correction Invoice - Freight18VatSumSyTax Amount (SC)Num196
59CSI6A/R Corr. Inv. - Installments16VatSumSyTax Amount (SC)Num196
60CSV1A/R Correction Invoice Reversal - Rows77VatSumSyTax Amount (SC)Num196
61CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
62CSV2A/R Correction Invoice Reversal - Freight - Rows18VatSumSyTax Amount (SC)Num196
63CSV25A/R Correction Invoice Reversal - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
64CSV3A/R Correction Invoice Reversal - Freight18VatSumSyTax Amount (SC)Num196
65CSV6A/R Correction Invoice Reversal - Installments16VatSumSyTax Amount (SC)Num196
66DLN1Delivery - Rows77VatSumSyTax Amount (SC)Num196
67DLN13Delivery Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
68DLN2Delivery Notes - Freight - Rows18VatSumSyTax Amount (SC)Num196
69DLN25Delivery - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
70DLN3Delivery Notes - Freight18VatSumSyTax Amount (SC)Num196
71DLN6Delivery - Installments16VatSumSyTax Amount (SC)Num196
72DPI1A/R Down Payment - Rows77VatSumSyTax Amount (SC)Num196
73DPI13A/R Down Payment Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
74DPI2A/R Down Payment - Freight - Rows18VatSumSyTax Amount (SC)Num196
75DPI25A/R Down Payment - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
76DPI3A/R Down Payment - Freight18VatSumSyTax Amount (SC)Num196
77DPI6A/R Down Payment - Installments16VatSumSyTax Amount (SC)Num196
78DPO1A/P Down Payment - Rows77VatSumSyTax Amount (SC)Num196
79DPO13A/P Down Payment Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
80DPO2A/P Down Payment - Freight - Rows18VatSumSyTax Amount (SC)Num196
81DPO25A/P Down Payment - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
82DPO3A/P Down Payment - Freight18VatSumSyTax Amount (SC)Num196
83DPO6Down Payment Out - Installments16VatSumSyTax Amount (SC)Num196
84DRF1Draft - Rows77VatSumSyTax Amount (SC)Num196
85DRF13Draft Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
86DRF2Draft - Freight - Rows18VatSumSyTax Amount (SC)Num196
87DRF25Draft - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
88DRF3Draft - Freight18VatSumSyTax Amount (SC)Num196
89DRF6Document Drafts - Installments16VatSumSyTax Amount (SC)Num196
90IEI1Incoming Excise Invoice - Rows77VatSumSyTax Amount (SC)Num196
91IEI13Incoming Excise Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
92IEI2Incoming Excise Invoice - Freight - History - Rows18VatSumSyTax Amount (SC)Num196
93IEI25Incoming Excise Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
94IEI3IEI - Freight18VatSumSyTax Amount (SC)Num196
95IEI6IEI - Installments16VatSumSyTax Amount (SC)Num196
96IGE25Goods Issue - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
97IGN25Goods Receipt - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
98INV1A/R Invoice - Rows77VatSumSyTax Amount (SC)Num196
99INV13A/R Invoice Rows - Distributed Freights18VatSumSyTax Amount (SC)Num196
100INV2A/R Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
101INV25A/R Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
102INV3A/R Invoice - Freight18VatSumSyTax Amount (SC)Num196
103INV6A/R Invoice - Installments16VatSumSyTax Amount (SC)Num196
104OCINA/R Correction Invoice57VatSumSyTax Amount (SC)Num196
105OCPIA/P Correction Invoice57VatSumSyTax Amount (SC)Num196
106OCPVA/P Correction Invoice Reversal57VatSumSyTax Amount (SC)Num196
107OCSIA/R Correction Invoice57VatSumSyTax Amount (SC)Num196
108OCSVA/R Correction Invoice Reversal57VatSumSyTax Amount (SC)Num196
109ODLNDelivery57VatSumSyTax Amount (SC)Num196
110ODPIA/R Down Payment57VatSumSyTax Amount (SC)Num196
111ODPOA/P Down Payment57VatSumSyTax Amount (SC)Num196
112ODRFDrafts57VatSumSyTax Amount (SC)Num196
113OEI1Outgoing Excise Invoice - Rows77VatSumSyTax Amount (SC)Num196
114OEI13Outgoing Excise Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
115OEI2OEI - Freight Rows18VatSumSyTax Amount (SC)Num196
116OEI25Outgoing Excise Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
117OEI3OEI - Freight18VatSumSyTax Amount (SC)Num196
118OEI6Outgoing Excise Invoice - Installments16VatSumSyTax Amount (SC)Num196
119OIEIIncoming Excise Invoice57VatSumSyTax Amount (SC)Num196
120OINVA/R Invoice57VatSumSyTax Amount (SC)Num196
121OOEIOutgoing Excise Invoice57VatSumSyTax Amount (SC)Num196
122OPCHA/P Invoice57VatSumSyTax Amount (SC)Num196
123OPDNGoods Receipt PO57VatSumSyTax Amount (SC)Num196
124OPORPurchase Order57VatSumSyTax Amount (SC)Num196
125OPQTPurchase Quotation57VatSumSyTax Amount (SC)Num196
126OPRQPurchase Request57VatSumSyTax Amount (SC)Num196
127OPRRGoods Return Request57VatSumSyTax Amount (SC)Num196
128OQUTSales Quotation57VatSumSyTax Amount (SC)Num196
129ORDNReturns57VatSumSyTax Amount (SC)Num196
130ORDRSales Order57VatSumSyTax Amount (SC)Num196
131ORINA/R Credit Memo57VatSumSyTax Amount (SC)Num196
132ORPCA/P Credit Memo57VatSumSyTax Amount (SC)Num196
133ORPDGoods Return57VatSumSyTax Amount (SC)Num196
134ORRRReturn Request57VatSumSyTax Amount (SC)Num196
135OSFCSelf Credit Memo57VatSumSyTax Amount (SC)Num196
136OSFISelf Invoice57VatSumSyTax Amount (SC)Num196
137PCH1A/P Invoice - Rows77VatSumSyTax Amount (SC)Num196
138PCH13A/P Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
139PCH2A/P Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
140PCH25A/P Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
141PCH3A/P Invoice - Freight18VatSumSyTax Amount (SC)Num196
142PCH6A/P Invoice - Installments16VatSumSyTax Amount (SC)Num196
143PDN1Goods Receipt PO - Rows77VatSumSyTax Amount (SC)Num196
144PDN13Goods Receipt PO Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
145PDN2Goods Receipt PO - Freight - Rows18VatSumSyTax Amount (SC)Num196
146PDN25Goods Receipt PO - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
147PDN3Goods Receipt PO - Freight18VatSumSyTax Amount (SC)Num196
148PDN6Goods Receipt PO - Installments16VatSumSyTax Amount (SC)Num196
149POR1Purchase Order - Rows77VatSumSyTax Amount (SC)Num196
150POR13Purchase Order Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
151POR2Purchase Order - Freight - Rows18VatSumSyTax Amount (SC)Num196
152POR25Purchase Order - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
153POR3Purchase Order - Freight18VatSumSyTax Amount (SC)Num196
154POR6Purchase Order - Installments16VatSumSyTax Amount (SC)Num196
155PQT1Purchase Quotation - Rows77VatSumSyTax Amount (SC)Num196
156PQT13Purchase Quotation Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
157PQT2Purchase Quotation - Freight - Rows18VatSumSyTax Amount (SC)Num196
158PQT25Purchase Quotation - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
159PQT3Purchase Quotation - Freight18VatSumSyTax Amount (SC)Num196
160PQT6Purchase Quotation - Installments16VatSumSyTax Amount (SC)Num196
161PRQ1Purchase Request - Rows77VatSumSyTax Amount (SC)Num196
162PRQ13Purchase Request Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
163PRQ2Purchase Request - Freight - Rows18VatSumSyTax Amount (SC)Num196
164PRQ25Purchase Request - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
165PRQ3Purchase Request - Freight18VatSumSyTax Amount (SC)Num196
166PRQ6Purchase Request - Installments16VatSumSyTax Amount (SC)Num196
167PRR1A/P Return Request - Rows77VatSumSyTax Amount (SC)Num196
168PRR13A/P Return Request - Distributed Freights18VatSumSyTax Amount (SC)Num196
169PRR2A/P Return Request - Freight - Rows18VatSumSyTax Amount (SC)Num196
170PRR25Goods Return Request - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
171PRR3A/P Return Request - Freight18VatSumSyTax Amount (SC)Num196
172PRR6A/P Return Request - Installments16VatSumSyTax Amount (SC)Num196
173QUT1Sales Quotation - Rows77VatSumSyTax Amount (SC)Num196
174QUT13Sales Quotation Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
175QUT2Sales Quotation - Freight - Rows18VatSumSyTax Amount (SC)Num196
176QUT25Sales Quotation - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
177QUT3Sales Quotation - Freight18VatSumSyTax Amount (SC)Num196
178QUT6Sales Quotation - Installments16VatSumSyTax Amount (SC)Num196
179RDN1Returns - Rows77VatSumSyTax Amount (SC)Num196
180RDN13Returns Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
181RDN2Return - Freight - Rows18VatSumSyTax Amount (SC)Num196
182RDN25Returns - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
183RDN3Return - Freight18VatSumSyTax Amount (SC)Num196
184RDN6Returns - Installments16VatSumSyTax Amount (SC)Num196
185RDR1Sales Order - Rows77VatSumSyTax Amount (SC)Num196
186RDR13Sales Order Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
187RDR2Sales Order - Freight - Rows18VatSumSyTax Amount (SC)Num196
188RDR25Sales Order - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
189RDR3Sales Order - Freight18VatSumSyTax Amount (SC)Num196
190RDR6Sales Order - Installments16VatSumSyTax Amount (SC)Num196
191RIN1A/R Credit Memo - Rows77VatSumSyTax Amount (SC)Num196
192RIN13A/R Credit Memo Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
193RIN2A/R Credit Memo - Freight - Rows18VatSumSyTax Amount (SC)Num196
194RIN25A/R Credit Memo - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
195RIN3A/R Credit Memo - Freight18VatSumSyTax Amount (SC)Num196
196RIN6A/R Credit Memo - Installments16VatSumSyTax Amount (SC)Num196
197RPC1A/P Credit Memo - Rows77VatSumSyTax Amount (SC)Num196
198RPC13A/P Credit Memo Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
199RPC2A/P Credit Memo Rows - Expenses18VatSumSyTax Amount (SC)Num196
200RPC25A/P Credit Memo - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
201RPC3A/P Credit Memo - Freight18VatSumSyTax Amount (SC)Num196
202RPC6A/P Credit Memo - Installments16VatSumSyTax Amount (SC)Num196
203RPD1Goods Return - Rows77VatSumSyTax Amount (SC)Num196
204RPD13Goods Returns Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
205RPD2Goods Return - Freight - Rows18VatSumSyTax Amount (SC)Num196
206RPD25Goods Return - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
207RPD3Goods Return - Freight18VatSumSyTax Amount (SC)Num196
208RPD6Goods Return - Installments16VatSumSyTax Amount (SC)Num196
209RRR1A/R Return Request - Rows77VatSumSyTax Amount (SC)Num196
210RRR13A/R Return Request - Distributed Freights18VatSumSyTax Amount (SC)Num196
211RRR2A/R Return Request - Freight - Rows18VatSumSyTax Amount (SC)Num196
212RRR25Return Request - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
213RRR3A/R Return Request - Freight18VatSumSyTax Amount (SC)Num196
214RRR6A/R Return Request - Installments16VatSumSyTax Amount (SC)Num196
215SFC1Self Credit Memo - Rows77VatSumSyTax Amount (SC)Num196
216SFC13Self Credit Memo Rows - Distributed Freights18VatSumSyTax Amount (SC)Num196
217SFC2Self Credit Memo - Freight - Rows18VatSumSyTax Amount (SC)Num196
218SFC25Self Credit Memo - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
219SFC3Self Credit Memo - Freight18VatSumSyTax Amount (SC)Num196
220SFC6Self Credit Memo - Installments16VatSumSyTax Amount (SC)Num196
221SFI1Self Invoice - Rows77VatSumSyTax Amount (SC)Num196
222SFI13Self Invoice Rows - Distributed Freights18VatSumSyTax Amount (SC)Num196
223SFI2Self Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
224SFI25Self Invoice - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
225SFI3Self Invoice - Freight18VatSumSyTax Amount (SC)Num196
226SFI6Self Invoice - Installments16VatSumSyTax Amount (SC)Num196
227WTQ25Inventory Transfer Request - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196
228WTR25Inventory Transfer - Amt Per VAT Grp9VatSumSyTax Amount (SC)Num196