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

172 columns | Print definition?B1 8.8  | ITEMCODE

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