SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

87 columns | Print definition?B1 8.8  | BASELINE

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