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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

190 columns | Print definition?B1 9.3  | OCRCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AEXDFreight Setup25OcrCodeDistribution RulenVarChar80
2OEXDFreight Setup25OcrCodeDistr. RulenVarChar80
TOPBanking
3ARC2Incoming Payment - Invoices - History50OcrCodeDistribution RulenVarChar80
4ARC4Incoming Payment - Account List - History13OcrCodeDistribution RulenVarChar80
5ODPSDeposit54OcrCodeDistribution RulenVarChar80
6ODPTPostdated Deposit29OcrCodeDistribution RulenVarChar80
7PDF2Payment Draft - Invoices50OcrCodeDistribution RulenVarChar80
8PDF4Payment Draft - Account List13OcrCodeDistribution RulenVarChar80
9PWZ3Payment Wizard - Rows 367OcrCodeDistribution RulenVarChar80
10RCC4Incoming Payment - Credit Vouchers13OcrCodeDistribution RulenVarChar80
11RCT2Incoming Payments - Invoices50OcrCodeDistribution RulenVarChar80
12RCT4Incoming Payment - Account List13OcrCodeDistribution RulenVarChar80
13VPM2Outgoing Payments - Invoices50OcrCodeDistribution RulenVarChar80
14VPM4Outgoing Payments - Accounts13OcrCodeDistribution RulenVarChar80
TOPFinance
15ACD1Credit Memo - Rows18OcrCodeDistribution RulenVarChar80
16ACQ1Capitalization - Rows18OcrCodeDistribution RulenVarChar80
17AFA1Asset Document - Rows18OcrCodeDistribution RulenVarChar80
18AMDRManual Distribution Rule1OcrCodeFactor CodenVarChar80
19AMDR1Manual Distribution Rule - Rows1OcrCodeFactor CodenVarChar80
20BGT2Budget - Cost Accounting2OcrCodeFactor CodenVarChar80
21BGT3Budget - Cost Accounting Rows2OcrCodeFactor CodenVarChar80
22FTR1Transfer - Rows18OcrCodeDistribution RulenVarChar80
23MDP1Manual Depreciation - Rows18OcrCodeDistribution RulenVarChar80
24MDR1Manual Distribution Rule - Rows1OcrCodeFactor CodenVarChar80
25OBGSBudget Scenario11OcrCodeDimension 1nVarChar80
26OCFLCash Flow Additional Trans.14OcrCodeDistribution Rule 1nVarChar80
27OMDRManual Distribution Rule1OcrCodeFactor CodenVarChar80
28RCR1Recurring Postings - Rows13OcrCodeDistr. RulenVarChar80
29RTI1Retirement - Rows18OcrCodeDistribution RulenVarChar80
30TRT1Posting Templates - Rows11OcrCodeDistr. RulenVarChar80
TOPInventory and Production
31AIN1Inventory Counting - Rows24OcrCodeDistribution Rule CodenVarChar80
32AIT6Asset Item Distribution Rules5OcrCodeDistribution RulenVarChar80
33AITTProduct Tree - History16OcrCodeDistribution RulenVarChar80
34AMR1Inventory Revaluation - History - Rows17OcrCodeDistribution RulenVarChar80
35AQI1Inventory Opening Balance - Rows13OcrCodeDistribution RulenVarChar80
36AQR1Inventory Posting - Rows13OcrCodeDistribution RulenVarChar80
37ATT1Bill of Materials - Components - History17OcrCodeDistribution RulenVarChar80
38AWO1Production Order (Rows) - History12OcrCodeDistribution RulenVarChar80
39AWORProduction Order - History27OcrCodeDistribution RulenVarChar80
40ICD1Inventory Counting Draft - Rows24OcrCodeDistribution Rule CodenVarChar80
41IGE1Goods Issue - Rows42OcrCodeDistribution RulenVarChar80
42IGE13Goods Issue Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
43IGE2Goods Issue - Freight - Rows46OcrCodeDistribution RulenVarChar80
44IGE3Goods Issue - Freight53OcrCodeDistribution RulenVarChar80
45IGN1Goods Receipt - Rows42OcrCodeDistribution RulenVarChar80
46IGN13Goods Receipt Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
47IGN2Goods Receipt - Freight - Rows46OcrCodeDistribution RulenVarChar80
48IGN3Goods Receipt - Freight53OcrCodeDistribution RulenVarChar80
49INC1Inventory Counting - Rows24OcrCodeDistribution Rule CodenVarChar80
50IOD1Inventory Opening Balance Draft - Rows13OcrCodeDistribution RulenVarChar80
51IPD1Inventory Posting Draft - Rows13OcrCodeDistribution RulenVarChar80
52IPF1Landed Costs - Rows68OcrCodeDistribution RulenVarChar80
53IQI1Inventory Opening Balance - Rows13OcrCodeDistribution RulenVarChar80
54IQR1Inventory Posting - Rows13OcrCodeDistribution RulenVarChar80
55ITM6Asset Item Distribution Rules5OcrCodeDistribution RulenVarChar80
56ITT1Bill of Materials - Components17OcrCodeDistribution RulenVarChar80
57MRV1Inventory Revaluation Information Array17OcrCodeDistribution RulenVarChar80
58OAIMArchive Inventory Message25OcrCodeDistribution RulenVarChar80
59OILMInventory Log Message35OcrCodeDistribution RulenVarChar80
60OITTProduct Tree16OcrCodeDistribution RulenVarChar80
61OWORProduction Order27OcrCodeDistribution RulenVarChar80
62UILMIVI Inventory Log Message35OcrCodeDistribution RulenVarChar80
63UWORProduction Order27OcrCodeDistribution RulenVarChar80
64UWOR1Production Order - Rows12OcrCodeDistribution RulenVarChar80
65WOR1Production Order - Rows12OcrCodeDistribution RulenVarChar80
66WTQ1Inventory Transfer Request - Rows42OcrCodeProfit CenternVarChar80
67WTQ13Inventory Transfer Request Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
68WTQ2Inventory Transfer Request - Freight - Rows46OcrCodeDistribution RulenVarChar80
69WTQ3Inventory Transfer Request - Freight53OcrCodeDistribution RulenVarChar80
70WTR1Inventory Transfer - Rows42OcrCodeCosting CodenVarChar80
71WTR13Inventory Transfer Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
72WTR2Inventory Transfer - Freight - Rows46OcrCodeDistribution RulenVarChar80
73WTR3Inventory Transfer - Freight53OcrCodeDistribution RulenVarChar80
TOPMarketing Documents
74ADO1A/R Invoice (Rows) - History42OcrCodeDistribution RulenVarChar80
75ADO13A/R Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
76ADO2A/R Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
77ADO3A/R Invoice - Freight - History53OcrCodeDistribution RulenVarChar80
78CIN1Correction Invoice - Rows42OcrCodeCosting CodenVarChar80
79CIN13Correction Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
80CIN2A/R Correction Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
81CIN3A/R Correction Invoice - Freight53OcrCodeDistribution RulenVarChar80
82CPI1A/P Correction Invoice - Rows42OcrCodeDistribution RulenVarChar80
83CPI13A/P Correction Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
84CPI2A/P Correction Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
85CPI3A/P Correction Invoice - Freight53OcrCodeDistribution RulenVarChar80
86CPV1A/P Correction Invoice Reversal - Rows42OcrCodeDistribution RulenVarChar80
87CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
88CPV2A/P Correction Invoice Reversal - Freight - Rows46OcrCodeDistribution RulenVarChar80
89CPV3A/P Correction Invoice Reversal - Freight53OcrCodeDistribution RulenVarChar80
90CSI1A/R Correction Invoice - Rows42OcrCodeDistribution RulenVarChar80
91CSI13A/R Correction Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
92CSI2A/R Corr Inv - Freight - Rows46OcrCodeDistribution RulenVarChar80
93CSI3A/R Correction Invoice - Freight53OcrCodeDistribution RulenVarChar80
94CSV1A/R Correction Invoice Reversal - Rows42OcrCodeDistribution RulenVarChar80
95CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
96CSV2A/R Correction Invoice Reversal - Freight - Rows46OcrCodeDistribution RulenVarChar80
97CSV3A/R Correction Invoice Reversal - Freight53OcrCodeDistribution RulenVarChar80
98DLN1Delivery - Rows42OcrCodeDistribution RulenVarChar80
99DLN13Delivery Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
100DLN2Delivery Notes - Freight - Rows46OcrCodeDistribution RulenVarChar80
101DLN3Delivery Notes - Freight53OcrCodeDistribution RulenVarChar80
102DPI1A/R Down Payment - Rows42OcrCodeDistribution RulenVarChar80
103DPI13A/R Down Payment Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
104DPI2A/R Down Payment - Freight - Rows46OcrCodeDistribution RulenVarChar80
105DPI3A/R Down Payment - Freight53OcrCodeDistribution RulenVarChar80
106DPO1A/P Down Payment - Rows42OcrCodeDistribution RulenVarChar80
107DPO13A/P Down Payment Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
108DPO2A/P Down Payment - Freight - Rows46OcrCodeDistribution RulenVarChar80
109DPO3A/P Down Payment - Freight53OcrCodeDistribution RulenVarChar80
110DRF1Draft - Rows42OcrCodeDistribution RulenVarChar80
111DRF13Draft Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
112DRF2Draft - Freight - Rows46OcrCodeDistribution RulenVarChar80
113DRF3Draft - Freight53OcrCodeDistribution RulenVarChar80
114IEI1Incoming Excise Invoice - Rows42OcrCodeDistribution RulenVarChar80
115IEI13Incoming Excise Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
116IEI2Incoming Excise Invoice - Freight - History - Rows46OcrCodeDistribution RulenVarChar80
117IEI3IEI - Freight53OcrCodeDistribution RulenVarChar80
118INV1A/R Invoice - Rows42OcrCodeDistribution RulenVarChar80
119INV13A/R Invoice Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
120INV2A/R Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
121INV3A/R Invoice - Freight53OcrCodeDistribution RulenVarChar80
122ODWZDunning Wizard25OcrCodeCosting CodenVarChar80
123OEI1Outgoing Excise Invoice - Rows42OcrCodeDistribution RulenVarChar80
124OEI13Outgoing Excise Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
125OEI2OEI - Freight Rows46OcrCodeDistribution RulenVarChar80
126OEI3OEI - Freight53OcrCodeDistribution RulenVarChar80
127PCH1A/P Invoice - Rows42OcrCodeDistribution RulenVarChar80
128PCH13A/P Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
129PCH2A/P Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
130PCH3A/P Invoice - Freight53OcrCodeDistribution RulenVarChar80
131PDN1Goods Receipt PO - Rows42OcrCodeDistribution RulenVarChar80
132PDN13Goods Receipt PO Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
133PDN2Goods Receipt PO - Freight - Rows46OcrCodeDistribution RulenVarChar80
134PDN3Goods Receipt PO - Freight53OcrCodeDistribution RulenVarChar80
135POR1Purchase Order - Rows42OcrCodeDistribution RulenVarChar80
136POR13Purchase Order Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
137POR2Purchase Order - Freight - Rows46OcrCodeDistribution RulenVarChar80
138POR3Purchase Order - Freight53OcrCodeDistribution RulenVarChar80
139PQT1Purchase Quotation - Rows42OcrCodeDistribution RulenVarChar80
140PQT13Purchase Quotation Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
141PQT2Purchase Quotation - Freight - Rows46OcrCodeDistribution RulenVarChar80
142PQT3Purchase Quotation - Freight53OcrCodeDistribution RulenVarChar80
143PRQ1Purchase Request - Rows42OcrCodeDistribution RulenVarChar80
144PRQ13Purchase Request Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
145PRQ2Purchase Request - Freight - Rows46OcrCodeDistribution RulenVarChar80
146PRQ3Purchase Request - Freight53OcrCodeDistribution RulenVarChar80
147PRR1A/P Return Request - Rows42OcrCodeDistribution RulenVarChar80
148PRR13A/P Return Request - Distributed Freights54OcrCodeDistribution RulenVarChar80
149PRR2A/P Return Request - Freight - Rows46OcrCodeDistribution RulenVarChar80
150PRR3A/P Return Request - Freight53OcrCodeDistribution RulenVarChar80
151QUT1Sales Quotation - Rows42OcrCodeDistribution RulenVarChar80
152QUT13Sales Quotation Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
153QUT2Sales Quotation - Freight - Rows46OcrCodeDistribution RulenVarChar80
154QUT3Sales Quotation - Freight53OcrCodeDistribution RulenVarChar80
155RDN1Returns - Rows42OcrCodeCosting CodenVarChar80
156RDN13Returns Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
157RDN2Return - Freight - Rows46OcrCodeDistribution RulenVarChar80
158RDN3Return - Freight53OcrCodeDistribution RulenVarChar80
159RDR1Sales Order - Rows42OcrCodeDistribution RulenVarChar80
160RDR13Sales Order Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
161RDR2Sales Order - Freight - Rows46OcrCodeDistribution RulenVarChar80
162RDR3Sales Order - Freight53OcrCodeDistribution RulenVarChar80
163RIN1A/R Credit Memo - Rows42OcrCodeDistribution RulenVarChar80
164RIN13A/R Credit Memo Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
165RIN2A/R Credit Memo - Freight - Rows46OcrCodeDistribution RulenVarChar80
166RIN3A/R Credit Memo - Freight53OcrCodeDistribution RulenVarChar80
167RPC1A/P Credit Memo - Rows42OcrCodeDistribution RulenVarChar80
168RPC13A/P Credit Memo Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
169RPC2A/P Credit Memo Rows - Expenses46OcrCodeDistribution RulenVarChar80
170RPC3A/P Credit Memo - Freight53OcrCodeDistribution RulenVarChar80
171RPD1Goods Return - Rows42OcrCodeDistribution RulenVarChar80
172RPD13Goods Returns Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
173RPD2Goods Return - Freight - Rows46OcrCodeDistribution RulenVarChar80
174RPD3Goods Return - Freight53OcrCodeDistribution RulenVarChar80
175RRR1A/R Return Request - Rows42OcrCodeDistribution RulenVarChar80
176RRR13A/R Return Request - Distributed Freights54OcrCodeDistribution RulenVarChar80
177RRR2A/R Return Request - Freight - Rows46OcrCodeDistribution RulenVarChar80
178RRR3A/R Return Request - Freight53OcrCodeDistribution RulenVarChar80
179SFC1Self Credit Memo - Rows42OcrCodeDistribution RulenVarChar80
180SFC13Self Credit Memo Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
181SFC2Self Credit Memo - Freight - Rows46OcrCodeDistribution RulenVarChar80
182SFC3Self Credit Memo - Freight53OcrCodeDistribution RulenVarChar80
183SFI1Self Invoice - Rows42OcrCodeDistribution RulenVarChar80
184SFI13Self Invoice Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
185SFI2Self Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
186SFI3Self Invoice - Freight53OcrCodeDistribution RulenVarChar80
TOPSales Opportunities
187AOC1Distribution Rule - Rows1OcrCodeFactor CodenVarChar80
188AOCRDistribution Rule1OcrCodeFactor CodenVarChar80
189OCR1Distribution Rule - Rows1OcrCodeFactor CodenVarChar80
190OOCRDistribution Rule1OcrCodeFactor CodenVarChar80