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

145 columns | Print definition?B1 8.82  | EQUVATSUMS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC4Incoming Payment - Account List - History35EquVatSumSEqualization VAT Amount (SC)Num196
2ARC5Reciept log 26EquVatSumSTotal Equalization Tax (SC)Num196
3PDF4Payment Draft - Account List35EquVatSumSEqualization VAT Amount (SC)Num196
4PDF5PaymentDraft - 26EquVatSumSTotal Equalization Tax (SC)Num196
5PMN5Payment - VAT Adjustment26EquVatSumSTotal Equalization Tax (SC)Num196
6RCC4Incoming Payment - Credit Vouchers35EquVatSumSEqualization VAT Amount (SC)Num196
7RCT4Incoming Payment - Account List35EquVatSumSEqualization VAT Amount (SC)Num196
8RCT5Reciept vat adjustment26EquVatSumSTotal Equalization Tax (SC)Num196
9VPM4Outgoing Payments - Accounts35EquVatSumSEqualization VAT Amount (SC)Num196
10VPM5Outgoing Payments - Vat Adjustment26EquVatSumSEquVatSumSNum196
TOPInventory and Production
11IGE1Goods Issue - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
12IGE13Goods Issue Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
13IGE2Goods Issue - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
14IGE3Goods Issue - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
15IGN1Goods Receipt - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
16IGN13Goods Receipt Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
17IGN2Goods Receipt - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
18IGN3Goods Receipt - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
19OIGEGoods Issue148EquVatSumSTotal Equalization Tax (SC)Num196
20OIGNGoods Receipt148EquVatSumSTotal Equalization Tax (SC)Num196
21OWTQInventory Transfer Request148EquVatSumSTotal Equalization Tax (SC)Num196
22OWTRInventory Transfer148EquVatSumSTotal Equalization Tax (SC)Num196
23WTQ1Inventory Transfer Request - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
24WTQ13Inventory Transfer Request Rows - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
25WTQ2Inventory Transfer Request - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
26WTQ3Inventory Transfer Request - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
27WTR1Inventory Transfer - Rows120EquVatSumSEqualization Tax Total SCNum196
28WTR13Inventory Transfer Rows - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
29WTR2Inventory Transfer - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
30WTR3Inventory Transfer - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
TOPMarketing Documents
31ADO1A/R Invoice (Rows) - History120EquVatSumSTotal Equalization Tax (SC)Num196
32ADO13A/R Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
33ADO2A/R Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
34ADO3A/R Invoice - Freight - History32EquVatSumSTotal Equalization Tax (SC)Num196
35ADOCInvoice - History148EquVatSumSTotal Equalization Tax (SC)Num196
36CIN1Correction Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
37CIN13Correction Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
38CIN2A/R Correction Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
39CIN3A/R Correction Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
40CPI1A/P Correction Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
41CPI13A/P Correction Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
42CPI2A/P Correction Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
43CPI3A/P Correction Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
44CPV1A/P Correction Invoice Reversal - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
45CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
46CPV2A/P Correction Invoice Reversal - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
47CPV3A/P Correction Invoice Reversal - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
48CSI1A/R Correction Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
49CSI13A/R Correction Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
50CSI2A/R Corr Inv - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
51CSI3A/R Correction Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
52CSV1A/R Correction Invoice Reversal - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
53CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
54CSV2A/R Correction Invoice Reversal - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
55CSV3A/R Correction Invoice Reversal - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
56DLN1Delivery - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
57DLN13Delivery Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
58DLN2Delivery Notes - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
59DLN3Delivery Notes - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
60DPI1A/R Down Payment - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
61DPI13A/R Down Payment Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
62DPI2A/R Down Payment - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
63DPI3A/R Down Payment - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
64DPO1A/P Down Payment - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
65DPO13A/P Down Payment Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
66DPO2A/P Down Payment - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
67DPO3A/P Down Payment - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
68DRF1Draft - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
69DRF13Draft Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
70DRF2Draft - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
71DRF3Draft - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
72IEI1Incoming Excise Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
73IEI13Incoming Excise Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
74IEI2Incoming Excise Invoice - Freight - History - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
75IEI3IEI - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
76INV1A/R Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
77INV13A/R Invoice Rows - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
78INV2A/R Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
79INV3A/R Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
80OCINA/R Correction Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
81OCPIA/P Correction Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
82OCPVA/P Correction Invoice Reversal148EquVatSumSTotal Equalization Tax (SC)Num196
83OCSIA/R Correction Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
84OCSVA/R Correction Invoice Reversal148EquVatSumSTotal Equalization Tax (SC)Num196
85ODLNDelivery148EquVatSumSTotal Equalization Tax (SC)Num196
86ODPIA/R Down Payment148EquVatSumSTotal Equalization Tax (SC)Num196
87ODPOA/P Down Payment148EquVatSumSTotal Equalization Tax (SC)Num196
88ODRFDrafts148EquVatSumSTotal Equalization Tax (SC)Num196
89OEI1Outgoing Excise Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
90OEI13Outgoing Excise Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
91OEI2OEI - Freight Rows31EquVatSumSTotal Equalization Tax (SC)Num196
92OEI3OEI - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
93OIEIIncoming Excise Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
94OINVA/R Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
95OOEIOutgoing Excise Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
96OPCHA/P Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
97OPDNGoods Receipt PO148EquVatSumSTotal Equalization Tax (SC)Num196
98OPORPurchase Order148EquVatSumSTotal Equalization Tax (SC)Num196
99OPQTPurchase Quotation148EquVatSumSTotal Equalization Tax (SC)Num196
100OQUTSales Quotation148EquVatSumSTotal Equalization Tax (SC)Num196
101ORDNReturns148EquVatSumSTotal Equalization Tax (SC)Num196
102ORDRSales Order148EquVatSumSTotal Equalization Tax (SC)Num196
103ORINA/R Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
104ORPCA/P Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
105ORPDGoods Return148EquVatSumSTotal Equalization Tax (SC)Num196
106PCH1A/P Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
107PCH13A/P Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
108PCH2A/P Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
109PCH3A/P Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
110PDN1Goods Receipt PO - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
111PDN13Goods Receipt PO Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
112PDN2Goods Receipt PO - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
113PDN3Goods Receipt PO - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
114POR1Purchase Order - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
115POR13Purchase Order Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
116POR2Purchase Order - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
117POR3Purchase Order - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
118PQT1Purchase Quotation - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
119PQT13Purchase Quotation Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
120PQT2Purchase Quotation - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
121PQT3Purchase Quotation - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
122QUT1Sales Quotation - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
123QUT13Sales Quotation Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
124QUT2Sales Quotation - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
125QUT3Sales Quotation - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
126RDN1Returns - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
127RDN13Returns Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
128RDN2Return - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
129RDN3Return - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
130RDR1Sales Order - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
131RDR13Sales Order Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
132RDR2Sales Order - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
133RDR3Sales Order - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
134RIN1A/R Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
135RIN13A/R Credit Memo Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
136RIN2A/R Credit Memo - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
137RIN3A/R Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
138RPC1A/P Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
139RPC13A/P Credit Memo Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
140RPC2A/P Credit Memo Rows - Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
141RPC3A/P Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
142RPD1Goods Return - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
143RPD13Goods Returns Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
144RPD2Goods Return - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
145RPD3Goods Return - Freight32EquVatSumSTotal Equalization Tax (SC)Num196