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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
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
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

96 columns | Print definition?B1 8.82  | BASELINE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1AJD2Withholding Tax - History20BaseLineBase RowInt110
2BTF2Journal Voucher Withholding Tax - History20BaseLineBase RowInt110
3JDT2Withholding Tax - History20BaseLineBase RowInt110
4JST1TDS Adjustment - Rows6BaseLineBase RowInt110
TOPInventory and Production
5AMR2Inventory Revaluation FIFO Rows (Archive)2BaseLineBase Row NumberInt110
6AWO2Production Order - Base4BaseLineProduction Order Base LineInt110
7IGE1Goods Issue - Rows8BaseLineBase RowInt110
8IGE5Goods Issue - Withholding Tax20BaseLineBase LineInt110
9IGE9Goods Issue - Drawn Dpm4BaseLineBase Document RowInt110
10IGN1Goods Receipt - Rows8BaseLineBase RowInt110
11IGN5Goods Receipt - Withholding Tax20BaseLineBase LineInt110
12IGN9Goods Receipt - Drawn Dpm4BaseLineBase Document RowInt110
13MRV2Inventory Revaluation FIFO Rows2BaseLineBase Row NumberInt110
14OAIMArchive Inventory Message22BaseLineBase Row NumberInt110-1
15OILMInventory Log Message30BaseLineBase Line NumberInt110-1
16OINMWhse Journal55BaseLineBase Row NumberInt110-1
17OITLInventory Transactions Log11BaseLineBase Document Row NumberInt110-1
18UILMIVI Inventory Log Message30BaseLineBase Row NumberInt110-1
19UWO2Production Order - Base4BaseLineProduction Order Base LineInt110
20WOR2Production Order - Base4BaseLineProduction Order Base LineInt110
21WTQ1Inventory Transfer Request - Rows8BaseLineBase RowInt110
22WTQ5Inventory Transfer Request - Withholding Tax20BaseLineBase LineInt110
23WTQ9Inventory Transfer Request - Drawn DPM4BaseLineBase Document RowInt110
24WTR1Inventory Transfer - Rows8BaseLineBase RowInt110
25WTR5Inventory Transfer - Withholding Tax20BaseLineBase LineInt110
26WTR9Inventory Transfer - Drawn Dpm4BaseLineBase Document RowInt110
TOPMarketing Documents
27ADO1A/R Invoice (Rows) - History8BaseLineBase RowInt110
28ADO5Withholding Tax - History20BaseLineBase LineInt110
29ADO9A/R Invoice (Rows) - History4BaseLineBase Document RowInt110
30CIN1Correction Invoice - Rows8BaseLineBase RowInt110
31CIN5AR Correction Invoice - Withholding Tax20BaseLineBase LineInt110
32CIN9Correction Invoice - Drawn Dpm4BaseLineBase Document RowInt110
33CPI1A/P Correction Invoice - Rows8BaseLineBase RowInt110
34CPI5Withholding Tax Data20BaseLineBase LineInt110
35CPI9A/P Corr. Invoice - Drawn Dpm4BaseLineBase Document RowInt110
36CPV1A/P Correction Invoice Reversal - Rows8BaseLineBase RowInt110
37CPV5A/P Correction Invoice Reversal - WTax20BaseLineBase LineInt110
38CPV9A/P Corr Inv Rvrsl - Drawn Dpm4BaseLineBase Document RowInt110
39CSI1A/R Correction Invoice - Rows8BaseLineBase RowInt110
40CSI5A/R Correction Invoice - Withholding Tax20BaseLineBase LineInt110
41CSI9A/R Corr. Inv. - Drawn Dpm4BaseLineBase Document RowInt110
42CSV1A/R Correction Invoice Reversal - Rows8BaseLineBase RowInt110
43CSV5A/R Correction Invoice Reversal - WTax20BaseLineBase LineInt110
44CSV9A/R CrIn Rev - Drawn Dpm4BaseLineBase Document RowInt110
45DLN1Delivery - Rows8BaseLineBase RowInt110
46DLN5Delivery - Withholding Tax20BaseLineBase RowInt110
47DLN9Delivery - Drawn Dpm4BaseLineBase Document RowInt110
48DPI1A/R Down Payment - Rows8BaseLineBase RowInt110
49DPI5A/R Down Payment - Withholding Tax20BaseLineBase LineInt110
50DPI9Down Payment Incoming - Drawn Dpm4BaseLineBase Document RowInt110
51DPO1A/P Down Payment - Rows8BaseLineBase RowInt110
52DPO5A/P Down Payment - Withholding Tax20BaseLineBase LineInt110
53DPO9Down Payment Outgoing - Drawn Dpm4BaseLineBase Document RowInt110
54DRF1Draft - Rows8BaseLineBase RowInt110
55DRF5Draft Documents - Withholding Tax20BaseLineBase LineInt110
56DRF9Document Draft - Drawn Dpm4BaseLineBase Document RowInt110
57IEI1Incoming Excise Invoice - Rows8BaseLineBase RowInt110
58IEI5Incoming Excise Invoice - Withholding Tax20BaseLineBase RowInt110
59IEI9IEI - Drawn Dpm4BaseLineBase Document RowInt110
60INV1A/R Invoice - Rows8BaseLineBase RowInt110
61INV5A/R Invoice - Withholding Tax20BaseLineBase RowInt110
62INV9A/R Invoice - Drawn Dpm4BaseLineBase Document RowInt110
63OEI1Outgoing Excise Invoice - Rows8BaseLineBase RowInt110
64OEI5Outgoing Excise Invoice - Withholding Tax20BaseLineBase RowInt110
65OEI9OEI - Drawn Dpm4BaseLineBase Document RowInt110
66PCH1A/P Invoice - Rows8BaseLineBase RowInt110
67PCH5A/P Invoice - Withholding Tax Data20BaseLineBase LineInt110
68PCH9A/P Invoice - Drawn Dpm4BaseLineBase Document RowInt110
69PDN1Goods Receipt PO - Rows8BaseLineBase RowInt110
70PDN5Goods Reciept PO - Withholding Tax20BaseLineBase LineInt110
71PDN9Goods Receipt PO - Drawn Dpm4BaseLineBase Document RowInt110
72POR1Purchase Order - Rows8BaseLineBase RowInt110
73POR5Purchase Order - Withholding Tax20BaseLineBase LineInt110
74POR9Purchase Order - Drawn Dpm4BaseLineBase Document RowInt110
75PQT1Purchase Quotation - Rows8BaseLineBase RowInt110
76PQT5Purchase Quotation - Withholding Tax20BaseLineBase LineInt110
77PQT9Purchase Quotation - Drawn DPM4BaseLineBase Document RowInt110
78QUT1Sales Quotation - Rows8BaseLineBase RowInt110
79QUT5Sales Quotation - Tax20BaseLineBase LineInt110
80QUT9Sales Quotation - Drawn Dpm4BaseLineBase Document RowInt110
81RDN1Returns - Rows8BaseLineBase RowInt110
82RDN5Returns - Withholding Tax20BaseLineBase LineInt110
83RDN9Returns - Drawn Dpm4BaseLineBase Document RowInt110
84RDR1Sales Order - Rows8BaseLineBase RowInt110
85RDR5Sales Order - Withholding Tax20BaseLineBase LineInt110
86RDR9Order - Drawn Dpm4BaseLineBase Document RowInt110
87RIN1A/R Credit Memo - Rows8BaseLineBase RowInt110
88RIN5A/R Credit Memo - Withholding Tax20BaseLineBase LineInt110
89RIN9A/R Credit Memo - Drawn Dpm4BaseLineBase Document RowInt110
90RPC1A/P Credit Memo - Rows8BaseLineBase RowInt110
91RPC5A/P Credit Memo - Withholding Tax20BaseLineBase LineInt110
92RPC9A/P Credit Memo - Drawn Dpm4BaseLineBase Document RowInt110
93RPD1Goods Return - Rows8BaseLineBase RowInt110
94RPD5Goods Return - Withholding Tax Data20BaseLineBase LineInt110
95RPD9Goods Return - Drawn Dpm4BaseLineBase Document RowInt110
TOPMRP
96MSN3MRP Pegging Information6BaseLineBase RowInt110