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

133 columns | Print definition?B1 9.3  | CURRENCY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ABOEBill of Exchange for Payment - History20CurrencyBill of Exchange CurrencynVarChar30
2ACHOChecks for Payment - History17CurrencyCheck CurrencynVarChar30
3ADS1House Bank Accounts79CurrencyCurrencynVarChar30
4ARC1Incoming Payment - Checks - History11CurrencyCheck CurrencynVarChar30
5DSC1House Bank Accounts79CurrencyCurrencynVarChar30
6MTH1VJournal Entries of External Reconciliation17CurrencyCurrencynVarChar30
7OBNHBank Statement Header9CurrencyCurrencynVarChar30
8OBOEBill of Exchange for Payment20CurrencyBill of Exchange CurrencynVarChar30
9OCHDChecks for Payment Drafts17CurrencyCheck CurrencynVarChar30
10OCHHCheck Register21CurrencyCheck CurrencynVarChar30
11OCHOChecks for Payment17CurrencyCheck CurrencynVarChar30
12OPEXPayment Results Table32CurrencyMain CurrencynVarChar30
13PDF1Payment Draft - Checks11CurrencyCheck CurrencynVarChar30
14PWZ5Payment Wizard - Rows 513CurrencyCurrencynVarChar30
15RCT1Incoming Payment - Checks11CurrencyCheck CurrencynVarChar30
16VPM1Outgoing Payments - Check Rows11CurrencyCheck CurrencynVarChar30
TOPBusiness Partners
17ACRDBusiness Partners - History44CurrencyBP CurrencynVarChar30
18AOA1Blanket Agreement - Rows8CurrencyPrice CurrencynVarChar30
19OAT1Blanket Agreement - Rows8CurrencyPrice CurrencynVarChar30
20OCRDBusiness Partner44CurrencyBP CurrencynVarChar30
TOPFinance
21AFADAsset Document - History13CurrencyCurrencynVarChar30
22GBI6GBI Row 6 - G/L Account Balance4CurrencyAccount CurrencynVarChar30
23GBI7GBI Row 7 - Accounting Vouchers9CurrencyTransaction CurrencynVarChar30
24OACDCredit Memo13CurrencyCurrencynVarChar30
25OACQCapitalization13CurrencyCurrencynVarChar30
26OFTRTransfer13CurrencyCurrencynVarChar30
27OGBIGB Interface: Common Info5CurrencyCurrency UnitnVarChar100
28OMDPManual Depreciation13CurrencyCurrencynVarChar30
29ORTIRetirement13CurrencyCurrencynVarChar30
30ORTSCPI and FC Rates for Reports2CurrencyCurrency CodenVarChar30
31ORTTCPI and FC Rates2CurrencyCurrency CodenVarChar30
32RCR1Recurring Postings - Rows7CurrencyCurrencynVarChar30
33SLM1Special Ledger - Analytical Accounting Report Lines: Material23CurrencyForeign CurrencynVarChar30
34SLR1Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses23CurrencyForeign CurrencynVarChar30
TOPGeneral
35ARSC2Resources - Prices - Log4CurrencyCurrency for List PricenVarChar30
36OPMXPayroll3CurrencyCurrencynVarChar30
37RSC2Resources - Prices4CurrencyCurrency for List PricenVarChar30
TOPInventory and Production
38AIT1Item - Prices - History4CurrencyPrice List CurrencynVarChar30
39AIT9Item - UoM Prices6CurrencyCurrency for UoM PricenVarChar30
40AQI1Inventory Opening Balance - Rows9CurrencyPrice CurrencynVarChar30
41AQR1Inventory Posting - Rows9CurrencyPrice CurrencynVarChar30
42ASP1Special Prices - Data Areas5CurrencyPrice CurrencynVarChar30
43ASP2Special Prices - Quantity Areas7CurrencyPrice CurrencynVarChar30
44ASPPSpecial Prices4CurrencyPrice CurrencynVarChar30
45ATT1Bill of Materials - Components - History8CurrencyCurrencynVarChar30
46IGE1Goods Issue - Rows16CurrencyPrice CurrencynVarChar30
47IGN1Goods Receipt - Rows16CurrencyPrice CurrencynVarChar30
48IOD1Inventory Opening Balance Draft - Rows9CurrencyPrice CurrencynVarChar30
49IPD1Inventory Posting Draft - Rows9CurrencyPrice CurrencynVarChar30
50IPF1Landed Costs - Rows9CurrencyPrice CurrencynVarChar30
51IQI1Inventory Opening Balance - Rows9CurrencyPrice CurrencynVarChar30
52IQR1Inventory Posting - Rows9CurrencyPrice CurrencynVarChar30
53ITM1Items - Prices4CurrencyCurrency for List PricenVarChar30
54ITM9Item - UoM Prices6CurrencyCurrency for UoM PricenVarChar30
55ITT1Bill of Materials - Components8CurrencyCurrencynVarChar30
56OAIMArchive Inventory Message13CurrencyDocument CurrencynVarChar30
57OILMInventory Log Message15CurrencyDoc CurrencynVarChar30
58OIVLWhse Journal11CurrencyPrice CurrencynVarChar30
59OSPPSpecial Prices4CurrencyPrice CurrencynVarChar30
60SIVLWhse Journal11CurrencyPrice CurrencynVarChar30
61SPP1Special Prices - Data Areas5CurrencyPrice CurrencynVarChar30
62SPP2Special Prices - Quantity Areas7CurrencyPrice CurrencynVarChar30
63UILMIVI Inventory Log Message15CurrencyDoc CurrencynVarChar30
64UIVLWhse Journal11CurrencyPrice CurrencynVarChar30
65UWKO1Production Instructions - Rows7CurrencyPrice CurrencynVarChar30
66WKO1Production Instructions - Rows7CurrencyPrice CurrencynVarChar30
67WTQ1Inventory Transfer Request - Rows16CurrencyPrice CurrencynVarChar30
68WTR1Inventory Transfer - Rows16CurrencyPrice CurrencynVarChar30
TOPMarketing Documents
69ADO1A/R Invoice (Rows) - History16CurrencyPrice CurrencynVarChar30
70ADO25Mktg Docs - Amt Per VAT Grp - History11CurrencyPrice CurrencynVarChar30
71CIN1Correction Invoice - Rows16CurrencyPrice CurrencynVarChar30
72CIN25Correction Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
73CPI1A/P Correction Invoice - Rows16CurrencyPrice CurrencynVarChar30
74CPI25A/P Correction Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
75CPV1A/P Correction Invoice Reversal - Rows16CurrencyPrice CurrencynVarChar30
76CPV25A/P Correction Invoice Reversal - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
77CSI1A/R Correction Invoice - Rows16CurrencyPrice CurrencynVarChar30
78CSI25A/R Correction Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
79CSV1A/R Correction Invoice Reversal - Rows16CurrencyPrice CurrencynVarChar30
80CSV25A/R Correction Invoice Reversal - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
81DLN1Delivery - Rows16CurrencyPrice CurrencynVarChar30
82DLN25Delivery - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
83DPI1A/R Down Payment - Rows16CurrencyPrice CurrencynVarChar30
84DPI25A/R Down Payment - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
85DPO1A/P Down Payment - Rows16CurrencyPrice CurrencynVarChar30
86DPO25A/P Down Payment - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
87DRF1Draft - Rows16CurrencyPrice CurrencynVarChar30
88DRF25Draft - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
89IEI1Incoming Excise Invoice - Rows16CurrencyPrice CurrencynVarChar30
90IEI25Incoming Excise Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
91IGE25Goods Issue - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
92IGN25Goods Receipt - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
93INV1A/R Invoice - Rows16CurrencyPrice CurrencynVarChar30
94INV25A/R Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
95OEI1Outgoing Excise Invoice - Rows16CurrencyPrice CurrencynVarChar30
96OEI25Outgoing Excise Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
97OMINA/R Monthly Invoice6CurrencyCurrency of Monthly InvoicenVarChar30
98OMIVA/P Monthly Invoice6CurrencyCurrencynVarChar30
99PCH1A/P Invoice - Rows16CurrencyPrice CurrencynVarChar30
100PCH25A/P Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
101PDN1Goods Receipt PO - Rows16CurrencyPrice CurrencynVarChar30
102PDN25Goods Receipt PO - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
103POR1Purchase Order - Rows16CurrencyPrice CurrencynVarChar30
104POR25Purchase Order - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
105PQT1Purchase Quotation - Rows16CurrencyPrice CurrencynVarChar30
106PQT25Purchase Quotation - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
107PRQ1Purchase Request - Rows16CurrencyPrice CurrencynVarChar30
108PRQ25Purchase Request - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
109PRR1A/P Return Request - Rows16CurrencyPrice CurrencynVarChar30
110PRR25Goods Return Request - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
111QUT1Sales Quotation - Rows16CurrencyPrice CurrencynVarChar30
112QUT25Sales Quotation - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
113RDN1Returns - Rows16CurrencyPrice CurrencynVarChar30
114RDN25Returns - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
115RDR1Sales Order - Rows16CurrencyPrice CurrencynVarChar30
116RDR25Sales Order - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
117RIN1A/R Credit Memo - Rows16CurrencyPrice CurrencynVarChar30
118RIN25A/R Credit Memo - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
119RPC1A/P Credit Memo - Rows16CurrencyPrice CurrencynVarChar30
120RPC25A/P Credit Memo - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
121RPD1Goods Return - Rows16CurrencyPrice CurrencynVarChar30
122RPD25Goods Return - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
123RRR1A/R Return Request - Rows16CurrencyPrice CurrencynVarChar30
124RRR25Return Request - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
125SFC1Self Credit Memo - Rows16CurrencyPrice CurrencynVarChar30
126SFC25Self Credit Memo - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
127SFI1Self Invoice - Rows16CurrencyPrice CurrencynVarChar30
128SFI25Self Invoice - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
129VRT2Tax Invoice Report Grid Info18CurrencyCurrencynVarChar30
130WTQ25Inventory Transfer Request - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
131WTR25Inventory Transfer - Amt Per VAT Grp11CurrencyPrice CurrencynVarChar30
TOPMRP
132ORCMRecommendation Data12CurrencyPrice CurrencynVarChar30
TOPReports
133SOI5Statement of Import - Lines13CurrencyCurrencynVarChar30