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

281 columns | Print definition?B1 9.3  | QUANTITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBusiness Partners
1AOA2Blanket Agreement - Details9QuantityItem QuantityNum196
2OAT2Blanket Agreement - Details9QuantityItem QuantityNum196
TOPFinance
3ACD1Credit Memo - Rows5QuantityQuantityNum196
4ACQ1Capitalization - Rows5QuantityQuantityNum196
5AFA1Asset Document - Rows5QuantityQuantityNum196
6FTR1Transfer - Rows5QuantityQuantityNum196
7GBI7GBI Row 7 - Accounting Vouchers15QuantityQuantityNum196
8ISW3Declaration Rows11QuantityQuantityNum196
9IWZ3Items Last Revaluation Data15QuantityQuantityNum196
10MDP1Manual Depreciation - Rows5QuantityQuantityNum196
11RTI1Retirement - Rows5QuantityQuantityNum196
TOPGeneral
12OBVLSerial Numbers and Batch Valuation Log19QuantityQuantityNum196
13TCN1Tracking Note - Line Data5QuantityQuantityNum196
14UBVLSerial Numbers and Batch Valuation Log19QuantityQuantityNum196
TOPInventory and Production
15ABTNBatch Numbers Master Data26QuantityQuantityNum196
16AIN11Inventory Counting - Individual Counters - Row SnB9QuantityQuantityNum196
17AIN3Inventory Count - SnB9QuantityQuantityNum196
18AIN7Inventory Counting - Team Counter - Row SnB9QuantityQuantityNum196
19AIT8Asset Item Balances - History6QuantityAsset QuantityNum196
20AMR1Inventory Revaluation - History - Rows5QuantityQuantityNum196
21AMR2Inventory Revaluation FIFO Rows (Archive)4QuantityQuantityNum196
22AQI1Inventory Opening Balance - Rows8QuantityQuantity - DeltaNum196
23AQI2Inventory Opening Balance - SnB9QuantityQuantityNum196
24AQI3Inventory Opening Balance - Tracking Note Assignment - History6QuantityQuantityNum196
25AQR1Inventory Posting - Rows8QuantityQuantity - DeltaNum196
26AQR3Inventory Count - SnB9QuantityQuantityNum196
27AQR4Inventory Opening Balance - Tracking Note Assignment - History6QuantityQuantityNum196
28ASRNSerial Numbers Master Data26QuantityQuantityNum196
29ATT1Bill of Materials - Components - History5QuantityQuantityNum196
30AWO3Production Order - (Closure) - History4QuantityQuantityNum196
31ENT1Entry - Rows9QuantityQuantityNum196
32ICD11Inventory Counting Draft - Individual Counter - Row SnB9QuantityQuantityNum196
33ICD3Inventory Count Draft - SnB9QuantityQuantityNum196
34ICD7Inventory Counting Draft - Team Counter - Row SnB9QuantityQuantityNum196
35IGE1Goods Issue - Rows12QuantityQuantityNum196
36IGE14Goods Issue - Assembly - Rows6QuantityQuantityNum196
37IGE16Goods Issue - SnB properties9QuantityQuantityNum196
38IGE19Goods Issue - Bin Allocation Data8QuantityQuantityNum196
39IGE8Items in Package - Goods Issue4QuantityQuantityNum196
40IGN1Goods Receipt - Rows12QuantityQuantityNum196
41IGN14Goods Receipt - Assembly - Rows6QuantityQuantityNum196
42IGN16Goods Receipt - SnB properties9QuantityQuantityNum196
43IGN19Goods Receipt - Bin Allocation Data8QuantityQuantityNum196
44IGN8Goods Receipt - Items in Package4QuantityQuantityNum196
45ILM1Srl & Batch Det of Inv Log Msg4QuantityQuantityNum196
46ILM3Non-Inventory and Resource Components Log Msg8QuantityQuantityNum196
47INC11Inventory Counting - Individual Counter - Row SnB9QuantityQuantityNum196
48INC3Inventory Count - SnB9QuantityQuantityNum196
49INC7Inventory Counting - Team Counter - Row SnB9QuantityQuantityNum196
50IOD1Inventory Opening Balance Draft - Rows8QuantityQuantity - DeltaNum196
51IOD2Inventory Opening Balance Draft - SnB9QuantityQuantityNum196
52IPD1Inventory Posting Draft - Rows8QuantityQuantity - DeltaNum196
53IPD3Inventory Posting Draft - SnB9QuantityQuantityNum196
54IPF1Landed Costs - Rows7QuantityQuantityNum196
55IQI1Inventory Opening Balance - Rows8QuantityOpening BalanceNum196
56IQI2Inventory Opening Balance - SnB9QuantityQuantityNum196
57IQI3Inventory Opening Balance - Tracking Note Assignment6QuantityQuantityNum196
58IQR1Inventory Posting - Rows8QuantityVarianceNum196
59IQR3Inventory Posting - SnB9QuantityQuantityNum196
60IQR4Inventory Posting - Tracking Note Assignment6QuantityQuantityNum196
61ITL1Srl & Batch Details in Transac4QuantityQuantityNum196
62ITM8Asset Item Balances6QuantityAsset QuantityNum196
63ITT1Bill of Materials - Components5QuantityQuantityNum196
64IVL2Inventory Components for Production11QuantityQuantityNum196
65MRV1Inventory Revaluation Information Array5QuantityQuantityNum196
66MRV2Inventory Revaluation FIFO Rows4QuantityQuantityNum196
67OAIMArchive Inventory Message5QuantityQuantity in DocumentNum196
68OBTLBin Transaction Log5QuantityQuantityNum196
69OBTNBatch Numbers Master Data26QuantityQuantityNum196
70OBTQBatch No. Quantities4QuantityQuantityNum196
71ODBNBat. Nos - Draft - Master Data26QuantityQuantityNum196
72ODSNSNs - Draft - Master Data26QuantityQuantityNum196
73OILMInventory Log Message5QuantityQuantity in DocNum196
74OSRNSerial Numbers Master Data26QuantityQuantityNum196
75OSRQSerial No. Quantities4QuantityQuantityNum196
76OTNLCCD Log4QuantityQuantityNum196
77SIVL2Inventory Components for Production11QuantityQuantityNum196
78UBTNBatch Numbers Master Data26QuantityQuantityNum196
79UILMIVI Inventory Log Message5QuantityQuantity in DocNum196
80UILM1Srl & Batch Det of Inv Log Msg4QuantityQuantityNum196
81UILM3Non-Inventory and Resource Components Log Msg8QuantityQuantityNum196
82UIVL2Inventory Components for Production11QuantityQuantityNum196
83USRNSerial Numbers Master Data26QuantityQuantityNum196
84UWKO1Production Instructions - Rows5QuantityItem QuantityNum196
85UWOR3Production Order - Closure4QuantityQuantityNum196
86WKO1Production Instructions - Rows5QuantityItem QuantityNum196
87WOR3Production Order - Closure4QuantityQuantityNum196
88WTQ1Inventory Transfer Request - Rows12QuantityQuantityNum196
89WTQ14Inventory Transfer Request - Assembly - Rows6QuantityQuantityNum196
90WTQ16Inventory Transfer Request - SnB Properties9QuantityQuantityNum196
91WTQ19Inventory Transfer Request - Bin Allocation Data8QuantityQuantityNum196
92WTQ8Inventory Transfer Request - Items in Package4QuantityQuantityNum196
93WTR1Inventory Transfer - Rows12QuantityQuantityNum196
94WTR14Inventory Transfer - Assembly - Rows6QuantityQuantityNum196
95WTR16Inventory Transfer - SnB properties9QuantityQuantityNum196
96WTR19Inventory Transfer - Bin Allocation Data8QuantityQuantityNum196
97WTR8Inventory Transfer - Items in Package4QuantityQuantityNum196
TOPMarketing Documents
98ADO1A/R Invoice (Rows) - History12QuantityQuantityNum196
99ADO14Invoice - Assembly - Rows - History6QuantityQuantityNum196
100ADO16Draft - SnB properties9QuantityQuantityNum196
101ADO19Bin Allocation Data - History8QuantityQuantityNum196
102ADO24Mktg Docs - Tracking Note Assignment - History6QuantityQuantityNum196
103ADO8Items in Package - History4QuantityQuantityNum196
104CIN1Correction Invoice - Rows12QuantityQuantityNum196
105CIN19Correction Invoice - Bin Allocation Data8QuantityQuantityNum196
106CIN24Correction Invoice - Tracking Note Assignment6QuantityQuantityNum196
107CIN8Items in Package - Correction Invoice4QuantityQuantityNum196
108CPI1A/P Correction Invoice - Rows12QuantityQuantityNum196
109CPI14A/P Correction Invoice - Assembly - Rows6QuantityQuantityNum196
110CPI16A/P Corr. Inv - SnB properties9QuantityQuantityNum196
111CPI19A/P Correction Invoice - Bin Allocation Data8QuantityQuantityNum196
112CPI24A/P Correction Invoice - Tracking Note Assignment6QuantityQuantityNum196
113CPI8A/P Correction Invoice - Items in Package4QuantityQuantityNum196
114CPV1A/P Correction Invoice Reversal - Rows12QuantityQuantityNum196
115CPV14A/P Correction Invoice Reversal - Assembly - Rows6QuantityQuantityNum196
116CPV16A/P Correction Invoice Reversal - SnB properties9QuantityQuantityNum196
117CPV19A/P Correction Invoice Reversal - Bin Allocation Data8QuantityQuantityNum196
118CPV24A/P Correction Invoice Reversal - Tracking Note Assignment6QuantityQuantityNum196
119CPV8A/P Correction Invoice Reversal - Items in Package4QuantityQuantityNum196
120CSI1A/R Correction Invoice - Rows12QuantityQuantityNum196
121CSI14A/R Correction Invoice - Assembly - Rows6QuantityQuantityNum196
122CSI16A/R Corr. Inv. - SnB properties9QuantityQuantityNum196
123CSI19A/R Correction Invoice - Bin Allocation Data8QuantityQuantityNum196
124CSI24A/R Correction Invoice - Tracking Note Assignment6QuantityQuantityNum196
125CSI8A/R Corr. Inv. - Items in Pkg4QuantityQuantityNum196
126CSV1A/R Correction Invoice Reversal - Rows12QuantityQuantityNum196
127CSV14A/R Correction Invoice Reversal - Assembly - Rows6QuantityQuantityNum196
128CSV16A/R Correction Invoice Reversal - SnB properties9QuantityQuantityNum196
129CSV19A/R Correction Invoice Reversal - Bin Allocation Data8QuantityQuantityNum196
130CSV24A/R Correction Invoice Reversal - Tracking Note Assignment6QuantityQuantityNum196
131CSV8A/R Correction Invoice Reversal - Items in Package4QuantityQuantityNum196
132DLN1Delivery - Rows12QuantityQuantityNum196
133DLN14Delivery Notes - Assembly - Rows6QuantityQuantityNum196
134DLN16Delivery - SnB properties9QuantityQuantityNum196
135DLN19Delivery - Bin Allocation Data8QuantityQuantityNum196
136DLN24Delivery - Tracking Note Assignment6QuantityQuantityNum196
137DLN8Items in Package - Delivery4QuantityQuantityNum196
138DOC24Mktg Docs - Tracking Note Assignment6QuantityQuantityNum196
139DPI1A/R Down Payment - Rows12QuantityQuantityNum196
140DPI14A/R Down Payment - Assembly - Rows6QuantityQuantityNum196
141DPI16A/R Down Payment - SnB properties9QuantityQuantityNum196
142DPI19A/R Down Payment - Bin Allocation Data8QuantityQuantityNum196
143DPI24A/R Down Payment - Tracking Note Assignment6QuantityQuantityNum196
144DPI8Items in Package - A/R Down Pmt.4QuantityQuantityNum196
145DPO1A/P Down Payment - Rows12QuantityQuantityNum196
146DPO14A/P Down Payment - Assembly - Rows6QuantityQuantityNum196
147DPO16A/P Down Payment - SnB properties9QuantityQuantityNum196
148DPO19A/P Down Payment - Bin Allocation Data8QuantityQuantityNum196
149DPO24A/P Down Payment - Tracking Note Assignment6QuantityQuantityNum196
150DPO8Items in Package - A/P Down Pmt.4QuantityQuantityNum196
151DRF1Draft - Rows12QuantityQuantityNum196
152DRF14Draft - Assembly - Rows6QuantityQuantityNum196
153DRF16Draft - SnB - Rows9QuantityQuantityNum196
154DRF19Draft - Bin Allocation Data8QuantityQuantityNum196
155DRF24Draft - Tracking Note Assignment6QuantityQuantityNum196
156DRF8Items in Package - Draft4QuantityQuantityNum196
157GPA1Gross Profit Adjustment - Documents14QuantityQuantityNum196
158GTI1GTS Invoice Details7QuantityQuantityNum196
159GTM1GTS Mapping Object Details8QuantityQuantityNum196
160IEI1Incoming Excise Invoice - Rows12QuantityQuantityNum196
161IEI14Incoming Excise Invoice - Assembly - Rows6QuantityQuantityNum196
162IEI16Incoming Excise Invoice - SnB properties9QuantityQuantityNum196
163IEI19Incoming Excise Invoice - Bin Allocation Data8QuantityQuantityNum196
164IEI24Incoming Excise Invoice - Tracking Note Assignment6QuantityQuantityNum196
165IEI8Incoming Excise Invoice - Items in Package4QuantityQuantityNum196
166IGE24Goods Issue - Tracking Note Assignment6QuantityQuantityNum196
167IGN24Goods Receipt - Tracking Note Assignment6QuantityQuantityNum196
168INV1A/R Invoice - Rows12QuantityQuantityNum196
169INV14A/R Invoice - Assembly - Rows6QuantityQuantityNum196
170INV16A/R Invoice - SnB properties9QuantityQuantityNum196
171INV19A/R Invoice - Bin Allocation Data8QuantityQuantityNum196
172INV24A/R Invoice - Tracking Note Assignment6QuantityQuantityNum196
173INV8A/R Invoice - Items in Package4QuantityQuantityNum196
174OEI1Outgoing Excise Invoice - Rows12QuantityQuantityNum196
175OEI14Outgoing Excise Invoice - Assembly - Rows6QuantityQuantityNum196
176OEI16Outgoing Excise Invoice - SnB properties9QuantityQuantityNum196
177OEI19Outgoing Excise Invoice - Bin Allocation Data8QuantityQuantityNum196
178OEI24Outgoing Excise Invoice - Tracking Note Assignment6QuantityQuantityNum196
179OEI8Outgoing Excise Invoice - Items in Package4QuantityQuantityNum196
180PCH1A/P Invoice - Rows12QuantityQuantityNum196
181PCH14A/P Invoice - Assembly - Rows6QuantityQuantityNum196
182PCH16A/P Invoice - SnB properties9QuantityQuantityNum196
183PCH19A/P Invoice - Bin Allocation Data8QuantityQuantityNum196
184PCH24A/P Invoice - Tracking Note Assignment6QuantityQuantityNum196
185PCH8A/P Invoice - Items in Package4QuantityQuantityNum196
186PDN1Goods Receipt PO - Rows12QuantityQuantityNum196
187PDN14Goods Receipt PO - Assembly - Rows6QuantityQuantityNum196
188PDN16Goods Receipt PO - SnB properties9QuantityQuantityNum196
189PDN19Goods Receipt PO - Bin Allocation Data8QuantityQuantityNum196
190PDN24Goods Receipt PO - Tracking Note Assignment6QuantityQuantityNum196
191PDN8Goods Receipt PO - Items in Package4QuantityQuantityNum196
192POR1Purchase Order - Rows12QuantityQuantityNum196
193POR14Purchase Order - Assembly - Rows6QuantityQuantityNum196
194POR16Purchase Order - SnB properties9QuantityQuantityNum196
195POR19Purchase Order - Bin Allocation Data8QuantityQuantityNum196
196POR24Purchase Order - Tracking Note Assignment6QuantityQuantityNum196
197POR8Items in Package - Purchase Order4QuantityQuantityNum196
198PQT1Purchase Quotation - Rows12QuantityQuantityNum196
199PQT14Purchase Quotation - Assembly - Rows6QuantityQuantityNum196
200PQT16Purchase Quotation - SnB properties9QuantityQuantityNum196
201PQT19Purchase Quotation - Bin Allocation Data8QuantityQuantityNum196
202PQT24Purchase Quotation - Tracking Note Assignment6QuantityQuantityNum196
203PQT8Items in Package - Purchase Quotation4QuantityQuantityNum196
204PRQ1Purchase Request - Rows12QuantityQuantityNum196
205PRQ14Purchase Request - Assembly - Rows6QuantityQuantityNum196
206PRQ16Purchase Request - SnB Properties9QuantityQuantityNum196
207PRQ19Purchase Request - Bin Allocation Data8QuantityQuantityNum196
208PRQ24Purchase Request - Tracking Note Assignment6QuantityQuantityNum196
209PRQ8Items in Package - Purchase Request4QuantityQuantityNum196
210PRR1A/P Return Request - Rows12QuantityQuantityNum196
211PRR14A/P Return Request - Assembly - Rows6QuantityQuantityNum196
212PRR16A/P Return Request - SnB properties9QuantityQuantityNum196
213PRR19A/P Return Request - Bin Allocation Data8QuantityQuantityNum196
214PRR24Goods Return Request - Tracking Note Assignment6QuantityQuantityNum196
215PRR8A/P Return Request - Items in Package4QuantityQuantityNum196
216QUT1Sales Quotation - Rows12QuantityQuantityNum196
217QUT14Sales Quotation - Assembly - Rows6QuantityQuantityNum196
218QUT16Sales Quotation - SnB properties9QuantityQuantityNum196
219QUT19Sales Quotation - Bin Allocation Data8QuantityQuantityNum196
220QUT24Sales Quotation - Tracking Note Assignment6QuantityQuantityNum196
221QUT8Sales Quotation - Items in Package4QuantityQuantityNum196
222RDN1Returns - Rows12QuantityQuantityNum196
223RDN14Return - Assembly - Rows6QuantityQuantityNum196
224RDN16Returns - SnB properties9QuantityQuantityNum196
225RDN19Returns - Bin Allocation Data8QuantityQuantityNum196
226RDN24Returns - Tracking Note Assignment6QuantityQuantityNum196
227RDN8Returns - Items in Package4QuantityQuantityNum196
228RDR1Sales Order - Rows12QuantityQuantityNum196
229RDR14Sales Order - Assembly - Rows6QuantityQuantityNum196
230RDR16Sales Order - SnB properties9QuantityQuantityNum196
231RDR19Sales Order - Bin Allocation Data8QuantityQuantityNum196
232RDR24Sales Order - Tracking Note Assignment6QuantityQuantityNum196
233RDR8Sales Order - Items in Package4QuantityQuantityNum196
234RIN1A/R Credit Memo - Rows12QuantityQuantityNum196
235RIN14A/R Credit Memo - Assembly - Rows6QuantityQuantityNum196
236RIN16A/R Credit Memo - SnB properties9QuantityQuantityNum196
237RIN19A/R Credit Memo - Bin Allocation Data8QuantityQuantityNum196
238RIN24A/R Credit Memo - Tracking Note Assignment6QuantityQuantityNum196
239RIN8Items in Package - A/R Credit Memo4QuantityQuantityNum196
240RPC1A/P Credit Memo - Rows12QuantityQuantityNum196
241RPC14A/P Credit Memo - Assembly - Rows6QuantityQuantityNum196
242RPC16A/P Credit Memo - SnB properties9QuantityQuantityNum196
243RPC19A/P Credit Memo - Bin Allocation Data8QuantityQuantityNum196
244RPC24A/P Credit Memo - Tracking Note Assignment6QuantityQuantityNum196
245RPC8Items in Package - A/P Credit Memo4QuantityQuantityNum196
246RPD1Goods Return - Rows12QuantityQuantityNum196
247RPD14Goods Return - Assembly - Rows6QuantityQuantityNum196
248RPD16Goods Return - SnB properties9QuantityQuantityNum196
249RPD19Goods Return - Bin Allocation Data8QuantityQuantityNum196
250RPD24Goods Return - Tracking Note Assignment6QuantityQuantityNum196
251RPD8Goods Return - Items in Package4QuantityQuantityNum196
252RRR1A/R Return Request - Rows12QuantityQuantityNum196
253RRR14A/R Return Request - Assembly - Rows6QuantityQuantityNum196
254RRR16A/R Return Request - SnB properties9QuantityQuantityNum196
255RRR19A/R Return Request - Bin Allocation Data8QuantityQuantityNum196
256RRR24Return Request - Tracking Note Assignment6QuantityQuantityNum196
257RRR8A/R Return Request - Items in Package4QuantityQuantityNum196
258SAL1Salida - Rows9QuantityQuantityNum196
259SFC1Self Credit Memo - Rows12QuantityQuantityNum196
260SFC14Self Credit Memo - Assembly - Rows6QuantityQuantityNum196
261SFC16Self Credit Memo - SnB properties9QuantityQuantityNum196
262SFC19Self Credit Memo - Bin Allocation Data8QuantityQuantityNum196
263SFC24Self Credit Memo - Tracking Note Assignment6QuantityQuantityNum196
264SFC8Self Credit Memo - Items in Package4QuantityQuantityNum196
265SFI1Self Invoice - Rows12QuantityQuantityNum196
266SFI14Self Invoice - Assembly - Rows6QuantityQuantityNum196
267SFI16Self Invoice - SnB properties9QuantityQuantityNum196
268SFI19Self Invoice - Bin Allocation Data8QuantityQuantityNum196
269SFI24Self Invoice - Tracking Note Assignment6QuantityQuantityNum196
270SFI8Self Invoice - Items in Package4QuantityQuantityNum196
271TRA1Transition - Rows9QuantityQuantityNum196
272VRT1Tax Invoice Report - Rows6QuantityQuantityNum196
273VRT2Tax Invoice Report Grid Info21QuantityQuantityNum196
274WTQ24Inventory Transfer Request - Tracking Note Assignment6QuantityQuantityNum196
275WTR24Inventory Transfer - Tracking Note Assignment6QuantityQuantityNum196
TOPMRP
276FCT1Sales Forecast - Rows5QuantityQuantityNum196
277MSN3MRP Pegging Information4QuantityQuantityNum196
278ORCMRecommendation Data7QuantityQuantityNum196
TOPReports
279SOI5Statement of Import - Lines10QuantityQuantityNum196
TOPService
280ASC3Service Call Travel/Labor Expenses - History7QuantityQuantityNum196
281SCL3Service Call Travel/Labor Expenses7QuantityQuantityNum196