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
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OSRN20Serial Numbers Master Data
7ORCT154Incoming Payment
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

213 columns | Print definition?B1 8.8  | VATSUM

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