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

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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