SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

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
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

103 columns | Print definition?B1 9.2  | RATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ASTCSales Tax Codes3RateRateNum196
2OSTASales Tax Authorities3RateRateNum196
3OSTCSales Tax Codes3RateRateNum196
4STA1Valid Period4RateRateNum196
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
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