SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

153 columns | Print definition?B1 9.2  | 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
104OQUTSales Quotation146EquVatSumTotal Equalization TaxNum196
105ORDNReturns146EquVatSumTotal Equalization TaxNum196
106ORDRSales Order146EquVatSumTotal Equalization TaxNum196
107ORINA/R Credit Memo146EquVatSumTotal Equalization TaxNum196
108ORPCA/P Credit Memo146EquVatSumTotal Equalization TaxNum196
109ORPDGoods Return146EquVatSumTotal Equalization TaxNum196
110PCH1A/P Invoice - Rows118EquVatSumTotal Equalization TaxNum196
111PCH13A/P Invoice Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
112PCH2A/P Invoice - Freight - Rows29EquVatSumTotal Equalization TaxNum196
113PCH3A/P Invoice - Freight30EquVatSumTotal Equalization TaxNum196
114PDN1Goods Receipt PO - Rows118EquVatSumTotal Equalization TaxNum196
115PDN13Goods Receipt PO Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
116PDN2Goods Receipt PO - Freight - Rows29EquVatSumTotal Equalization TaxNum196
117PDN3Goods Receipt PO - Freight30EquVatSumTotal Equalization TaxNum196
118POR1Purchase Order - Rows118EquVatSumTotal Equalization TaxNum196
119POR13Purchase Order Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
120POR2Purchase Order - Freight - Rows29EquVatSumTotal Equalization TaxNum196
121POR3Purchase Order - Freight30EquVatSumTotal Equalization TaxNum196
122PQT1Purchase Quotation - Rows118EquVatSumTotal Equalization TaxNum196
123PQT13Purchase Quotation Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
124PQT2Purchase Quotation - Freight - Rows29EquVatSumTotal Equalization TaxNum196
125PQT3Purchase Quotation - Freight30EquVatSumTotal Equalization TaxNum196
126PRQ1Purchase Request - Rows118EquVatSumTotal Equalization TaxNum196
127PRQ13Purchase Request Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
128PRQ2Purchase Request - Freight - Rows29EquVatSumTotal Equalization TaxNum196
129PRQ3Purchase Request - Freight30EquVatSumTotal Equalization TaxNum196
130QUT1Sales Quotation - Rows118EquVatSumTotal Equalization TaxNum196
131QUT13Sales Quotation Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
132QUT2Sales Quotation - Freight - Rows29EquVatSumTotal Equalization TaxNum196
133QUT3Sales Quotation - Freight30EquVatSumTotal Equalization TaxNum196
134RDN1Returns - Rows118EquVatSumTotal Equalization TaxNum196
135RDN13Returns Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
136RDN2Return - Freight - Rows29EquVatSumTotal Equalization TaxNum196
137RDN3Return - Freight30EquVatSumTotal Equalization TaxNum196
138RDR1Sales Order - Rows118EquVatSumTotal Equalization TaxNum196
139RDR13Sales Order Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
140RDR2Sales Order - Freight - Rows29EquVatSumTotal Equalization TaxNum196
141RDR3Sales Order - Freight30EquVatSumTotal Equalization TaxNum196
142RIN1A/R Credit Memo - Rows118EquVatSumTotal Equalization TaxNum196
143RIN13A/R Credit Memo Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
144RIN2A/R Credit Memo - Freight - Rows29EquVatSumTotal Equalization TaxNum196
145RIN3A/R Credit Memo - Freight30EquVatSumTotal Equalization TaxNum196
146RPC1A/P Credit Memo - Rows118EquVatSumTotal Equalization TaxNum196
147RPC13A/P Credit Memo Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
148RPC2A/P Credit Memo Rows - Expenses29EquVatSumTotal Equalization TaxNum196
149RPC3A/P Credit Memo - Freight30EquVatSumTotal Equalization TaxNum196
150RPD1Goods Return - Rows118EquVatSumTotal Equalization TaxNum196
151RPD13Goods Returns Rows - Distributed Expenses29EquVatSumTotal Equalization TaxNum196
152RPD2Goods Return - Freight - Rows29EquVatSumTotal Equalization TaxNum196
153RPD3Goods Return - Freight30EquVatSumTotal Equalization TaxNum196