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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

122 columns | Print definition?B1 9.2  | BASEABSENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1AJD2Withholding Tax - History19BaseAbsEntBase Document ReferenceInt110-1
2BTF2Journal Voucher Withholding Tax - History19BaseAbsEntBase Document ReferenceInt110-1
3JDT2Withholding Tax - History19BaseAbsEntBase Document ReferenceInt110-1
TOPGeneral
4ORCJResource Capacity Log11BaseAbsEntBase Absolute EntryInt110
TOPInventory and Production
5IGE13Goods Issue Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
6IGE3Goods Issue - Freight40BaseAbsEntBase Abs EntryInt110-1
7IGE5Goods Issue - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
8IGN13Goods Receipt Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
9IGN3Goods Receipt - Freight40BaseAbsEntBase Abs EntryInt110-1
10IGN5Goods Receipt - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
11ILM3Non-Inventory and Resource Components Log Msg10BaseAbsEntAbs. Entry of Base Doc.Int110-1
12OAIMArchive Inventory Message11BaseAbsEntInternal No. of Base DocInt110
13OILMInventory Log Message12BaseAbsEntAbs Entry of Base DocInt110
14UILMIVI Inventory Log Message12BaseAbsEntInternal ID of Base DocumentInt110
15UILM3Non-Inventory and Resource Components Log Msg10BaseAbsEntAbs. Entry of Base Doc.Int110-1
16WTQ13Inventory Transfer Request Rows - Distributed Freights40BaseAbsEntBase Abs EntryInt110-1
17WTQ3Inventory Transfer Request - Freight40BaseAbsEntBase Abs EntryInt110-1
18WTQ5Inventory Transfer Request - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
19WTR13Inventory Transfer Rows - Distributed Freights40BaseAbsEntBase Abs EntryInt110-1
20WTR3Inventory Transfer - Freight40BaseAbsEntBase Abs EntryInt110-1
21WTR5Inventory Transfer - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
TOPMarketing Documents
22ADO13A/R Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
23ADO20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
24ADO3A/R Invoice - Freight - History40BaseAbsEntBase Abs EntryInt110-1
25ADO5Withholding Tax - History19BaseAbsEntBase Abs EntryInt110-1
26CIN13Correction Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
27CIN20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
28CIN3A/R Correction Invoice - Freight40BaseAbsEntBase Abs EntryInt110-1
29CIN5AR Correction Invoice - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
30CPI13A/P Correction Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
31CPI20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
32CPI3A/P Correction Invoice - Freight40BaseAbsEntBase Abs EntryInt110-1
33CPI5Withholding Tax Data19BaseAbsEntBase Abs EntryInt110-1
34CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
35CPV20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
36CPV3A/P Correction Invoice Reversal - Freight40BaseAbsEntBase Abs EntryInt110-1
37CPV5A/P Correction Invoice Reversal - WTax19BaseAbsEntBase Abs EntryInt110-1
38CSI13A/R Correction Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
39CSI20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
40CSI3A/R Correction Invoice - Freight40BaseAbsEntBase Abs EntryInt110-1
41CSI5A/R Correction Invoice - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
42CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
43CSV20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
44CSV3A/R Correction Invoice Reversal - Freight40BaseAbsEntBase Abs EntryInt110-1
45CSV5A/R Correction Invoice Reversal - WTax19BaseAbsEntBase Abs EntryInt110-1
46DLN13Delivery Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
47DLN20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
48DLN3Delivery Notes - Freight40BaseAbsEntBase Abs EntryInt110-1
49DLN5Delivery - Withholding Tax19BaseAbsEntBase Document Internal No.Int110-1
50DOC20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
51DPI13A/R Down Payment Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
52DPI20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
53DPI3A/R Down Payment - Freight40BaseAbsEntBase Abs EntryInt110-1
54DPI5A/R Down Payment - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
55DPO13A/P Down Payment Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
56DPO20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
57DPO3A/P Down Payment - Freight40BaseAbsEntBase Abs EntryInt110-1
58DPO5A/P Down Payment - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
59DRF13Draft Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
60DRF20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
61DRF3Draft - Freight40BaseAbsEntBase Abs EntryInt110-1
62DRF5Draft Documents - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
63IEI13Incoming Excise Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
64IEI20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
65IEI3IEI - Freight40BaseAbsEntBase Abs EntryInt110-1
66IEI5Incoming Excise Invoice - Withholding Tax19BaseAbsEntBase Document Internal No.Int110-1
67IGE20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
68IGN20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
69INV13A/R Invoice Rows - Distributed Freights40BaseAbsEntBase Abs EntryInt110-1
70INV20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
71INV3A/R Invoice - Freight40BaseAbsEntBase Abs EntryInt110-1
72INV5A/R Invoice - Withholding Tax19BaseAbsEntBase Document Internal No.Int110-1
73OEI13Outgoing Excise Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
74OEI20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
75OEI3OEI - Freight40BaseAbsEntBase Abs EntryInt110-1
76OEI5Outgoing Excise Invoice - Withholding Tax19BaseAbsEntBase Document Internal No.Int110-1
77PCH13A/P Invoice Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
78PCH20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
79PCH3A/P Invoice - Freight40BaseAbsEntBase Abs EntryInt110-1
80PCH5A/P Invoice - Withholding Tax Data19BaseAbsEntBase Abs EntryInt110-1
81PDN13Goods Receipt PO Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
82PDN20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
83PDN3Goods Receipt PO - Freight40BaseAbsEntBase Abs EntryInt110-1
84PDN5Goods Reciept PO - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
85POR13Purchase Order Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
86POR20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
87POR3Purchase Order - Freight40BaseAbsEntBase Abs EntryInt110-1
88POR5Purchase Order - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
89PQT13Purchase Quotation Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
90PQT20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
91PQT3Purchase Quotation - Freight40BaseAbsEntBase Abs EntryInt110-1
92PQT5Purchase Quotation - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
93PRQ13Purchase Request Rows - Distributed Expenses40BaseAbsEntBase Abs. EntryInt110-1
94PRQ20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
95PRQ3Purchase Request - Freight40BaseAbsEntBase Abs. EntryInt110-1
96PRQ5Purchase Request - Withholding Tax19BaseAbsEntBase Abs. EntryInt110-1
97QUT13Sales Quotation Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
98QUT20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
99QUT3Sales Quotation - Freight40BaseAbsEntBase Abs EntryInt110-1
100QUT5Sales Quotation - Tax19BaseAbsEntBase Abs EntryInt110-1
101RDN13Returns Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
102RDN20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
103RDN3Return - Freight40BaseAbsEntBase Abs EntryInt110-1
104RDN5Returns - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
105RDR13Sales Order Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
106RDR20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
107RDR3Sales Order - Freight40BaseAbsEntBase Abs EntryInt110-1
108RDR5Sales Order - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
109RIN13A/R Credit Memo Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
110RIN20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
111RIN3A/R Credit Memo - Freight40BaseAbsEntBase Abs EntryInt110-1
112RIN5A/R Credit Memo - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
113RPC13A/P Credit Memo Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
114RPC20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
115RPC3A/P Credit Memo - Freight40BaseAbsEntBase Abs EntryInt110-1
116RPC5A/P Credit Memo - Withholding Tax19BaseAbsEntBase Abs EntryInt110-1
117RPD13Goods Returns Rows - Distributed Expenses40BaseAbsEntBase Abs EntryInt110-1
118RPD20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
119RPD3Goods Return - Freight40BaseAbsEntBase Abs EntryInt110-1
120RPD5Goods Return - Withholding Tax Data19BaseAbsEntBase Abs EntryInt110-1
121WTQ20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1
122WTR20Intrastat Expenses11BaseAbsEntBase Abs. EntryInt110-1