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

219 columns | Print definition?B1 9.3  | PROJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AEXDFreight Setup35ProjectProjectnVarChar200
2OEXDFreight Setup35ProjectProjectnVarChar200
3PQW1Purchase Quotation Generation: Line Items20ProjectProject CodenVarChar200
TOPBanking
4ABT1Internal Bank Operation Codes - Accounts - Log4ProjectProjectnVarChar200
5ARC4Incoming Payment - Account List - History14ProjectProject CodenVarChar200
6BNK2Bank Statement - Recommendation List11ProjectProjectnVarChar200
7BTC1Internal Bank Operation Codes - Accounts4ProjectProjectnVarChar200
8OCHHCheck Register28ProjectProject CodenVarChar200
9OCRHCredit Card Management38ProjectProject CodenVarChar200
10ODPSDeposit52ProjectProject CodenVarChar200
11ODPTPostdated Deposit28ProjectProject CodenVarChar200
12PDF4Payment Draft - Account List14ProjectProject CodenVarChar200
13RCC4Incoming Payment - Credit Vouchers14ProjectProject CodenVarChar200
14RCT4Incoming Payment - Account List14ProjectProject CodenVarChar200
15VPM4Outgoing Payments - Accounts14ProjectProject CodenVarChar200
TOPBusiness Partners
16AOA1Blanket Agreement - Rows29ProjectProject CodenVarChar200
17AOATBlanket Agreement48ProjectProject CodenVarChar200
18OAT1Blanket Agreement - Rows29ProjectProject CodenVarChar200
19OOATBlanket Agreement48ProjectProject CodenVarChar200
TOPFinance
20AACTG/L Account - History43ProjectProject CodenVarChar200
21ACD1Credit Memo - Rows23ProjectProject CodenVarChar200
22ACQ1Capitalization - Rows23ProjectProject CodenVarChar200
23AFA1Asset Document - Rows23ProjectProject CodenVarChar200
24AJD1Journal Entry - History - Rows27ProjectProject CodenVarChar200
25AJDTJournal Entry - History19ProjectProject CodenVarChar200
26BTF1Journal Voucher - Rows27ProjectProject CodenVarChar200
27FTR1Transfer - Rows23ProjectProject CodenVarChar200
28JDT1Journal Entry - Rows27ProjectProject CodenVarChar200
29MDP1Manual Depreciation - Rows23ProjectProject CodenVarChar200
30OACTG/L Accounts43ProjectProject CodenVarChar200
31OBTFJournal Voucher Entry19ProjectProject CodenVarChar200
32OCFLCash Flow Additional Trans.4ProjectProject CodenVarChar200
33OJDTJournal Entry19ProjectProject CodenVarChar200
34RCR1Recurring Postings - Rows27ProjectProject CodenVarChar200
35RTI1Retirement - Rows23ProjectProject CodenVarChar200
36TRT1Posting Templates - Rows25ProjectProject CodenVarChar200
TOPInventory and Production
37AIT5Asset Item Projects - History5ProjectProjectnVarChar200
38AITTProduct Tree - History23ProjectProject CodenVarChar200
39AMR1Inventory Revaluation - History - Rows23ProjectProject CodenVarChar200
40AQI1Inventory Opening Balance - Rows23ProjectProject CodenVarChar200
41AQR1Inventory Posting - Rows23ProjectProject CodenVarChar200
42ATT1Bill of Materials - Components - History23ProjectProject CodenVarChar200
43AWO1Production Order (Rows) - History19ProjectProject CodenVarChar200
44AWORProduction Order - History40ProjectProject CodenVarChar200
45IGE1Goods Issue - Rows43ProjectProject CodenVarChar200
46IGE13Goods Issue Rows - Distributed Expenses59ProjectProject CodenVarChar200
47IGE2Goods Issue - Freight - Rows51ProjectProject CodenVarChar200
48IGE3Goods Issue - Freight59ProjectProject CodenVarChar200
49IGN1Goods Receipt - Rows43ProjectProject CodenVarChar200
50IGN13Goods Receipt Rows - Distributed Expenses59ProjectProject CodenVarChar200
51IGN2Goods Receipt - Freight - Rows51ProjectProject CodenVarChar200
52IGN3Goods Receipt - Freight59ProjectProject CodenVarChar200
53IOD1Inventory Opening Balance Draft - Rows23ProjectProject CodenVarChar200
54IPD1Inventory Posting Draft - Rows23ProjectProject CodenVarChar200
55IPF1Landed Costs - Rows67ProjectProject CodenVarChar200
56IQI1Inventory Opening Balance - Rows23ProjectProject CodenVarChar200
57IQR1Inventory Posting - Rows23ProjectProject CodenVarChar200
58ITM5Asset Item Projects5ProjectProjectnVarChar200
59ITT1Bill of Materials - Components23ProjectProject CodenVarChar200
60MRV1Inventory Revaluation Information Array23ProjectProject CodenVarChar200
61OIGEGoods Issue136ProjectProject CodenVarChar200
62OIGNGoods Receipt136ProjectProject CodenVarChar200
63OITTProduct Tree23ProjectProject CodenVarChar200
64OMRLAdvanced Inventory Revaluation32ProjectProject CodenVarChar200
65OWORProduction Order40ProjectProject CodenVarChar200
66OWTQInventory Transfer Request136ProjectProject CodenVarChar200
67OWTRInventory Transfer136ProjectProject CodenVarChar200
68UWORProduction Order40ProjectProject CodenVarChar200
69UWOR1Production Order - Rows19ProjectProject CodenVarChar200
70WOR1Production Order - Rows19ProjectProject CodenVarChar200
71WTQ1Inventory Transfer Request - Rows43ProjectProject CodenVarChar200
72WTQ13Inventory Transfer Request Rows - Distributed Freights59ProjectProject CodenVarChar200
73WTQ2Inventory Transfer Request - Freight - Rows51ProjectProject CodenVarChar200
74WTQ3Inventory Transfer Request - Freight59ProjectDrawn TotalnVarChar200
75WTR1Inventory Transfer - Rows43ProjectProject CodenVarChar200
76WTR13Inventory Transfer Rows - Distributed Freights59ProjectProject CodenVarChar200
77WTR2Inventory Transfer - Freight - Rows51ProjectProject CodenVarChar200
78WTR3Inventory Transfer - Freight59ProjectProject CodenVarChar200
TOPMarketing Documents
79ADO1A/R Invoice (Rows) - History43ProjectProject CodenVarChar200
80ADO13A/R Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
81ADO2A/R Invoice - Freight - Rows51ProjectProject CodenVarChar200
82ADO3A/R Invoice - Freight - History59ProjectProject CodenVarChar200
83ADOCInvoice - History136ProjectProject CodenVarChar200
84CIN1Correction Invoice - Rows43ProjectProject CodenVarChar200
85CIN13Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
86CIN2A/R Correction Invoice - Freight - Rows51ProjectProject CodenVarChar200
87CIN3A/R Correction Invoice - Freight59ProjectProject CodenVarChar200
88CPI1A/P Correction Invoice - Rows43ProjectProject CodenVarChar200
89CPI13A/P Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
90CPI2A/P Correction Invoice - Freight - Rows51ProjectProject CodenVarChar200
91CPI3A/P Correction Invoice - Freight59ProjectProject CodenVarChar200
92CPV1A/P Correction Invoice Reversal - Rows43ProjectProject CodenVarChar200
93CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses59ProjectProject CodenVarChar200
94CPV2A/P Correction Invoice Reversal - Freight - Rows51ProjectProject CodenVarChar200
95CPV3A/P Correction Invoice Reversal - Freight59ProjectProject CodenVarChar200
96CSI1A/R Correction Invoice - Rows43ProjectProject CodenVarChar200
97CSI13A/R Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
98CSI2A/R Corr Inv - Freight - Rows51ProjectProject CodenVarChar200
99CSI3A/R Correction Invoice - Freight59ProjectProject CodenVarChar200
100CSV1A/R Correction Invoice Reversal - Rows43ProjectProject CodenVarChar200
101CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses59ProjectProject CodenVarChar200
102CSV2A/R Correction Invoice Reversal - Freight - Rows51ProjectProject CodenVarChar200
103CSV3A/R Correction Invoice Reversal - Freight59ProjectProject CodenVarChar200
104DLN1Delivery - Rows43ProjectProject CodenVarChar200
105DLN13Delivery Rows - Distributed Expenses59ProjectProject CodenVarChar200
106DLN2Delivery Notes - Freight - Rows51ProjectProject CodenVarChar200
107DLN3Delivery Notes - Freight59ProjectProject CodenVarChar200
108DPI1A/R Down Payment - Rows43ProjectProject CodenVarChar200
109DPI13A/R Down Payment Rows - Distributed Expenses59ProjectProject CodenVarChar200
110DPI2A/R Down Payment - Freight - Rows51ProjectProject CodenVarChar200
111DPI3A/R Down Payment - Freight59ProjectProject CodenVarChar200
112DPO1A/P Down Payment - Rows43ProjectProject CodenVarChar200
113DPO13A/P Down Payment Rows - Distributed Expenses59ProjectProject CodenVarChar200
114DPO2A/P Down Payment - Freight - Rows51ProjectProject CodenVarChar200
115DPO3A/P Down Payment - Freight59ProjectProject CodenVarChar200
116DRF1Draft - Rows43ProjectProject CodenVarChar200
117DRF13Draft Rows - Distributed Expenses59ProjectProject CodenVarChar200
118DRF2Draft - Freight - Rows51ProjectProject CodenVarChar200
119DRF3Draft - Freight59ProjectProject CodenVarChar200
120IEI1Incoming Excise Invoice - Rows43ProjectProject CodenVarChar200
121IEI13Incoming Excise Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
122IEI2Incoming Excise Invoice - Freight - History - Rows51ProjectProject CodenVarChar200
123IEI3IEI - Freight59ProjectProject CodenVarChar200
124INV1A/R Invoice - Rows43ProjectProject CodenVarChar200
125INV13A/R Invoice Rows - Distributed Freights59ProjectProject CodenVarChar200
126INV2A/R Invoice - Freight - Rows51ProjectProject CodenVarChar200
127INV3A/R Invoice - Freight59ProjectProject CodenVarChar200
128OCINA/R Correction Invoice136ProjectProject CodenVarChar200
129OCPIA/P Correction Invoice136ProjectProject CodenVarChar200
130OCPVA/P Correction Invoice Reversal136ProjectProject CodenVarChar200
131OCSIA/R Correction Invoice136ProjectProject CodenVarChar200
132OCSVA/R Correction Invoice Reversal136ProjectProject CodenVarChar200
133ODLNDelivery136ProjectProject CodenVarChar200
134ODPIA/R Down Payment136ProjectProject CodenVarChar200
135ODPOA/P Down Payment136ProjectProject CodenVarChar200
136ODRFDrafts136ProjectProject CodenVarChar200
137ODWZDunning Wizard24ProjectProjectnVarChar200
138OEI1Outgoing Excise Invoice - Rows43ProjectProject CodenVarChar200
139OEI13Outgoing Excise Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
140OEI2OEI - Freight Rows51ProjectProject CodenVarChar200
141OEI3OEI - Freight59ProjectProject CodenVarChar200
142OIEIIncoming Excise Invoice136ProjectProject CodenVarChar200
143OINVA/R Invoice136ProjectProject CodenVarChar200
144OOEIOutgoing Excise Invoice136ProjectProject CodenVarChar200
145OPCHA/P Invoice136ProjectProject CodenVarChar200
146OPDNGoods Receipt PO136ProjectProject CodenVarChar200
147OPORPurchase Order136ProjectProject CodenVarChar200
148OPQTPurchase Quotation136ProjectProject CodenVarChar200
149OPRQPurchase Request136ProjectProject CodenVarChar200
150OPRRGoods Return Request136ProjectProject CodenVarChar200
151OQUTSales Quotation136ProjectProject CodenVarChar200
152ORDNReturns136ProjectProject CodenVarChar200
153ORDRSales Order136ProjectProject CodenVarChar200
154ORINA/R Credit Memo136ProjectProject CodenVarChar200
155ORPCA/P Credit Memo136ProjectProject CodenVarChar200
156ORPDGoods Return136ProjectProject CodenVarChar200
157ORRRReturn Request136ProjectProject CodenVarChar200
158OSFCSelf Credit Memo136ProjectProject CodenVarChar200
159OSFISelf Invoice136ProjectProject CodenVarChar200
160PCH1A/P Invoice - Rows43ProjectProject CodenVarChar200
161PCH13A/P Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
162PCH2A/P Invoice - Freight - Rows51ProjectProject CodenVarChar200
163PCH3A/P Invoice - Freight59ProjectProject CodenVarChar200
164PDN1Goods Receipt PO - Rows43ProjectProject CodenVarChar200
165PDN13Goods Receipt PO Rows - Distributed Expenses59ProjectProject CodenVarChar200
166PDN2Goods Receipt PO - Freight - Rows51ProjectProject CodenVarChar200
167PDN3Goods Receipt PO - Freight59ProjectProject CodenVarChar200
168POR1Purchase Order - Rows43ProjectProject CodenVarChar200
169POR13Purchase Order Rows - Distributed Expenses59ProjectProject CodenVarChar200
170POR2Purchase Order - Freight - Rows51ProjectProject CodenVarChar200
171POR3Purchase Order - Freight59ProjectProject CodenVarChar200
172PQT1Purchase Quotation - Rows43ProjectProject CodenVarChar200
173PQT13Purchase Quotation Rows - Distributed Expenses59ProjectProject CodenVarChar200
174PQT2Purchase Quotation - Freight - Rows51ProjectProject CodenVarChar200
175PQT3Purchase Quotation - Freight59ProjectProject CodenVarChar200
176PRQ1Purchase Request - Rows43ProjectProject CodenVarChar200
177PRQ13Purchase Request Rows - Distributed Expenses59ProjectProject CodenVarChar200
178PRQ2Purchase Request - Freight - Rows51ProjectProject CodenVarChar200
179PRQ3Purchase Request - Freight59ProjectProject CodenVarChar200
180PRR1A/P Return Request - Rows43ProjectProject CodenVarChar200
181PRR13A/P Return Request - Distributed Freights59ProjectProject CodenVarChar200
182PRR2A/P Return Request - Freight - Rows51ProjectProject CodenVarChar200
183PRR3A/P Return Request - Freight59ProjectProject CodenVarChar200
184QUT1Sales Quotation - Rows43ProjectProject CodenVarChar200
185QUT13Sales Quotation Rows - Distributed Expenses59ProjectProject CodenVarChar200
186QUT2Sales Quotation - Freight - Rows51ProjectProject CodenVarChar200
187QUT3Sales Quotation - Freight59ProjectProject CodenVarChar200
188RDN1Returns - Rows43ProjectProject CodenVarChar200
189RDN13Returns Rows - Distributed Expenses59ProjectProject CodenVarChar200
190RDN2Return - Freight - Rows51ProjectProject CodenVarChar200
191RDN3Return - Freight59ProjectProject CodenVarChar200
192RDR1Sales Order - Rows43ProjectProject CodenVarChar200
193RDR13Sales Order Rows - Distributed Expenses59ProjectProject CodenVarChar200
194RDR2Sales Order - Freight - Rows51ProjectProject CodenVarChar200
195RDR3Sales Order - Freight59ProjectProject CodenVarChar200
196RIN1A/R Credit Memo - Rows43ProjectProject CodenVarChar200
197RIN13A/R Credit Memo Rows - Distributed Expenses59ProjectProject CodenVarChar200
198RIN2A/R Credit Memo - Freight - Rows51ProjectProject CodenVarChar200
199RIN3A/R Credit Memo - Freight59ProjectProject CodenVarChar200
200RPC1A/P Credit Memo - Rows43ProjectProject CodenVarChar200
201RPC13A/P Credit Memo Rows - Distributed Expenses59ProjectProject CodenVarChar200
202RPC2A/P Credit Memo Rows - Expenses51ProjectProject CodenVarChar200
203RPC3A/P Credit Memo - Freight59ProjectProject CodenVarChar200
204RPD1Goods Return - Rows43ProjectProject CodenVarChar200
205RPD13Goods Returns Rows - Distributed Expenses59ProjectProject CodenVarChar200
206RPD2Goods Return - Freight - Rows51ProjectProject CodenVarChar200
207RPD3Goods Return - Freight59ProjectProject CodenVarChar200
208RRR1A/R Return Request - Rows43ProjectProject CodenVarChar200
209RRR13A/R Return Request - Distributed Freights59ProjectProject CodenVarChar200
210RRR2A/R Return Request - Freight - Rows51ProjectProject CodenVarChar200
211RRR3A/R Return Request - Freight59ProjectProject CodenVarChar200
212SFC1Self Credit Memo - Rows43ProjectProject CodenVarChar200
213SFC13Self Credit Memo Rows - Distributed Freights59ProjectProject CodenVarChar200
214SFC2Self Credit Memo - Freight - Rows51ProjectProject CodenVarChar200
215SFC3Self Credit Memo - Freight59ProjectProject CodenVarChar200
216SFI1Self Invoice - Rows43ProjectProject CodenVarChar200
217SFI13Self Invoice Rows - Distributed Freights59ProjectProject CodenVarChar200
218SFI2Self Invoice - Freight - Rows51ProjectProject CodenVarChar200
219SFI3Self Invoice - Freight59ProjectProject CodenVarChar200