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

172 columns | Print definition?B1 9.2  | 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
32ADO3A/R Invoice - Freight - History18VatSumSyTax Amount (SC)Num196
33ADO6Documents History - Installments16VatSumSyTax Amount (SC)Num196
34ADOCInvoice - History57VatSumSyTax Amount (SC)Num196
35CIN1Correction Invoice - Rows77VatSumSyTax Amount (SC)Num196
36CIN13Correction Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
37CIN2A/R Correction Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
38CIN3A/R Correction Invoice - Freight18VatSumSyTax Amount (SC)Num196
39CIN6Correction Invoice - Installments16VatSumSyTax Amount (SC)Num196
40CPI1A/P Correction Invoice - Rows77VatSumSyTax Amount (SC)Num196
41CPI13A/P Correction Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
42CPI2A/P Correction Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
43CPI3A/P Correction Invoice - Freight18VatSumSyTax Amount (SC)Num196
44CPI6Documents History - Installments16VatSumSyTax Amount (SC)Num196
45CPV1A/P Correction Invoice Reversal - Rows77VatSumSyTax Amount (SC)Num196
46CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
47CPV2A/P Correction Invoice Reversal - Freight - Rows18VatSumSyTax Amount (SC)Num196
48CPV3A/P Correction Invoice Reversal - Freight18VatSumSyTax Amount (SC)Num196
49CPV6A/P Correction Invoice Reversal - Installments16VatSumSyTax Amount (SC)Num196
50CSI1A/R Correction Invoice - Rows77VatSumSyTax Amount (SC)Num196
51CSI13A/R Correction Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
52CSI2A/R Corr Inv - Freight - Rows18VatSumSyTax Amount (SC)Num196
53CSI3A/R Correction Invoice - Freight18VatSumSyTax Amount (SC)Num196
54CSI6A/R Corr. Inv. - Installments16VatSumSyTax Amount (SC)Num196
55CSV1A/R Correction Invoice Reversal - Rows77VatSumSyTax Amount (SC)Num196
56CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
57CSV2A/R Correction Invoice Reversal - Freight - Rows18VatSumSyTax Amount (SC)Num196
58CSV3A/R Correction Invoice Reversal - Freight18VatSumSyTax Amount (SC)Num196
59CSV6A/R Correction Invoice Reversal - Installments16VatSumSyTax Amount (SC)Num196
60DLN1Delivery - Rows77VatSumSyTax Amount (SC)Num196
61DLN13Delivery Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
62DLN2Delivery Notes - Freight - Rows18VatSumSyTax Amount (SC)Num196
63DLN3Delivery Notes - Freight18VatSumSyTax Amount (SC)Num196
64DLN6Delivery - Installments16VatSumSyTax Amount (SC)Num196
65DPI1A/R Down Payment - Rows77VatSumSyTax Amount (SC)Num196
66DPI13A/R Down Payment Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
67DPI2A/R Down Payment - Freight - Rows18VatSumSyTax Amount (SC)Num196
68DPI3A/R Down Payment - Freight18VatSumSyTax Amount (SC)Num196
69DPI6A/R Down Payment - Installments16VatSumSyTax Amount (SC)Num196
70DPO1A/P Down Payment - Rows77VatSumSyTax Amount (SC)Num196
71DPO13A/P Down Payment Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
72DPO2A/P Down Payment - Freight - Rows18VatSumSyTax Amount (SC)Num196
73DPO3A/P Down Payment - Freight18VatSumSyTax Amount (SC)Num196
74DPO6Down Payment Out - Installments16VatSumSyTax Amount (SC)Num196
75DRF1Draft - Rows77VatSumSyTax Amount (SC)Num196
76DRF13Draft Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
77DRF2Draft - Freight - Rows18VatSumSyTax Amount (SC)Num196
78DRF3Draft - Freight18VatSumSyTax Amount (SC)Num196
79DRF6Document Drafts - Installments16VatSumSyTax Amount (SC)Num196
80IEI1Incoming Excise Invoice - Rows77VatSumSyTax Amount (SC)Num196
81IEI13Incoming Excise Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
82IEI2Incoming Excise Invoice - Freight - History - Rows18VatSumSyTax Amount (SC)Num196
83IEI3IEI - Freight18VatSumSyTax Amount (SC)Num196
84IEI6IEI - Installments16VatSumSyTax Amount (SC)Num196
85INV1A/R Invoice - Rows77VatSumSyTax Amount (SC)Num196
86INV13A/R Invoice Rows - Distributed Freights18VatSumSyTax Amount (SC)Num196
87INV2A/R Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
88INV3A/R Invoice - Freight18VatSumSyTax Amount (SC)Num196
89INV6A/R Invoice - Installments16VatSumSyTax Amount (SC)Num196
90OCINA/R Correction Invoice57VatSumSyTax Amount (SC)Num196
91OCPIA/P Correction Invoice57VatSumSyTax Amount (SC)Num196
92OCPVA/P Correction Invoice Reversal57VatSumSyTax Amount (SC)Num196
93OCSIA/R Correction Invoice57VatSumSyTax Amount (SC)Num196
94OCSVA/R Correction Invoice Reversal57VatSumSyTax Amount (SC)Num196
95ODLNDelivery57VatSumSyTax Amount (SC)Num196
96ODPIA/R Down Payment57VatSumSyTax Amount (SC)Num196
97ODPOA/P Down Payment57VatSumSyTax Amount (SC)Num196
98ODRFDrafts57VatSumSyTax Amount (SC)Num196
99OEI1Outgoing Excise Invoice - Rows77VatSumSyTax Amount (SC)Num196
100OEI13Outgoing Excise Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
101OEI2OEI - Freight Rows18VatSumSyTax Amount (SC)Num196
102OEI3OEI - Freight18VatSumSyTax Amount (SC)Num196
103OEI6Outgoing Excise Invoice - Installments16VatSumSyTax Amount (SC)Num196
104OIEIIncoming Excise Invoice57VatSumSyTax Amount (SC)Num196
105OINVA/R Invoice57VatSumSyTax Amount (SC)Num196
106OOEIOutgoing Excise Invoice57VatSumSyTax Amount (SC)Num196
107OPCHA/P Invoice57VatSumSyTax Amount (SC)Num196
108OPDNGoods Receipt PO57VatSumSyTax Amount (SC)Num196
109OPORPurchase Order57VatSumSyTax Amount (SC)Num196
110OPQTPurchase Quotation57VatSumSyTax Amount (SC)Num196
111OPRQPurchase Request57VatSumSyTax Amount (SC)Num196
112OQUTSales Quotation57VatSumSyTax Amount (SC)Num196
113ORDNReturns57VatSumSyTax Amount (SC)Num196
114ORDRSales Order57VatSumSyTax Amount (SC)Num196
115ORINA/R Credit Memo57VatSumSyTax Amount (SC)Num196
116ORPCA/P Credit Memo57VatSumSyTax Amount (SC)Num196
117ORPDGoods Return57VatSumSyTax Amount (SC)Num196
118PCH1A/P Invoice - Rows77VatSumSyTax Amount (SC)Num196
119PCH13A/P Invoice Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
120PCH2A/P Invoice - Freight - Rows18VatSumSyTax Amount (SC)Num196
121PCH3A/P Invoice - Freight18VatSumSyTax Amount (SC)Num196
122PCH6A/P Invoice - Installments16VatSumSyTax Amount (SC)Num196
123PDN1Goods Receipt PO - Rows77VatSumSyTax Amount (SC)Num196
124PDN13Goods Receipt PO Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
125PDN2Goods Receipt PO - Freight - Rows18VatSumSyTax Amount (SC)Num196
126PDN3Goods Receipt PO - Freight18VatSumSyTax Amount (SC)Num196
127PDN6Goods Receipt PO - Installments16VatSumSyTax Amount (SC)Num196
128POR1Purchase Order - Rows77VatSumSyTax Amount (SC)Num196
129POR13Purchase Order Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
130POR2Purchase Order - Freight - Rows18VatSumSyTax Amount (SC)Num196
131POR3Purchase Order - Freight18VatSumSyTax Amount (SC)Num196
132POR6Purchase Order - Installments16VatSumSyTax Amount (SC)Num196
133PQT1Purchase Quotation - Rows77VatSumSyTax Amount (SC)Num196
134PQT13Purchase Quotation Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
135PQT2Purchase Quotation - Freight - Rows18VatSumSyTax Amount (SC)Num196
136PQT3Purchase Quotation - Freight18VatSumSyTax Amount (SC)Num196
137PQT6Purchase Quotation - Installments16VatSumSyTax Amount (SC)Num196
138PRQ1Purchase Request - Rows77VatSumSyTax Amount (SC)Num196
139PRQ13Purchase Request Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
140PRQ2Purchase Request - Freight - Rows18VatSumSyTax Amount (SC)Num196
141PRQ3Purchase Request - Freight18VatSumSyTax Amount (SC)Num196
142PRQ6Purchase Request - Installments16VatSumSyTax Amount (SC)Num196
143QUT1Sales Quotation - Rows77VatSumSyTax Amount (SC)Num196
144QUT13Sales Quotation Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
145QUT2Sales Quotation - Freight - Rows18VatSumSyTax Amount (SC)Num196
146QUT3Sales Quotation - Freight18VatSumSyTax Amount (SC)Num196
147QUT6Sales Quotation - Installments16VatSumSyTax Amount (SC)Num196
148RDN1Returns - Rows77VatSumSyTax Amount (SC)Num196
149RDN13Returns Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
150RDN2Return - Freight - Rows18VatSumSyTax Amount (SC)Num196
151RDN3Return - Freight18VatSumSyTax Amount (SC)Num196
152RDN6Returns - Installments16VatSumSyTax Amount (SC)Num196
153RDR1Sales Order - Rows77VatSumSyTax Amount (SC)Num196
154RDR13Sales Order Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
155RDR2Sales Order - Freight - Rows18VatSumSyTax Amount (SC)Num196
156RDR3Sales Order - Freight18VatSumSyTax Amount (SC)Num196
157RDR6Sales Order - Installments16VatSumSyTax Amount (SC)Num196
158RIN1A/R Credit Memo - Rows77VatSumSyTax Amount (SC)Num196
159RIN13A/R Credit Memo Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
160RIN2A/R Credit Memo - Freight - Rows18VatSumSyTax Amount (SC)Num196
161RIN3A/R Credit Memo - Freight18VatSumSyTax Amount (SC)Num196
162RIN6A/R Credit Memo - Installments16VatSumSyTax Amount (SC)Num196
163RPC1A/P Credit Memo - Rows77VatSumSyTax Amount (SC)Num196
164RPC13A/P Credit Memo Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
165RPC2A/P Credit Memo Rows - Expenses18VatSumSyTax Amount (SC)Num196
166RPC3A/P Credit Memo - Freight18VatSumSyTax Amount (SC)Num196
167RPC6A/P Credit Memo - Installments16VatSumSyTax Amount (SC)Num196
168RPD1Goods Return - Rows77VatSumSyTax Amount (SC)Num196
169RPD13Goods Returns Rows - Distributed Expenses18VatSumSyTax Amount (SC)Num196
170RPD2Goods Return - Freight - Rows18VatSumSyTax Amount (SC)Num196
171RPD3Goods Return - Freight18VatSumSyTax Amount (SC)Num196
172RPD6Goods Return - Installments16VatSumSyTax Amount (SC)Num196