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

173 columns | Print definition?B1 9.3  | EQUVATSUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC4Incoming Payment - Account List - History33EquVatSumEqualization VAT AmountNum196
2ARC5Reciept log vat adjustment-History24EquVatSumTotal Equalization TaxNum196
3PDF4Payment Draft - Account List33EquVatSumEqualization VAT AmountNum196
4PDF5PaymentDraft - vat adjustment24EquVatSumTotal Equalization TaxNum196
5PMN5Payment - VAT Adjustment24EquVatSumTotal Equalization TaxNum196
6RCC4Incoming Payment - Credit Vouchers33EquVatSumEqualization VAT AmountNum196
7RCT4Incoming Payment - Account List33EquVatSumEqualization VAT AmountNum196
8RCT5Reciept vat adjustment24EquVatSumTotal Equalization TaxNum196
9VPM4Outgoing Payments - Accounts33EquVatSumEqualization VAT AmountNum196
10VPM5Outgoing Payments - Vat Adjustment24EquVatSumTotal Equalization TaxNum196
TOPFinance
11AJD1Journal Entry - History - Rows97EquVatSumEqualization Tax AmountNum196
12BTF1Journal Voucher - Rows97EquVatSumEqualization Tax AmountNum196
13JDT1Journal Entry - Rows97EquVatSumEqualization Tax AmountNum196
TOPInventory and Production
14IGE1Goods Issue - Rows118EquVatSumTotal Equalization TaxNum196
15IGE13Goods Issue Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
16IGE2Goods Issue - Freight - Rows29EquVatSumTotal Equalization TaxNum196
17IGE3Goods Issue - Freight30EquVatSumTotal Equalization TaxNum196
18IGN1Goods Receipt - Rows118EquVatSumTotal Equalization TaxNum196
19IGN13Goods Receipt Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
20IGN2Goods Receipt - Freight - Rows29EquVatSumTotal Equalization TaxNum196
21IGN3Goods Receipt - Freight30EquVatSumTotal Equalization TaxNum196
22OIGEGoods Issue146EquVatSumTotal Equalization TaxNum196
23OIGNGoods Receipt146EquVatSumTotal Equalization TaxNum196
24OWTQInventory Transfer Request146EquVatSumTotal Equalization TaxNum196
25OWTRInventory Transfer146EquVatSumTotal Equalization TaxNum196
26WTQ1Inventory Transfer Request - Rows118EquVatSumTotal Equalization TaxNum196
27WTQ13Inventory Transfer Request Rows - Distributed Freights29EquVatSumTotal Equalization TaxNum196
28WTQ2Inventory Transfer Request - Freight - Rows29EquVatSumTotal Equalization TaxNum196
29WTQ3Inventory Transfer Request - Freight30EquVatSumTotal Equalization TaxNum196
30WTR1Inventory Transfer - Rows118EquVatSumEqualization Tax TotalNum196
31WTR13Inventory Transfer Rows - Distributed Freights29EquVatSumTotal Equalization TaxNum196
32WTR2Inventory Transfer - Freight - Rows29EquVatSumTotal Equalization TaxNum196
33WTR3Inventory Transfer - Freight30EquVatSumTotal Equalization TaxNum196
TOPMarketing Documents
34ADO1A/R Invoice (Rows) - History118EquVatSumTotal Equalization TaxNum196
35ADO13A/R Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
36ADO2A/R Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
37ADO3A/R Invoice - Freight - History30EquVatSumTotal Equalization TaxNum196
38ADOCInvoice - History146EquVatSumTotal Equalization TaxNum196
39CIN1Correction Invoice - Rows118EquVatSumTotal Equalization TaxNum196
40CIN13Correction Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
41CIN2A/R Correction Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
42CIN3A/R Correction Invoice - Freight30EquVatSumTotal Equalization TaxNum196
43CPI1A/P Correction Invoice - Rows118EquVatSumTotal Equalization TaxNum196
44CPI13A/P Correction Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
45CPI2A/P Correction Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
46CPI3A/P Correction Invoice - Freight30EquVatSumTotal Equalization TaxNum196
47CPV1A/P Correction Invoice Reversal - Rows118EquVatSumTotal Equalization TaxNum196
48CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
49CPV2A/P Correction Invoice Reversal - Freight - Rows29EquVatSumTotal Equalization TaxNum196
50CPV3A/P Correction Invoice Reversal - Freight30EquVatSumTotal Equalization TaxNum196
51CSI1A/R Correction Invoice - Rows118EquVatSumTotal Equalization TaxNum196
52CSI13A/R Correction Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
53CSI2A/R Corr Inv - Freight - Rows29EquVatSumTotal Equalization TaxNum196
54CSI3A/R Correction Invoice - Freight30EquVatSumTotal Equalization TaxNum196
55CSV1A/R Correction Invoice Reversal - Rows118EquVatSumTotal Equalization TaxNum196
56CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
57CSV2A/R Correction Invoice Reversal - Freight - Rows29EquVatSumTotal Equalization TaxNum196
58CSV3A/R Correction Invoice Reversal - Freight30EquVatSumTotal Equalization TaxNum196
59DLN1Delivery - Rows118EquVatSumTotal Equalization TaxNum196
60DLN13Delivery Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
61DLN2Delivery Notes - Freight - Rows29EquVatSumTotal Equalization TaxNum196
62DLN3Delivery Notes - Freight30EquVatSumTotal Equalization TaxNum196
63DPI1A/R Down Payment - Rows118EquVatSumTotal Equalization TaxNum196
64DPI13A/R Down Payment Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
65DPI2A/R Down Payment - Freight - Rows29EquVatSumTotal Equalization TaxNum196
66DPI3A/R Down Payment - Freight30EquVatSumTotal Equalization TaxNum196
67DPO1A/P Down Payment - Rows118EquVatSumTotal Equalization TaxNum196
68DPO13A/P Down Payment Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
69DPO2A/P Down Payment - Freight - Rows29EquVatSumTotal Equalization TaxNum196
70DPO3A/P Down Payment - Freight30EquVatSumTotal Equalization TaxNum196
71DRF1Draft - Rows118EquVatSumTotal Equalization TaxNum196
72DRF13Draft Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
73DRF2Draft - Freight - Rows29EquVatSumTotal Equalization TaxNum196
74DRF3Draft - Freight30EquVatSumTotal Equalization TaxNum196
75IEI1Incoming Excise Invoice - Rows118EquVatSumTotal Equalization TaxNum196
76IEI13Incoming Excise Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
77IEI2Incoming Excise Invoice - Freight - History - Rows29EquVatSumTotal Equalization TaxNum196
78IEI3IEI - Freight30EquVatSumTotal Equalization TaxNum196
79INV1A/R Invoice - Rows118EquVatSumTotal Equalization TaxNum196
80INV13A/R Invoice Rows - Distributed Freights29EquVatSumTotal Equalization TaxNum196
81INV2A/R Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
82INV3A/R Invoice - Freight30EquVatSumTotal Equalization TaxNum196
83OCINA/R Correction Invoice146EquVatSumTotal Equalization TaxNum196
84OCPIA/P Correction Invoice146EquVatSumTotal Equalization TaxNum196
85OCPVA/P Correction Invoice Reversal146EquVatSumTotal Equalization TaxNum196
86OCSIA/R Correction Invoice146EquVatSumTotal Equalization TaxNum196
87OCSVA/R Correction Invoice Reversal146EquVatSumTotal Equalization TaxNum196
88ODLNDelivery146EquVatSumTotal Equalization TaxNum196
89ODPIA/R Down Payment146EquVatSumTotal Equalization TaxNum196
90ODPOA/P Down Payment146EquVatSumTotal Equalization TaxNum196
91ODRFDrafts146EquVatSumTotal Equalization TaxNum196
92OEI1Outgoing Excise Invoice - Rows118EquVatSumTotal Equalization TaxNum196
93OEI13Outgoing Excise Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
94OEI2OEI - Freight Rows29EquVatSumTotal Equalization TaxNum196
95OEI3OEI - Freight30EquVatSumTotal Equalization TaxNum196
96OIEIIncoming Excise Invoice146EquVatSumTotal Equalization TaxNum196
97OINVA/R Invoice146EquVatSumTotal Equalization TaxNum196
98OOEIOutgoing Excise Invoice146EquVatSumTotal Equalization TaxNum196
99OPCHA/P Invoice146EquVatSumTotal Equalization TaxNum196
100OPDNGoods Receipt PO146EquVatSumTotal Equalization TaxNum196
101OPORPurchase Order146EquVatSumTotal Equalization TaxNum196
102OPQTPurchase Quotation146EquVatSumTotal Equalization TaxNum196
103OPRQPurchase Request146EquVatSumTotal Equalization TaxNum196
104OPRRGoods Return Request146EquVatSumTotal Equalization TaxNum196
105OQUTSales Quotation146EquVatSumTotal Equalization TaxNum196
106ORDNReturns146EquVatSumTotal Equalization TaxNum196
107ORDRSales Order146EquVatSumTotal Equalization TaxNum196
108ORINA/R Credit Memo146EquVatSumTotal Equalization TaxNum196
109ORPCA/P Credit Memo146EquVatSumTotal Equalization TaxNum196
110ORPDGoods Return146EquVatSumTotal Equalization TaxNum196
111ORRRReturn Request146EquVatSumTotal Equalization TaxNum196
112OSFCSelf Credit Memo146EquVatSumTotal Equalization TaxNum196
113OSFISelf Invoice146EquVatSumTotal Equalization TaxNum196
114PCH1A/P Invoice - Rows118EquVatSumTotal Equalization TaxNum196
115PCH13A/P Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
116PCH2A/P Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
117PCH3A/P Invoice - Freight30EquVatSumTotal Equalization TaxNum196
118PDN1Goods Receipt PO - Rows118EquVatSumTotal Equalization TaxNum196
119PDN13Goods Receipt PO Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
120PDN2Goods Receipt PO - Freight - Rows29EquVatSumTotal Equalization TaxNum196
121PDN3Goods Receipt PO - Freight30EquVatSumTotal Equalization TaxNum196
122POR1Purchase Order - Rows118EquVatSumTotal Equalization TaxNum196
123POR13Purchase Order Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
124POR2Purchase Order - Freight - Rows29EquVatSumTotal Equalization TaxNum196
125POR3Purchase Order - Freight30EquVatSumTotal Equalization TaxNum196
126PQT1Purchase Quotation - Rows118EquVatSumTotal Equalization TaxNum196
127PQT13Purchase Quotation Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
128PQT2Purchase Quotation - Freight - Rows29EquVatSumTotal Equalization TaxNum196
129PQT3Purchase Quotation - Freight30EquVatSumTotal Equalization TaxNum196
130PRQ1Purchase Request - Rows118EquVatSumTotal Equalization TaxNum196
131PRQ13Purchase Request Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
132PRQ2Purchase Request - Freight - Rows29EquVatSumTotal Equalization TaxNum196
133PRQ3Purchase Request - Freight30EquVatSumTotal Equalization TaxNum196
134PRR1A/P Return Request - Rows118EquVatSumTotal Equalization TaxNum196
135PRR13A/P Return Request - Distributed Freights29EquVatSumTotal Equalization TaxNum196
136PRR2A/P Return Request - Freight - Rows29EquVatSumTotal Equalization TaxNum196
137PRR3A/P Return Request - Freight30EquVatSumTotal Equalization TaxNum196
138QUT1Sales Quotation - Rows118EquVatSumTotal Equalization TaxNum196
139QUT13Sales Quotation Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
140QUT2Sales Quotation - Freight - Rows29EquVatSumTotal Equalization TaxNum196
141QUT3Sales Quotation - Freight30EquVatSumTotal Equalization TaxNum196
142RDN1Returns - Rows118EquVatSumTotal Equalization TaxNum196
143RDN13Returns Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
144RDN2Return - Freight - Rows29EquVatSumTotal Equalization TaxNum196
145RDN3Return - Freight30EquVatSumTotal Equalization TaxNum196
146RDR1Sales Order - Rows118EquVatSumTotal Equalization TaxNum196
147RDR13Sales Order Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
148RDR2Sales Order - Freight - Rows29EquVatSumTotal Equalization TaxNum196
149RDR3Sales Order - Freight30EquVatSumTotal Equalization TaxNum196
150RIN1A/R Credit Memo - Rows118EquVatSumTotal Equalization TaxNum196
151RIN13A/R Credit Memo Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
152RIN2A/R Credit Memo - Freight - Rows29EquVatSumTotal Equalization TaxNum196
153RIN3A/R Credit Memo - Freight30EquVatSumTotal Equalization TaxNum196
154RPC1A/P Credit Memo - Rows118EquVatSumTotal Equalization TaxNum196
155RPC13A/P Credit Memo Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
156RPC2A/P Credit Memo Rows - Expenses29EquVatSumTotal Equalization TaxNum196
157RPC3A/P Credit Memo - Freight30EquVatSumTotal Equalization TaxNum196
158RPD1Goods Return - Rows118EquVatSumTotal Equalization TaxNum196
159RPD13Goods Returns Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
160RPD2Goods Return - Freight - Rows29EquVatSumTotal Equalization TaxNum196
161RPD3Goods Return - Freight30EquVatSumTotal Equalization TaxNum196
162RRR1A/R Return Request - Rows118EquVatSumTotal Equalization TaxNum196
163RRR13A/R Return Request - Distributed Freights29EquVatSumTotal Equalization TaxNum196
164RRR2A/R Return Request - Freight - Rows29EquVatSumTotal Equalization TaxNum196
165RRR3A/R Return Request - Freight30EquVatSumTotal Equalization TaxNum196
166SFC1Self Credit Memo - Rows118EquVatSumTotal Equalization TaxNum196
167SFC13Self Credit Memo Rows - Distributed Freights29EquVatSumTotal Equalization TaxNum196
168SFC2Self Credit Memo - Freight - Rows29EquVatSumTotal Equalization TaxNum196
169SFC3Self Credit Memo - Freight30EquVatSumTotal Equalization TaxNum196
170SFI1Self Invoice - Rows118EquVatSumTotal Equalization TaxNum196
171SFI13Self Invoice Rows - Distributed Freights29EquVatSumTotal Equalization TaxNum196
172SFI2Self Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
173SFI3Self Invoice - Freight30EquVatSumTotal Equalization TaxNum196