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

107 columns | Print definition?B1 8.82  | WHSCODE

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