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

239 columns | Print definition?B1 9.2  | VATSUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC5Reciept log vat adjustment-History8VatSumTax Amount - HistoryNum196
2ARCTIncoming Payment - History71VatSumTax AmountNum196
3OPDFPayment Draft71VatSumTax AmountNum196
4ORCTIncoming Payment71VatSumTax AmountNum196
5OVPMOutgoing Payments71VatSumTax AmountNum196
6PDF5PaymentDraft - vat adjustment8VatSumTax AmountNum196
7PMN5Payment - VAT Adjustment8VatSumTax AmountNum196
8RCT5Reciept vat adjustment8VatSumTax AmountNum196
9VPM5Outgoing Payments - Vat Adjustment8VatSumTax AmountNum196
TOPFinance
10TAX1VAT Transactions - Rows26VatSumVAT SumNum196
11UTX1Unreported VAT Transactions - Rows26VatSumVAT SumNum196
TOPGeneral
12CIN11Correction Invoice - Drawn Dpm Detail11VatSumTax LCNum196
TOPInventory and Production
13IGE1Goods Issue - Rows75VatSumTotal TaxNum196
14IGE11Goods Issue - Drawn Dpm Detail11VatSumTax LCNum196
15IGE13Goods Issue Rows - Distributed Expenses16VatSumTax AmountNum196
16IGE15Gds Issue - Drawn Dpm Applied12VatSumTax LCNum196
17IGE2Goods Issue - Freight - Rows16VatSumTax AmountNum196
18IGE3Goods Issue - Freight16VatSumTax AmountNum196
19IGE6Goods Issue - Installments14VatSumTotal TaxNum196
20IGN1Goods Receipt - Rows75VatSumTotal TaxNum196
21IGN11Goods Receipt - Drawn Dpm Det11VatSumTax LCNum196
22IGN13Goods Receipt Rows - Distributed Expenses16VatSumTax AmountNum196
23IGN15Gds Rcpt - Drawn Dpm Applied12VatSumTax LCNum196
24IGN2Goods Receipt - Freight - Rows16VatSumTax AmountNum196
25IGN3Goods Receipt - Freight16VatSumTax AmountNum196
26IGN6Goods Receipt- Installments14VatSumTotal TaxNum196
27IPF1Landed Costs - Rows82VatSumTotal of VATNum196
28OIGEGoods Issue18VatSumTotal TaxNum196
29OIGNGoods Receipt18VatSumTotal TaxNum196
30OWTQInventory Transfer Request18VatSumTotal TaxNum196
31OWTRInventory Transfer18VatSumTotal TaxNum196
32WTQ1Inventory Transfer Request - Rows75VatSumTotal TaxNum196
33WTQ11Inv. Transfer Request - Drawn Dpm Det.11VatSumTax LCNum196
34WTQ13Inventory Transfer Request Rows - Distributed Freights16VatSumTax AmountNum196
35WTQ15Inv. Transfer Request - Drawn Dpm Appl12VatSumTax LCNum196
36WTQ2Inventory Transfer Request - Freight - Rows16VatSumTax AmountNum196
37WTQ3Inventory Transfer Request - Freight16VatSumTax AmountNum196
38WTQ6Inventory Transfer Request - Installments14VatSumTotal TaxNum196
39WTR1Inventory Transfer - Rows75VatSumTax TotalNum196
40WTR11Inv. Transfer - Drawn Dpm Det.11VatSumTax LCNum196
41WTR13Inventory Transfer Rows - Distributed Freights16VatSumTax AmountNum196
42WTR15Inv. Transfer - Drawn Dpm Appl12VatSumTax LCNum196
43WTR2Inventory Transfer - Freight - Rows16VatSumTax AmountNum196
44WTR3Inventory Transfer - Freight16VatSumTax AmountNum196
45WTR6Inventory Transfer - Installments14VatSumTotal TaxNum196
TOPMarketing Documents
46ADO1A/R Invoice (Rows) - History75VatSumTotal TaxNum196
47ADO11A/R Inv (Drawn Dpm Det) - Hist11VatSumTax LCNum196
48ADO13A/R Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
49ADO15A/R Inv (Drawn Dpm Applied) - Hist12VatSumTax LCNum196
50ADO2A/R Invoice - Freight - Rows16VatSumTax AmountNum196
51ADO3A/R Invoice - Freight - History16VatSumTax AmountNum196
52ADO6Documents History - Installments14VatSumTotal TaxNum196
53ADOCInvoice - History18VatSumTotal TaxNum196
54ATXITax Invoice - History32VatSumTotal TaxNum196
55CIN1Correction Invoice - Rows75VatSumTax AmountNum196
56CIN13Correction Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
57CIN2A/R Correction Invoice - Freight - Rows16VatSumTax AmountNum196
58CIN3A/R Correction Invoice - Freight16VatSumTax AmountNum196
59CIN6Correction Invoice - Installments14VatSumTotal TaxNum196
60CPI1A/P Correction Invoice - Rows75VatSumTotal TaxNum196
61CPI11A/P Corr. Inv - Drawn Dpm Det.11VatSumTax LCNum196
62CPI13A/P Correction Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
63CPI15A/P Corr Inv - Drawn Dpm Appld12VatSumTax LCNum196
64CPI2A/P Correction Invoice - Freight - Rows16VatSumTax AmountNum196
65CPI3A/P Correction Invoice - Freight16VatSumTax AmountNum196
66CPI6Documents History - Installments14VatSumTotal TaxNum196
67CPV1A/P Correction Invoice Reversal - Rows75VatSumTotal TaxNum196
68CPV11A/P CrIn Rev - Drawn Dpm Det.11VatSumTax LCNum196
69CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses16VatSumTax AmountNum196
70CPV15A/P CrIn Rev - Drawn Dpm Appld12VatSumTax LCNum196
71CPV2A/P Correction Invoice Reversal - Freight - Rows16VatSumTax AmountNum196
72CPV3A/P Correction Invoice Reversal - Freight16VatSumTax AmountNum196
73CPV6A/P Correction Invoice Reversal - Installments14VatSumTotal TaxNum196
74CSI1A/R Correction Invoice - Rows75VatSumTotal TaxNum196
75CSI11A/R Corr. Inv. - Drawn Dpm Det11VatSumTax LCNum196
76CSI13A/R Correction Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
77CSI15A/R Corr Inv - Drawn Dpm Appld12VatSumTax LCNum196
78CSI2A/R Corr Inv - Freight - Rows16VatSumTax AmountNum196
79CSI3A/R Correction Invoice - Freight16VatSumTax AmountNum196
80CSI6A/R Corr. Inv. - Installments14VatSumTotal TaxNum196
81CSV1A/R Correction Invoice Reversal - Rows75VatSumTotal TaxNum196
82CSV11A/R CrIn Rev - Drawn Dpm Det.11VatSumTax LCNum196
83CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses16VatSumTax AmountNum196
84CSV15A/R CrIn Rev - Drawn Dpm Appld12VatSumTax LCNum196
85CSV2A/R Correction Invoice Reversal - Freight - Rows16VatSumTax AmountNum196
86CSV3A/R Correction Invoice Reversal - Freight16VatSumTax AmountNum196
87CSV6A/R Correction Invoice Reversal - Installments14VatSumTotal TaxNum196
88DLN1Delivery - Rows75VatSumTotal TaxNum196
89DLN11Delivery - Drawn Dpm Detail11VatSumTax LCNum196
90DLN13Delivery Rows - Distributed Expenses16VatSumTax AmountNum196
91DLN15Delivery - Drawn Dpm Applied12VatSumTax LCNum196
92DLN2Delivery Notes - Freight - Rows16VatSumTax AmountNum196
93DLN3Delivery Notes - Freight16VatSumTax AmountNum196
94DLN6Delivery - Installments14VatSumTotal TaxNum196
95DPI1A/R Down Payment - Rows75VatSumTotal TaxNum196
96DPI11A/R DP - Drawn Dpm Detail11VatSumTax LCNum196
97DPI13A/R Down Payment Rows - Distributed Expenses16VatSumTax AmountNum196
98DPI15A/R DP - Drawn Dpm Applied12VatSumTax LCNum196
99DPI2A/R Down Payment - Freight - Rows16VatSumTax AmountNum196
100DPI3A/R Down Payment - Freight16VatSumTax AmountNum196
101DPI6A/R Down Payment - Installments14VatSumTotal TaxNum196
102DPO1A/P Down Payment - Rows75VatSumTotal TaxNum196
103DPO11A/P DP - Drawn Dpm Detail11VatSumTax LCNum196
104DPO13A/P Down Payment Rows - Distributed Expenses16VatSumTax AmountNum196
105DPO15A/P DP - Drawn Dpm Applied12VatSumTax LCNum196
106DPO2A/P Down Payment - Freight - Rows16VatSumTax AmountNum196
107DPO3A/P Down Payment - Freight16VatSumTax AmountNum196
108DPO6Down Payment Out - Installments14VatSumTotal TaxNum196
109DRF1Draft - Rows75VatSumTotal TaxNum196
110DRF11Draft - Drawn Dpm Detail11VatSumTax LCNum196
111DRF13Draft Rows - Distributed Expenses16VatSumTax AmountNum196
112DRF15Draft - Drawn Dpm Applied12VatSumTax LCNum196
113DRF2Draft - Freight - Rows16VatSumTax AmountNum196
114DRF3Draft - Freight16VatSumTax AmountNum196
115DRF6Document Drafts - Installments14VatSumTotal TaxNum196
116IEI1Incoming Excise Invoice - Rows75VatSumTotal TaxNum196
117IEI11IEI - Drawn Dpm Detail11VatSumTax LCNum196
118IEI13Incoming Excise Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
119IEI15IEI - Drawn Dpm Applied12VatSumTax LCNum196
120IEI2Incoming Excise Invoice - Freight - History - Rows16VatSumTax AmountNum196
121IEI3IEI - Freight16VatSumTax AmountNum196
122IEI6IEI - Installments14VatSumTotal TaxNum196
123INV1A/R Invoice - Rows75VatSumTotal TaxNum196
124INV11A/R Invoice - Drawn Dpm Detail11VatSumTax LCNum196
125INV13A/R Invoice Rows - Distributed Freights16VatSumTax AmountNum196
126INV15A/R Inv. - Drawn Dpm Applied12VatSumTax LCNum196
127INV2A/R Invoice - Freight - Rows16VatSumTax AmountNum196
128INV3A/R Invoice - Freight16VatSumTax AmountNum196
129INV6A/R Invoice - Installments14VatSumTotal TaxNum196
130OCINA/R Correction Invoice18VatSumTotal TaxNum196
131OCPIA/P Correction Invoice18VatSumTotal TaxNum196
132OCPVA/P Correction Invoice Reversal18VatSumTotal TaxNum196
133OCSIA/R Correction Invoice18VatSumTotal TaxNum196
134OCSVA/R Correction Invoice Reversal18VatSumTotal TaxNum196
135ODLNDelivery18VatSumTotal TaxNum196
136ODPIA/R Down Payment18VatSumTotal TaxNum196
137ODPOA/P Down Payment18VatSumTotal TaxNum196
138ODRFDrafts18VatSumTotal TaxNum196
139OEI1Outgoing Excise Invoice - Rows75VatSumTotal TaxNum196
140OEI11OEI - Drawn Dpm Detail11VatSumTax LCNum196
141OEI13Outgoing Excise Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
142OEI15OEI - Drawn Dpm Applied12VatSumTax LCNum196
143OEI2OEI - Freight Rows16VatSumTax AmountNum196
144OEI3OEI - Freight16VatSumTax AmountNum196
145OEI6Outgoing Excise Invoice - Installments14VatSumTotal TaxNum196
146OIEIIncoming Excise Invoice18VatSumTotal TaxNum196
147OINVA/R Invoice18VatSumTotal TaxNum196
148OOEIOutgoing Excise Invoice18VatSumTotal TaxNum196
149OPCHA/P Invoice18VatSumTotal TaxNum196
150OPDNGoods Receipt PO18VatSumTotal TaxNum196
151OPORPurchase Order18VatSumTotal TaxNum196
152OPQTPurchase Quotation18VatSumTotal TaxNum196
153OPRQPurchase Request18VatSumTotal TaxNum196
154OQUTSales Quotation18VatSumTotal TaxNum196
155ORDNReturns18VatSumTotal TaxNum196
156ORDRSales Order18VatSumTotal TaxNum196
157ORINA/R Credit Memo18VatSumTotal TaxNum196
158ORPCA/P Credit Memo18VatSumTotal TaxNum196
159ORPDGoods Return18VatSumTotal TaxNum196
160OTPIPurchase Tax Invoice32VatSumTotal TaxNum196
161OTSISales Tax Invoice32VatSumTotal TaxNum196
162OTXDTax Invoice Draft32VatSumTotal TaxNum196
163PCH1A/P Invoice - Rows75VatSumTotal TaxNum196
164PCH11A/P Invoice - Drawn Dpm Det.11VatSumTax LCNum196
165PCH13A/P Invoice Rows - Distributed Expenses16VatSumTax AmountNum196
166PCH15A/P Invoice - Drawn Dpm Appld12VatSumTax LCNum196
167PCH2A/P Invoice - Freight - Rows16VatSumTax AmountNum196
168PCH3A/P Invoice - Freight16VatSumTax AmountNum196
169PCH6A/P Invoice - Installments14VatSumTotal TaxNum196
170PDN1Goods Receipt PO - Rows75VatSumTotal TaxNum196
171PDN11GRPO - Drawn Dpm Detail11VatSumTax LCNum196
172PDN13Goods Receipt PO Rows - Distributed Expenses16VatSumTax AmountNum196
173PDN15GRPO - Drawn Dpm Applied12VatSumTax LCNum196
174PDN2Goods Receipt PO - Freight - Rows16VatSumTax AmountNum196
175PDN3Goods Receipt PO - Freight16VatSumTax AmountNum196
176PDN6Goods Receipt PO - Installments14VatSumTotal TaxNum196
177POR1Purchase Order - Rows75VatSumTotal TaxNum196
178POR11PO - Drawn Dpm Detail11VatSumTax LCNum196
179POR13Purchase Order Rows - Distributed Expenses16VatSumTax AmountNum196
180POR15PO - Drawn Dpm Applied12VatSumTax LCNum196
181POR2Purchase Order - Freight - Rows16VatSumTax AmountNum196
182POR3Purchase Order - Freight16VatSumTax AmountNum196
183POR6Purchase Order - Installments14VatSumTotal TaxNum196
184PQT1Purchase Quotation - Rows75VatSumTotal TaxNum196
185PQT11PQ - Drawn DPM Detail11VatSumTax LCNum196
186PQT13Purchase Quotation Rows - Distributed Expenses16VatSumTax AmountNum196
187PQT15PQ - Drawn DPM Applied12VatSumTax LCNum196
188PQT2Purchase Quotation - Freight - Rows16VatSumTax AmountNum196
189PQT3Purchase Quotation - Freight16VatSumTax AmountNum196
190PQT6Purchase Quotation - Installments14VatSumTotal TaxNum196
191PRQ1Purchase Request - Rows75VatSumTotal TaxNum196
192PRQ11PR - Drawn DPM Detail11VatSumTax LCNum196
193PRQ13Purchase Request Rows - Distributed Expenses16VatSumTax AmountNum196
194PRQ15PR - Drawn DPM Applied12VatSumTax LCNum196
195PRQ2Purchase Request - Freight - Rows16VatSumTax AmountNum196
196PRQ3Purchase Request - Freight16VatSumTax AmountNum196
197PRQ6Purchase Request - Installments14VatSumTotal TaxNum196
198QUT1Sales Quotation - Rows75VatSumTax TotalNum196
199QUT11Sls Quote - Drawn Dpm Detail11VatSumTax LCNum196
200QUT13Sales Quotation Rows - Distributed Expenses16VatSumTax AmountNum196
201QUT15Sls Quote - Drawn Dpm Applied12VatSumTax LCNum196
202QUT2Sales Quotation - Freight - Rows16VatSumTax AmountNum196
203QUT3Sales Quotation - Freight16VatSumTax AmountNum196
204QUT6Sales Quotation - Installments14VatSumTotal TaxNum196
205RDN1Returns - Rows75VatSumTax TotalNum196
206RDN11Returns - Drawn Dpm Detail11VatSumTax LCNum196
207RDN13Returns Rows - Distributed Expenses16VatSumTax AmountNum196
208RDN15Returns - Drawn Dpm Applied12VatSumTax LCNum196
209RDN2Return - Freight - Rows16VatSumTax AmountNum196
210RDN3Return - Freight16VatSumTax AmountNum196
211RDN6Returns - Installments14VatSumTotal TaxNum196
212RDR1Sales Order - Rows75VatSumTotal Tax - RowNum196
213RDR11Sls Ord. - Drawn Dpm Detail11VatSumTax LCNum196
214RDR13Sales Order Rows - Distributed Expenses16VatSumTax AmountNum196
215RDR15Sls Ord. - Drawn Dpm Applied12VatSumTax LCNum196
216RDR2Sales Order - Freight - Rows16VatSumTax AmountNum196
217RDR3Sales Order - Freight16VatSumTax AmountNum196
218RDR6Sales Order - Installments14VatSumTotal TaxNum196
219RIN1A/R Credit Memo - Rows75VatSumTotal TaxNum196
220RIN11A/R Cr. Memo - Drawn Dpm Det.11VatSumTax LCNum196
221RIN13A/R Credit Memo Rows - Distributed Expenses16VatSumTax AmountNum196
222RIN15A/R Cr. Memo - Drawn Dpm Appld12VatSumTax LCNum196
223RIN2A/R Credit Memo - Freight - Rows16VatSumTax AmountNum196
224RIN3A/R Credit Memo - Freight16VatSumTax AmountNum196
225RIN6A/R Credit Memo - Installments14VatSumTotal TaxNum196
226RPC1A/P Credit Memo - Rows75VatSumTotal TaxNum196
227RPC11A/P Cr. Memo - Drawn Dpm Det.11VatSumTax LCNum196
228RPC13A/P Credit Memo Rows - Distributed Expenses16VatSumTax AmountNum196
229RPC15A/P Cr. Memo - Drawn Dpm Appld12VatSumTax LCNum196
230RPC2A/P Credit Memo Rows - Expenses16VatSumTax AmountNum196
231RPC3A/P Credit Memo - Freight16VatSumTax AmountNum196
232RPC6A/P Credit Memo - Installments14VatSumTotal TaxNum196
233RPD1Goods Return - Rows75VatSumTotal TaxNum196
234RPD11Gds Return - Drawn Dpm Detail11VatSumTax LCNum196
235RPD13Goods Returns Rows - Distributed Expenses16VatSumTax AmountNum196
236RPD15Gds Return - Drawn Dpm Applied12VatSumTax LCNum196
237RPD2Goods Return - Freight - Rows16VatSumTax AmountNum196
238RPD3Goods Return - Freight16VatSumTax AmountNum196
239RPD6Goods Return - Installments14VatSumTotal TaxNum196