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

177 columns | Print definition?B1 8.82  | PROJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AEXDFreight Setup35ProjectProjectnVarChar200
2OEXDFreight Setup35ProjectProjectnVarChar200
TOPBanking
3ABT1Internal Bank Operation Codes - Accounts - Log4ProjectProjectnVarChar200
4ARC4Incoming Payment - Account List - History14ProjectProject CodenVarChar200
5BNK2Bank Statement - Recommendation List11ProjectProjectnVarChar200
6BTC1Internal Bank Operation Codes - Accounts4ProjectProjectnVarChar200
7OCHHCheck Register28ProjectProject CodenVarChar200
8OCRHCredit Card Management38ProjectProject CodenVarChar200
9ODPSDeposit52ProjectProject CodenVarChar200
10ODPTPostdated Deposit28ProjectProject CodenVarChar200
11PDF4Payment Draft - Account List14ProjectProject CodenVarChar200
12RCC4Incoming Payment - Credit Vouchers14ProjectProject CodenVarChar200
13RCT4Incoming Payment - Account List14ProjectProject CodenVarChar200
14VPM4Outgoing Payments - Accounts14ProjectProject CodenVarChar200
TOPFinance
15AACTG/L Account - History43ProjectProject CodenVarChar200
16AJD1Journal Entry - History - Rows27ProjectProject CodenVarChar200
17AJDTJournal Entry - History19ProjectProject CodenVarChar200
18BTF1Journal Voucher 27ProjectProject CodenVarChar200
19JDT1Journal Entry - Rows27ProjectProject CodenVarChar200
20OACTG/L Accounts43ProjectProject CodenVarChar200
21OBTFJournal Voucher Entry19ProjectProject CodenVarChar200
22OJDTJournal Entry19ProjectProject CodenVarChar200
23RCR1Recurring Postings - Rows27ProjectProject CodenVarChar200
24TRT1Posting Templates - Rows25ProjectProject CodenVarChar200
TOPInventory and Production
25AITTProduct Tree - History24ProjectProject CodenVarChar200
26AMR1Inventory Revaluation - History - Rows23ProjectProject CodenVarChar200
27ATT1Bill of Materials - Component Items - History22ProjectProject CodenVarChar200
28AWO1Production Order (Rows) - History20ProjectProject CodenVarChar200
29AWORProduction Order - History41ProjectProject CodenVarChar200
30IGE1Goods Issue - Rows43ProjectProject CodenVarChar200
31IGE13Goods Issue Rows - Distributed Expenses59ProjectProject CodenVarChar200
32IGE2Goods Issue - Freight - Rows51ProjectProject CodenVarChar200
33IGE3Goods Issue - Freight59ProjectProject CodenVarChar200
34IGN1Goods Receipt - Rows43ProjectProject CodenVarChar200
35IGN13Goods Receipt Rows - Distributed Expenses59ProjectProject CodenVarChar200
36IGN2Goods Receipt - Freight - Rows51ProjectProject CodenVarChar200
37IGN3Goods Receipt - Freight59ProjectProject CodenVarChar200
38IPF1Landed Costs - Rows67ProjectProject CodenVarChar200
39IQI1Inventory Initial Qty Rows23ProjectProject CodenVarChar200
40IQR1Inventory Stock Posting (Reconcile) Lines23ProjectProject CodenVarChar200
41ITT1Bill of Materials - Component Items22ProjectProject CodenVarChar200
42MRV1Inventory Revaluation Information Array23ProjectProject CodenVarChar200
43OIGEGoods Issue136ProjectProject CodenVarChar200
44OIGNGoods Receipt136ProjectProject CodenVarChar200
45OITTProduct Tree24ProjectProject CodenVarChar200
46OMRLAdvanced Inventory Revaluation32ProjectProject CodenVarChar200
47OWORProduction Order41ProjectProject CodenVarChar200
48OWTQInventory Transfer Request136ProjectProject CodenVarChar200
49OWTRInventory Transfer136ProjectProject CodenVarChar200
50TMP1Bill of Materials - Component Items22ProjectProject CodenVarChar200
51UWORProduction Order41ProjectProject CodenVarChar200
52UWOR1Production Order - Rows20ProjectProject CodenVarChar200
53WOR1Production Order - Rows20ProjectProject CodenVarChar200
54WTQ1Inventory Transfer Request - Rows43ProjectProject CodenVarChar200
55WTQ13Inventory Transfer Request Rows - Distributed Freights59ProjectProject CodenVarChar200
56WTQ2Inventory Transfer Request - Freight - Rows51ProjectProject CodenVarChar200
57WTQ3Inventory Transfer Request - Freight59ProjectDrawn TotalnVarChar200
58WTR1Inventory Transfer - Rows43ProjectProject CodenVarChar200
59WTR13Inventory Transfer Rows - Distributed Freights59ProjectProject CodenVarChar200
60WTR2Inventory Transfer - Freight - Rows51ProjectProject CodenVarChar200
61WTR3Inventory Transfer - Freight59ProjectProject CodenVarChar200
TOPMarketing Documents
62ADO1A/R Invoice (Rows) - History43ProjectProject CodenVarChar200
63ADO13A/R Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
64ADO2A/R Invoice - Freight - Rows51ProjectProject CodenVarChar200
65ADO3A/R Invoice - Freight - History59ProjectProject CodenVarChar200
66ADOCInvoice - History136ProjectProject CodenVarChar200
67CIN1Correction Invoice - Rows43ProjectProject CodenVarChar200
68CIN13Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
69CIN2A/R Correction Invoice - Freight - Rows51ProjectProject CodenVarChar200
70CIN3A/R Correction Invoice - Freight59ProjectProject CodenVarChar200
71CPI1A/P Correction Invoice - Rows43ProjectProject CodenVarChar200
72CPI13A/P Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
73CPI2A/P Correction Invoice - Freight - Rows51ProjectProject CodenVarChar200
74CPI3A/P Correction Invoice - Freight59ProjectProject CodenVarChar200
75CPV1A/P Correction Invoice Reversal - Rows43ProjectProject CodenVarChar200
76CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses59ProjectProject CodenVarChar200
77CPV2A/P Correction Invoice Reversal - Freight - Rows51ProjectProject CodenVarChar200
78CPV3A/P Correction Invoice Reversal - Freight59ProjectProject CodenVarChar200
79CSI1A/R Correction Invoice - Rows43ProjectProject CodenVarChar200
80CSI13A/R Correction Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
81CSI2A/R Corr Inv - Freight - Rows51ProjectProject CodenVarChar200
82CSI3A/R Correction Invoice - Freight59ProjectProject CodenVarChar200
83CSV1A/R Correction Invoice Reversal - Rows43ProjectProject CodenVarChar200
84CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses59ProjectProject CodenVarChar200
85CSV2A/R Correction Invoice Reversal - Freight - Rows51ProjectProject CodenVarChar200
86CSV3A/R Correction Invoice Reversal - Freight59ProjectProject CodenVarChar200
87DLN1Delivery - Rows43ProjectProject CodenVarChar200
88DLN13Delivery Rows - Distributed Expenses59ProjectProject CodenVarChar200
89DLN2Delivery Notes - Freight - Rows51ProjectProject CodenVarChar200
90DLN3Delivery Notes - Freight59ProjectProject CodenVarChar200
91DPI1A/R Down Payment - Rows43ProjectProject CodenVarChar200
92DPI13A/R Down Payment Rows - Distributed Expenses59ProjectProject CodenVarChar200
93DPI2A/R Down Payment - Freight - Rows51ProjectProject CodenVarChar200
94DPI3A/R Down Payment - Freight59ProjectProject CodenVarChar200
95DPO1A/P Down Payment - Rows43ProjectProject CodenVarChar200
96DPO13A/P Down Payment Rows - Distributed Expenses59ProjectProject CodenVarChar200
97DPO2A/P Down Payment - Freight - Rows51ProjectProject CodenVarChar200
98DPO3A/P Down Payment - Freight59ProjectProject CodenVarChar200
99DRF1Draft - Rows43ProjectProject CodenVarChar200
100DRF13Draft Rows - Distributed Expenses59ProjectProject CodenVarChar200
101DRF2Draft - Freight - Rows51ProjectProject CodenVarChar200
102DRF3Draft - Freight59ProjectProject CodenVarChar200
103IEI1Incoming Excise Invoice - Rows43ProjectProject CodenVarChar200
104IEI13Incoming Excise Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
105IEI2Incoming Excise Invoice - Freight - History - Rows51ProjectProject CodenVarChar200
106IEI3IEI - Freight59ProjectProject CodenVarChar200
107INV1A/R Invoice - Rows43ProjectProject CodenVarChar200
108INV13A/R Invoice Rows - Distributed Freights59ProjectProject CodenVarChar200
109INV2A/R Invoice - Freight - Rows51ProjectProject CodenVarChar200
110INV3A/R Invoice - Freight59ProjectProject CodenVarChar200
111OCINA/R Correction Invoice136ProjectProject CodenVarChar200
112OCPIA/P Correction Invoice136ProjectProject CodenVarChar200
113OCPVA/P Correction Invoice Reversal136ProjectProject CodenVarChar200
114OCSIA/R Correction Invoice136ProjectProject CodenVarChar200
115OCSVA/R Correction Invoice Reversal136ProjectProject CodenVarChar200
116ODLNDelivery136ProjectProject CodenVarChar200
117ODPIA/R Down Payment136ProjectProject CodenVarChar200
118ODPOA/P Down Payment136ProjectProject CodenVarChar200
119ODRFDrafts136ProjectProject CodenVarChar200
120ODWZDunning Wizard24ProjectProjectnVarChar200
121OEI1Outgoing Excise Invoice - Rows43ProjectProject CodenVarChar200
122OEI13Outgoing Excise Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
123OEI2OEI - Freight Rows51ProjectProject CodenVarChar200
124OEI3OEI - Freight59ProjectProject CodenVarChar200
125OIEIIncoming Excise Invoice136ProjectProject CodenVarChar200
126OINVA/R Invoice136ProjectProject CodenVarChar200
127OOEIOutgoing Excise Invoice136ProjectProject CodenVarChar200
128OPCHA/P Invoice136ProjectProject CodenVarChar200
129OPDNGoods Receipt PO136ProjectProject CodenVarChar200
130OPORPurchase Order136ProjectProject CodenVarChar200
131OPQTPurchase Quotation136ProjectProject CodenVarChar200
132OQUTSales Quotation136ProjectProject CodenVarChar200
133ORDNReturns136ProjectProject CodenVarChar200
134ORDRSales Order136ProjectProject CodenVarChar200
135ORINA/R Credit Memo136ProjectProject CodenVarChar200
136ORPCA/P Credit Memo136ProjectProject CodenVarChar200
137ORPDGoods Return136ProjectProject CodenVarChar200
138PCH1A/P Invoice - Rows43ProjectProject CodenVarChar200
139PCH13A/P Invoice Rows - Distributed Expenses59ProjectProject CodenVarChar200
140PCH2A/P Invoice - Freight - Rows51ProjectProject CodenVarChar200
141PCH3A/P Invoice - Freight59ProjectProject CodenVarChar200
142PDN1Goods Receipt PO - Rows43ProjectProject CodenVarChar200
143PDN13Goods Receipt PO Rows - Distributed Expenses59ProjectProject CodenVarChar200
144PDN2Goods Receipt PO - Freight - Rows51ProjectProject CodenVarChar200
145PDN3Goods Receipt PO - Freight59ProjectProject CodenVarChar200
146POR1Purchase Order - Rows43ProjectProject CodenVarChar200
147POR13Purchase Order Rows - Distributed Expenses59ProjectProject CodenVarChar200
148POR2Purchase Order - Freight - Rows51ProjectProject CodenVarChar200
149POR3Purchase Order - Freight59ProjectProject CodenVarChar200
150PQT1Purchase Quotation - Rows43ProjectProject CodenVarChar200
151PQT13Purchase Quotation Rows - Distributed Expenses59ProjectProject CodenVarChar200
152PQT2Purchase Quotation - Freight - Rows51ProjectProject CodenVarChar200
153PQT3Purchase Quotation - Freight59ProjectProject CodenVarChar200
154QUT1Sales Quotation - Rows43ProjectProject CodenVarChar200
155QUT13Sales Quotation Rows - Distributed Expenses59ProjectProject CodenVarChar200
156QUT2Sales Quotation - Freight - Rows51ProjectProject CodenVarChar200
157QUT3Sales Quotation - Freight59ProjectProject CodenVarChar200
158RDN1Returns - Rows43ProjectProject CodenVarChar200
159RDN13Returns Rows - Distributed Expenses59ProjectProject CodenVarChar200
160RDN2Return - Freight - Rows51ProjectProject CodenVarChar200
161RDN3Return - Freight59ProjectProject CodenVarChar200
162RDR1Sales Order - Rows43ProjectProject CodenVarChar200
163RDR13Sales Order Rows - Distributed Expenses59ProjectProject CodenVarChar200
164RDR2Sales Order - Freight - Rows51ProjectProject CodenVarChar200
165RDR3Sales Order - Freight59ProjectProject CodenVarChar200
166RIN1A/R Credit Memo - Rows43ProjectProject CodenVarChar200
167RIN13A/R Credit Memo Rows - Distributed Expenses59ProjectProject CodenVarChar200
168RIN2A/R Credit Memo - Freight - Rows51ProjectProject CodenVarChar200
169RIN3A/R Credit Memo - Freight59ProjectProject CodenVarChar200
170RPC1A/P Credit Memo - Rows43ProjectProject CodenVarChar200
171RPC13A/P Credit Memo Rows - Distributed Expenses59ProjectProject CodenVarChar200
172RPC2A/P Credit Memo Rows - Expenses51ProjectProject CodenVarChar200
173RPC3A/P Credit Memo - Freight59ProjectProject CodenVarChar200
174RPD1Goods Return - Rows43ProjectProject CodenVarChar200
175RPD13Goods Returns Rows - Distributed Expenses59ProjectProject CodenVarChar200
176RPD2Goods Return - Freight - Rows51ProjectProject CodenVarChar200
177RPD3Goods Return - Freight59ProjectProject CodenVarChar200