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

165 columns | Print definition?B1 9.3  | EXPNSCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AEXDFreight Setup1ExpnsCodeInternal NumberInt110
2OEXDFreight Setup1ExpnsCodeInternal NumberInt110
TOPBusiness Partners
3AWD5WTax Codes Details for Freight4ExpnsCodeFreight CodeInt110
4WTD5WTax Codes Details for Freight4ExpnsCodeFreight CodeInt110
TOPInventory and Production
5IGE13Goods Issue Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
6IGE2Goods Issue - Freight - Rows4ExpnsCodeFreight CodeInt110
7IGE3Goods Issue - Freight2ExpnsCodeFreight CodeInt110
8IGE4Goods Issue - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
9IGN13Goods Receipt Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
10IGN2Goods Receipt - Freight - Rows4ExpnsCodeFreight CodeInt110
11IGN3Goods Receipt - Freight2ExpnsCodeFreight CodeInt110
12IGN4Goods Receipt - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
13WTQ13Inventory Transfer Request Rows - Distributed Freights4ExpnsCodeFreight CodeInt110
14WTQ2Inventory Transfer Request - Freight - Rows4ExpnsCodeExpense CodeInt110
15WTQ3Inventory Transfer Request - Freight2ExpnsCodeExpense CodeInt110
16WTQ4Inventory Transfer Request - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
17WTR13Inventory Transfer Rows - Distributed Freights4ExpnsCodeFreight CodeInt110
18WTR2Inventory Transfer - Freight - Rows4ExpnsCodeFreight CodeInt110
19WTR3Inventory Transfer - Freight2ExpnsCodeFreight CodeInt110
20WTR4Inventory Transfer - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
TOPMarketing Documents
21ADO13A/R Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
22ADO2A/R Invoice - Freight - Rows4ExpnsCodeExpense CodeInt110
23ADO20Intrastat Expenses2ExpnsCodeFreight CodeInt110
24ADO3A/R Invoice - Freight - History2ExpnsCodeExpense CodeInt110
25ADO4Documents - Tax - History4ExpnsCodeExpense CodeInt110-1
26CIN13Correction Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
27CIN2A/R Correction Invoice - Freight - Rows4ExpnsCodeExpense CodeInt110
28CIN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
29CIN3A/R Correction Invoice - Freight2ExpnsCodeExpense CodeInt110
30CIN4Correction Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
31CPI13A/P Correction Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
32CPI2A/P Correction Invoice - Freight - Rows4ExpnsCodeExpense CodeInt110
33CPI20Intrastat Expenses2ExpnsCodeFreight CodeInt110
34CPI3A/P Correction Invoice - Freight2ExpnsCodeExpense CodeInt110
35CPI4A/P Correction Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
36CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
37CPV2A/P Correction Invoice Reversal - Freight - Rows4ExpnsCodeExpense CodeInt110
38CPV20Intrastat Expenses2ExpnsCodeFreight CodeInt110
39CPV3A/P Correction Invoice Reversal - Freight2ExpnsCodeExpense CodeInt110
40CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.4ExpnsCodeExpense CodeInt110-1
41CSI13A/R Correction Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
42CSI2A/R Corr Inv - Freight - Rows4ExpnsCodeExpense CodeInt110
43CSI20Intrastat Expenses2ExpnsCodeFreight CodeInt110
44CSI3A/R Correction Invoice - Freight2ExpnsCodeExpense CodeInt110
45CSI4A/R Correction Invoice - Tax Amount Per Document4ExpnsCodeExpense CodeInt110-1
46CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
47CSV2A/R Correction Invoice Reversal - Freight - Rows4ExpnsCodeExpense CodeInt110
48CSV20Intrastat Expenses2ExpnsCodeFreight CodeInt110
49CSV3A/R Correction Invoice Reversal - Freight2ExpnsCodeExpense CodeInt110
50CSV4A/R Correction Invoice Reversal - Tax Amount Per Document4ExpnsCodeExpense CodeInt110-1
51DLN13Delivery Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
52DLN2Delivery Notes - Freight - Rows4ExpnsCodeExpense CodeInt110
53DLN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
54DLN3Delivery Notes - Freight2ExpnsCodeExpense CodeInt110
55DLN4Delivery - Tax Amount per Document4ExpnsCodeFreight CodeInt110-1
56DOC20Intrastat Expenses2ExpnsCodeFreight CodeInt110
57DPI13A/R Down Payment Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
58DPI2A/R Down Payment - Freight - Rows4ExpnsCodeFreight CodeInt110
59DPI20Intrastat Expenses2ExpnsCodeFreight CodeInt110
60DPI3A/R Down Payment - Freight2ExpnsCodeFreight CodeInt110
61DPI4A/R Down Payment - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
62DPO13A/P Down Payment Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
63DPO2A/P Down Payment - Freight - Rows4ExpnsCodeFreight CodeInt110
64DPO20Intrastat Expenses2ExpnsCodeFreight CodeInt110
65DPO3A/P Down Payment - Freight2ExpnsCodeFreight CodeInt110
66DPO4A/P Down Payment - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
67DRF13Draft Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
68DRF2Draft - Freight - Rows4ExpnsCodeFreight CodeInt110
69DRF20Intrastat Expenses2ExpnsCodeFreight CodeInt110
70DRF3Draft - Freight2ExpnsCodeFreight CodeInt110
71DRF4Draft Documents - Tax4ExpnsCodeExpense CodeInt110-1
72IEI13Incoming Excise Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
73IEI2Incoming Excise Invoice - Freight - History - Rows4ExpnsCodeFreight CodeInt110
74IEI20Intrastat Expenses2ExpnsCodeFreight CodeInt110
75IEI3IEI - Freight2ExpnsCodeFreight CodeInt110
76IEI4Incoming Excise Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
77IGE20Intrastat Expenses2ExpnsCodeFreight CodeInt110
78IGN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
79INV13A/R Invoice Rows - Distributed Freights4ExpnsCodeFreight CodeInt110
80INV2A/R Invoice - Freight - Rows4ExpnsCodeFreight CodeInt110
81INV20Intrastat Expenses2ExpnsCodeFreight CodeInt110
82INV3A/R Invoice - Freight2ExpnsCodeFreight CodeInt110
83INV4A/R Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
84OEI13Outgoing Excise Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
85OEI2OEI - Freight Rows4ExpnsCodeFreight CodeInt110
86OEI20Intrastat Expenses2ExpnsCodeFreight CodeInt110
87OEI3OEI - Freight2ExpnsCodeFreight CodeInt110
88OEI4Outgoing Excise Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
89PCH13A/P Invoice Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
90PCH2A/P Invoice - Freight - Rows4ExpnsCodeFreight CodeInt110
91PCH20Intrastat Expenses2ExpnsCodeFreight CodeInt110
92PCH3A/P Invoice - Freight2ExpnsCodeFreight CodeInt110
93PCH4A/P Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
94PDN13Goods Receipt PO Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
95PDN2Goods Receipt PO - Freight - Rows4ExpnsCodeFreight CodeInt110
96PDN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
97PDN3Goods Receipt PO - Freight2ExpnsCodeFreight CodeInt110
98PDN4Goods Receipt PO - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
99POR13Purchase Order Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
100POR2Purchase Order - Freight - Rows4ExpnsCodeFreight CodeInt110
101POR20Intrastat Expenses2ExpnsCodeFreight CodeInt110
102POR3Purchase Order - Freight2ExpnsCodeFreight CodeInt110
103POR4Purchase Order - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
104PQT13Purchase Quotation Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
105PQT2Purchase Quotation - Freight - Rows4ExpnsCodeFreight CodeInt110
106PQT20Intrastat Expenses2ExpnsCodeFreight CodeInt110
107PQT3Purchase Quotation - Freight2ExpnsCodeFreight CodeInt110
108PQT4Purchase Quotation - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
109PRQ13Purchase Request Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
110PRQ2Purchase Request - Freight - Rows4ExpnsCodeFreight CodeInt110
111PRQ20Intrastat Expenses2ExpnsCodeFreight CodeInt110
112PRQ3Purchase Request - Freight2ExpnsCodeFreight CodeInt110
113PRQ4Purchase Request - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
114PRR13A/P Return Request - Distributed Freights4ExpnsCodeFreight CodeInt110
115PRR2A/P Return Request - Freight - Rows4ExpnsCodeFreight CodeInt110
116PRR20Intrastat Expenses2ExpnsCodeFreight CodeInt110
117PRR3A/P Return Request - Freight2ExpnsCodeFreight CodeInt110
118PRR4A/P Return Request - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
119QUT13Sales Quotation Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
120QUT2Sales Quotation - Freight - Rows4ExpnsCodeFreight CodeInt110
121QUT20Intrastat Expenses2ExpnsCodeFreight CodeInt110
122QUT3Sales Quotation - Freight2ExpnsCodeFreight CodeInt110
123QUT4Sales Quotation - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
124RDN13Returns Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
125RDN2Return - Freight - Rows4ExpnsCodeFreight CodeInt110
126RDN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
127RDN3Return - Freight2ExpnsCodeFreight CodeInt110
128RDN4Returns - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
129RDR13Sales Order Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
130RDR2Sales Order - Freight - Rows4ExpnsCodeFreight CodeInt110
131RDR20Intrastat Expenses2ExpnsCodeFreight CodeInt110
132RDR3Sales Order - Freight2ExpnsCodeFreight CodeInt110
133RDR4Sales Order - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
134RIN13A/R Credit Memo Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
135RIN2A/R Credit Memo - Freight - Rows4ExpnsCodeFreight CodeInt110
136RIN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
137RIN3A/R Credit Memo - Freight2ExpnsCodeFreight CodeInt110
138RIN4A/R Credit Memo - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
139RPC13A/P Credit Memo Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
140RPC2A/P Credit Memo Rows - Expenses4ExpnsCodeFreight CodeInt110
141RPC20Intrastat Expenses2ExpnsCodeFreight CodeInt110
142RPC3A/P Credit Memo - Freight2ExpnsCodeFreight CodeInt110
143RPC4A/P Credit Memo - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
144RPD13Goods Returns Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
145RPD2Goods Return - Freight - Rows4ExpnsCodeFreight CodeInt110
146RPD20Intrastat Expenses2ExpnsCodeFreight CodeInt110
147RPD3Goods Return - Freight2ExpnsCodeFreight CodeInt110
148RPD4Goods Return - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
149RRR13A/R Return Request - Distributed Freights4ExpnsCodeFreight CodeInt110
150RRR2A/R Return Request - Freight - Rows4ExpnsCodeFreight CodeInt110
151RRR20Intrastat Expenses2ExpnsCodeFreight CodeInt110
152RRR3A/R Return Request - Freight2ExpnsCodeFreight CodeInt110
153RRR4A/R Return Request - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
154SFC13Self Credit Memo Rows - Distributed Freights4ExpnsCodeFreight CodeInt110
155SFC2Self Credit Memo - Freight - Rows4ExpnsCodeFreight CodeInt110
156SFC20Intrastat Expenses2ExpnsCodeFreight CodeInt110
157SFC3Self Credit Memo - Freight2ExpnsCodeFreight CodeInt110
158SFC4Self Credit Memo - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
159SFI13Self Invoice Rows - Distributed Freights4ExpnsCodeFreight CodeInt110
160SFI2Self Invoice - Freight - Rows4ExpnsCodeFreight CodeInt110
161SFI20Intrastat Expenses2ExpnsCodeFreight CodeInt110
162SFI3Self Invoice - Freight2ExpnsCodeFreight CodeInt110
163SFI4Self Invoice - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
164WTQ20Intrastat Expenses2ExpnsCodeFreight CodeInt110
165WTR20Intrastat Expenses2ExpnsCodeFreight CodeInt110