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

203 columns | Print definition?B1 9.3  | WHSCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1PQW1Purchase Quotation Generation: Line Items13WhsCodeWarehouse CodenVarChar80
TOPBusiness Partners
2AOA2Blanket Agreement - Details8WhsCodeWarehouse CodenVarChar80-1
3OAT2Blanket Agreement - Details8WhsCodeWarehouse CodenVarChar80-1
TOPFinance
4AGARG/L Account Advanced Rules - History20WhsCodeWarehouse CodenVarChar80
5OGARG/L Account Advanced Rules20WhsCodeWarehouse CodenVarChar80
TOPGeneral
6AGRSG/L Account Advanced Rules for Resources - History20WhsCodeWarehouse CodenVarChar80
7ARSC1Resources - Warehouses - Log2WhsCodeWarehouse CodenVarChar80
8ODSLSchedule Row Detail7WhsCodeWarehouse CodenVarChar80
9OGRSG/L Account Advanced Rules for Resources20WhsCodeWarehouse CodenVarChar80
10ORCJResource Capacity Log3WhsCodeWarehouse CodenVarChar80
11OSLDSchedule Row Detail7WhsCodeWarehouse CodenVarChar80
12RSC1Resources - Warehouses2WhsCodeWarehouse CodenVarChar80
13TCN3Tracking Note - Warehouse Qty3WhsCodeWarehouse CodenVarChar80
TOPInventory and Production
14ABINBin Location - History3WhsCodeWarehouse CodenVarChar80
15ABTWBatch Attributes in Location3WhsCodeWarehouse CodenVarChar80
16AIGWItem Group - Warehouse - History3WhsCodeWarehouse CodenVarChar80
17AIN1Inventory Counting - Rows6WhsCodeWarehouse CodenVarChar80
18AIN11Inventory Counting - Individual Counters - Row SnB5WhsCodeWarehousenVarChar80
19AIN3Inventory Count - SnB5WhsCodeWarehousenVarChar80
20AIN7Inventory Counting - Team Counter - Row SnB5WhsCodeWarehousenVarChar80
21AITWItems - Warehouse - History2WhsCodeWarehouse CodenVarChar80
22AMR1Inventory Revaluation - History - Rows8WhsCodeWarehouse CodenVarChar80
23AQI1Inventory Opening Balance - Rows14WhsCodeWarehouse CodenVarChar80
24AQI2Inventory Opening Balance - SnB5WhsCodeWarehousenVarChar80
25AQR1Inventory Posting - Rows14WhsCodeWarehouse CodenVarChar80
26AQR3Inventory Count - SnB5WhsCodeWarehousenVarChar80
27AWHSWarehouses - History1WhsCodeWarehouse CodenVarChar80
28AWO3Production Order - (Closure) - History7WhsCodeWarehouse CodenVarChar80
29CCS1Cycle Count Determination- Subtable1WhsCodeWarehouse CodenVarChar80
30ICD1Inventory Counting Draft - Rows6WhsCodeWarehouse CodenVarChar80
31ICD11Inventory Counting Draft - Individual Counter - Row SnB5WhsCodeWarehousenVarChar80
32ICD3Inventory Count Draft - SnB5WhsCodeWarehousenVarChar80
33ICD7Inventory Counting Draft - Team Counter - Row SnB5WhsCodeWarehousenVarChar80
34IGE1Goods Issue - Rows25WhsCodeWarehouse CodenVarChar80
35IGE14Goods Issue - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
36IGE16Goods Issue - SnB properties5WhsCodeWarehousenVarChar80
37IGE19Goods Issue - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
38IGN1Goods Receipt - Rows25WhsCodeWarehouse CodenVarChar80
39IGN14Goods Receipt - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
40IGN16Goods Receipt - SnB properties5WhsCodeWarehousenVarChar80
41IGN19Goods Receipt - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
42INC1Inventory Counting - Rows6WhsCodeWarehouse CodenVarChar80
43INC11Inventory Counting - Individual Counter - Row SnB5WhsCodeWarehousenVarChar80
44INC3Inventory Count - SnB5WhsCodeWarehousenVarChar80
45INC7Inventory Counting - Team Counter - Row SnB5WhsCodeWarehousenVarChar80
46IOD1Inventory Opening Balance Draft - Rows14WhsCodeWarehouse CodenVarChar80
47IOD2Inventory Opening Balance Draft - SnB5WhsCodeWarehousenVarChar80
48IPD1Inventory Posting Draft - Rows14WhsCodeWarehouse CodenVarChar80
49IPD3Inventory Posting Draft - SnB5WhsCodeWarehousenVarChar80
50IPF1Landed Costs - Rows36WhsCodeWarehouse CodenVarChar80
51IQI1Inventory Opening Balance - Rows14WhsCodeWarehouse CodenVarChar80
52IQI2Inventory Opening Balance - SnB5WhsCodeWarehousenVarChar80
53IQR1Inventory Posting - Rows14WhsCodeWarehouse CodenVarChar80
54IQR3Inventory Posting - SnB5WhsCodeWarehousenVarChar80
55ITW1Item Count Alert2WhsCodeWarehouse CodenVarChar80
56MRV1Inventory Revaluation Information Array8WhsCodeWarehouse CodenVarChar80
57OBBQItem - Serial/Batch - Bin Accumulator6WhsCodeWarehouse CodenVarChar80
58OBINBin Location3WhsCodeWarehouse CodenVarChar80
59OBTQBatch No. Quantities3WhsCodeWarehouse CodenVarChar80
60OBTWBatch Attributes in Location3WhsCodeWarehouse CodenVarChar80
61OCCSCycle Count Determination1WhsCodeWarehouse CodenVarChar80
62ODBWBatch Draft Attribs in Locat.3WhsCodeWarehouse CodenVarChar80
63ODSWSN Draft Attribs in Location3WhsCodeWarehouse CodenVarChar80
64OIBQItem - Bin Accumulator5WhsCodeWarehouse CodenVarChar80
65OIGWItem Group - Warehouse3WhsCodeWarehouse CodenVarChar80
66OITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
67OIWBItems - Warehouse Counting Data Backup3WhsCodeWarehouse CodenVarChar80
68OSBQItem - Serial/Batch - Bin Accumulator6WhsCodeWarehouse CodenVarChar80
69OSRQSerial No. Quantities3WhsCodeWarehouse CodenVarChar80
70OSRWSerial No. Attribs in Location3WhsCodeWarehouse CodenVarChar80
71OTNLCCD Log5WhsCodeWarehouse CodenVarChar80
72OWHSWarehouses1WhsCodeWarehouse CodenVarChar80
73SITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
74UITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
75UWKO1Production Instructions - Rows8WhsCodeItem WarehousenVarChar80
76UWOR3Production Order - Closure7WhsCodeWarehouse CodenVarChar80
77WKO1Production Instructions - Rows8WhsCodeItem WarehousenVarChar80
78WOR3Production Order - Closure7WhsCodeWarehouse CodenVarChar80
79WTQ1Inventory Transfer Request - Rows25WhsCodeWarehouse CodenVarChar80
80WTQ14Inventory Transfer Request - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
81WTQ16Inventory Transfer Request - SnB Properties5WhsCodeWarehouse CodenVarChar80
82WTQ19Inventory Transfer Request - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
83WTR1Inventory Transfer - Rows25WhsCodeWarehouse CodenVarChar80
84WTR14Inventory Transfer - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
85WTR16Inventory Transfer - SnB properties5WhsCodeWarehousenVarChar80
86WTR19Inventory Transfer - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
TOPMarketing Documents
87ADO1A/R Invoice (Rows) - History25WhsCodeWarehouse CodenVarChar80
88ADO14Invoice - Assembly - Rows - History5WhsCodeWarehouse CodenVarChar80
89ADO16Draft - SnB properties5WhsCodeWarehouse CodenVarChar80
90ADO19Bin Allocation Data - History10WhsCodeWarehouse CodenVarChar80
91ATROTransportation Document - History23WhsCodeWarehouse CodenVarChar80
92CIN1Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
93CIN19Correction Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
94CPI1A/P Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
95CPI14A/P Correction Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
96CPI16A/P Corr. Inv - SnB properties5WhsCodeWarehousenVarChar80
97CPI19A/P Correction Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
98CPV1A/P Correction Invoice Reversal - Rows25WhsCodeWarehouse CodenVarChar80
99CPV14A/P Correction Invoice Reversal - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
100CPV16A/P Correction Invoice Reversal - SnB properties5WhsCodeWarehousenVarChar80
101CPV19A/P Correction Invoice Reversal - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
102CSI1A/R Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
103CSI14A/R Correction Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
104CSI16A/R Corr. Inv. - SnB properties5WhsCodeWarehousenVarChar80
105CSI19A/R Correction Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
106CSV1A/R Correction Invoice Reversal - Rows25WhsCodeWarehouse CodenVarChar80
107CSV14A/R Correction Invoice Reversal - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
108CSV16A/R Correction Invoice Reversal - SnB properties5WhsCodeWarehousenVarChar80
109CSV19A/R Correction Invoice Reversal - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
110DLN1Delivery - Rows25WhsCodeWarehouse CodenVarChar80
111DLN14Delivery Notes - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
112DLN16Delivery - SnB properties5WhsCodeWarehousenVarChar80
113DLN19Delivery - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
114DPI1A/R Down Payment - Rows25WhsCodeWarehouse CodenVarChar80
115DPI14A/R Down Payment - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
116DPI16A/R Down Payment - SnB properties5WhsCodeWarehousenVarChar80
117DPI19A/R Down Payment - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
118DPO1A/P Down Payment - Rows25WhsCodeWarehouse CodenVarChar80
119DPO14A/P Down Payment - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
120DPO16A/P Down Payment - SnB properties5WhsCodeWarehousenVarChar80
121DPO19A/P Down Payment - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
122DRF1Draft - Rows25WhsCodeWarehouse CodenVarChar80
123DRF14Draft - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
124DRF16Draft - SnB - Rows5WhsCodeWarehousenVarChar80
125DRF19Draft - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
126GPA1Gross Profit Adjustment - Documents13WhsCodeWarehouse CodenVarChar80
127IEI1Incoming Excise Invoice - Rows25WhsCodeWarehouse CodenVarChar80
128IEI14Incoming Excise Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
129IEI16Incoming Excise Invoice - SnB properties5WhsCodeWarehousenVarChar80
130IEI19Incoming Excise Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
131INV1A/R Invoice - Rows25WhsCodeWarehouse CodenVarChar80
132INV14A/R Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
133INV16A/R Invoice - SnB properties5WhsCodeWarehousenVarChar80
134INV19A/R Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
135OBALOpening Balances3WhsCodeWarehouse CodenVarChar80
136OEI1Outgoing Excise Invoice - Rows25WhsCodeWarehouse CodenVarChar80
137OEI14Outgoing Excise Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
138OEI16Outgoing Excise Invoice - SnB properties5WhsCodeWarehousenVarChar80
139OEI19Outgoing Excise Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
140OTROTransportation Document23WhsCodeWarehouse CodenVarChar80
141PCH1A/P Invoice - Rows25WhsCodeWarehouse CodenVarChar80
142PCH14A/P Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
143PCH16A/P Invoice - SnB properties5WhsCodeWarehousenVarChar80
144PCH19A/P Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
145PDN1Goods Receipt PO - Rows25WhsCodeWarehouse CodenVarChar80
146PDN14Goods Receipt PO - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
147PDN16Goods Receipt PO - SnB properties5WhsCodeWarehousenVarChar80
148PDN19Goods Receipt PO - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
149POR1Purchase Order - Rows25WhsCodeWarehouse CodenVarChar80
150POR14Purchase Order - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
151POR16Purchase Order - SnB properties5WhsCodeWarehousenVarChar80
152POR19Purchase Order - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
153PQT1Purchase Quotation - Rows25WhsCodeWarehouse CodenVarChar80
154PQT14Purchase Quotation - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
155PQT16Purchase Quotation - SnB properties5WhsCodeWarehousenVarChar80
156PQT19Purchase Quotation - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
157PRQ1Purchase Request - Rows25WhsCodeWarehouse CodenVarChar80
158PRQ14Purchase Request - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
159PRQ16Purchase Request - SnB Properties5WhsCodeWarehousenVarChar80
160PRQ19Purchase Request - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
161PRR1A/P Return Request - Rows25WhsCodeWarehouse CodenVarChar80
162PRR14A/P Return Request - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
163PRR16A/P Return Request - SnB properties5WhsCodeWarehousenVarChar80
164PRR19A/P Return Request - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
165QUT1Sales Quotation - Rows25WhsCodeWarehouse CodenVarChar80
166QUT14Sales Quotation - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
167QUT16Sales Quotation - SnB properties5WhsCodeWarehousenVarChar80
168QUT19Sales Quotation - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
169RDN1Returns - Rows25WhsCodeWarehouse CodenVarChar80
170RDN14Return - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
171RDN16Returns - SnB properties5WhsCodeWarehousenVarChar80
172RDN19Returns - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
173RDR1Sales Order - Rows25WhsCodeWarehouse CodenVarChar80
174RDR14Sales Order - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
175RDR16Sales Order - SnB properties5WhsCodeWarehousenVarChar80
176RDR19Sales Order - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
177RIN1A/R Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
178RIN14A/R Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
179RIN16A/R Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
180RIN19A/R Credit Memo - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
181RPC1A/P Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
182RPC14A/P Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
183RPC16A/P Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
184RPC19A/P Credit Memo - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
185RPD1Goods Return - Rows25WhsCodeWarehouse CodenVarChar80
186RPD14Goods Return - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
187RPD16Goods Return - SnB properties5WhsCodeWarehousenVarChar80
188RPD19Goods Return - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
189RRR1A/R Return Request - Rows25WhsCodeWarehouse CodenVarChar80
190RRR14A/R Return Request - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
191RRR16A/R Return Request - SnB properties5WhsCodeWarehousenVarChar80
192RRR19A/R Return Request - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
193SFC1Self Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
194SFC14Self Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
195SFC16Self Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
196SFC19Self Credit Memo - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
197SFI1Self Invoice - Rows25WhsCodeWarehouse CodenVarChar80
198SFI14Self Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
199SFI16Self Invoice - SnB properties5WhsCodeWarehousenVarChar80
200SFI19Self Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
TOPMRP
201FCT1Sales Forecast - Rows6WhsCodeWarehousenVarChar80-1
202MSN1MRP Scenarios - Warehouses Array2WhsCodeWarehouse CodenVarChar80
203MSN3MRP Pegging Information15WhsCodeWarehouse CodenVarChar80