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

128 columns | Print definition?B1 9.2  | 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
19SDRCDrag&Relate - Categories3VisOrderVisual orderInt60
20SDRFDrag&Relate - Files5VisOrderVisual orderInt60
21SDRODrag&Relate - Output fields4VisOrderVisual orderInt60
TOPInventory and Production
22AIN1Inventory Counting - Rows27VisOrderVisual OrderInt110
23AIN4Inventory Counting - Team Counters7VisOrderVisual OrderInt110
24AIN8Inventory Counting - Individual Counters7VisOrderVisual OrderInt110
25AIT11Asset Item Period Control4VisOrderVisual OrderInt110
26AIT7Asset Item Depreciation Params - History4VisOrderVisual OrderInt110
27AQI1Inventory Opening Balance - Rows36VisOrderVisual OrderInt110
28AQR1Inventory Posting - Rows42VisOrderVisual OrderInt110
29AWO1Production Order (Rows) - History9VisOrderVisual OrderInt110
30ICD1Inventory Counting Draft - Rows27VisOrderVisual OrderInt110
31ICD4Inventory Counting Draft - Team Counters7VisOrderVisual OrderInt110
32ICD8Inventory Counting Draft - Individual Counters7VisOrderVisual OrderInt110
33IGE1Goods Issue - Rows93VisOrderVisual OrderInt110
34IGE13Goods Issue Rows - Distributed Expenses49VisOrderVisual OrderInt110
35IGE2Goods Issue - Freight - Rows43VisOrderVisual OrderInt110
36IGN1Goods Receipt - Rows93VisOrderVisual OrderInt110
37IGN13Goods Receipt Rows - Distributed Expenses49VisOrderVisual OrderInt110
38IGN2Goods Receipt - Freight - Rows43VisOrderVisual OrderInt110
39INC1Inventory Counting - Rows27VisOrderVisual OrderInt110
40INC4Inventory Counting - Team Counters7VisOrderVisual OrderInt110
41INC8Inventory Counting - Individual Counters7VisOrderVisual OrderInt110
42IOD1Inventory Opening Balance Draft - Rows36VisOrderVisual OrderInt110
43IPD1Inventory Posting Draft - Rows42VisOrderVisual OrderInt110
44IQI1Inventory Opening Balance - Rows36VisOrderVisual OrderInt110
45IQR1Inventory Posting - Rows42VisOrderVisual OrderInt110
46ITM11Asset Item Period Control4VisOrderVisual OrderInt110
47ITM7Asset Item Depreciation Params4VisOrderVisual OrderInt110
48UWOR1Production Order - Rows9VisOrderVisual OrderInt110
49WOR1Production Order - Rows9VisOrderVisual OrderInt110
50WTQ1Inventory Transfer Request - Rows93VisOrderVisual OrderInt110
51WTQ13Inventory Transfer Request Rows - Distributed Freights49VisOrderVisual OrderInt110
52WTQ2Inventory Transfer Request - Freight - Rows43VisOrderVisual OrderInt110
53WTR1Inventory Transfer - Rows93VisOrderVisual OrderInt110
54WTR13Inventory Transfer Rows - Distributed Freights49VisOrderVisual OrderInt110
55WTR2Inventory Transfer - Freight - Rows43VisOrderVisual OrderInt110
TOPMarketing Documents
56ADO1A/R Invoice (Rows) - History93VisOrderVisual OrderInt110
57ADO13A/R Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
58ADO2A/R Invoice - Freight - Rows43VisOrderVisual OrderInt110
59CIN1Correction Invoice - Rows93VisOrderVisual OrderInt110
60CIN13Correction Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
61CIN2A/R Correction Invoice - Freight - Rows43VisOrderVisual OrderInt110
62CPI1A/P Correction Invoice - Rows93VisOrderVisual OrderInt110
63CPI13A/P Correction Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
64CPI2A/P Correction Invoice - Freight - Rows43VisOrderVisual OrderInt110
65CPV1A/P Correction Invoice Reversal - Rows93VisOrderVisual OrderInt110
66CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses49VisOrderVisual OrderInt110
67CPV2A/P Correction Invoice Reversal - Freight - Rows43VisOrderVisual OrderInt110
68CSI1A/R Correction Invoice - Rows93VisOrderVisual OrderInt110
69CSI13A/R Correction Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
70CSI2A/R Corr Inv - Freight - Rows43VisOrderVisual OrderInt110
71CSV1A/R Correction Invoice Reversal - Rows93VisOrderVisual OrderInt110
72CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses49VisOrderVisual OrderInt110
73CSV2A/R Correction Invoice Reversal - Freight - Rows43VisOrderVisual OrderInt110
74DLN1Delivery - Rows93VisOrderVisual OrderInt110
75DLN13Delivery Rows - Distributed Expenses49VisOrderVisual OrderInt110
76DLN2Delivery Notes - Freight - Rows43VisOrderVisual OrderInt110
77DPI1A/R Down Payment - Rows93VisOrderVisual OrderInt110
78DPI13A/R Down Payment Rows - Distributed Expenses49VisOrderVisual OrderInt110
79DPI2A/R Down Payment - Freight - Rows43VisOrderVisual OrderInt110
80DPO1A/P Down Payment - Rows93VisOrderVisual OrderInt110
81DPO13A/P Down Payment Rows - Distributed Expenses49VisOrderVisual OrderInt110
82DPO2A/P Down Payment - Freight - Rows43VisOrderVisual OrderInt110
83DRF1Draft - Rows93VisOrderVisual OrderInt110
84DRF13Draft Rows - Distributed Expenses49VisOrderVisual OrderInt110
85DRF2Draft - Freight - Rows43VisOrderVisual OrderInt110
86IEI1Incoming Excise Invoice - Rows93VisOrderVisual OrderInt110
87IEI13Incoming Excise Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
88IEI2Incoming Excise Invoice - Freight - History - Rows43VisOrderVisual OrderInt110
89INV1A/R Invoice - Rows93VisOrderVisual OrderInt110
90INV13A/R Invoice Rows - Distributed Freights49VisOrderVisual OrderInt110
91INV2A/R Invoice - Freight - Rows43VisOrderVisual OrderInt110
92OEI1Outgoing Excise Invoice - Rows93VisOrderVisual OrderInt110
93OEI13Outgoing Excise Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
94OEI2OEI - Freight Rows43VisOrderVisual OrderInt110
95PCH1A/P Invoice - Rows93VisOrderVisual OrderInt110
96PCH13A/P Invoice Rows - Distributed Expenses49VisOrderVisual OrderInt110
97PCH2A/P Invoice - Freight - Rows43VisOrderVisual OrderInt110
98PDN1Goods Receipt PO - Rows93VisOrderVisual OrderInt110
99PDN13Goods Receipt PO Rows - Distributed Expenses49VisOrderVisual OrderInt110
100PDN2Goods Receipt PO - Freight - Rows43VisOrderVisual OrderInt110
101POR1Purchase Order - Rows93VisOrderVisual OrderInt110
102POR13Purchase Order Rows - Distributed Expenses49VisOrderVisual OrderInt110
103POR2Purchase Order - Freight - Rows43VisOrderVisual OrderInt110
104PQT1Purchase Quotation - Rows93VisOrderVisual OrderInt110
105PQT13Purchase Quotation Rows - Distributed Expenses49VisOrderVisual OrderInt110
106PQT2Purchase Quotation - Freight - Rows43VisOrderVisual OrderInt110
107PRQ1Purchase Request - Rows93VisOrderVisual OrderInt110
108PRQ13Purchase Request Rows - Distributed Expenses49VisOrderVisual OrderInt110
109PRQ2Purchase Request - Freight - Rows43VisOrderVisual OrderInt110
110QUT1Sales Quotation - Rows93VisOrderVisual OrderInt110
111QUT13Sales Quotation Rows - Distributed Expenses49VisOrderVisual OrderInt110
112QUT2Sales Quotation - Freight - Rows43VisOrderVisual OrderInt110
113RDN1Returns - Rows93VisOrderVisual OrderInt110
114RDN13Returns Rows - Distributed Expenses49VisOrderVisual OrderInt110
115RDN2Return - Freight - Rows43VisOrderVisual OrderInt110
116RDR1Sales Order - Rows93VisOrderVisual OrderInt110
117RDR13Sales Order Rows - Distributed Expenses49VisOrderVisual OrderInt110
118RDR2Sales Order - Freight - Rows43VisOrderVisual OrderInt110
119RIN1A/R Credit Memo - Rows93VisOrderVisual OrderInt110
120RIN13A/R Credit Memo Rows - Distributed Expenses49VisOrderVisual OrderInt110
121RIN2A/R Credit Memo - Freight - Rows43VisOrderVisual OrderInt110
122RPC1A/P Credit Memo - Rows93VisOrderVisual OrderInt110
123RPC13A/P Credit Memo Rows - Distributed Expenses49VisOrderVisual OrderInt110
124RPC2A/P Credit Memo Rows - Expenses43VisOrderVisual OrderInt110
125RPD1Goods Return - Rows93VisOrderVisual OrderInt110
126RPD13Goods Returns Rows - Distributed Expenses49VisOrderVisual OrderInt110
127RPD2Goods Return - Freight - Rows43VisOrderVisual OrderInt110
TOPReports
128EJB2Docs List for ERV-JAb Wizard9VisOrderVisual OrderInt110