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
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

82 columns | Print definition?B1 8.8  | RATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1OSTASales Tax Authorities3RateRateNum196
2OSTCSales Tax Codes3RateRateNum196
3STA1Valid Period4RateRateNum196
TOPBanking
4ARC6Incoming Payments - WTax Rows - History9RateRateNum196
5PDF6Payment Drafts - Withholding Tax - Rows9RateRateNum196
6RCT6Incoming Payments - WTax Rows9RateRateNum196
7VPM6Outgoing Payments - WTax 9RateRateNum196
TOPFinance
8AVT1Tax Definition3RateRateNum196
9AVTGTax Definition3RateRate %Num196
10AWH1Tax Definition3RateRateNum196
11AWH2WTax Definition - Rows24RateTax RateNum196
12AWH3Value Range6RateRateNum196
13AWHTWithholding Tax3RateRateNum196
14GBI7GBI Row 7 - Accounting Vouchers14RateExchange RateNum196
15JST1TDS Adjustment - Rows8RateRateNum196
16ORTSCPI and FC Rates for Reports3RateCurrency RateNum196
17ORTTCPI and FC Rates3RateCurrency RateNum196
18OVTGTax Definition3RateRate %Num196
19OWHTWithholding Tax3RateRateNum196
20VTG1Tax Definition3RateRateNum196
21WHT1Withholding Tax Definition3RateRateNum196
22WHT2Withholding Tax Definition - Rows24RateTax RateNum196
23WHT3Value Range6RateRateNum196
TOPInventory and Production
24IGE1Goods Issue - Rows17RateCurrency RateNum196
25IGE5Goods Issue - Withholding Tax3RateRateNum196
26IGN1Goods Receipt - Rows17RateCurrency RateNum196
27IGN5Goods Receipt - Withholding Tax3RateRateNum196
28IPF1Landed Costs - Rows10RateCurrency PriceNum196
29IQI1Inventory Initial Qty Rows10RateCurrency PriceNum196
30IQR1Inventory Stock Posting (Reconcile) Lines10RateCurrency PriceNum196
31OINMWhse Journal21RateCurrency PriceNum196
32OIVLWhse Journal12RateCurrency PriceNum196
33UIVLWhse Journal12RateCurrency PriceNum196
34WTR1Inventory Transfer - Rows17RateCurrency RateNum196
35WTR5Inventory Transfer - Withholding Tax3RateRateNum196
TOPMarketing Documents
36ADO1A/R Invoice (Rows) - History17RateCurrency RateNum196
37ADO5Withholding Tax - History3RateRateNum196
38AJD2Withholding Tax - History3RateRateNum196
39BTF2Journal Voucher Withholding Tax - History3RateRateNum196
40CIN1Correction Invoice - Rows17RateCurrency RateNum196
41CIN5AR Correction Invoice - Withholding Tax3RateRateNum196
42CPI1A/P Correction Invoice - Rows17RateCurrency RateNum196
43CPI5Withholding Tax Data3RateRateNum196
44CPV1A/P Correction Invoice Reversal - Rows17RateCurrency RateNum196
45CPV5A/P Correction Invoice Reversal - WTax3RateRateNum196
46CSI1A/R Correction Invoice - Rows17RateCurrency RateNum196
47CSI5A/R Correction Invoice - Withholding Tax3RateRateNum196
48CSV1A/R Correction Invoice Reversal - Rows17RateCurrency RateNum196
49CSV5A/R Correction Invoice Reversal - WTax3RateRateNum196
50DLN1Delivery - Rows17RateCurrency RateNum196
51DLN5Delivery - Withholding Tax3RateRateNum196
52DPI1A/R Down Payment - Rows17RateCurrency RateNum196
53DPI5A/R Down Payment - Withholding Tax3RateRateNum196
54DPO1A/P Down Payment - Rows17RateCurrency RateNum196
55DPO5A/P Down Payment - Withholding Tax3RateRateNum196
56DRF1Draft - Rows17RateCurrency RateNum196
57DRF5Draft Documents - Withholding Tax3RateRateNum196
58IEI1Incoming Excise Invoice - Rows17RateCurrency RateNum196
59IEI5Incoming Excise Invoice - Withholding Tax3RateRateNum196
60INV1A/R Invoice - Rows17RateCurrency RateNum196
61INV5A/R Invoice - Withholding Tax3RateRateNum196
62JDT2Withholding Tax - History3RateRateNum196
63OEI1Outgoing Excise Invoice - Rows17RateCurrency RateNum196
64OEI5Outgoing Excise Invoice - Withholding Tax3RateRateNum196
65PCH1A/P Invoice - Rows17RateCurrency RateNum196
66PCH5A/P Invoice - Withholding Tax Data3RateRateNum196
67PDN1Goods Receipt PO - Rows17RateCurrency RateNum196
68PDN5Goods Reciept PO - Withholding Tax3RateRateNum196
69POR1Purchase Order - Rows17RateCurrency RateNum196
70POR5Purchase Order - Withholding Tax3RateRateNum196
71QUT1Sales Quotation - Rows17RateCurrency RateNum196
72QUT5Sales Quotation - Tax3RateRateNum196
73RDN1Returns - Rows17RateCurrency RateNum196
74RDN5Returns - Withholding Tax3RateRateNum196
75RDR1Sales Order - Rows17RateCurrency RateNum196
76RDR5Sales Order - Withholding Tax3RateRateNum196
77RIN1A/R Credit Memo - Rows17RateCurrency RateNum196
78RIN5A/R Credit Memo - Withholding Tax3RateRateNum196
79RPC1A/P Credit Memo - Rows17RateCurrency RateNum196
80RPC5A/P Credit Memo - Withholding Tax3RateRateNum196
81RPD1Goods Return - Rows17RateCurrency RateNum196
82RPD5Goods Return - Withholding Tax Data3RateRateNum196