SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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