SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

143 columns | Print definition?B1 8.82  | QUANTITY

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