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
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

195 columns | Print definition?B1 9.2  | 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
TOPFinance
16AACTG/L Account - History43ProjectProject CodenVarChar200
17ACD1Credit Memo - Rows23ProjectProject CodenVarChar200
18ACQ1Capitalization - Rows23ProjectProject CodenVarChar200
19AFA1Asset Document - Rows23ProjectProject CodenVarChar200
20AJD1Journal Entry - History - Rows27ProjectProject CodenVarChar200
21AJDTJournal Entry - History19ProjectProject CodenVarChar200
22BTF1Journal Voucher - Rows27ProjectProject CodenVarChar200
23FTR1Transfer - Rows23ProjectProject CodenVarChar200
24JDT1Journal Entry - Rows27ProjectProject CodenVarChar200
25MDP1Manual Depreciation - Rows23ProjectProject CodenVarChar200
26OACTG/L Accounts43ProjectProject CodenVarChar200
27OBTFJournal Voucher Entry19ProjectProject CodenVarChar200
28OCFLCash Flow Additional Trans.4ProjectProject CodenVarChar200
29OJDTJournal Entry19ProjectProject CodenVarChar200
30RCR1Recurring Postings - Rows27ProjectProject CodenVarChar200
31RTI1Retirement - Rows23ProjectProject CodenVarChar200
32TRT1Posting Templates - Rows25ProjectProject CodenVarChar200
TOPInventory and Production
33AIT5Asset Item Projects - History5ProjectProjectnVarChar200
34AITTProduct Tree - History24ProjectProject CodenVarChar200
35AMR1Inventory Revaluation - History - Rows23ProjectProject CodenVarChar200
36AQI1Inventory Opening Balance - Rows23ProjectProject CodenVarChar200
37AQR1Inventory Posting - Rows23ProjectProject CodenVarChar200
38ATT1Bill of Materials - Components - History22ProjectProject CodenVarChar200
39AWO1Production Order (Rows) - History20ProjectProject CodenVarChar200
40AWORProduction Order - History41ProjectProject CodenVarChar200
41IGE1Goods Issue - Rows43ProjectProject CodenVarChar200
42IGE13Goods Issue Rows - Distributed Expenses59ProjectProject CodenVarChar200
43IGE2Goods Issue - Freight - Rows51ProjectProject CodenVarChar200
44IGE3Goods Issue - Freight59ProjectProject CodenVarChar200
45IGN1Goods Receipt - Rows43ProjectProject CodenVarChar200
46IGN13Goods Receipt Rows - Distributed Expenses59ProjectProject CodenVarChar200
47IGN2Goods Receipt - Freight - Rows51ProjectProject CodenVarChar200
48IGN3Goods Receipt - Freight59ProjectProject CodenVarChar200
49IOD1Inventory Opening Balance Draft - Rows23ProjectProject CodenVarChar200
50IPD1Inventory Posting Draft - Rows23ProjectProject CodenVarChar200
51IPF1Landed Costs - Rows67ProjectProject CodenVarChar200
52IQI1Inventory Opening Balance - Rows23ProjectProject CodenVarChar200
53IQR1Inventory Posting - Rows23ProjectProject CodenVarChar200
54ITM5Asset Item Projects5ProjectProjectnVarChar200
55ITT1Bill of Materials - Components22ProjectProject CodenVarChar200
56MRV1Inventory Revaluation Information Array23ProjectProject CodenVarChar200
57OIGEGoods Issue136ProjectProject CodenVarChar200
58OIGNGoods Receipt136ProjectProject CodenVarChar200
59OITTProduct Tree24ProjectProject CodenVarChar200
60OMRLAdvanced Inventory Revaluation32ProjectProject CodenVarChar200
61OWORProduction Order41ProjectProject CodenVarChar200
62OWTQInventory Transfer Request136ProjectProject CodenVarChar200
63OWTRInventory Transfer136ProjectProject CodenVarChar200
64UWORProduction Order41ProjectProject CodenVarChar200
65UWOR1Production Order - Rows20ProjectProject CodenVarChar200
66WOR1Production Order - Rows20ProjectProject CodenVarChar200
67WTQ1Inventory Transfer Request - Rows43ProjectProject CodenVarChar200
68WTQ13Inventory Transfer Request Rows - Distributed Freights59ProjectProject CodenVarChar200
69WTQ2Inventory Transfer Request - Freight - Rows51ProjectProject CodenVarChar200
70WTQ3Inventory Transfer Request - Freight59ProjectDrawn TotalnVarChar200
71WTR1Inventory Transfer - Rows43ProjectProject CodenVarChar200
72WTR13Inventory Transfer Rows - Distributed Freights59ProjectProject CodenVarChar200
73WTR2Inventory Transfer - Freight - Rows51ProjectProject CodenVarChar200
74WTR3Inventory Transfer - Freight59ProjectProject CodenVarChar200
TOPMarketing Documents
75ADO1A/R Invoice (Rows) - History43ProjectProject CodenVarChar200
76ADO13A/R Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
77ADO2A/R Invoice - Freight - Rows51ProjectProject CodenVarChar200
78ADO3A/R Invoice - Freight - History59ProjectProject CodenVarChar200
79ADOCInvoice - History136ProjectProject CodenVarChar200
80CIN1Correction Invoice - Rows43ProjectProject CodenVarChar200
81CIN13Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
82CIN2A/R Correction Invoice - Freight - Rows51ProjectProject CodenVarChar200
83CIN3A/R Correction Invoice - Freight59ProjectProject CodenVarChar200
84CPI1A/P Correction Invoice - Rows43ProjectProject CodenVarChar200
85CPI13A/P Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
86CPI2A/P Correction Invoice - Freight - Rows51ProjectProject CodenVarChar200
87CPI3A/P Correction Invoice - Freight59ProjectProject CodenVarChar200
88CPV1A/P Correction Invoice Reversal - Rows43ProjectProject CodenVarChar200
89CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses59ProjectProject CodenVarChar200
90CPV2A/P Correction Invoice Reversal - Freight - Rows51ProjectProject CodenVarChar200
91CPV3A/P Correction Invoice Reversal - Freight59ProjectProject CodenVarChar200
92CSI1A/R Correction Invoice - Rows43ProjectProject CodenVarChar200
93CSI13A/R Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
94CSI2A/R Corr Inv - Freight - Rows51ProjectProject CodenVarChar200
95CSI3A/R Correction Invoice - Freight59ProjectProject CodenVarChar200
96CSV1A/R Correction Invoice Reversal - Rows43ProjectProject CodenVarChar200
97CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses59ProjectProject CodenVarChar200
98CSV2A/R Correction Invoice Reversal - Freight - Rows51ProjectProject CodenVarChar200
99CSV3A/R Correction Invoice Reversal - Freight59ProjectProject CodenVarChar200
100DLN1Delivery - Rows43ProjectProject CodenVarChar200
101DLN13Delivery Rows - Distributed Expenses59ProjectProject CodenVarChar200
102DLN2Delivery Notes - Freight - Rows51ProjectProject CodenVarChar200
103DLN3Delivery Notes - Freight59ProjectProject CodenVarChar200
104DPI1A/R Down Payment - Rows43ProjectProject CodenVarChar200
105DPI13A/R Down Payment Rows - Distributed Expenses59ProjectProject CodenVarChar200
106DPI2A/R Down Payment - Freight - Rows51ProjectProject CodenVarChar200
107DPI3A/R Down Payment - Freight59ProjectProject CodenVarChar200
108DPO1A/P Down Payment - Rows43ProjectProject CodenVarChar200
109DPO13A/P Down Payment Rows - Distributed Expenses59ProjectProject CodenVarChar200
110DPO2A/P Down Payment - Freight - Rows51ProjectProject CodenVarChar200
111DPO3A/P Down Payment - Freight59ProjectProject CodenVarChar200
112DRF1Draft - Rows43ProjectProject CodenVarChar200
113DRF13Draft Rows - Distributed Expenses59ProjectProject CodenVarChar200
114DRF2Draft - Freight - Rows51ProjectProject CodenVarChar200
115DRF3Draft - Freight59ProjectProject CodenVarChar200
116IEI1Incoming Excise Invoice - Rows43ProjectProject CodenVarChar200
117IEI13Incoming Excise Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
118IEI2Incoming Excise Invoice - Freight - History - Rows51ProjectProject CodenVarChar200
119IEI3IEI - Freight59ProjectProject CodenVarChar200
120INV1A/R Invoice - Rows43ProjectProject CodenVarChar200
121INV13A/R Invoice Rows - Distributed Freights59ProjectProject CodenVarChar200
122INV2A/R Invoice - Freight - Rows51ProjectProject CodenVarChar200
123INV3A/R Invoice - Freight59ProjectProject CodenVarChar200
124OCINA/R Correction Invoice136ProjectProject CodenVarChar200
125OCPIA/P Correction Invoice136ProjectProject CodenVarChar200
126OCPVA/P Correction Invoice Reversal136ProjectProject CodenVarChar200
127OCSIA/R Correction Invoice136ProjectProject CodenVarChar200
128OCSVA/R Correction Invoice Reversal136ProjectProject CodenVarChar200
129ODLNDelivery136ProjectProject CodenVarChar200
130ODPIA/R Down Payment136ProjectProject CodenVarChar200
131ODPOA/P Down Payment136ProjectProject CodenVarChar200
132ODRFDrafts136ProjectProject CodenVarChar200
133ODWZDunning Wizard24ProjectProjectnVarChar200
134OEI1Outgoing Excise Invoice - Rows43ProjectProject CodenVarChar200
135OEI13Outgoing Excise Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
136OEI2OEI - Freight Rows51ProjectProject CodenVarChar200
137OEI3OEI - Freight59ProjectProject CodenVarChar200
138OIEIIncoming Excise Invoice136ProjectProject CodenVarChar200
139OINVA/R Invoice136ProjectProject CodenVarChar200
140OOEIOutgoing Excise Invoice136ProjectProject CodenVarChar200
141OPCHA/P Invoice136ProjectProject CodenVarChar200
142OPDNGoods Receipt PO136ProjectProject CodenVarChar200
143OPORPurchase Order136ProjectProject CodenVarChar200
144OPQTPurchase Quotation136ProjectProject CodenVarChar200
145OPRQPurchase Request136ProjectProject CodenVarChar200
146OQUTSales Quotation136ProjectProject CodenVarChar200
147ORDNReturns136ProjectProject CodenVarChar200
148ORDRSales Order136ProjectProject CodenVarChar200
149ORINA/R Credit Memo136ProjectProject CodenVarChar200
150ORPCA/P Credit Memo136ProjectProject CodenVarChar200
151ORPDGoods Return136ProjectProject CodenVarChar200
152PCH1A/P Invoice - Rows43ProjectProject CodenVarChar200
153PCH13A/P Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
154PCH2A/P Invoice - Freight - Rows51ProjectProject CodenVarChar200
155PCH3A/P Invoice - Freight59ProjectProject CodenVarChar200
156PDN1Goods Receipt PO - Rows43ProjectProject CodenVarChar200
157PDN13Goods Receipt PO Rows - Distributed Expenses59ProjectProject CodenVarChar200
158PDN2Goods Receipt PO - Freight - Rows51ProjectProject CodenVarChar200
159PDN3Goods Receipt PO - Freight59ProjectProject CodenVarChar200
160POR1Purchase Order - Rows43ProjectProject CodenVarChar200
161POR13Purchase Order Rows - Distributed Expenses59ProjectProject CodenVarChar200
162POR2Purchase Order - Freight - Rows51ProjectProject CodenVarChar200
163POR3Purchase Order - Freight59ProjectProject CodenVarChar200
164PQT1Purchase Quotation - Rows43ProjectProject CodenVarChar200
165PQT13Purchase Quotation Rows - Distributed Expenses59ProjectProject CodenVarChar200
166PQT2Purchase Quotation - Freight - Rows51ProjectProject CodenVarChar200
167PQT3Purchase Quotation - Freight59ProjectProject CodenVarChar200
168PRQ1Purchase Request - Rows43ProjectProject CodenVarChar200
169PRQ13Purchase Request Rows - Distributed Expenses59ProjectProject CodenVarChar200
170PRQ2Purchase Request - Freight - Rows51ProjectProject CodenVarChar200
171PRQ3Purchase Request - Freight59ProjectProject CodenVarChar200
172QUT1Sales Quotation - Rows43ProjectProject CodenVarChar200
173QUT13Sales Quotation Rows - Distributed Expenses59ProjectProject CodenVarChar200
174QUT2Sales Quotation - Freight - Rows51ProjectProject CodenVarChar200
175QUT3Sales Quotation - Freight59ProjectProject CodenVarChar200
176RDN1Returns - Rows43ProjectProject CodenVarChar200
177RDN13Returns Rows - Distributed Expenses59ProjectProject CodenVarChar200
178RDN2Return - Freight - Rows51ProjectProject CodenVarChar200
179RDN3Return - Freight59ProjectProject CodenVarChar200
180RDR1Sales Order - Rows43ProjectProject CodenVarChar200
181RDR13Sales Order Rows - Distributed Expenses59ProjectProject CodenVarChar200
182RDR2Sales Order - Freight - Rows51ProjectProject CodenVarChar200
183RDR3Sales Order - Freight59ProjectProject CodenVarChar200
184RIN1A/R Credit Memo - Rows43ProjectProject CodenVarChar200
185RIN13A/R Credit Memo Rows - Distributed Expenses59ProjectProject CodenVarChar200
186RIN2A/R Credit Memo - Freight - Rows51ProjectProject CodenVarChar200
187RIN3A/R Credit Memo - Freight59ProjectProject CodenVarChar200
188RPC1A/P Credit Memo - Rows43ProjectProject CodenVarChar200
189RPC13A/P Credit Memo Rows - Distributed Expenses59ProjectProject CodenVarChar200
190RPC2A/P Credit Memo Rows - Expenses51ProjectProject CodenVarChar200
191RPC3A/P Credit Memo - Freight59ProjectProject CodenVarChar200
192RPD1Goods Return - Rows43ProjectProject CodenVarChar200
193RPD13Goods Returns Rows - Distributed Expenses59ProjectProject CodenVarChar200
194RPD2Goods Return - Freight - Rows51ProjectProject CodenVarChar200
195RPD3Goods Return - Freight59ProjectProject CodenVarChar200