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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

131 columns | Print definition?B1 8.8  | QUANTITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1GBI7GBI Row 7 - Accounting Vouchers15QuantityQuantityNum196
2IWZ3Items Last Revaluation Data15QuantityQuantityNum196
TOPInventory and Production
3AMR1Inventory Revaluation - History - Rows5QuantityQuantityNum196
4AMR2Inventory Revaluation FIFO Rows (Archive)4QuantityQuantityNum196
5ATT1Bill of Materials - Component Items - History4QuantityQuantityNum196
6ENT1Entry - Rows9QuantityQuantityNum196
7IGE1Goods Issue - Rows12QuantityQuantityNum196
8IGE8Items in Package - Goods Issue4QuantityQuantityNum196
9IGN1Goods Receipt - Rows12QuantityQuantityNum196
10IGN8Goods Receipt - Items in Package4QuantityQuantityNum196
11ILM1Srl & Batch Det of Inv Log Msg4QuantityQuantityNum196
12IPF1Landed Costs - Rows7QuantityQuantityNum196
13IQI1Inventory Initial Qty Rows8QuantityQuantity - DeltaNum196
14IQR1Inventory Stock Posting (Reconcile) Lines8QuantityQuantity - DeltaNum196
15ITL1Srl & Batch Details in Transac4QuantityQuantityNum196
16ITT1Bill of Materials - Component Items4QuantityQuantityNum196
17MRV1Inventory Revaluation Information Array5QuantityQuantityNum196
18MRV2Inventory Revaluation FIFO Rows4QuantityQuantityNum196
19OAIMArchive Inventory Message5QuantityQuantity in DocumentNum196
20OBTQBatch No. Quantities4QuantityQuantityNum196
21OIBTBatch No. for Item12QuantityQuantityNum196
22OILMInventory Log Message5QuantityQuantity in DocNum196
23OSRISerial Numbers for Items14QuantityQuantityNum196
24OSRQSerial No. Quantities4QuantityQuantityNum196
25TMP1Bill of Materials - Component Items4QuantityQuantityNum196
26UILMIVI Inventory Log Message5QuantityQuantity in DocNum196
27UILM1Srl & Batch Det of Inv Log Msg4QuantityQuantityNum196
28UWKO1Production Instructions - Rows5QuantityItem QuantityNum196
29WKO1Production Instructions - Rows5QuantityItem QuantityNum196
30WTR1Inventory Transfer - Rows12QuantityQuantityNum196
31WTR8Inventory Transfer - Items in Package4QuantityQuantityNum196
TOPMarketing Documents
32ADO1A/R Invoice (Rows) - History12QuantityQuantityNum196
33ADO14Invoice - Assembly - Rows - History6QuantityQuantityNum196
34ADO16Draft - SnB properties9QuantityQttyNum196
35ADO8Items in Package - History4QuantityQuantityNum196
36CIN1Correction Invoice - Rows12QuantityQuantityNum196
37CIN8Items in Package - Correction Invoice4QuantityQuantityNum196
38CPI1A/P Correction Invoice - Rows12QuantityQuantityNum196
39CPI14A/P Correction Invoice - Assembly - Rows6QuantityQuantityNum196
40CPI16A/P Corr. Inv - SnB properties9QuantityQttyNum196
41CPI8A/P Correction Invoice - Items in Package4QuantityQuantityNum196
42CPV1A/P Correction Invoice Reversal - Rows12QuantityQuantityNum196
43CPV14A/P Correction Invoice Reversal - Assembly - Rows6QuantityQuantityNum196
44CPV16A/P Correction Invoice Reversal - SnB properties9QuantityQttyNum196
45CPV8A/P Correction Invoice Reversal - Items in Package4QuantityQuantityNum196
46CSI1A/R Correction Invoice - Rows12QuantityQuantityNum196
47CSI14A/R Correction Invoice - Assembly - Rows6QuantityQuantityNum196
48CSI16A/R Corr. Inv. - SnB properties9QuantityQttyNum196
49CSI8A/R Corr. Inv. - Items in Pkg4QuantityQuantityNum196
50CSV1A/R Correction Invoice Reversal - Rows12QuantityQuantityNum196
51CSV14A/R Correction Invoice Reversal - Assembly - Rows6QuantityQuantityNum196
52CSV16A/R Correction Invoice Reversal - SnB properties9QuantityQttyNum196
53CSV8A/R Correction Invoice Reversal - Items in Package4QuantityQuantityNum196
54DLN1Delivery - Rows12QuantityQuantityNum196
55DLN14Delivery Notes - Assembly - Rows6QuantityQuantityNum196
56DLN16Delivery - SnB properties9QuantityQttyNum196
57DLN8Items in Package - Delivery4QuantityQuantityNum196
58DPI1A/R Down Payment - Rows12QuantityQuantityNum196
59DPI14A/R Down Payment - Assembly - Rows6QuantityQuantityNum196
60DPI16A/R Down Payment - SnB properties9QuantityQttyNum196
61DPI8Items in Package - A/R Down Pmt.4QuantityQuantityNum196
62DPO1A/P Down Payment - Rows12QuantityQuantityNum196
63DPO14A/P Down Payment - Assembly - Rows6QuantityQuantityNum196
64DPO16A/P Down Payment - SnB properties9QuantityQttyNum196
65DPO8Items in Package - A/P Down Pmt.4QuantityQuantityNum196
66DRF1Draft - Rows12QuantityQuantityNum196
67DRF14Draft - Assembly - Rows6QuantityQuantityNum196
68DRF16Draft - SnB - Rows9QuantityQttyNum196
69DRF8Items in Package - Draft4QuantityQuantityNum196
70IEI1Incoming Excise Invoice - Rows12QuantityQuantityNum196
71IEI14Incoming Excise Invoice - Assembly - Rows6QuantityQuantityNum196
72IEI16Incoming Excise Invoice - SnB properties9QuantityQttyNum196
73IEI8Incoming Excise Invoice - Items in Package4QuantityQuantityNum196
74IGE14Goods Issue - Assembly - Rows6QuantityQuantityNum196
75IGE16Goods Issue - SnB properties9QuantityQttyNum196
76IGN14Goods Receipt - Assembly - Rows6QuantityQuantityNum196
77IGN16Goods Receipt - SnB properties9QuantityQttyNum196
78INV1A/R Invoice - Rows12QuantityQuantityNum196
79INV14A/R Invoice - Assembly - Rows6QuantityQuantityNum196
80INV16A/R Invoice - SnB properties9QuantityQttyNum196
81INV8A/R Invoice - Items in Package4QuantityQuantityNum196
82OEI1Outgoing Excise Invoice - Rows12QuantityQuantityNum196
83OEI14Outgoing Excise Invoice - Assembly - Rows6QuantityQuantityNum196
84OEI16Outgoing Excise Invoice - SnB properties9QuantityQttyNum196
85OEI8Outgoing Excise Invoice - Items in Package4QuantityQuantityNum196
86PCH1A/P Invoice - Rows12QuantityQuantityNum196
87PCH14A/P Invoice - Assembly - Rows6QuantityQuantityNum196
88PCH16A/P Invoice - SnB properties9QuantityQttyNum196
89PCH8A/P Invoice - Items in Package4QuantityQuantityNum196
90PDN1Goods Receipt PO - Rows12QuantityQuantityNum196
91PDN14Goods Receipt PO - Assembly - Rows6QuantityQuantityNum196
92PDN16Goods Receipt PO - SnB properties9QuantityQttyNum196
93PDN8Goods Receipt PO - Items in Package4QuantityQuantityNum196
94POR1Purchase Order - Rows12QuantityQuantityNum196
95POR14Purchase Order - Assembly - Rows6QuantityQuantityNum196
96POR16Purchase Order - SnB properties9QuantityQttyNum196
97POR8Items in Package - Purchase Order4QuantityQuantityNum196
98QUT1Sales Quotation - Rows12QuantityQuantityNum196
99QUT14Sales Quotation - Assembly - Rows6QuantityQuantityNum196
100QUT16Sales Quotation - SnB properties9QuantityQttyNum196
101QUT8Sales Quotation - Items in Package4QuantityQuantityNum196
102RDN1Returns - Rows12QuantityQuantityNum196
103RDN14Return - Assembly - Rows6QuantityQuantityNum196
104RDN16Returns - SnB properties9QuantityQttyNum196
105RDN8Returns - Items in Package4QuantityQuantityNum196
106RDR1Sales Order - Rows12QuantityQuantityNum196
107RDR14Sales Order - Assembly - Rows6QuantityQuantityNum196
108RDR16Sales Order - SnB properties9QuantityQttyNum196
109RDR8Sales Order - Items in Package4QuantityQuantityNum196
110RIN1A/R Credit Memo - Rows12QuantityQuantityNum196
111RIN14A/R Credit Memo - Assembly - Rows6QuantityQuantityNum196
112RIN16A/R Credit Memo - SnB properties9QuantityQttyNum196
113RIN8Items in Package - A/R Credit Memo4QuantityQuantityNum196
114RPC1A/P Credit Memo - Rows12QuantityQuantityNum196
115RPC14A/P Credit Memo - Assembly - Rows6QuantityQuantityNum196
116RPC16A/P Credit Memo - SnB properties9QuantityQttyNum196
117RPC8Items in Package - A/P Credit Memo4QuantityQuantityNum196
118RPD1Goods Return - Rows12QuantityQuantityNum196
119RPD14Goods Return - Assembly - Rows6QuantityQuantityNum196
120RPD16Goods Return - SnB properties9QuantityQttyNum196
121RPD8Goods Return - Items in Package4QuantityQuantityNum196
122SAL1Salida - Rows9QuantityQuantityNum196
123TRA1Transition - Rows9QuantityQuantityNum196
124VRT1Tax Invoice Report - Rows6QuantityQuantityNum196
125WTR14Inventory Transfer - Assembly - Rows6QuantityQuantityNum196
126WTR16Inventory Transfer - SnB properties9QuantityQttyNum196
TOPMRP
127FCT1Sales Forecast - Rows5QuantityQuantityNum196
128MSN3MRP Pegging Information4QuantityQuantityNum196
129ORCMRecommendation Data7QuantityQuantityNum196
TOPService
130ASC3Service Call Travel/Labor Expenses - History7QuantityQuantityNum196
131SCL3Service Call Travel/Labor Expenses7QuantityQuantityNum196