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
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
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

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

103 columns | Print definition?B1 9.2  | RATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ASTCSales Tax Codes3RateRateNum196
2OSTASales Tax Authorities3RateRateNum196
3OSTCSales Tax Codes3RateRateNum196
4STA1Valid Period4RateRateNum196
TOPBanking
5ARC6Incoming Payments - WTax Rows - History9RateRateNum196
6PDF6Payment Drafts - Withholding Tax - Rows9RateRateNum196
7RCT6Incoming Payments - WTax Rows9RateRateNum196
8VPM6Outgoing Payments - WTax Rows9RateRateNum196
TOPBusiness Partners
9AWD3WTax Codes Details for BP8RateCurrency RateNum196
10WTD3WTax Codes Details for BP8RateCurrency RateNum196
TOPFinance
11AJD2Withholding Tax - History3RateRateNum196
12AVT1Tax Definition3RateRateNum196
13AVTGTax Definition3RateRate %Num196
14AWD1Withholding Tax Dates4RateRateNum196
15AWD2Value Ranges4RateRateNum196
16AWH1Tax Definition3RateRateNum196
17AWH2WTax Definition - Rows24RateTax RateNum196
18AWH3Value Range6RateRateNum196
19AWHTWithholding Tax3RateRateNum196
20AWTDWithholding Tax Definition4RateRateNum196
21BTF2Journal Voucher Withholding Tax - History3RateRateNum196
22GBI7GBI Row 7 - Accounting Vouchers14RateExchange RateNum196
23JDT2Withholding Tax - History3RateRateNum196
24JST1TDS Adjustment - Rows8RateRateNum196
25ORTSCPI and FC Rates for Reports3RateCurrency RateNum196
26ORTTCPI and FC Rates3RateCurrency RateNum196
27OVTGTax Definition3RateRate %Num196
28OWHTWithholding Tax3RateRateNum196
29OWTDWithholding Tax Definition4RateRateNum196
30UWTX1WTax Transactions - Rows13RateRateNum196
31VTG1Tax Definition3RateRateNum196
32WHT1Withholding Tax Definition3RateRateNum196
33WHT2Withholding Tax Definition - Rows24RateTax RateNum196
34WHT3Value Range6RateRateNum196
35WTD1Withholding Tax Dates4RateRateNum196
36WTD2Value Ranges4RateRateNum196
37WTX1WTax Transactions - Rows13RateRateNum196
TOPInventory and Production
38AQI1Inventory Opening Balance - Rows10RateCurrency PriceNum196
39AQR1Inventory Posting - Rows10RateCurrency PriceNum196
40IGE1Goods Issue - Rows17RateCurrency RateNum196
41IGE5Goods Issue - Withholding Tax3RateRateNum196
42IGN1Goods Receipt - Rows17RateCurrency RateNum196
43IGN5Goods Receipt - Withholding Tax3RateRateNum196
44IOD1Inventory Opening Balance Draft - Rows10RateCurrency PriceNum196
45IPD1Inventory Posting Draft - Rows10RateCurrency PriceNum196
46IPF1Landed Costs - Rows10RateCurrency PriceNum196
47IQI1Inventory Opening Balance - Rows10RateCurrency PriceNum196
48IQR1Inventory Posting - Rows10RateCurrency PriceNum196
49OIVLWhse Journal12RateCurrency PriceNum196
50SIVLWhse Journal12RateCurrency PriceNum196
51UIVLWhse Journal12RateCurrency PriceNum196
52WTQ1Inventory Transfer Request - Rows17RateCurrency RateNum196
53WTQ5Inventory Transfer Request - Withholding Tax3RateRateNum196
54WTR1Inventory Transfer - Rows17RateCurrency RateNum196
55WTR5Inventory Transfer - Withholding Tax3RateRateNum196
TOPMarketing Documents
56ADO1A/R Invoice (Rows) - History17RateCurrency RateNum196
57ADO5Withholding Tax - History3RateRateNum196
58CIN1Correction Invoice - Rows17RateCurrency RateNum196
59CIN5AR Correction Invoice - Withholding Tax3RateRateNum196
60CPI1A/P Correction Invoice - Rows17RateCurrency RateNum196
61CPI5Withholding Tax Data3RateRateNum196
62CPV1A/P Correction Invoice Reversal - Rows17RateCurrency RateNum196
63CPV5A/P Correction Invoice Reversal - WTax3RateRateNum196
64CSI1A/R Correction Invoice - Rows17RateCurrency RateNum196
65CSI5A/R Correction Invoice - Withholding Tax3RateRateNum196
66CSV1A/R Correction Invoice Reversal - Rows17RateCurrency RateNum196
67CSV5A/R Correction Invoice Reversal - WTax3RateRateNum196
68DLN1Delivery - Rows17RateCurrency RateNum196
69DLN5Delivery - Withholding Tax3RateRateNum196
70DPI1A/R Down Payment - Rows17RateCurrency RateNum196
71DPI5A/R Down Payment - Withholding Tax3RateRateNum196
72DPO1A/P Down Payment - Rows17RateCurrency RateNum196
73DPO5A/P Down Payment - Withholding Tax3RateRateNum196
74DRF1Draft - Rows17RateCurrency RateNum196
75DRF5Draft Documents - Withholding Tax3RateRateNum196
76IEI1Incoming Excise Invoice - Rows17RateCurrency RateNum196
77IEI5Incoming Excise Invoice - Withholding Tax3RateRateNum196
78INV1A/R Invoice - Rows17RateCurrency RateNum196
79INV5A/R Invoice - Withholding Tax3RateRateNum196
80OEI1Outgoing Excise Invoice - Rows17RateCurrency RateNum196
81OEI5Outgoing Excise Invoice - Withholding Tax3RateRateNum196
82PCH1A/P Invoice - Rows17RateCurrency RateNum196
83PCH5A/P Invoice - Withholding Tax Data3RateRateNum196
84PDN1Goods Receipt PO - Rows17RateCurrency RateNum196
85PDN5Goods Reciept PO - Withholding Tax3RateRateNum196
86POR1Purchase Order - Rows17RateCurrency RateNum196
87POR5Purchase Order - Withholding Tax3RateRateNum196
88PQT1Purchase Quotation - Rows17RateCurrency RateNum196
89PQT5Purchase Quotation - Withholding Tax3RateRateNum196
90PRQ1Purchase Request - Rows17RateCurrency RateNum196
91PRQ5Purchase Request - Withholding Tax3RateRateNum196
92QUT1Sales Quotation - Rows17RateCurrency RateNum196
93QUT5Sales Quotation - Tax3RateRateNum196
94RDN1Returns - Rows17RateCurrency RateNum196
95RDN5Returns - Withholding Tax3RateRateNum196
96RDR1Sales Order - Rows17RateCurrency RateNum196
97RDR5Sales Order - Withholding Tax3RateRateNum196
98RIN1A/R Credit Memo - Rows17RateCurrency RateNum196
99RIN5A/R Credit Memo - Withholding Tax3RateRateNum196
100RPC1A/P Credit Memo - Rows17RateCurrency RateNum196
101RPC5A/P Credit Memo - Withholding Tax3RateRateNum196
102RPD1Goods Return - Rows17RateCurrency RateNum196
103RPD5Goods Return - Withholding Tax Data3RateRateNum196