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

95 columns | Print definition?B1 8.8  | WHSCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1AITWItems - Warehouse - History2WhsCodeWarehouse CodenVarChar80
2AMR1Inventory Revaluation - History - Rows8WhsCodeWarehouse CodenVarChar80
3AWHSWarehouses - History1WhsCodeWarehouse CodenVarChar80
4IGE1Goods Issue - Rows25WhsCodeWarehouse CodenVarChar80
5IGN1Goods Receipt - Rows25WhsCodeWarehouse CodenVarChar80
6IPF1Landed Costs - Rows36WhsCodeWarehouse CodenVarChar80
7IQI1Inventory Initial Qty Rows14WhsCodeWarehouse CodenVarChar80
8IQR1Inventory Stock Posting (Reconcile) Lines14WhsCodeWarehouse CodenVarChar80
9ITW1Item Count Alert2WhsCodeWarehouse CodenVarChar80
10MRV1Inventory Revaluation Information Array8WhsCodeWarehouse CodenVarChar80
11OBTQBatch No. Quantities3WhsCodeWarehouse CodenVarChar80
12OBTWBatch Attributes in Location3WhsCodeWarehouse CodenVarChar80
13ODBWBatch Draft Attribs in Locat.3WhsCodeWarehouse CodenVarChar80
14ODSWSN Draft Attribs in Location3WhsCodeWarehouse CodenVarChar80
15OIBTBatch No. for Item3WhsCodeWarehouse CodenVarChar80
16OITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
17OSRISerial Numbers for Items11WhsCodeWarehouse CodenVarChar80
18OSRQSerial No. Quantities3WhsCodeWarehouse CodenVarChar80
19OSRWSerial No. Attribs in Location3WhsCodeWarehouse CodenVarChar80
20OWHSWarehouses1WhsCodeWarehouse CodenVarChar80
21UITWItems - Warehouse2WhsCodeWarehouse CodenVarChar80
22UWKO1Production Instructions - Rows8WhsCodeItem WarehousenVarChar80
23WKO1Production Instructions - Rows8WhsCodeItem WarehousenVarChar80
24WTR1Inventory Transfer - Rows25WhsCodeWarehouse CodenVarChar80
TOPMarketing Documents
25ADO1A/R Invoice (Rows) - History25WhsCodeWarehouse CodenVarChar80
26ADO14Invoice - Assembly - Rows - History5WhsCodeWarehouse CodenVarChar80
27ADO16Draft - SnB properties5WhsCodeWarehouse CodenVarChar80
28CIN1Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
29CPI1A/P Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
30CPI14A/P Correction Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
31CPI16A/P Corr. Inv - SnB properties5WhsCodeWarehousenVarChar80
32CPV1A/P Correction Invoice Reversal - Rows25WhsCodeWarehouse CodenVarChar80
33CPV14A/P Correction Invoice Reversal - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
34CPV16A/P Correction Invoice Reversal - SnB properties5WhsCodeWarehousenVarChar80
35CSI1A/R Correction Invoice - Rows25WhsCodeWarehouse CodenVarChar80
36CSI14A/R Correction Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
37CSI16A/R Corr. Inv. - SnB properties5WhsCodeWarehousenVarChar80
38CSV1A/R Correction Invoice Reversal - Rows25WhsCodeWarehouse CodenVarChar80
39CSV14A/R Correction Invoice Reversal - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
40CSV16A/R Correction Invoice Reversal - SnB properties5WhsCodeWarehousenVarChar80
41DLN1Delivery - Rows25WhsCodeWarehouse CodenVarChar80
42DLN14Delivery Notes - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
43DLN16Delivery - SnB properties5WhsCodeWarehousenVarChar80
44DPI1A/R Down Payment - Rows25WhsCodeWarehouse CodenVarChar80
45DPI14A/R Down Payment - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
46DPI16A/R Down Payment - SnB properties5WhsCodeWarehousenVarChar80
47DPO1A/P Down Payment - Rows25WhsCodeWarehouse CodenVarChar80
48DPO14A/P Down Payment - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
49DPO16A/P Down Payment - SnB properties5WhsCodeWarehousenVarChar80
50DRF1Draft - Rows25WhsCodeWarehouse CodenVarChar80
51DRF14Draft - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
52DRF16Draft - SnB - Rows5WhsCodeWarehousenVarChar80
53IEI1Incoming Excise Invoice - Rows25WhsCodeWarehouse CodenVarChar80
54IEI14Incoming Excise Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
55IEI16Incoming Excise Invoice - SnB properties5WhsCodeWarehousenVarChar80
56IGE14Goods Issue - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
57IGE16Goods Issue - SnB properties5WhsCodeWarehousenVarChar80
58IGN14Goods Receipt - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
59IGN16Goods Receipt - SnB properties5WhsCodeWarehousenVarChar80
60INV1A/R Invoice - Rows25WhsCodeWarehouse CodenVarChar80
61INV14A/R Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
62INV16A/R Invoice - SnB properties5WhsCodeWarehousenVarChar80
63OEI1Outgoing Excise Invoice - Rows25WhsCodeWarehouse CodenVarChar80
64OEI14Outgoing Excise Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
65OEI16Outgoing Excise Invoice - SnB properties5WhsCodeWarehousenVarChar80
66PCH1A/P Invoice - Rows25WhsCodeWarehouse CodenVarChar80
67PCH14A/P Invoice - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
68PCH16A/P Invoice - SnB properties5WhsCodeWarehousenVarChar80
69PDN1Goods Receipt PO - Rows25WhsCodeWarehouse CodenVarChar80
70PDN14Goods Receipt PO - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
71PDN16Goods Receipt PO - SnB properties5WhsCodeWarehousenVarChar80
72POR1Purchase Order - Rows25WhsCodeWarehouse CodenVarChar80
73POR14Purchase Order - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
74POR16Purchase Order - SnB properties5WhsCodeWarehousenVarChar80
75QUT1Sales Quotation - Rows25WhsCodeWarehouse CodenVarChar80
76QUT14Sales Quotation - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
77QUT16Sales Quotation - SnB properties5WhsCodeWarehousenVarChar80
78RDN1Returns - Rows25WhsCodeWarehouse CodenVarChar80
79RDN14Return - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
80RDN16Returns - SnB properties5WhsCodeWarehousenVarChar80
81RDR1Sales Order - Rows25WhsCodeWarehouse CodenVarChar80
82RDR14Sales Order - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
83RDR16Sales Order - SnB properties5WhsCodeWarehousenVarChar80
84RIN1A/R Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
85RIN14A/R Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
86RIN16A/R Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
87RPC1A/P Credit Memo - Rows25WhsCodeWarehouse CodenVarChar80
88RPC14A/P Credit Memo - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
89RPC16A/P Credit Memo - SnB properties5WhsCodeWarehousenVarChar80
90RPD1Goods Return - Rows25WhsCodeWarehouse CodenVarChar80
91RPD14Goods Return - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
92RPD16Goods Return - SnB properties5WhsCodeWarehousenVarChar80
93WTR14Inventory Transfer - Assembly - Rows5WhsCodeWarehouse CodenVarChar80
94WTR16Inventory Transfer - SnB properties5WhsCodeWarehousenVarChar80
TOPMRP
95MSN1MRP Scenarios - Warehouses Array2WhsCodeWarehouse CodenVarChar80