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

150 columns | Print definition?B1 9.2  | EQUVATSUMS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC4Incoming Payment - Account List - History35EquVatSumSEqualization VAT Amount (SC)Num196
2ARC5Reciept log vat adjustment-History26EquVatSumSTotal Equalization Tax (SC)Num196
3PDF4Payment Draft - Account List35EquVatSumSEqualization VAT Amount (SC)Num196
4PDF5PaymentDraft - vat adjustment26EquVatSumSTotal 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 Adjustment26EquVatSumSTotal Equalization Tax (SC)Num196
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
100OPRQPurchase Request148EquVatSumSTotal Equalization Tax (SC)Num196
101OQUTSales Quotation148EquVatSumSTotal Equalization Tax (SC)Num196
102ORDNReturns148EquVatSumSTotal Equalization Tax (SC)Num196
103ORDRSales Order148EquVatSumSTotal Equalization Tax (SC)Num196
104ORINA/R Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
105ORPCA/P Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
106ORPDGoods Return148EquVatSumSTotal Equalization Tax (SC)Num196
107PCH1A/P Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
108PCH13A/P Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
109PCH2A/P Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
110PCH3A/P Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
111PDN1Goods Receipt PO - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
112PDN13Goods Receipt PO Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
113PDN2Goods Receipt PO - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
114PDN3Goods Receipt PO - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
115POR1Purchase Order - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
116POR13Purchase Order Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
117POR2Purchase Order - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
118POR3Purchase Order - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
119PQT1Purchase Quotation - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
120PQT13Purchase Quotation Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
121PQT2Purchase Quotation - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
122PQT3Purchase Quotation - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
123PRQ1Purchase Request - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
124PRQ13Purchase Request Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
125PRQ2Purchase Request - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
126PRQ3Purchase Request - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
127QUT1Sales Quotation - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
128QUT13Sales Quotation Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
129QUT2Sales Quotation - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
130QUT3Sales Quotation - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
131RDN1Returns - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
132RDN13Returns Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
133RDN2Return - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
134RDN3Return - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
135RDR1Sales Order - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
136RDR13Sales Order Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
137RDR2Sales Order - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
138RDR3Sales Order - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
139RIN1A/R Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
140RIN13A/R Credit Memo Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
141RIN2A/R Credit Memo - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
142RIN3A/R Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
143RPC1A/P Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
144RPC13A/P Credit Memo Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
145RPC2A/P Credit Memo Rows - Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
146RPC3A/P Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
147RPD1Goods Return - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
148RPD13Goods Returns Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
149RPD2Goods Return - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
150RPD3Goods Return - Freight32EquVatSumSTotal Equalization Tax (SC)Num196