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
2FMARCPAR4Parallelization of FMARC_BATCH
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4/ISDFPS/CHVW_E34External Batch Where-Used List
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
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OUSR101Users
10OWTR386Inventory Transfer

B1 8.8: Top 10 requests

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

88 columns | Print definition?B1 8.82  | ADDRESS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ALR1Queue of messages to be sent7AddressAddressnVarChar1000
2AUSRArchive Users - History59AddressAddressnVarChar1000
3OUDGUser Defaults12AddressAddressnVarChar2540
4OUSRUsers59AddressAddressnVarChar1000
TOPBanking
5ABOEBill of Exchange for Payment - History27AddressAddressnVarChar2540
6ACHOChecks for Payment - History29AddressAddressnVarChar2540
7ARCTIncoming Payment - History11AddressAddressnVarChar2540
8OBOEBill of Exchange for Payment27AddressAddressnVarChar2540
9OCHDChecks for Payment Drafts29AddressAddressnVarChar2540
10OCHOChecks for Payment29AddressAddressnVarChar2540
11OPDFPayment Draft11AddressAddressnVarChar2540
12OPYMPayment Methods for Payment Wizard5AddressCheck AddressVarChar10N
13ORCTIncoming Payment11AddressAddressnVarChar2540
14OVPMOutgoing Payments11AddressAddressnVarChar2540
TOPBusiness Partners
15ABPLBusiness Place8AddressAddressnVarChar2540
16ACPRContact Persons - History5AddressAddressnVarChar1000
17ACR1Business Partner Addresses - History1AddressAddress NamenVarChar500
18ACR7Fiscal IDs for BP Master Data2AddressAddressnVarChar500
19ACRDBusiness Partners - History6AddressBill-to StreetnVarChar1000
20CRD1Business Partners - Addresses1AddressAddress NamenVarChar500
21CRD7Fiscal IDs for BP Master Data2AddressAddressnVarChar500
22OBPLBusiness Place8AddressAddressnVarChar2540
23OCPRContact Persons5AddressAddressnVarChar1000
24OCRDBusiness Partner6AddressBill-to StreetnVarChar1000
TOPFinance
25GBI4GBI Row 4 - Business Partners8AddressStreet/PO BoxnVarChar1000
TOPInventory and Production
26IGE1Goods Issue - Rows99AddressAddressnVarChar2540
27IGN1Goods Receipt - Rows99AddressAddressnVarChar2540
28OENTShipping Types12AddressAddressnVarChar2540
29OIGEGoods Issue15AddressBill tonVarChar2540
30OIGNGoods Receipt15AddressBill tonVarChar2540
31OWTQInventory Transfer Request15AddressBill tonVarChar2540
32OWTRInventory Transfer15AddressBill tonVarChar2540
33WTQ1Inventory Transfer Request - Rows99AddressAddressnVarChar2540
34WTR1Inventory Transfer - Rows99AddressAddressnVarChar2540
TOPMarketing Documents
35ADO1A/R Invoice (Rows) - History99AddressAddressnVarChar2540
36ADOCInvoice - History15AddressBill tonVarChar2540
37ATXITax Invoice - History21AddressBill tonVarChar2540
38CIN1Correction Invoice - Rows99AddressAddressnVarChar2540
39CPI1A/P Correction Invoice - Rows99AddressAddressnVarChar2540
40CPV1A/P Correction Invoice Reversal - Rows99AddressAddressnVarChar2540
41CSI1A/R Correction Invoice - Rows99AddressAddressnVarChar2540
42CSV1A/R Correction Invoice Reversal - Rows99AddressAddressnVarChar2540
43DLN1Delivery - Rows99AddressAddressnVarChar2540
44DPI1A/R Down Payment - Rows99AddressAddressnVarChar2540
45DPO1A/P Down Payment - Rows99AddressAddressnVarChar2540
46DRF1Draft - Rows99AddressAddressnVarChar2540
47IEI1Incoming Excise Invoice - Rows99AddressAddressnVarChar2540
48INV1A/R Invoice - Rows99AddressAddressnVarChar2540
49OCINA/R Correction Invoice15AddressBill tonVarChar2540
50OCPIA/P Correction Invoice15AddressBill tonVarChar2540
51OCPVA/P Correction Invoice Reversal15AddressBill tonVarChar2540
52OCSIA/R Correction Invoice15AddressBill tonVarChar2540
53OCSVA/R Correction Invoice Reversal15AddressBill tonVarChar2540
54ODLNDelivery15AddressBill tonVarChar2540
55ODPIA/R Down Payment15AddressBill tonVarChar2540
56ODPOA/P Down Payment15AddressBill tonVarChar2540
57ODRFDrafts15AddressBill tonVarChar2540
58OEI1Outgoing Excise Invoice - Rows99AddressAddressnVarChar2540
59OIEIIncoming Excise Invoice15AddressBill tonVarChar2540
60OINVA/R Invoice15AddressBill tonVarChar2540
61OOEIOutgoing Excise Invoice15AddressBill tonVarChar2540
62OPCHA/P Invoice15AddressBill tonVarChar2540
63OPDNGoods Receipt PO15AddressBill tonVarChar2540
64OPORPurchase Order15AddressBill tonVarChar2540
65OPQTPurchase Quotation15AddressBill tonVarChar2540
66OQUTSales Quotation15AddressBill tonVarChar2540
67ORDNReturns15AddressBill tonVarChar2540
68ORDRSales Order15AddressBill tonVarChar2540
69ORINA/R Credit Memo15AddressBill tonVarChar2540
70ORPCA/P Credit Memo15AddressBill tonVarChar2540
71ORPDGoods Return15AddressBill tonVarChar2540
72OSALOutgoing12AddressAddressnVarChar2540
73OTPIPurchase Tax Invoice21AddressBill tonVarChar2540
74OTRATransition12AddressAddressnVarChar2540
75OTSISales Tax Invoice21AddressBill tonVarChar2540
76OTXDTax Invoice Draft21AddressBill tonVarChar2540
77PCH1A/P Invoice - Rows99AddressAddressnVarChar2540
78PDN1Goods Receipt PO - Rows99AddressAddressnVarChar2540
79POR1Purchase Order - Rows99AddressAddressnVarChar2540
80PQT1Purchase Quotation - Rows99AddressAddressnVarChar2540
81QUT1Sales Quotation - Rows99AddressAddressnVarChar2540
82RDN1Returns - Rows99AddressAddressnVarChar2540
83RDR1Sales Order - Rows99AddressAddressnVarChar2540
84RIN1A/R Credit Memo - Rows99AddressAddressnVarChar2540
85RPC1A/P Credit Memo - Rows99AddressAddressnVarChar2540
86RPD1Goods Return - Rows99AddressAddressnVarChar2540
TOPService
87OTBPTarget Group Business Partner10AddressAddressnVarChar1000
88TGG1Target Group Details14AddressAddressnVarChar1000