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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
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

207 columns | Print definition?B1 9.3  | TAXCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1TCD3Tax Code Determination5TaxCodeTax CodenVarChar80
2TCD5Tax Code by Usage4TaxCodeTax CodenVarChar80
TOPBusiness Partners
3ACR1Business Partner Addresses - History15TaxCodeTax CodenVarChar80
4AOA1Blanket Agreement - Rows30TaxCodeTax CodenVarChar80
5CRD1Business Partners - Addresses15TaxCodeTax CodenVarChar80
6OAT1Blanket Agreement - Rows30TaxCodeTax CodenVarChar80
TOPFinance
7AJD1Journal Entry - History - Rows76TaxCodeTax CodenVarChar80
8BTF1Journal Voucher - Rows76TaxCodeTax CodenVarChar80
9JDT1Journal Entry - Rows76TaxCodeTax CodenVarChar80
10RCR1Recurring Postings - Rows18TaxCodeTax CodenVarChar80
11TAX1VAT Transactions - Rows6TaxCodeTax CodenVarChar80
12TRT1Posting Templates - Rows16TaxCodeTax CodenVarChar80
13UTX1Unreported VAT Transactions - Rows6TaxCodeTax CodenVarChar80
TOPGeneral
14CIN11Correction Invoice - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
15LGL1Legal Data - Rows4TaxCodeTax CodenVarChar80
TOPInventory and Production
16IGE1Goods Issue - Rows100TaxCodeTax CodenVarChar80
17IGE11Goods Issue - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
18IGE13Goods Issue Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
19IGE15Gds Issue - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
20IGE2Goods Issue - Freight - Rows23TaxCodeTax CodenVarChar80
21IGE3Goods Issue - Freight23TaxCodeTax CodenVarChar80
22IGN1Goods Receipt - Rows100TaxCodeTax CodenVarChar80
23IGN11Goods Receipt - Drawn Dpm Det56TaxCodeTax CodenVarChar80
24IGN13Goods Receipt Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
25IGN15Gds Rcpt - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
26IGN2Goods Receipt - Freight - Rows23TaxCodeTax CodenVarChar80
27IGN3Goods Receipt - Freight23TaxCodeTax CodenVarChar80
28WTQ1Inventory Transfer Request - Rows100TaxCodeTax CodenVarChar80
29WTQ11Inv. Transfer Request - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
30WTQ13Inventory Transfer Request Rows - Distributed Freights23TaxCodeTax CodenVarChar80
31WTQ15Inv. Transfer Request - Drawn Dpm Appl57TaxCodeTax CodenVarChar80
32WTQ2Inventory Transfer Request - Freight - Rows23TaxCodeTax CodenVarChar80
33WTQ3Inventory Transfer Request - Freight23TaxCodeTax CodenVarChar80
34WTR1Inventory Transfer - Rows100TaxCodeTax CodenVarChar80
35WTR11Inv. Transfer - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
36WTR13Inventory Transfer Rows - Distributed Freights23TaxCodeTax CodenVarChar80
37WTR15Inv. Transfer - Drawn Dpm Appl57TaxCodeTax CodenVarChar80
38WTR2Inventory Transfer - Freight - Rows23TaxCodeTax CodenVarChar80
39WTR3Inventory Transfer - Freight23TaxCodeTax CodenVarChar80
TOPMarketing Documents
40ADO1A/R Invoice (Rows) - History100TaxCodeTax CodenVarChar80
41ADO11A/R Inv (Drawn Dpm Det) - Hist56TaxCodeTax CodenVarChar80
42ADO13A/R Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
43ADO15A/R Inv (Drawn Dpm Applied) - Hist57TaxCodeTax CodenVarChar80
44ADO2A/R Invoice - Freight - Rows23TaxCodeTax CodenVarChar80
45ADO3A/R Invoice - Freight - History23TaxCodeTax CodenVarChar80
46CIN1Correction Invoice - Rows100TaxCodeTax CodenVarChar80
47CIN13Correction Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
48CIN2A/R Correction Invoice - Freight - Rows23TaxCodeTax CodenVarChar80
49CIN3A/R Correction Invoice - Freight23TaxCodeTax CodenVarChar80
50CPI1A/P Correction Invoice - Rows100TaxCodeTax CodenVarChar80
51CPI11A/P Corr. Inv - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
52CPI13A/P Correction Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
53CPI15A/P Corr Inv - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
54CPI2A/P Correction Invoice - Freight - Rows23TaxCodeTax CodenVarChar80
55CPI3A/P Correction Invoice - Freight23TaxCodeTax CodenVarChar80
56CPV1A/P Correction Invoice Reversal - Rows100TaxCodeTax CodenVarChar80
57CPV11A/P CrIn Rev - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
58CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
59CPV15A/P CrIn Rev - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
60CPV2A/P Correction Invoice Reversal - Freight - Rows23TaxCodeTax CodenVarChar80
61CPV3A/P Correction Invoice Reversal - Freight23TaxCodeTax CodenVarChar80
62CSI1A/R Correction Invoice - Rows100TaxCodeTax CodenVarChar80
63CSI11A/R Corr. Inv. - Drawn Dpm Det56TaxCodeTax CodenVarChar80
64CSI13A/R Correction Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
65CSI15A/R Corr Inv - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
66CSI2A/R Corr Inv - Freight - Rows23TaxCodeTax CodenVarChar80
67CSI3A/R Correction Invoice - Freight23TaxCodeTax CodenVarChar80
68CSV1A/R Correction Invoice Reversal - Rows100TaxCodeTax CodenVarChar80
69CSV11A/R CrIn Rev - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
70CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
71CSV15A/R CrIn Rev - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
72CSV2A/R Correction Invoice Reversal - Freight - Rows23TaxCodeTax CodenVarChar80
73CSV3A/R Correction Invoice Reversal - Freight23TaxCodeTax CodenVarChar80
74DLN1Delivery - Rows100TaxCodeTax CodenVarChar80
75DLN11Delivery - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
76DLN13Delivery Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
77DLN15Delivery - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
78DLN2Delivery Notes - Freight - Rows23TaxCodeTax CodenVarChar80
79DLN3Delivery Notes - Freight23TaxCodeTax CodenVarChar80
80DPI1A/R Down Payment - Rows100TaxCodeTax CodenVarChar80
81DPI11A/R DP - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
82DPI13A/R Down Payment Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
83DPI15A/R DP - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
84DPI2A/R Down Payment - Freight - Rows23TaxCodeTax CodenVarChar80
85DPI3A/R Down Payment - Freight23TaxCodeTax CodenVarChar80
86DPO1A/P Down Payment - Rows100TaxCodeTax CodenVarChar80
87DPO11A/P DP - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
88DPO13A/P Down Payment Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
89DPO15A/P DP - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
90DPO2A/P Down Payment - Freight - Rows23TaxCodeTax CodenVarChar80
91DPO3A/P Down Payment - Freight23TaxCodeTax CodenVarChar80
92DRF1Draft - Rows100TaxCodeTax CodenVarChar80
93DRF11Draft - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
94DRF13Draft Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
95DRF15Draft - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
96DRF2Draft - Freight - Rows23TaxCodeTax CodenVarChar80
97DRF3Draft - Freight23TaxCodeTax CodenVarChar80
98IEI1Incoming Excise Invoice - Rows100TaxCodeTax CodenVarChar80
99IEI11IEI - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
100IEI13Incoming Excise Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
101IEI15IEI - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
102IEI2Incoming Excise Invoice - Freight - History - Rows23TaxCodeTax CodenVarChar80
103IEI3IEI - Freight23TaxCodeTax CodenVarChar80
104INV1A/R Invoice - Rows100TaxCodeTax CodenVarChar80
105INV11A/R Invoice - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
106INV13A/R Invoice Rows - Distributed Freights23TaxCodeTax CodenVarChar80
107INV15A/R Inv. - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
108INV2A/R Invoice - Freight - Rows23TaxCodeTax CodenVarChar80
109INV3A/R Invoice - Freight23TaxCodeTax CodenVarChar80
110OEI1Outgoing Excise Invoice - Rows100TaxCodeTax CodenVarChar80
111OEI11OEI - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
112OEI13Outgoing Excise Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
113OEI15OEI - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
114OEI2OEI - Freight Rows23TaxCodeTax CodenVarChar80
115OEI3OEI - Freight23TaxCodeTax CodenVarChar80
116PCH1A/P Invoice - Rows100TaxCodeTax CodenVarChar80
117PCH11A/P Invoice - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
118PCH13A/P Invoice Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
119PCH15A/P Invoice - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
120PCH2A/P Invoice - Freight - Rows23TaxCodeTax CodenVarChar80
121PCH3A/P Invoice - Freight23TaxCodeTax CodenVarChar80
122PDN1Goods Receipt PO - Rows100TaxCodeTax CodenVarChar80
123PDN11GRPO - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
124PDN13Goods Receipt PO Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
125PDN15GRPO - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
126PDN2Goods Receipt PO - Freight - Rows23TaxCodeTax CodenVarChar80
127PDN3Goods Receipt PO - Freight23TaxCodeTax CodenVarChar80
128POR1Purchase Order - Rows100TaxCodeTax CodenVarChar80
129POR11PO - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
130POR13Purchase Order Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
131POR15PO - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
132POR2Purchase Order - Freight - Rows23TaxCodeTax CodenVarChar80
133POR3Purchase Order - Freight23TaxCodeTax CodenVarChar80
134PQT1Purchase Quotation - Rows100TaxCodeTax CodenVarChar80
135PQT11PQ - Drawn DPM Detail56TaxCodeTax CodenVarChar80
136PQT13Purchase Quotation Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
137PQT15PQ - Drawn DPM Applied57TaxCodeTax CodenVarChar80
138PQT2Purchase Quotation - Freight - Rows23TaxCodeTax CodenVarChar80
139PQT3Purchase Quotation - Freight23TaxCodeTax CodenVarChar80
140PRQ1Purchase Request - Rows100TaxCodeTax CodenVarChar80
141PRQ11PR - Drawn DPM Detail56TaxCodeTax CodenVarChar80
142PRQ13Purchase Request Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
143PRQ15PR - Drawn DPM Applied57TaxCodeTax CodenVarChar80
144PRQ2Purchase Request - Freight - Rows23TaxCodeTax CodenVarChar80
145PRQ3Purchase Request - Freight23TaxCodeTax CodenVarChar80
146PRR1A/P Return Request - Rows100TaxCodeTax CodenVarChar80
147PRR11A/P Return Request - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
148PRR13A/P Return Request - Distributed Freights23TaxCodeTax CodenVarChar80
149PRR15A/P Return Request - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
150PRR2A/P Return Request - Freight - Rows23TaxCodeTax CodenVarChar80
151PRR3A/P Return Request - Freight23TaxCodeTax CodenVarChar80
152QUT1Sales Quotation - Rows100TaxCodeTax CodenVarChar80
153QUT11Sls Quote - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
154QUT13Sales Quotation Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
155QUT15Sls Quote - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
156QUT2Sales Quotation - Freight - Rows23TaxCodeTax CodenVarChar80
157QUT3Sales Quotation - Freight23TaxCodeTax CodenVarChar80
158RDN1Returns - Rows100TaxCodeTax CodenVarChar80
159RDN11Returns - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
160RDN13Returns Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
161RDN15Returns - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
162RDN2Return - Freight - Rows23TaxCodeTax CodenVarChar80
163RDN3Return - Freight23TaxCodeTax CodenVarChar80
164RDR1Sales Order - Rows100TaxCodeTax CodenVarChar80
165RDR11Sls Ord. - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
166RDR13Sales Order Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
167RDR15Sls Ord. - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
168RDR2Sales Order - Freight - Rows23TaxCodeTax CodenVarChar80
169RDR3Sales Order - Freight23TaxCodeTax CodenVarChar80
170RIN1A/R Credit Memo - Rows100TaxCodeTax CodenVarChar80
171RIN11A/R Cr. Memo - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
172RIN13A/R Credit Memo Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
173RIN15A/R Cr. Memo - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
174RIN2A/R Credit Memo - Freight - Rows23TaxCodeTax CodenVarChar80
175RIN3A/R Credit Memo - Freight23TaxCodeTax CodenVarChar80
176RPC1A/P Credit Memo - Rows100TaxCodeTax CodenVarChar80
177RPC11A/P Cr. Memo - Drawn Dpm Det.56TaxCodeTax CodenVarChar80
178RPC13A/P Credit Memo Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
179RPC15A/P Cr. Memo - Drawn Dpm Appld57TaxCodeTax CodenVarChar80
180RPC2A/P Credit Memo Rows - Expenses23TaxCodeTax CodenVarChar80
181RPC3A/P Credit Memo - Freight23TaxCodeTax CodenVarChar80
182RPD1Goods Return - Rows100TaxCodeTax CodenVarChar80
183RPD11Gds Return - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
184RPD13Goods Returns Rows - Distributed Expenses23TaxCodeTax CodenVarChar80
185RPD15Gds Return - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
186RPD2Goods Return - Freight - Rows23TaxCodeTax CodenVarChar80
187RPD3Goods Return - Freight23TaxCodeTax CodenVarChar80
188RRR1A/R Return Request - Rows100TaxCodeTax CodenVarChar80
189RRR11A/R Return Request - Drawn Dpm Detail56TaxCodeTax CodenVarChar80
190RRR13A/R Return Request - Distributed Freights23TaxCodeTax CodenVarChar80
191RRR15A/R Return Request - Drawn Dpm Applied57TaxCodeTax CodenVarChar80
192RRR2A/R Return Request - Freight - Rows23TaxCodeTax CodenVarChar80
193RRR3A/R Return Request - Freight23TaxCodeTax CodenVarChar80
194SFC1Self Credit Memo - Rows100TaxCodeTax CodenVarChar80
195SFC11Self Credit Memo - Drawn Down Payment Detail56TaxCodeTax CodenVarChar80
196SFC13Self Credit Memo Rows - Distributed Freights23TaxCodeTax CodenVarChar80
197SFC15Self Credit Memo - Drawn Down Payment Applied57TaxCodeTax CodenVarChar80
198SFC2Self Credit Memo - Freight - Rows23TaxCodeTax CodenVarChar80
199SFC3Self Credit Memo - Freight23TaxCodeTax CodenVarChar80
200SFI1Self Invoice - Rows100TaxCodeTax CodenVarChar80
201SFI11Self Invoice - Drawn Down Payment Detail56TaxCodeTax CodenVarChar80
202SFI13Self Invoice Rows - Distributed Freights23TaxCodeTax CodenVarChar80
203SFI15Self Invoice - Drawn Down Payment Applied57TaxCodeTax CodenVarChar80
204SFI2Self Invoice - Freight - Rows23TaxCodeTax CodenVarChar80
205SFI3Self Invoice - Freight23TaxCodeTax CodenVarChar80
206VRT2Tax Invoice Report Grid Info9TaxCodeTax CodenVarChar80
TOPReports
207ORFLAlready Displayed 347, 349 and WTax Reports5TaxCodeTax CodenVarChar80