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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OPCH268A/P Invoice
5OVPM154Outgoing Payments
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

198 columns | Print definition?B1 8.82  | ITEMCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DADBData Archive DSA Balance2ItemCodeItem NumbernVarChar200
2OSRLSerial Numbers1ItemCodeItem No.nVarChar200
3PQW1Purchase Quotation Generation: Line Items3ItemCodeItem No.nVarChar200
4TRN1Subtable of OTRN3ItemCodeItem CodenVarChar2540
TOPBusiness Partners
5ACP2Campaign - Items3ItemCodeItem No.nVarChar200
6AOA1Blanket Agreement - Rows3ItemCodeItem No.nVarChar200
7CPN2Campaign - Items3ItemCodeItem No.nVarChar200
8OAT1Blanket Agreement - Rows3ItemCodeItem No.nVarChar200
9OSCNCustomer/Vendor Cat. No.1ItemCodeItem No.nVarChar200
TOPFinance
10IWZ3Items Last Revaluation Data2ItemCodeItem NumbernVarChar200
TOPInventory and Production
11ABTNBatch Numbers Master Data1ItemCodeItem No.nVarChar200
12ABTWBatch Attributes in Location1ItemCodeItem CodenVarChar200
13AIT1Item - Prices - History1ItemCodeItem NumbernVarChar200
14AIT2Items - Multiple Preferred Vendors - History1ItemCodeItem No.nVarChar200
15AITMItems - History1ItemCodeItem NumbernVarChar200
16AITWItems - Warehouse - History1ItemCodeItem No.nVarChar200
17AMR1Inventory Revaluation - History - Rows3ItemCodeItem CodenVarChar200
18ASRNSerial Numbers Master Data1ItemCodeItem No.nVarChar200
19AWO1Production Order (Rows) - History3ItemCodeItem No.nVarChar200
20AWORProduction Order - History4ItemCodeProduct No.nVarChar200
21ENT1Entry - Rows13ItemCodeItem No.nVarChar200
22IGE1Goods Issue - Rows10ItemCodeItem No.nVarChar200
23IGE14Goods Issue - Assembly - Rows4ItemCodeItem no.nVarChar200
24IGE16Goods Issue - SnB properties4ItemCodeItem CodenVarChar200
25IGE8Items in Package - Goods Issue3ItemCodeItem CodenVarChar200
26IGN1Goods Receipt - Rows10ItemCodeItem No.nVarChar200
27IGN14Goods Receipt - Assembly - Rows4ItemCodeItem no.nVarChar200
28IGN16Goods Receipt - SnB properties4ItemCodeItem CodenVarChar200
29IGN8Goods Receipt - Items in Package3ItemCodeItem CodenVarChar200
30ILM1Srl & Batch Det of Inv Log Msg2ItemCodeItem CodenVarChar200
31IPF1Landed Costs - Rows5ItemCodeItem No.nVarChar200
32IQI1Inventory Initial Qty Rows3ItemCodeItem No.nVarChar200
33IQR1Inventory Stock Posting (Reconcile) Lines3ItemCodeItem No.nVarChar200
34ITL1Srl & Batch Details in Transac2ItemCodeItem CodenVarChar200
35ITM1Items - Prices1ItemCodeItem No.nVarChar200
36ITM2Items - Multiple Preferred Vendors1ItemCodeItem No.nVarChar200
37ITW1Item Count Alert1ItemCodeItem No.nVarChar200
38MRV1Inventory Revaluation Information Array3ItemCodeItem CodenVarChar200
39OAIMArchive Inventory Message18ItemCodeItem CodenVarChar200
40OBTNBatch Numbers Master Data1ItemCodeItem No.nVarChar200
41OBTQBatch No. Quantities1ItemCodeItem CodenVarChar200
42OBTWBatch Attributes in Location1ItemCodeItem CodenVarChar200
43ODBNBat. Nos - Draft - Master Data1ItemCodeItem No.nVarChar200
44ODBWBatch Draft Attribs in Locat.1ItemCodeItem CodenVarChar200
45ODSNSNs - Draft - Master Data1ItemCodeItem No.nVarChar200
46ODSWSN Draft Attribs in Location1ItemCodeItem CodenVarChar200
47OIBTBatch No. for Item1ItemCodeItem No.nVarChar200
48OILMInventory Log Message22ItemCodeItem CodenVarChar200
49OINMWhse Journal15ItemCodeItem No.nVarChar200
50OITLInventory Transactions Log3ItemCodeItem CodenVarChar200
51OITMItems1ItemCodeItem No.nVarChar200
52OITWItems - Warehouse1ItemCodeItem No.nVarChar200
53OIVEFIFO Based Sales Return11ItemCodeItem CodenVarChar200
54OIVLWhse Journal7ItemCodeItem No.nVarChar200
55OIVQFIFO Queue Working Table9ItemCodeItem CodenVarChar200
56OSPPSpecial Prices1ItemCodeItem No.nVarChar200
57OSRISerial Numbers for Items1ItemCodeItem No.nVarChar200
58OSRNSerial Numbers Master Data1ItemCodeItem No.nVarChar200
59OSRQSerial No. Quantities1ItemCodeItem CodenVarChar200
60OSRWSerial No. Attribs in Location1ItemCodeItem CodenVarChar200
61OWORProduction Order4ItemCodeProduct No.nVarChar200
62SITMItems1ItemCodeItem No.nVarChar200
63SITWItems - Warehouse1ItemCodeItem No.nVarChar200
64SIVEFIFO Based Sales Return11ItemCodeItem CodenVarChar200
65SIVLWhse Journal7ItemCodeItem No.nVarChar200
66SIVQFIFO Queue Working Table9ItemCodeItem CodenVarChar200
67SPP1Special Prices - Data Areas1ItemCodeItem No.nVarChar200
68SPP2Special Prices - Quantity Areas1ItemCodeItem No.nVarChar200
69UILMIVI Inventory Log Message22ItemCodeItem CodenVarChar200
70UILM1Srl & Batch Det of Inv Log Msg2ItemCodeItem CodenVarChar200
71UITMItems1ItemCodeItem No.nVarChar200
72UITWItems - Warehouse1ItemCodeItem No.nVarChar200
73UIVEFIFO Based Sales Return11ItemCodeItem CodenVarChar200
74UIVLWhse Journal7ItemCodeItem No.nVarChar200
75UIVQFIFO Queue Working Table9ItemCodeItem CodenVarChar200
76UWKO1Production Instructions - Rows3ItemCodeItem No.nVarChar200
77UWORProduction Order4ItemCodeProduct No.nVarChar200
78UWOR1Production Order - Rows3ItemCodeItem No.nVarChar200
79WKO1Production Instructions - Rows3ItemCodeItem No.nVarChar200
80WOR1Production Order - Rows3ItemCodeItem No.nVarChar200
81WTQ1Inventory Transfer Request - Rows10ItemCodeItem No.nVarChar200
82WTQ14Inventory Transfer Request - Assembly - Rows4ItemCodeItem No.nVarChar200
83WTQ16Inventory Transfer Request - SnB Properties4ItemCodeItem CodenVarChar200
84WTQ8Inventory Transfer Request - Items in Package3ItemCodeItem CodenVarChar200
85WTR1Inventory Transfer - Rows10ItemCodeItem CodenVarChar200
86WTR14Inventory Transfer - Assembly - Rows4ItemCodeItem no.nVarChar200
87WTR16Inventory Transfer - SnB properties4ItemCodeItem CodenVarChar200
88WTR8Inventory Transfer - Items in Package3ItemCodeItem CodenVarChar200
TOPMarketing Documents
89ADO1A/R Invoice (Rows) - History10ItemCodeItem No.nVarChar200
90ADO14Invoice - Assembly - Rows - History4ItemCodeItem no.nVarChar200
91ADO16Draft - SnB properties4ItemCodeItem CodenVarChar200
92ADO8Items in Package - History3ItemCodeItem CodenVarChar200
93CIN1Correction Invoice - Rows10ItemCodeItem No.nVarChar200
94CIN8Items in Package - Correction Invoice3ItemCodeItem CodenVarChar200
95CPI1A/P Correction Invoice - Rows10ItemCodeItem No.nVarChar200
96CPI14A/P Correction Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
97CPI16A/P Corr. Inv - SnB properties4ItemCodeItem CodenVarChar200
98CPI8A/P Correction Invoice - Items in Package3ItemCodeItem CodenVarChar200
99CPV1A/P Correction Invoice Reversal - Rows10ItemCodeItem No.nVarChar200
100CPV14A/P Correction Invoice Reversal - Assembly - Rows4ItemCodeItem no.nVarChar200
101CPV16A/P Correction Invoice Reversal - SnB properties4ItemCodeItem CodenVarChar200
102CPV8A/P Correction Invoice Reversal - Items in Package3ItemCodeItem NumbernVarChar200
103CSI1A/R Correction Invoice - Rows10ItemCodeItem No.nVarChar200
104CSI14A/R Correction Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
105CSI16A/R Corr. Inv. - SnB properties4ItemCodeItem CodenVarChar200
106CSI8A/R Corr. Inv. - Items in Pkg3ItemCodeItem CodenVarChar200
107CSV1A/R Correction Invoice Reversal - Rows10ItemCodeItem No.nVarChar200
108CSV14A/R Correction Invoice Reversal - Assembly - Rows4ItemCodeItem no.nVarChar200
109CSV16A/R Correction Invoice Reversal - SnB properties4ItemCodeItem CodenVarChar200
110CSV8A/R Correction Invoice Reversal - Items in Package3ItemCodeItem NumbernVarChar200
111DLN1Delivery - Rows10ItemCodeItem No.nVarChar200
112DLN14Delivery Notes - Assembly - Rows4ItemCodeItem no.nVarChar200
113DLN16Delivery - SnB properties4ItemCodeItem CodenVarChar200
114DLN8Items in Package - Delivery3ItemCodeItem NumbernVarChar200
115DPI1A/R Down Payment - Rows10ItemCodeItem No.nVarChar200
116DPI14A/R Down Payment - Assembly - Rows4ItemCodeItem no.nVarChar200
117DPI16A/R Down Payment - SnB properties4ItemCodeItem CodenVarChar200
118DPI8Items in Package - A/R Down Pmt.3ItemCodeItem CodenVarChar200
119DPO1A/P Down Payment - Rows10ItemCodeItem No.nVarChar200
120DPO14A/P Down Payment - Assembly - Rows4ItemCodeItem no.nVarChar200
121DPO16A/P Down Payment - SnB properties4ItemCodeItem CodenVarChar200
122DPO8Items in Package - A/P Down Pmt.3ItemCodeItem CodenVarChar200
123DRF1Draft - Rows10ItemCodeItem No.nVarChar200
124DRF14Draft - Assembly - Rows4ItemCodeItem no.nVarChar200
125DRF16Draft - SnB - Rows4ItemCodeItem CodenVarChar200
126DRF8Items in Package - Draft3ItemCodeItem CodenVarChar200
127GTM1GTS Mapping Object Details3ItemCodeItem CodenVarChar200
128IEI1Incoming Excise Invoice - Rows10ItemCodeItem No.nVarChar200
129IEI14Incoming Excise Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
130IEI16Incoming Excise Invoice - SnB properties4ItemCodeItem CodenVarChar200
131IEI8Incoming Excise Invoice - Items in Package3ItemCodeItem CodenVarChar200
132INV1A/R Invoice - Rows10ItemCodeItem No.nVarChar200
133INV14A/R Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
134INV16A/R Invoice - SnB properties4ItemCodeItem CodenVarChar200
135INV8A/R Invoice - Items in Package3ItemCodeItem CodenVarChar200
136MIN2Item Imformation of MI6ItemCodeItem No.nVarChar200
137MIV2A/P Monthly Invoice - Item6ItemCodeItem No.nVarChar200
138OEI1Outgoing Excise Invoice - Rows10ItemCodeItem No.nVarChar200
139OEI14Outgoing Excise Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
140OEI16Outgoing Excise Invoice - SnB properties4ItemCodeItem CodenVarChar200
141OEI8Outgoing Excise Invoice - Items in Package3ItemCodeItem CodenVarChar200
142PCH1A/P Invoice - Rows10ItemCodeItem No.nVarChar200
143PCH14A/P Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
144PCH16A/P Invoice - SnB properties4ItemCodeItem CodenVarChar200
145PCH8A/P Invoice - Items in Package3ItemCodeItem CodenVarChar200
146PDN1Goods Receipt PO - Rows10ItemCodeItem No.nVarChar200
147PDN14Goods Receipt PO - Assembly - Rows4ItemCodeItem no.nVarChar200
148PDN16Goods Receipt PO - SnB properties4ItemCodeItem CodenVarChar200
149PDN8Goods Receipt PO - Items in Package3ItemCodeItem CodenVarChar200
150POR1Purchase Order - Rows10ItemCodeItem No.nVarChar200
151POR14Purchase Order - Assembly - Rows4ItemCodeItem no.nVarChar200
152POR16Purchase Order - SnB properties4ItemCodeItem CodenVarChar200
153POR8Items in Package - Purchase Order3ItemCodeItem CodenVarChar200
154PQT1Purchase Quotation - Rows10ItemCodeItem No.nVarChar200
155PQT14Purchase Quotation - Assembly - Rows4ItemCodeItem no.nVarChar200
156PQT16Purchase Quotation - SnB properties4ItemCodeItem CodenVarChar200
157PQT8Items in Package - Purchase Quotation3ItemCodeItem CodenVarChar200
158QUT1Sales Quotation - Rows10ItemCodeItem No.nVarChar200
159QUT14Sales Quotation - Assembly - Rows4ItemCodeItem no.nVarChar200
160QUT16Sales Quotation - SnB properties4ItemCodeItem CodenVarChar200
161QUT8Sales Quotation - Items in Package3ItemCodeItem CodenVarChar200
162RDN1Returns - Rows10ItemCodeItem No.nVarChar200
163RDN14Return - Assembly - Rows4ItemCodeItem no.nVarChar200
164RDN16Returns - SnB properties4ItemCodeItem CodenVarChar200
165RDN8Returns - Items in Package3ItemCodeItem CodenVarChar200
166RDR1Sales Order - Rows10ItemCodeItem No.nVarChar200
167RDR14Sales Order - Assembly - Rows4ItemCodeItem no.nVarChar200
168RDR16Sales Order - SnB properties4ItemCodeItem CodenVarChar200
169RDR8Sales Order - Items in Package3ItemCodeItem CodenVarChar200
170RIN1A/R Credit Memo - Rows10ItemCodeItem No.nVarChar200
171RIN14A/R Credit Memo - Assembly - Rows4ItemCodeItem no.nVarChar200
172RIN16A/R Credit Memo - SnB properties4ItemCodeItem CodenVarChar200
173RIN8Items in Package - A/R Credit Memo3ItemCodeItem CodenVarChar200
174RPC1A/P Credit Memo - Rows10ItemCodeItem No.nVarChar200
175RPC14A/P Credit Memo - Assembly - Rows4ItemCodeItem no.nVarChar200
176RPC16A/P Credit Memo - SnB properties4ItemCodeItem CodenVarChar200
177RPC8Items in Package - A/P Credit Memo3ItemCodeItem CodenVarChar200
178RPD1Goods Return - Rows10ItemCodeItem No.nVarChar200
179RPD14Goods Return - Assembly - Rows4ItemCodeItem no.nVarChar200
180RPD16Goods Return - SnB properties4ItemCodeItem CodenVarChar200
181RPD8Goods Return - Items in Package3ItemCodeItem CodenVarChar200
182SAL1Salida - Rows13ItemCodeItem No.nVarChar200
183TRA1Transition - Rows13ItemCodeItem No.nVarChar200
TOPMRP
184FCT1Sales Forecast - Rows3ItemCodeItem No.nVarChar200
185MSN2MRP Run Results2ItemCodeItem No.nVarChar200
186MSN3MRP Pegging Information2ItemCodeItem No.nVarChar200
187MSN4MRP Scenarios - Items Array2ItemCodeItem CodenVarChar200
188ORCMRecommendation Data4ItemCodeItem No.nVarChar200
TOPService
189AINSCustomer Equipment Card - History14itemCodeForeign Key To ItemnVarChar200
190ASC2Service Call Inventory Expenses - History3ItemCodeItem No. - HistorynVarChar200
191ASC3Service Call Travel/Labor Expenses - History3ItemCodeItem NumbernVarChar200
192ASCLHistory15itemCodeItem NumbernVarChar200
193CTR1Service Contract - Items5ItemCodeItem No.nVarChar200
194OINSCustomer Equipment Card14itemCodeItem No.nVarChar200
195OSCLService Calls15itemCodeItem No.nVarChar200
196OSLTService Call Solutions2ItemCodeItem No.nVarChar200
197SCL2Service Call Inventory Expenses3ItemCodeItem No.nVarChar200
198SCL3Service Call Travel/Labor Expenses3ItemCodeItem No.nVarChar200