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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data

203 columns | Print definition?B1 9.1  | WHSCODE

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