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

185 columns | Print definition?B1 9.3  | VISORDER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1APJ1Project Plan Steps4VisOrderVisual OrderInt110
2CDRODrag & Relate - Output Fields4VisOrderVisual OrderInt600
3OUPTUser Autorization Tree5VisOrderDisplay OrderInt60
4PJT1Project Plan Steps4VisOrderVisual OrderInt110
5UPT1User Authorization Tree - Extended Permission3VisOrderDisplay OrderInt60
TOPBanking
6OBNKExternal Bank Statement Received23VisOrderVisual OrderInt110
TOPBusiness Partners
7ACP1Campaign - BPs19VisOrderVisual OrderInt110
8ACP2Campaign - Items8VisOrderVisual OrderInt110
9ACP3Campaign - Partners8VisOrderVisual OrderInt110
10AOA1Blanket Agreement - Rows15VisOrderVisual OrderInt110
11CPN1Campaign - BPs19VisOrderVisual OrderInt110
12CPN2Campaign - Items8VisOrderVisual OrderInt110
13CPN3Campaign - Partners8VisOrderVisual OrderInt110
14OAT1Blanket Agreement - Rows15VisOrderVisual OrderInt110
TOPFinance
15FAC2Fixed Asset Parameter Change - Period Control Change5VisOrderVisual OrderInt110
16FRC1Extend Cat. f. Financial Rep.4VisOrderDisplay OrderInt60
17OFRCFinancial Report Categories9VisOrderDisplay OrderInt60
TOPGeneral
18NFN5NF Skipped Numbers8VisOrderVisual OrderInt60
19OFLRObject Filter5VisOrderVisible OrderInt60
20SDRCDrag&Relate - Categories3VisOrderVisual orderInt60
21SDRFDrag&Relate - Files5VisOrderVisual orderInt60
22SDRODrag&Relate - Output fields4VisOrderVisual orderInt60
23TTP1ToolTip Preview - Rows4VisOrderVisual OrderInt110
TOPInventory and Production
24AIN1Inventory Counting - Rows27VisOrderVisual OrderInt110
25AIN4Inventory Counting - Team Counters7VisOrderVisual OrderInt110
26AIN8Inventory Counting - Individual Counters7VisOrderVisual OrderInt110
27AIT11Asset Item Period Control4VisOrderVisual OrderInt110
28AIT7Asset Item Depreciation Params - History4VisOrderVisual OrderInt110
29AQI1Inventory Opening Balance - Rows36VisOrderVisual OrderInt110
30AQR1Inventory Posting - Rows42VisOrderVisual OrderInt110
31ATT1Bill of Materials - Components - History3VisOrderVisual OrderInt110
32AWO1Production Order (Rows) - History9VisOrderVisual OrderInt110
33ICD1Inventory Counting Draft - Rows27VisOrderVisual OrderInt110
34ICD4Inventory Counting Draft - Team Counters7VisOrderVisual OrderInt110
35ICD8Inventory Counting Draft - Individual Counters7VisOrderVisual OrderInt110
36IGE1Goods Issue - Rows93VisOrderVisual OrderInt110
37IGE13Goods Issue Rows - Distributed Expenses49VisOrderVisual OrderInt110
38IGE2Goods Issue - Freight - Rows43VisOrderVisual OrderInt110
39IGN1Goods Receipt - Rows93VisOrderVisual OrderInt110
40IGN13Goods Receipt Rows - Distributed Expenses49VisOrderVisual OrderInt110
41IGN2Goods Receipt - Freight - Rows43VisOrderVisual OrderInt110
42INC1Inventory Counting - Rows27VisOrderVisual OrderInt110
43INC4Inventory Counting - Team Counters7VisOrderVisual OrderInt110
44INC8Inventory Counting - Individual Counters7VisOrderVisual OrderInt110
45IOD1Inventory Opening Balance Draft - Rows36VisOrderVisual OrderInt110
46IPD1Inventory Posting Draft - Rows42VisOrderVisual OrderInt110
47IQI1Inventory Opening Balance - Rows36VisOrderVisual OrderInt110
48IQR1Inventory Posting - Rows42VisOrderVisual OrderInt110
49ITM11Asset Item Period Control4VisOrderVisual OrderInt110
50ITM7Asset Item Depreciation Params4VisOrderVisual OrderInt110
51ITT1Bill of Materials - Components3VisOrderVisual OrderInt110
52UWOR1Production Order - Rows9VisOrderVisual OrderInt110
53WOR1Production Order - Rows9VisOrderVisual OrderInt110
54WTQ1Inventory Transfer Request - Rows93VisOrderVisual OrderInt110
55WTQ13Inventory Transfer Request Rows - Distributed Freights49VisOrderVisual OrderInt110
56WTQ2Inventory Transfer Request - Freight - Rows43VisOrderVisual OrderInt110
57WTR1Inventory Transfer - Rows93VisOrderVisual OrderInt110
58WTR13Inventory Transfer Rows - Distributed Freights49VisOrderVisual OrderInt110
59WTR2Inventory Transfer - Freight - Rows43VisOrderVisual OrderInt110
TOPMarketing Documents
60ADO1A/R Invoice (Rows) - History93VisOrderVisual OrderInt110
61ADO13A/R Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
62ADO2A/R Invoice - Freight - Rows43VisOrderVisual OrderInt110
63ADO23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
64CIN1Correction Invoice - Rows93VisOrderVisual OrderInt110
65CIN13Correction Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
66CIN2A/R Correction Invoice - Freight - Rows43VisOrderVisual OrderInt110
67CIN23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
68CPI1A/P Correction Invoice - Rows93VisOrderVisual OrderInt110
69CPI13A/P Correction Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
70CPI2A/P Correction Invoice - Freight - Rows43VisOrderVisual OrderInt110
71CPI23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
72CPV1A/P Correction Invoice Reversal - Rows93VisOrderVisual OrderInt110
73CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses49VisOrderVisual OrderInt110
74CPV2A/P Correction Invoice Reversal - Freight - Rows43VisOrderVisual OrderInt110
75CPV23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
76CSI1A/R Correction Invoice - Rows93VisOrderVisual OrderInt110
77CSI13A/R Correction Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
78CSI2A/R Corr Inv - Freight - Rows43VisOrderVisual OrderInt110
79CSI23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
80CSV1A/R Correction Invoice Reversal - Rows93VisOrderVisual OrderInt110
81CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses49VisOrderVisual OrderInt110
82CSV2A/R Correction Invoice Reversal - Freight - Rows43VisOrderVisual OrderInt110
83CSV23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
84DLN1Delivery - Rows93VisOrderVisual OrderInt110
85DLN13Delivery Rows - Distributed Expenses49VisOrderVisual OrderInt110
86DLN2Delivery Notes - Freight - Rows43VisOrderVisual OrderInt110
87DLN23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
88DOC23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
89DPI1A/R Down Payment - Rows93VisOrderVisual OrderInt110
90DPI13A/R Down Payment Rows - Distributed Expenses49VisOrderVisual OrderInt110
91DPI2A/R Down Payment - Freight - Rows43VisOrderVisual OrderInt110
92DPI23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
93DPO1A/P Down Payment - Rows93VisOrderVisual OrderInt110
94DPO13A/P Down Payment Rows - Distributed Expenses49VisOrderVisual OrderInt110
95DPO2A/P Down Payment - Freight - Rows43VisOrderVisual OrderInt110
96DPO23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
97DRF1Draft - Rows93VisOrderVisual OrderInt110
98DRF13Draft Rows - Distributed Expenses49VisOrderVisual OrderInt110
99DRF2Draft - Freight - Rows43VisOrderVisual OrderInt110
100DRF23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
101IEI1Incoming Excise Invoice - Rows93VisOrderVisual OrderInt110
102IEI13Incoming Excise Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
103IEI2Incoming Excise Invoice - Freight - History - Rows43VisOrderVisual OrderInt110
104IEI23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
105IGE23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
106IGN23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
107INV1A/R Invoice - Rows93VisOrderVisual OrderInt110
108INV13A/R Invoice Rows - Distributed Freights49VisOrderVisual OrderInt110
109INV2A/R Invoice - Freight - Rows43VisOrderVisual OrderInt110
110INV23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
111OEI1Outgoing Excise Invoice - Rows93VisOrderVisual OrderInt110
112OEI13Outgoing Excise Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
113OEI2OEI - Freight Rows43VisOrderVisual OrderInt110
114OEI23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
115PCH1A/P Invoice - Rows93VisOrderVisual OrderInt110
116PCH13A/P Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
117PCH2A/P Invoice - Freight - Rows43VisOrderVisual OrderInt110
118PCH23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
119PDN1Goods Receipt PO - Rows93VisOrderVisual OrderInt110
120PDN13Goods Receipt PO Rows - Distributed Expenses49VisOrderVisual OrderInt110
121PDN2Goods Receipt PO - Freight - Rows43VisOrderVisual OrderInt110
122PDN23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
123POR1Purchase Order - Rows93VisOrderVisual OrderInt110
124POR13Purchase Order Rows - Distributed Expenses49VisOrderVisual OrderInt110
125POR2Purchase Order - Freight - Rows43VisOrderVisual OrderInt110
126POR23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
127PQT1Purchase Quotation - Rows93VisOrderVisual OrderInt110
128PQT13Purchase Quotation Rows - Distributed Expenses49VisOrderVisual OrderInt110
129PQT2Purchase Quotation - Freight - Rows43VisOrderVisual OrderInt110
130PQT23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
131PRQ1Purchase Request - Rows93VisOrderVisual OrderInt110
132PRQ13Purchase Request Rows - Distributed Expenses49VisOrderVisual OrderInt110
133PRQ2Purchase Request - Freight - Rows43VisOrderVisual OrderInt110
134PRQ23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
135PRR1A/P Return Request - Rows93VisOrderVisual OrderInt110
136PRR13A/P Return Request - Distributed Freights49VisOrderVisual OrderInt110
137PRR2A/P Return Request - Freight - Rows43VisOrderVisual OrderInt110
138PRR23A/P Return Request - Selected Asset Master Data9VisOrderVisual OrderInt110
139QUT1Sales Quotation - Rows93VisOrderVisual OrderInt110
140QUT13Sales Quotation Rows - Distributed Expenses49VisOrderVisual OrderInt110
141QUT2Sales Quotation - Freight - Rows43VisOrderVisual OrderInt110
142QUT23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
143RDN1Returns - Rows93VisOrderVisual OrderInt110
144RDN13Returns Rows - Distributed Expenses49VisOrderVisual OrderInt110
145RDN2Return - Freight - Rows43VisOrderVisual OrderInt110
146RDN23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
147RDR1Sales Order - Rows93VisOrderVisual OrderInt110
148RDR13Sales Order Rows - Distributed Expenses49VisOrderVisual OrderInt110
149RDR2Sales Order - Freight - Rows43VisOrderVisual OrderInt110
150RDR23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
151RIN1A/R Credit Memo - Rows93VisOrderVisual OrderInt110
152RIN13A/R Credit Memo Rows - Distributed Expenses49VisOrderVisual OrderInt110
153RIN2A/R Credit Memo - Freight - Rows43VisOrderVisual OrderInt110
154RIN23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
155RPC1A/P Credit Memo - Rows93VisOrderVisual OrderInt110
156RPC13A/P Credit Memo Rows - Distributed Expenses49VisOrderVisual OrderInt110
157RPC2A/P Credit Memo Rows - Expenses43VisOrderVisual OrderInt110
158RPC23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
159RPD1Goods Return - Rows93VisOrderVisual OrderInt110
160RPD13Goods Returns Rows - Distributed Expenses49VisOrderVisual OrderInt110
161RPD2Goods Return - Freight - Rows43VisOrderVisual OrderInt110
162RPD23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
163RRR1A/R Return Request - Rows93VisOrderVisual OrderInt110
164RRR13A/R Return Request - Distributed Freights49VisOrderVisual OrderInt110
165RRR2A/R Return Request - Freight - Rows43VisOrderVisual OrderInt110
166RRR23A/R Return Request - Selected Asset Master Data9VisOrderVisual OrderInt110
167SFC1Self Credit Memo - Rows93VisOrderVisual OrderInt110
168SFC13Self Credit Memo Rows - Distributed Freights49VisOrderVisual OrderInt110
169SFC2Self Credit Memo - Freight - Rows43VisOrderVisual OrderInt110
170SFC23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
171SFI1Self Invoice - Rows93VisOrderVisual OrderInt110
172SFI13Self Invoice Rows - Distributed Freights49VisOrderVisual OrderInt110
173SFI2Self Invoice - Freight - Rows43VisOrderVisual OrderInt110
174SFI23Self Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
175WTQ23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
176WTR23A/P Invoice - Selected Asset Master Data9VisOrderVisual OrderInt110
TOPReports
177EJB2Docs List for ERV-JAb Wizard9VisOrderVisual OrderInt110
TOPService
178ASC2Service Call Inventory Expenses - History18VisOrderVisual OrderInt110
179ASC3Service Call Travel/Labor Expenses - History18VisOrderVisual OrderInt110
180ASC4Service Call Travel/Labor Expenses - History15VisOrderVisual OrderInt110
181ASC5Service Call Activities - History10VisOrderVisual OrderInt110
182SCL2Service Call Inventory Expenses18VisOrderVisual OrderInt110
183SCL3Service Call Travel/Labor Expenses18VisOrderVisual OrderInt110
184SCL4Expense Documents15VisOrderVisual OrderInt110
185SCL5Service Call Activities10VisOrderVisual OrderInt110