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

169 columns | Print definition?B1 9.2  | 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
26OMDRManual Distribution Rule1OcrCodeFactor CodenVarChar80
27RCR1Recurring Postings - Rows13OcrCodeDistr. RulenVarChar80
28RTI1Retirement - Rows18OcrCodeDistribution RulenVarChar80
29TRT1Posting Templates - Rows11OcrCodeDistr. RulenVarChar80
TOPInventory and Production
30AIN1Inventory Counting - Rows24OcrCodeDistribution Rule CodenVarChar80
31AIT6Asset Item Distribution Rules5OcrCodeDistribution RulenVarChar80
32AITTProduct Tree - History17OcrCodeDistribution RulenVarChar80
33AMR1Inventory Revaluation - History - Rows17OcrCodeDistribution RulenVarChar80
34AQI1Inventory Opening Balance - Rows13OcrCodeDistribution RulenVarChar80
35AQR1Inventory Posting - Rows13OcrCodeDistribution RulenVarChar80
36ATT1Bill of Materials - Components - History16OcrCodeDistribution RulenVarChar80
37AWO1Production Order (Rows) - History12OcrCodeDistribution RulenVarChar80
38AWORProduction Order - History28OcrCodeDistribution RulenVarChar80
39ICD1Inventory Counting Draft - Rows24OcrCodeDistribution Rule CodenVarChar80
40IGE1Goods Issue - Rows42OcrCodeDistribution RulenVarChar80
41IGE13Goods Issue Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
42IGE2Goods Issue - Freight - Rows46OcrCodeDistribution RulenVarChar80
43IGE3Goods Issue - Freight53OcrCodeDistribution RulenVarChar80
44IGN1Goods Receipt - Rows42OcrCodeDistribution RulenVarChar80
45IGN13Goods Receipt Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
46IGN2Goods Receipt - Freight - Rows46OcrCodeDistribution RulenVarChar80
47IGN3Goods Receipt - Freight53OcrCodeDistribution RulenVarChar80
48INC1Inventory Counting - Rows24OcrCodeDistribution Rule CodenVarChar80
49IOD1Inventory Opening Balance Draft - Rows13OcrCodeDistribution RulenVarChar80
50IPD1Inventory Posting Draft - Rows13OcrCodeDistribution RulenVarChar80
51IPF1Landed Costs - Rows68OcrCodeDistribution RulenVarChar80
52IQI1Inventory Opening Balance - Rows13OcrCodeDistribution RulenVarChar80
53IQR1Inventory Posting - Rows13OcrCodeDistribution RulenVarChar80
54ITM6Asset Item Distribution Rules5OcrCodeDistribution RulenVarChar80
55ITT1Bill of Materials - Components16OcrCodeDistribution RulenVarChar80
56MRV1Inventory Revaluation Information Array17OcrCodeDistribution RulenVarChar80
57OAIMArchive Inventory Message25OcrCodeDistribution RulenVarChar80
58OILMInventory Log Message35OcrCodeDistribution RulenVarChar80
59OITTProduct Tree17OcrCodeDistribution RulenVarChar80
60OWORProduction Order28OcrCodeDistribution RulenVarChar80
61UILMIVI Inventory Log Message35OcrCodeDistribution RulenVarChar80
62UWORProduction Order28OcrCodeDistribution RulenVarChar80
63UWOR1Production Order - Rows12OcrCodeDistribution RulenVarChar80
64WOR1Production Order - Rows12OcrCodeDistribution RulenVarChar80
65WTQ1Inventory Transfer Request - Rows42OcrCodeProfit CenternVarChar80
66WTQ13Inventory Transfer Request Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
67WTQ2Inventory Transfer Request - Freight - Rows46OcrCodeDistribution RulenVarChar80
68WTQ3Inventory Transfer Request - Freight53OcrCodeDistribution RulenVarChar80
69WTR1Inventory Transfer - Rows42OcrCodeCosting CodenVarChar80
70WTR13Inventory Transfer Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
71WTR2Inventory Transfer - Freight - Rows46OcrCodeDistribution RulenVarChar80
72WTR3Inventory Transfer - Freight53OcrCodeDistribution RulenVarChar80
TOPMarketing Documents
73ADO1A/R Invoice (Rows) - History42OcrCodeDistribution RulenVarChar80
74ADO13A/R Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
75ADO2A/R Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
76ADO3A/R Invoice - Freight - History53OcrCodeDistribution RulenVarChar80
77CIN1Correction Invoice - Rows42OcrCodeCosting CodenVarChar80
78CIN13Correction Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
79CIN2A/R Correction Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
80CIN3A/R Correction Invoice - Freight53OcrCodeDistribution RulenVarChar80
81CPI1A/P Correction Invoice - Rows42OcrCodeDistribution RulenVarChar80
82CPI13A/P Correction Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
83CPI2A/P Correction Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
84CPI3A/P Correction Invoice - Freight53OcrCodeDistribution RulenVarChar80
85CPV1A/P Correction Invoice Reversal - Rows42OcrCodeDistribution RulenVarChar80
86CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
87CPV2A/P Correction Invoice Reversal - Freight - Rows46OcrCodeDistribution RulenVarChar80
88CPV3A/P Correction Invoice Reversal - Freight53OcrCodeDistribution RulenVarChar80
89CSI1A/R Correction Invoice - Rows42OcrCodeDistribution RulenVarChar80
90CSI13A/R Correction Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
91CSI2A/R Corr Inv - Freight - Rows46OcrCodeDistribution RulenVarChar80
92CSI3A/R Correction Invoice - Freight53OcrCodeDistribution RulenVarChar80
93CSV1A/R Correction Invoice Reversal - Rows42OcrCodeDistribution RulenVarChar80
94CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
95CSV2A/R Correction Invoice Reversal - Freight - Rows46OcrCodeDistribution RulenVarChar80
96CSV3A/R Correction Invoice Reversal - Freight53OcrCodeDistribution RulenVarChar80
97DLN1Delivery - Rows42OcrCodeDistribution RulenVarChar80
98DLN13Delivery Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
99DLN2Delivery Notes - Freight - Rows46OcrCodeDistribution RulenVarChar80
100DLN3Delivery Notes - Freight53OcrCodeDistribution RulenVarChar80
101DPI1A/R Down Payment - Rows42OcrCodeDistribution RulenVarChar80
102DPI13A/R Down Payment Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
103DPI2A/R Down Payment - Freight - Rows46OcrCodeDistribution RulenVarChar80
104DPI3A/R Down Payment - Freight53OcrCodeDistribution RulenVarChar80
105DPO1A/P Down Payment - Rows42OcrCodeDistribution RulenVarChar80
106DPO13A/P Down Payment Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
107DPO2A/P Down Payment - Freight - Rows46OcrCodeDistribution RulenVarChar80
108DPO3A/P Down Payment - Freight53OcrCodeDistribution RulenVarChar80
109DRF1Draft - Rows42OcrCodeDistribution RulenVarChar80
110DRF13Draft Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
111DRF2Draft - Freight - Rows46OcrCodeDistribution RulenVarChar80
112DRF3Draft - Freight53OcrCodeDistribution RulenVarChar80
113IEI1Incoming Excise Invoice - Rows42OcrCodeDistribution RulenVarChar80
114IEI13Incoming Excise Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
115IEI2Incoming Excise Invoice - Freight - History - Rows46OcrCodeDistribution RulenVarChar80
116IEI3IEI - Freight53OcrCodeDistribution RulenVarChar80
117INV1A/R Invoice - Rows42OcrCodeDistribution RulenVarChar80
118INV13A/R Invoice Rows - Distributed Freights54OcrCodeDistribution RulenVarChar80
119INV2A/R Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
120INV3A/R Invoice - Freight53OcrCodeDistribution RulenVarChar80
121ODWZDunning Wizard25OcrCodeCosting CodenVarChar80
122OEI1Outgoing Excise Invoice - Rows42OcrCodeDistribution RulenVarChar80
123OEI13Outgoing Excise Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
124OEI2OEI - Freight Rows46OcrCodeDistribution RulenVarChar80
125OEI3OEI - Freight53OcrCodeDistribution RulenVarChar80
126PCH1A/P Invoice - Rows42OcrCodeDistribution RulenVarChar80
127PCH13A/P Invoice Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
128PCH2A/P Invoice - Freight - Rows46OcrCodeDistribution RulenVarChar80
129PCH3A/P Invoice - Freight53OcrCodeDistribution RulenVarChar80
130PDN1Goods Receipt PO - Rows42OcrCodeDistribution RulenVarChar80
131PDN13Goods Receipt PO Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
132PDN2Goods Receipt PO - Freight - Rows46OcrCodeDistribution RulenVarChar80
133PDN3Goods Receipt PO - Freight53OcrCodeDistribution RulenVarChar80
134POR1Purchase Order - Rows42OcrCodeDistribution RulenVarChar80
135POR13Purchase Order Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
136POR2Purchase Order - Freight - Rows46OcrCodeDistribution RulenVarChar80
137POR3Purchase Order - Freight53OcrCodeDistribution RulenVarChar80
138PQT1Purchase Quotation - Rows42OcrCodeDistribution RulenVarChar80
139PQT13Purchase Quotation Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
140PQT2Purchase Quotation - Freight - Rows46OcrCodeDistribution RulenVarChar80
141PQT3Purchase Quotation - Freight53OcrCodeDistribution RulenVarChar80
142PRQ1Purchase Request - Rows42OcrCodeDistribution RulenVarChar80
143PRQ13Purchase Request Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
144PRQ2Purchase Request - Freight - Rows46OcrCodeDistribution RulenVarChar80
145PRQ3Purchase Request - Freight53OcrCodeDistribution RulenVarChar80
146QUT1Sales Quotation - Rows42OcrCodeDistribution RulenVarChar80
147QUT13Sales Quotation Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
148QUT2Sales Quotation - Freight - Rows46OcrCodeDistribution RulenVarChar80
149QUT3Sales Quotation - Freight53OcrCodeDistribution RulenVarChar80
150RDN1Returns - Rows42OcrCodeCosting CodenVarChar80
151RDN13Returns Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
152RDN2Return - Freight - Rows46OcrCodeDistribution RulenVarChar80
153RDN3Return - Freight53OcrCodeDistribution RulenVarChar80
154RDR1Sales Order - Rows42OcrCodeDistribution RulenVarChar80
155RDR13Sales Order Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
156RDR2Sales Order - Freight - Rows46OcrCodeDistribution RulenVarChar80
157RDR3Sales Order - Freight53OcrCodeDistribution RulenVarChar80
158RIN1A/R Credit Memo - Rows42OcrCodeDistribution RulenVarChar80
159RIN13A/R Credit Memo Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
160RIN2A/R Credit Memo - Freight - Rows46OcrCodeDistribution RulenVarChar80
161RIN3A/R Credit Memo - Freight53OcrCodeDistribution RulenVarChar80
162RPC1A/P Credit Memo - Rows42OcrCodeDistribution RulenVarChar80
163RPC13A/P Credit Memo Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
164RPC2A/P Credit Memo Rows - Expenses46OcrCodeDistribution RulenVarChar80
165RPC3A/P Credit Memo - Freight53OcrCodeDistribution RulenVarChar80
166RPD1Goods Return - Rows42OcrCodeDistribution RulenVarChar80
167RPD13Goods Returns Rows - Distributed Expenses54OcrCodeDistribution RulenVarChar80
168RPD2Goods Return - Freight - Rows46OcrCodeDistribution RulenVarChar80
169RPD3Goods Return - Freight53OcrCodeDistribution RulenVarChar80