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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

170 columns | Print definition?B1 9.3  | 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
101OPRRGoods Return Request148EquVatSumSTotal Equalization Tax (SC)Num196
102OQUTSales Quotation148EquVatSumSTotal Equalization Tax (SC)Num196
103ORDNReturns148EquVatSumSTotal Equalization Tax (SC)Num196
104ORDRSales Order148EquVatSumSTotal Equalization Tax (SC)Num196
105ORINA/R Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
106ORPCA/P Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
107ORPDGoods Return148EquVatSumSTotal Equalization Tax (SC)Num196
108ORRRReturn Request148EquVatSumSTotal Equalization Tax (SC)Num196
109OSFCSelf Credit Memo148EquVatSumSTotal Equalization Tax (SC)Num196
110OSFISelf Invoice148EquVatSumSTotal Equalization Tax (SC)Num196
111PCH1A/P Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
112PCH13A/P Invoice Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
113PCH2A/P Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
114PCH3A/P Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
115PDN1Goods Receipt PO - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
116PDN13Goods Receipt PO Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
117PDN2Goods Receipt PO - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
118PDN3Goods Receipt PO - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
119POR1Purchase Order - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
120POR13Purchase Order Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
121POR2Purchase Order - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
122POR3Purchase Order - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
123PQT1Purchase Quotation - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
124PQT13Purchase Quotation Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
125PQT2Purchase Quotation - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
126PQT3Purchase Quotation - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
127PRQ1Purchase Request - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
128PRQ13Purchase Request Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
129PRQ2Purchase Request - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
130PRQ3Purchase Request - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
131PRR1A/P Return Request - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
132PRR13A/P Return Request - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
133PRR2A/P Return Request - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
134PRR3A/P Return Request - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
135QUT1Sales Quotation - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
136QUT13Sales Quotation Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
137QUT2Sales Quotation - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
138QUT3Sales Quotation - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
139RDN1Returns - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
140RDN13Returns Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
141RDN2Return - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
142RDN3Return - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
143RDR1Sales Order - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
144RDR13Sales Order Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
145RDR2Sales Order - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
146RDR3Sales Order - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
147RIN1A/R Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
148RIN13A/R Credit Memo Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
149RIN2A/R Credit Memo - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
150RIN3A/R Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
151RPC1A/P Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
152RPC13A/P Credit Memo Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
153RPC2A/P Credit Memo Rows - Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
154RPC3A/P Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
155RPD1Goods Return - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
156RPD13Goods Returns Rows - Distributed Expenses31EquVatSumSTotal Equalization Tax (SC)Num196
157RPD2Goods Return - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
158RPD3Goods Return - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
159RRR1A/R Return Request - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
160RRR13A/R Return Request - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
161RRR2A/R Return Request - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
162RRR3A/R Return Request - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
163SFC1Self Credit Memo - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
164SFC13Self Credit Memo Rows - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
165SFC2Self Credit Memo - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
166SFC3Self Credit Memo - Freight32EquVatSumSTotal Equalization Tax (SC)Num196
167SFI1Self Invoice - Rows120EquVatSumSTotal Equalization Tax (SC)Num196
168SFI13Self Invoice Rows - Distributed Freights31EquVatSumSTotal Equalization Tax (SC)Num196
169SFI2Self Invoice - Freight - Rows31EquVatSumSTotal Equalization Tax (SC)Num196
170SFI3Self Invoice - Freight32EquVatSumSTotal Equalization Tax (SC)Num196