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

241 columns | Print definition?B1 9.1  | QUANTITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBusiness Partners
1AOA2Blanket Agreement - Details9QuantityItem QuantityNum196
2OAT2Blanket Agreement - Details9QuantityItem QuantityNum196
3OAT4VAgreement Document10QuantityItem QuantityNum196
TOPFinance
4ACD1Credit Memo - Rows5QuantityQuantityNum196
5ACQ1Capitalization - Rows5QuantityQuantityNum196
6AFA1Asset Document - Rows5QuantityQuantityNum196
7FAD1Asset Document - Rows5QuantityQuantityNum196
8FTR1Transfer - Rows5QuantityQuantityNum196
9GBI7GBI Row 7 - Accounting Vouchers15QuantityQuantityNum196
10ISW3Declaration Rows11QuantityQuantityNum196
11IWZ3Items Last Revaluation Data15QuantityQuantityNum196
12MDP1Manual Depreciation - Rows5QuantityQuantityNum196
13RTI1Retirement - Rows5QuantityQuantityNum196
TOPGeneral
14CIFVInventory-FIFO Revaluation5QuantityQuantity in LayerNum196
15OBVLSerial Numbers and Batch Valuation Log19QuantityQuantityNum196
16OFDVAsset Item Values7QuantityPosted QuantityNum196
17OFEVFixed Asset End Balances13QuantityAsset QuantityNum196
18RITLSnB Report Trans List11QuantityQuantityNum196
19TCN1Tracking Note - Line Data5QuantityQuantityNum196
20UBVLSerial Numbers and Batch Valuation Log19QuantityQuantityNum196
TOPInventory and Production
21ABTNBatch Numbers Master Data26QuantityQuantityNum196
22AIBTBatch No. for Item12QuantityQuantityNum196
23AIN11Inventory Counting - Individual Counters - Row SnB9QuantityQuantityNum196
24AIN3Inventory Count - SnB9QuantityQuantityNum196
25AIN7Inventory Counting - Team Counter - Row SnB9QuantityQuantityNum196
26AIT8Asset Item Balances - History6QuantityAsset QuantityNum196
27AMR1Inventory Revaluation - History - Rows5QuantityQuantityNum196
28AMR2Inventory Revaluation FIFO Rows (Archive)4QuantityQuantityNum196
29AQI1Inventory Initial Qty Rows8QuantityQuantity - DeltaNum196
30AQI2Inventory Count - SnB9QuantityQuantityNum196
31AQR1Inventory Stock Posting (Reconcile) Lines8QuantityQuantity - DeltaNum196
32AQR3Inventory Count - SnB9QuantityQuantityNum196
33ASRNSerial Numbers Master Data26QuantityQuantityNum196
34ATT1Bill of Materials - Components - History4QuantityQuantityNum196
35AWO3Production Order - (Closure) - History4QuantityQuantityNum196
36BTNTBatch Numbers in Document15QuantityQuantityNum196
37BTNT1Batch Numbers in Inventory Counting15QuantityQuantityNum196
38ENT1Entry - Rows9QuantityQuantityNum196
39IBT1Batch Number Transactions11QuantityQuantityNum196
40ICD11Inventory Counting Draft - Individual Counter - Row SnB9QuantityQuantityNum196
41ICD3Inventory Count Draft - SnB9QuantityQuantityNum196
42ICD7Inventory Counting Draft - Team Counter - Row SnB9QuantityQuantityNum196
43IGE1Goods Issue - Rows12QuantityQuantityNum196
44IGE14Goods Issue - Assembly - Rows6QuantityQuantityNum196
45IGE16Goods Issue - SnB properties9QuantityQttyNum196
46IGE19Goods Issue - Bin Allocation Data8QuantityQuantityNum196
47IGE8Items in Package - Goods Issue4QuantityQuantityNum196
48IGN1Goods Receipt - Rows12QuantityQuantityNum196
49IGN14Goods Receipt - Assembly - Rows6QuantityQuantityNum196
50IGN16Goods Receipt - SnB properties9QuantityQttyNum196
51IGN19Goods Receipt - Bin Allocation Data8QuantityQuantityNum196
52IGN8Goods Receipt - Items in Package4QuantityQuantityNum196
53ILM1Srl & Batch Det of Inv Log Msg4QuantityQuantityNum196
54ILM3Non-Inventory and Resource Components Log Msg8QuantityQuantityNum196
55INC11Inventory Counting - Individual Counter - Row SnB9QuantityQuantityNum196
56INC3Inventory Count - SnB9QuantityQuantityNum196
57INC7Inventory Counting - Team Counter - Row SnB9QuantityQuantityNum196
58IOD1Inventory Initial Qty Draft Rows8QuantityQuantity - DeltaNum196
59IOD2Inventory Count Draft - SnB9QuantityQuantityNum196
60IPD1Inventory Stock Posting Draft (Reconcile) Lines8QuantityQuantity - DeltaNum196
61IPD3Inventory Posting Draft - SnB9QuantityQuantityNum196
62IPF1Landed Costs - Rows7QuantityQuantityNum196
63IQI1Inventory Initial Qty Rows8QuantityQuantity - DeltaNum196
64IQI2Inventory Count - SnB9QuantityQuantityNum196
65IQR1Inventory Stock Posting (Reconcile) Lines8QuantityQuantity - DeltaNum196
66IQR3Inventory Posting - SnB9QuantityQuantityNum196
67ITL1Srl & Batch Details in Transac4QuantityQuantityNum196
68ITM8Asset Item Balances6QuantityAsset QuantityNum196
69ITT1Bill of Materials - Components4QuantityQuantityNum196
70MRV1Inventory Revaluation Information Array5QuantityQuantityNum196
71MRV2Inventory Revaluation FIFO Rows4QuantityQuantityNum196
72OAIMArchive Inventory Message5QuantityQuantity in DocumentNum196
73OBTLBin Transaction Log5QuantityQuantityNum196
74OBTNBatch Numbers Master Data26QuantityQuantityNum196
75OBTQBatch No. Quantities4QuantityQuantityNum196
76ODBNBat. Nos - Draft - Master Data26QuantityQuantityNum196
77ODIBBatch No. for Item Draft12QuantityQuantityNum196
78ODSNSNs - Draft - Master Data26QuantityQuantityNum196
79ODSRDraft Serial Numbers for Items14QuantityQuantityNum196
80OIBTBatch No. for Item12QuantityQuantityNum196
81OILMInventory Log Message5QuantityQuantity in DocNum196
82OSRISerial Numbers for Items14QuantityQuantityNum196
83OSRNSerial Numbers Master Data26QuantityQuantityNum196
84OSRQSerial No. Quantities4QuantityQuantityNum196
85RBTNBatch Report Master Data List7QuantityQUANTITYNum196
86RSRNSerial Number Report Master Data List7QuantityQUANTITYNum196
87SRNTSerial Numbers in Document15QuantityQuantityNum196
88SRNT1Serial Numbers in Inventory Counting15QuantityQuantityNum196
89TMP1Bill of Materials - Component Items4QuantityQuantityNum196
90UBTNBatch Numbers Master Data26QuantityQuantityNum196
91UILMIVI Inventory Log Message5QuantityQuantity in DocNum196
92UILM1Srl & Batch Det of Inv Log Msg4QuantityQuantityNum196
93UILM3Non-Inventory and Resource Components Log Msg8QuantityQuantityNum196
94USRNSerial Numbers Master Data26QuantityQuantityNum196
95UWKO1Production Instructions - Rows5QuantityItem QuantityNum196
96UWOR3Production Order - Closure4QuantityQuantityNum196
97WKO1Production Instructions - Rows5QuantityItem QuantityNum196
98WOR3Production Order - Closure4QuantityQuantityNum196
99WTQ1Inventory Transfer Request - Rows12QuantityQuantityNum196
100WTQ14Inventory Transfer Request - Assembly - Rows6QuantityQuantityNum196
101WTQ16Inventory Transfer Request - SnB Properties9QuantityQtyNum196
102WTQ19Inventory Transfer Request - Bin Allocation Data8QuantityQuantityNum196
103WTQ8Inventory Transfer Request - Items in Package4QuantityQuantityNum196
104WTR1Inventory Transfer - Rows12QuantityQuantityNum196
105WTR14Inventory Transfer - Assembly - Rows6QuantityQuantityNum196
106WTR16Inventory Transfer - SnB properties9QuantityQttyNum196
107WTR19Inventory Transfer - Bin Allocation Data8QuantityQuantityNum196
108WTR8Inventory Transfer - Items in Package4QuantityQuantityNum196
TOPMarketing Documents
109ADO1A/R Invoice (Rows) - History12QuantityQuantityNum196
110ADO14Invoice - Assembly - Rows - History6QuantityQuantityNum196
111ADO16Draft - SnB properties9QuantityQttyNum196
112ADO19Bin Allocation Data - History8QuantityQuantityNum196
113ADO8Items in Package - History4QuantityQuantityNum196
114CIN1Correction Invoice - Rows12QuantityQuantityNum196
115CIN19Correction Invoice - Bin Allocation Data8QuantityQuantityNum196
116CIN8Items in Package - Correction Invoice4QuantityQuantityNum196
117CPI1A/P Correction Invoice - Rows12QuantityQuantityNum196
118CPI14A/P Correction Invoice - Assembly - Rows6QuantityQuantityNum196
119CPI16A/P Corr. Inv - SnB properties9QuantityQttyNum196
120CPI19A/P Correction Invoice - Bin Allocation Data8QuantityQuantityNum196
121CPI8A/P Correction Invoice - Items in Package4QuantityQuantityNum196
122CPV1A/P Correction Invoice Reversal - Rows12QuantityQuantityNum196
123CPV14A/P Correction Invoice Reversal - Assembly - Rows6QuantityQuantityNum196
124CPV16A/P Correction Invoice Reversal - SnB properties9QuantityQttyNum196
125CPV19A/P Correction Invoice Reversal - Bin Allocation Data8QuantityQuantityNum196
126CPV8A/P Correction Invoice Reversal - Items in Package4QuantityQuantityNum196
127CSI1A/R Correction Invoice - Rows12QuantityQuantityNum196
128CSI14A/R Correction Invoice - Assembly - Rows6QuantityQuantityNum196
129CSI16A/R Corr. Inv. - SnB properties9QuantityQttyNum196
130CSI19A/R Correction Invoice - Bin Allocation Data8QuantityQuantityNum196
131CSI8A/R Corr. Inv. - Items in Pkg4QuantityQuantityNum196
132CSV1A/R Correction Invoice Reversal - Rows12QuantityQuantityNum196
133CSV14A/R Correction Invoice Reversal - Assembly - Rows6QuantityQuantityNum196
134CSV16A/R Correction Invoice Reversal - SnB properties9QuantityQttyNum196
135CSV19A/R Correction Invoice Reversal - Bin Allocation Data8QuantityQuantityNum196
136CSV8A/R Correction Invoice Reversal - Items in Package4QuantityQuantityNum196
137DLN1Delivery - Rows12QuantityQuantityNum196
138DLN14Delivery Notes - Assembly - Rows6QuantityQuantityNum196
139DLN16Delivery - SnB properties9QuantityQttyNum196
140DLN19Delivery - Bin Allocation Data8QuantityQuantityNum196
141DLN8Items in Package - Delivery4QuantityQuantityNum196
142DOC1Mktg Docs - Row12QuantityQuantityNum196
143DOC14Mktg Docs - Assembly Row6QuantityQuantityNum196
144DOC16Mktg Docs - SnB property9QuantityQttyNum196
145DOC19Mktg Docs - Bin Allocation Data8QuantityQuantityNum196
146DOC8Mktg Docs - Items in Package4QuantityQuantityNum196
147DPI1A/R Down Payment - Rows12QuantityQuantityNum196
148DPI14A/R Down Payment - Assembly - Rows6QuantityQuantityNum196
149DPI16A/R Down Payment - SnB properties9QuantityQttyNum196
150DPI19A/R Down Payment - Bin Allocation Data8QuantityQuantityNum196
151DPI8Items in Package - A/R Down Pmt.4QuantityQuantityNum196
152DPO1A/P Down Payment - Rows12QuantityQuantityNum196
153DPO14A/P Down Payment - Assembly - Rows6QuantityQuantityNum196
154DPO16A/P Down Payment - SnB properties9QuantityQttyNum196
155DPO19A/P Down Payment - Bin Allocation Data8QuantityQuantityNum196
156DPO8Items in Package - A/P Down Pmt.4QuantityQuantityNum196
157DRF1Draft - Rows12QuantityQuantityNum196
158DRF14Draft - Assembly - Rows6QuantityQuantityNum196
159DRF16Draft - SnB - Rows9QuantityQttyNum196
160DRF19Draft - Bin Allocation Data8QuantityQuantityNum196
161DRF8Items in Package - Draft4QuantityQuantityNum196
162GTI1GTS Invoice Details7QuantityQuantityNum196
163GTM1GTS Mapping Object Details8QuantityQuantityNum196
164IEI1Incoming Excise Invoice - Rows12QuantityQuantityNum196
165IEI14Incoming Excise Invoice - Assembly - Rows6QuantityQuantityNum196
166IEI16Incoming Excise Invoice - SnB properties9QuantityQttyNum196
167IEI19Incoming Excise Invoice - Bin Allocation Data8QuantityQuantityNum196
168IEI8Incoming Excise Invoice - Items in Package4QuantityQuantityNum196
169INV1A/R Invoice - Rows12QuantityQuantityNum196
170INV14A/R Invoice - Assembly - Rows6QuantityQuantityNum196
171INV16A/R Invoice - SnB properties9QuantityQttyNum196
172INV19A/R Invoice - Bin Allocation Data8QuantityQuantityNum196
173INV8A/R Invoice - Items in Package4QuantityQuantityNum196
174OEI1Outgoing Excise Invoice - Rows12QuantityQuantityNum196
175OEI14Outgoing Excise Invoice - Assembly - Rows6QuantityQuantityNum196
176OEI16Outgoing Excise Invoice - SnB properties9QuantityQttyNum196
177OEI19Outgoing Excise Invoice - Bin Allocation Data8QuantityQuantityNum196
178OEI8Outgoing Excise Invoice - Items in Package4QuantityQuantityNum196
179PCH1A/P Invoice - Rows12QuantityQuantityNum196
180PCH14A/P Invoice - Assembly - Rows6QuantityQuantityNum196
181PCH16A/P Invoice - SnB properties9QuantityQttyNum196
182PCH19A/P Invoice - Bin Allocation Data8QuantityQuantityNum196
183PCH8A/P Invoice - Items in Package4QuantityQuantityNum196
184PDN1Goods Receipt PO - Rows12QuantityQuantityNum196
185PDN14Goods Receipt PO - Assembly - Rows6QuantityQuantityNum196
186PDN16Goods Receipt PO - SnB properties9QuantityQttyNum196
187PDN19Goods Receipt PO - Bin Allocation Data8QuantityQuantityNum196
188PDN8Goods Receipt PO - Items in Package4QuantityQuantityNum196
189POR1Purchase Order - Rows12QuantityQuantityNum196
190POR14Purchase Order - Assembly - Rows6QuantityQuantityNum196
191POR16Purchase Order - SnB properties9QuantityQttyNum196
192POR19Purchase Order - Bin Allocation Data8QuantityQuantityNum196
193POR8Items in Package - Purchase Order4QuantityQuantityNum196
194PQT1Purchase Quotation - Rows12QuantityQuantityNum196
195PQT14Purchase Quotation - Assembly - Rows6QuantityQuantityNum196
196PQT16Purchase Quotation - SnB properties9QuantityQttyNum196
197PQT19Purchase Quotation - Bin Allocation Data8QuantityQuantityNum196
198PQT8Items in Package - Purchase Quotation4QuantityQuantityNum196
199PRQ1Purchase Request - Rows12QuantityQuantityNum196
200PRQ14Purchase Request - Assembly - Rows6QuantityQuantityNum196
201PRQ16Purchase Request - SnB Properties9QuantityQuantityNum196
202PRQ19Purchase Request - Bin Allocation Data8QuantityQuantityNum196
203PRQ8Items in Package - Purchase Request4QuantityQuantityNum196
204QUT1Sales Quotation - Rows12QuantityQuantityNum196
205QUT14Sales Quotation - Assembly - Rows6QuantityQuantityNum196
206QUT16Sales Quotation - SnB properties9QuantityQttyNum196
207QUT19Sales Quotation - Bin Allocation Data8QuantityQuantityNum196
208QUT8Sales Quotation - Items in Package4QuantityQuantityNum196
209RDN1Returns - Rows12QuantityQuantityNum196
210RDN14Return - Assembly - Rows6QuantityQuantityNum196
211RDN16Returns - SnB properties9QuantityQttyNum196
212RDN19Returns - Bin Allocation Data8QuantityQuantityNum196
213RDN8Returns - Items in Package4QuantityQuantityNum196
214RDR1Sales Order - Rows12QuantityQuantityNum196
215RDR14Sales Order - Assembly - Rows6QuantityQuantityNum196
216RDR16Sales Order - SnB properties9QuantityQttyNum196
217RDR19Sales Order - Bin Allocation Data8QuantityQuantityNum196
218RDR8Sales Order - Items in Package4QuantityQuantityNum196
219RIN1A/R Credit Memo - Rows12QuantityQuantityNum196
220RIN14A/R Credit Memo - Assembly - Rows6QuantityQuantityNum196
221RIN16A/R Credit Memo - SnB properties9QuantityQttyNum196
222RIN19A/R Credit Memo - Bin Allocation Data8QuantityQuantityNum196
223RIN8Items in Package - A/R Credit Memo4QuantityQuantityNum196
224RPC1A/P Credit Memo - Rows12QuantityQuantityNum196
225RPC14A/P Credit Memo - Assembly - Rows6QuantityQuantityNum196
226RPC16A/P Credit Memo - SnB properties9QuantityQttyNum196
227RPC19A/P Credit Memo - Bin Allocation Data8QuantityQuantityNum196
228RPC8Items in Package - A/P Credit Memo4QuantityQuantityNum196
229RPD1Goods Return - Rows12QuantityQuantityNum196
230RPD14Goods Return - Assembly - Rows6QuantityQuantityNum196
231RPD16Goods Return - SnB properties9QuantityQttyNum196
232RPD19Goods Return - Bin Allocation Data8QuantityQuantityNum196
233RPD8Goods Return - Items in Package4QuantityQuantityNum196
234SAL1Salida - Rows9QuantityQuantityNum196
235TRA1Transition - Rows9QuantityQuantityNum196
236VRT1Tax Invoice Report - Rows6QuantityQuantityNum196
TOPMRP
237FCT1Sales Forecast - Rows5QuantityQuantityNum196
238MSN3MRP Pegging Information4QuantityQuantityNum196
239ORCMRecommendation Data7QuantityQuantityNum196
TOPService
240ASC3Service Call Travel/Labor Expenses - History7QuantityQuantityNum196
241SCL3Service Call Travel/Labor Expenses7QuantityQuantityNum196