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
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

145 columns | Print definition?B1 9.2  | 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
114QUT13Sales Quotation Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
115QUT2Sales Quotation - Freight - Rows4ExpnsCodeFreight CodeInt110
116QUT20Intrastat Expenses2ExpnsCodeFreight CodeInt110
117QUT3Sales Quotation - Freight2ExpnsCodeFreight CodeInt110
118QUT4Sales Quotation - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
119RDN13Returns Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
120RDN2Return - Freight - Rows4ExpnsCodeFreight CodeInt110
121RDN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
122RDN3Return - Freight2ExpnsCodeFreight CodeInt110
123RDN4Returns - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
124RDR13Sales Order Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
125RDR2Sales Order - Freight - Rows4ExpnsCodeFreight CodeInt110
126RDR20Intrastat Expenses2ExpnsCodeFreight CodeInt110
127RDR3Sales Order - Freight2ExpnsCodeFreight CodeInt110
128RDR4Sales Order - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
129RIN13A/R Credit Memo Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
130RIN2A/R Credit Memo - Freight - Rows4ExpnsCodeFreight CodeInt110
131RIN20Intrastat Expenses2ExpnsCodeFreight CodeInt110
132RIN3A/R Credit Memo - Freight2ExpnsCodeFreight CodeInt110
133RIN4A/R Credit Memo - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
134RPC13A/P Credit Memo Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
135RPC2A/P Credit Memo Rows - Expenses4ExpnsCodeFreight CodeInt110
136RPC20Intrastat Expenses2ExpnsCodeFreight CodeInt110
137RPC3A/P Credit Memo - Freight2ExpnsCodeFreight CodeInt110
138RPC4A/P Credit Memo - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
139RPD13Goods Returns Rows - Distributed Expenses4ExpnsCodeFreight CodeInt110
140RPD2Goods Return - Freight - Rows4ExpnsCodeFreight CodeInt110
141RPD20Intrastat Expenses2ExpnsCodeFreight CodeInt110
142RPD3Goods Return - Freight2ExpnsCodeFreight CodeInt110
143RPD4Goods Return - Tax Amount per Document4ExpnsCodeExpense CodeInt110-1
144WTQ20Intrastat Expenses2ExpnsCodeFreight CodeInt110
145WTR20Intrastat Expenses2ExpnsCodeFreight CodeInt110