SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

181 columns | Print definition?B1 9.2  | 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
TOPInventory and Production
13ABINBin Location - History3WhsCodeWarehouse CodenVarChar80
14ABTWBatch Attributes in Location3WhsCodeWarehouse CodenVarChar80
15AIGWItem Group - Warehouse - History3WhsCodeWarehouse CodenVarChar80
16AIN1Inventory Counting - Rows6WhsCodeWarehouse CodenVarChar80
17AIN11Inventory Counting - Individual Counters - Row SnB5WhsCodeWarehousenVarChar80
18AIN3Inventory Count - SnB5WhsCodeWarehousenVarChar80
19AIN7Inventory Counting - Team Counter - Row SnB5WhsCodeWarehousenVarChar80
20AITWItems - Warehouse - History2WhsCodeWarehouse CodenVarChar80
21AMR1Inventory Revaluation - History - Rows8WhsCodeWarehouse CodenVarChar80
22AQI1Inventory Opening Balance - Rows14WhsCodeWarehouse CodenVarChar80
23AQI2Inventory Opening Balance - SnB5WhsCodeWarehousenVarChar80
24AQR1Inventory Posting - Rows14WhsCodeWarehouse CodenVarChar80
25AQR3Inventory Count - SnB5WhsCodeWarehousenVarChar80
26AWHSWarehouses - History1WhsCodeWarehouse CodenVarChar80
27AWO3Production Order - (Closure) - History7WhsCodeWarehouse CodenVarChar80
28CCS1Cycle Count Determination- Subtable1WhsCodeWarehouse CodenVarChar80
29ICD1Inventory Counting Draft - Rows6WhsCodeWarehouse CodenVarChar80
30ICD11Inventory Counting Draft - Individual Counter - Row SnB5WhsCodeWarehousenVarChar80
31ICD3Inventory Count Draft - SnB5WhsCodeWarehousenVarChar80
32ICD7Inventory Counting Draft - Team Counter - Row SnB5WhsCodeWarehousenVarChar80
33IGE1Goods Issue - Rows25WhsCodeWarehouse CodenVarChar80
34IGE14Goods Issue - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
35IGE16Goods Issue - SnB properties5WhsCodeWarehousenVarChar80
36IGE19Goods Issue - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
37IGN1Goods Receipt - Rows25WhsCodeWarehouse CodenVarChar80
38IGN14Goods Receipt - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
39IGN16Goods Receipt - SnB properties5WhsCodeWarehousenVarChar80
40IGN19Goods Receipt - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
41INC1Inventory Counting - Rows6WhsCodeWarehouse CodenVarChar80
42INC11Inventory Counting - Individual Counter - Row SnB5WhsCodeWarehousenVarChar80
43INC3Inventory Count - SnB5WhsCodeWarehousenVarChar80
44INC7Inventory Counting - Team Counter - Row SnB5WhsCodeWarehousenVarChar80
45IOD1Inventory Opening Balance Draft - Rows14WhsCodeWarehouse CodenVarChar80
46IOD2Inventory Opening Balance Draft - SnB5WhsCodeWarehousenVarChar80
47IPD1Inventory Posting Draft - Rows14WhsCodeWarehouse CodenVarChar80
48IPD3Inventory Posting Draft - SnB5WhsCodeWarehousenVarChar80
49IPF1Landed Costs - Rows36WhsCodeWarehouse CodenVarChar80
50IQI1Inventory Opening Balance - Rows14WhsCodeWarehouse CodenVarChar80
51IQI2Inventory Opening Balance - SnB5WhsCodeWarehousenVarChar80
52IQR1Inventory Posting - Rows14WhsCodeWarehouse CodenVarChar80
53IQR3Inventory Posting - SnB5WhsCodeWarehousenVarChar80
54ITW1Item Count Alert2WhsCodeWarehouse CodenVarChar80
55MRV1Inventory Revaluation Information Array8WhsCodeWarehouse CodenVarChar80
56OBBQItem - Serial/Batch - Bin Accumulator6WhsCodeWarehouse CodenVarChar80
57OBINBin Location3WhsCodeWarehouse CodenVarChar80
58OBTQBatch No. Quantities3WhsCodeWarehouse CodenVarChar80
59OBTWBatch Attributes in Location3WhsCodeWarehouse CodenVarChar80
60OCCSCycle Count Determination1WhsCodeWarehouse CodenVarChar80
61ODBWBatch Draft Attribs in Locat.3WhsCodeWarehouse CodenVarChar80
62ODSWSN Draft Attribs in Location3WhsCodeWarehouse CodenVarChar80
63OIBQItem - Bin Accumulator5WhsCodeWarehouse CodenVarChar80
64OIGWItem Group - Warehouse3WhsCodeWarehouse CodenVarChar80
65OITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
66OIWBItems - Warehouse Counting Data Backup3WhsCodeWarehouse CodenVarChar80
67OSBQItem - Serial/Batch - Bin Accumulator6WhsCodeWarehouse CodenVarChar80
68OSRQSerial No. Quantities3WhsCodeWarehouse CodenVarChar80
69OSRWSerial No. Attribs in Location3WhsCodeWarehouse CodenVarChar80
70OWHSWarehouses1WhsCodeWarehouse CodenVarChar80
71SITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
72UITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
73UWKO1Production Instructions - Rows8WhsCodeItem WarehousenVarChar80
74UWOR3Production Order - Closure7WhsCodeWarehouse CodenVarChar80
75WKO1Production Instructions - Rows8WhsCodeItem WarehousenVarChar80
76WOR3Production Order - Closure7WhsCodeWarehouse CodenVarChar80
77WTQ1Inventory Transfer Request - Rows25WhsCodeWarehouse CodenVarChar80
78WTQ14Inventory Transfer Request - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
79WTQ16Inventory Transfer Request - SnB Properties5WhsCodeWarehouse CodenVarChar80
80WTQ19Inventory Transfer Request - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
81WTR1Inventory Transfer - Rows25WhsCodeWarehouse CodenVarChar80
82WTR14Inventory Transfer - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
83WTR16Inventory Transfer - SnB properties5WhsCodeWarehousenVarChar80
84WTR19Inventory Transfer - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
TOPMarketing Documents
85ADO1A/R Invoice (Rows) - History25WhsCodeWarehouse CodenVarChar80
86ADO14Invoice - Assembly - Rows - History5WhsCodeWarehouse CodenVarChar80
87ADO16Draft - SnB properties5WhsCodeWarehouse CodenVarChar80
88ADO19Bin Allocation Data - History10WhsCodeWarehouse CodenVarChar80
89CIN1Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
90CIN19Correction Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
91CPI1A/P Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
92CPI14A/P Correction Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
93CPI16A/P Corr. Inv - SnB properties5WhsCodeWarehousenVarChar80
94CPI19A/P Correction Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
95CPV1A/P Correction Invoice Reversal - Rows25WhsCodeWarehouse CodenVarChar80
96CPV14A/P Correction Invoice Reversal - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
97CPV16A/P Correction Invoice Reversal - SnB properties5WhsCodeWarehousenVarChar80
98CPV19A/P Correction Invoice Reversal - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
99CSI1A/R Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
100CSI14A/R Correction Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
101CSI16A/R Corr. Inv. - SnB properties5WhsCodeWarehousenVarChar80
102CSI19A/R Correction Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
103CSV1A/R Correction Invoice Reversal - Rows25WhsCodeWarehouse CodenVarChar80
104CSV14A/R Correction Invoice Reversal - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
105CSV16A/R Correction Invoice Reversal - SnB properties5WhsCodeWarehousenVarChar80
106CSV19A/R Correction Invoice Reversal - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
107DLN1Delivery - Rows25WhsCodeWarehouse CodenVarChar80
108DLN14Delivery Notes - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
109DLN16Delivery - SnB properties5WhsCodeWarehousenVarChar80
110DLN19Delivery - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
111DPI1A/R Down Payment - Rows25WhsCodeWarehouse CodenVarChar80
112DPI14A/R Down Payment - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
113DPI16A/R Down Payment - SnB properties5WhsCodeWarehousenVarChar80
114DPI19A/R Down Payment - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
115DPO1A/P Down Payment - Rows25WhsCodeWarehouse CodenVarChar80
116DPO14A/P Down Payment - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
117DPO16A/P Down Payment - SnB properties5WhsCodeWarehousenVarChar80
118DPO19A/P Down Payment - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
119DRF1Draft - Rows25WhsCodeWarehouse CodenVarChar80
120DRF14Draft - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
121DRF16Draft - SnB - Rows5WhsCodeWarehousenVarChar80
122DRF19Draft - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
123GPA1Gross Profit Adjustment - Documents13WhsCodeWarehouse CodenVarChar80
124IEI1Incoming Excise Invoice - Rows25WhsCodeWarehouse CodenVarChar80
125IEI14Incoming Excise Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
126IEI16Incoming Excise Invoice - SnB properties5WhsCodeWarehousenVarChar80
127IEI19Incoming Excise Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
128INV1A/R Invoice - Rows25WhsCodeWarehouse CodenVarChar80
129INV14A/R Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
130INV16A/R Invoice - SnB properties5WhsCodeWarehousenVarChar80
131INV19A/R Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
132OEI1Outgoing Excise Invoice - Rows25WhsCodeWarehouse CodenVarChar80
133OEI14Outgoing Excise Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
134OEI16Outgoing Excise Invoice - SnB properties5WhsCodeWarehousenVarChar80
135OEI19Outgoing Excise Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
136PCH1A/P Invoice - Rows25WhsCodeWarehouse CodenVarChar80
137PCH14A/P Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
138PCH16A/P Invoice - SnB properties5WhsCodeWarehousenVarChar80
139PCH19A/P Invoice - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
140PDN1Goods Receipt PO - Rows25WhsCodeWarehouse CodenVarChar80
141PDN14Goods Receipt PO - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
142PDN16Goods Receipt PO - SnB properties5WhsCodeWarehousenVarChar80
143PDN19Goods Receipt PO - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
144POR1Purchase Order - Rows25WhsCodeWarehouse CodenVarChar80
145POR14Purchase Order - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
146POR16Purchase Order - SnB properties5WhsCodeWarehousenVarChar80
147POR19Purchase Order - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
148PQT1Purchase Quotation - Rows25WhsCodeWarehouse CodenVarChar80
149PQT14Purchase Quotation - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
150PQT16Purchase Quotation - SnB properties5WhsCodeWarehousenVarChar80
151PQT19Purchase Quotation - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
152PRQ1Purchase Request - Rows25WhsCodeWarehouse CodenVarChar80
153PRQ14Purchase Request - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
154PRQ16Purchase Request - SnB Properties5WhsCodeWarehousenVarChar80
155PRQ19Purchase Request - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
156QUT1Sales Quotation - Rows25WhsCodeWarehouse CodenVarChar80
157QUT14Sales Quotation - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
158QUT16Sales Quotation - SnB properties5WhsCodeWarehousenVarChar80
159QUT19Sales Quotation - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
160RDN1Returns - Rows25WhsCodeWarehouse CodenVarChar80
161RDN14Return - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
162RDN16Returns - SnB properties5WhsCodeWarehousenVarChar80
163RDN19Returns - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
164RDR1Sales Order - Rows25WhsCodeWarehouse CodenVarChar80
165RDR14Sales Order - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
166RDR16Sales Order - SnB properties5WhsCodeWarehousenVarChar80
167RDR19Sales Order - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
168RIN1A/R Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
169RIN14A/R Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
170RIN16A/R Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
171RIN19A/R Credit Memo - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
172RPC1A/P Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
173RPC14A/P Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
174RPC16A/P Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
175RPC19A/P Credit Memo - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
176RPD1Goods Return - Rows25WhsCodeWarehouse CodenVarChar80
177RPD14Goods Return - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
178RPD16Goods Return - SnB properties5WhsCodeWarehousenVarChar80
179RPD19Goods Return - Bin Allocation Data10WhsCodeWarehouse CodenVarChar80
TOPMRP
180MSN1MRP Scenarios - Warehouses Array2WhsCodeWarehouse CodenVarChar80
181MSN3MRP Pegging Information15WhsCodeWarehouse CodenVarChar80