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

145 columns | Print definition?B1 9.3  | 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
TOPGeneral
38OPMXPayroll4RateExchange RateNum196
TOPInventory and Production
39AQI1Inventory Opening Balance - Rows10RateCurrency PriceNum196
40AQR1Inventory Posting - Rows10RateCurrency PriceNum196
41IGE1Goods Issue - Rows17RateCurrency RateNum196
42IGE5Goods Issue - Withholding Tax3RateRateNum196
43IGN1Goods Receipt - Rows17RateCurrency RateNum196
44IGN5Goods Receipt - Withholding Tax3RateRateNum196
45IOD1Inventory Opening Balance Draft - Rows10RateCurrency PriceNum196
46IPD1Inventory Posting Draft - Rows10RateCurrency PriceNum196
47IPF1Landed Costs - Rows10RateCurrency PriceNum196
48IQI1Inventory Opening Balance - Rows10RateCurrency PriceNum196
49IQR1Inventory Posting - Rows10RateCurrency PriceNum196
50OIVLWhse Journal12RateCurrency PriceNum196
51SIVLWhse Journal12RateCurrency PriceNum196
52UIVLWhse Journal12RateCurrency PriceNum196
53WTQ1Inventory Transfer Request - Rows17RateCurrency RateNum196
54WTQ5Inventory Transfer Request - Withholding Tax3RateRateNum196
55WTR1Inventory Transfer - Rows17RateCurrency RateNum196
56WTR5Inventory Transfer - Withholding Tax3RateRateNum196
TOPMarketing Documents
57ADO1A/R Invoice (Rows) - History17RateCurrency RateNum196
58ADO25Mktg Docs - Amt Per VAT Grp - History12RateCurrency RateNum196
59ADO5Withholding Tax - History3RateRateNum196
60CIN1Correction Invoice - Rows17RateCurrency RateNum196
61CIN25Correction Invoice - Amt Per VAT Grp12RateCurrency RateNum196
62CIN5AR Correction Invoice - Withholding Tax3RateRateNum196
63CPI1A/P Correction Invoice - Rows17RateCurrency RateNum196
64CPI25A/P Correction Invoice - Amt Per VAT Grp12RateCurrency RateNum196
65CPI5Withholding Tax Data3RateRateNum196
66CPV1A/P Correction Invoice Reversal - Rows17RateCurrency RateNum196
67CPV25A/P Correction Invoice Reversal - Amt Per VAT Grp12RateCurrency RateNum196
68CPV5A/P Correction Invoice Reversal - WTax3RateRateNum196
69CSI1A/R Correction Invoice - Rows17RateCurrency RateNum196
70CSI25A/R Correction Invoice - Amt Per VAT Grp12RateCurrency RateNum196
71CSI5A/R Correction Invoice - Withholding Tax3RateRateNum196
72CSV1A/R Correction Invoice Reversal - Rows17RateCurrency RateNum196
73CSV25A/R Correction Invoice Reversal - Amt Per VAT Grp12RateCurrency RateNum196
74CSV5A/R Correction Invoice Reversal - WTax3RateRateNum196
75DLN1Delivery - Rows17RateCurrency RateNum196
76DLN25Delivery - Amt Per VAT Grp12RateCurrency RateNum196
77DLN5Delivery - Withholding Tax3RateRateNum196
78DPI1A/R Down Payment - Rows17RateCurrency RateNum196
79DPI25A/R Down Payment - Amt Per VAT Grp12RateCurrency RateNum196
80DPI5A/R Down Payment - Withholding Tax3RateRateNum196
81DPO1A/P Down Payment - Rows17RateCurrency RateNum196
82DPO25A/P Down Payment - Amt Per VAT Grp12RateCurrency RateNum196
83DPO5A/P Down Payment - Withholding Tax3RateRateNum196
84DRF1Draft - Rows17RateCurrency RateNum196
85DRF25Draft - Amt Per VAT Grp12RateCurrency RateNum196
86DRF5Draft Documents - Withholding Tax3RateRateNum196
87IEI1Incoming Excise Invoice - Rows17RateCurrency RateNum196
88IEI25Incoming Excise Invoice - Amt Per VAT Grp12RateCurrency RateNum196
89IEI5Incoming Excise Invoice - Withholding Tax3RateRateNum196
90IGE25Goods Issue - Amt Per VAT Grp12RateCurrency RateNum196
91IGN25Goods Receipt - Amt Per VAT Grp12RateCurrency RateNum196
92INV1A/R Invoice - Rows17RateCurrency RateNum196
93INV25A/R Invoice - Amt Per VAT Grp12RateCurrency RateNum196
94INV5A/R Invoice - Withholding Tax3RateRateNum196
95OEI1Outgoing Excise Invoice - Rows17RateCurrency RateNum196
96OEI25Outgoing Excise Invoice - Amt Per VAT Grp12RateCurrency RateNum196
97OEI5Outgoing Excise Invoice - Withholding Tax3RateRateNum196
98PCH1A/P Invoice - Rows17RateCurrency RateNum196
99PCH25A/P Invoice - Amt Per VAT Grp12RateCurrency RateNum196
100PCH5A/P Invoice - Withholding Tax Data3RateRateNum196
101PDN1Goods Receipt PO - Rows17RateCurrency RateNum196
102PDN25Goods Receipt PO - Amt Per VAT Grp12RateCurrency RateNum196
103PDN5Goods Reciept PO - Withholding Tax3RateRateNum196
104POR1Purchase Order - Rows17RateCurrency RateNum196
105POR25Purchase Order - Amt Per VAT Grp12RateCurrency RateNum196
106POR5Purchase Order - Withholding Tax3RateRateNum196
107PQT1Purchase Quotation - Rows17RateCurrency RateNum196
108PQT25Purchase Quotation - Amt Per VAT Grp12RateCurrency RateNum196
109PQT5Purchase Quotation - Withholding Tax3RateRateNum196
110PRQ1Purchase Request - Rows17RateCurrency RateNum196
111PRQ25Purchase Request - Amt Per VAT Grp12RateCurrency RateNum196
112PRQ5Purchase Request - Withholding Tax3RateRateNum196
113PRR1A/P Return Request - Rows17RateCurrency RateNum196
114PRR25Goods Return Request - Amt Per VAT Grp12RateCurrency RateNum196
115PRR5A/P Return Request - Withholding Tax3RateRateNum196
116QUT1Sales Quotation - Rows17RateCurrency RateNum196
117QUT25Sales Quotation - Amt Per VAT Grp12RateCurrency RateNum196
118QUT5Sales Quotation - Tax3RateRateNum196
119RDN1Returns - Rows17RateCurrency RateNum196
120RDN25Returns - Amt Per VAT Grp12RateCurrency RateNum196
121RDN5Returns - Withholding Tax3RateRateNum196
122RDR1Sales Order - Rows17RateCurrency RateNum196
123RDR25Sales Order - Amt Per VAT Grp12RateCurrency RateNum196
124RDR5Sales Order - Withholding Tax3RateRateNum196
125RIN1A/R Credit Memo - Rows17RateCurrency RateNum196
126RIN25A/R Credit Memo - Amt Per VAT Grp12RateCurrency RateNum196
127RIN5A/R Credit Memo - Withholding Tax3RateRateNum196
128RPC1A/P Credit Memo - Rows17RateCurrency RateNum196
129RPC25A/P Credit Memo - Amt Per VAT Grp12RateCurrency RateNum196
130RPC5A/P Credit Memo - Withholding Tax3RateRateNum196
131RPD1Goods Return - Rows17RateCurrency RateNum196
132RPD25Goods Return - Amt Per VAT Grp12RateCurrency RateNum196
133RPD5Goods Return - Withholding Tax Data3RateRateNum196
134RRR1A/R Return Request - Rows17RateCurrency RateNum196
135RRR25Return Request - Amt Per VAT Grp12RateCurrency RateNum196
136RRR5A/R Return Request - Withholding Tax3RateRateNum196
137SFC1Self Credit Memo - Rows17RateCurrency RateNum196
138SFC25Self Credit Memo - Amt Per VAT Grp12RateCurrency RateNum196
139SFC5Self Credit Memo - Withholding Tax3RateRateNum196
140SFI1Self Invoice - Rows17RateCurrency RateNum196
141SFI25Self Invoice - Amt Per VAT Grp12RateCurrency RateNum196
142SFI5Self Invoice - Withholding Tax3RateRateNum196
143WTQ25Inventory Transfer Request - Amt Per VAT Grp12RateCurrency RateNum196
144WTR25Inventory Transfer - Amt Per VAT Grp12RateCurrency RateNum196
TOPReports
145SOI5Statement of Import - Lines14RateLine RateNum196