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

102 columns | Print definition?B1 9.3  | ADDRESS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ALR1Queue of messages to be sent7AddressAddressnVarChar1000
2AUSRUsers - 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 AddressVarChar10NN=No, Y=Yes
13ORCTIncoming Payment11AddressAddressnVarChar2540
14OVPMOutgoing Payments11AddressAddressnVarChar2540
TOPBusiness Partners
15ABPLBusiness Place8AddressAddressnVarChar2540
16ACPRContact Persons - History5AddressAddressnVarChar1000
17ACR1Business Partner Addresses - History1AddressAddress NamenVarChar500
18ACR11BP Tributary Info.2AddressAddressnVarChar500
19ACR7Fiscal IDs for BP Master Data2AddressAddressnVarChar500
20ACRDBusiness Partners - History6AddressBill-to StreetnVarChar1000
21CRD1Business Partners - Addresses1AddressAddress NamenVarChar500
22CRD11BP Tributary Info.2AddressAddressnVarChar500
23CRD7Fiscal IDs for BP Master Data2AddressAddressnVarChar500
24OBPLBusiness Place8AddressAddressnVarChar2540
25OCPRContact Persons5AddressAddressnVarChar1000
26OCRDBusiness Partner6AddressBill-to StreetnVarChar1000
27OTBPTarget Group Business Partner10AddressAddressnVarChar1000
28TGG1Target Group Details14AddressAddressnVarChar1000
TOPFinance
29GBI4GBI Row 4 - Business Partners8AddressStreet/PO BoxnVarChar1000
TOPInventory and Production
30IGE1Goods Issue - Rows99AddressAddressnVarChar2540
31IGN1Goods Receipt - Rows99AddressAddressnVarChar2540
32OENTShipping Types12AddressAddressnVarChar2540
33OIGEGoods Issue15AddressBill tonVarChar2540
34OIGNGoods Receipt15AddressBill tonVarChar2540
35OWTQInventory Transfer Request15AddressBill tonVarChar2540
36OWTRInventory Transfer15AddressBill tonVarChar2540
37WTQ1Inventory Transfer Request - Rows99AddressAddressnVarChar2540
38WTR1Inventory Transfer - Rows99AddressAddressnVarChar2540
TOPMarketing Documents
39ADO1A/R Invoice (Rows) - History99AddressAddressnVarChar2540
40ADOCInvoice - History15AddressBill tonVarChar2540
41ATXITax Invoice - History21AddressBill tonVarChar2540
42CIN1Correction Invoice - Rows99AddressAddressnVarChar2540
43CPI1A/P Correction Invoice - Rows99AddressAddressnVarChar2540
44CPV1A/P Correction Invoice Reversal - Rows99AddressAddressnVarChar2540
45CSI1A/R Correction Invoice - Rows99AddressAddressnVarChar2540
46CSV1A/R Correction Invoice Reversal - Rows99AddressAddressnVarChar2540
47DLN1Delivery - Rows99AddressAddressnVarChar2540
48DPI1A/R Down Payment - Rows99AddressAddressnVarChar2540
49DPO1A/P Down Payment - Rows99AddressAddressnVarChar2540
50DRF1Draft - Rows99AddressAddressnVarChar2540
51IEI1Incoming Excise Invoice - Rows99AddressAddressnVarChar2540
52INV1A/R Invoice - Rows99AddressAddressnVarChar2540
53OCINA/R Correction Invoice15AddressBill tonVarChar2540
54OCPIA/P Correction Invoice15AddressBill tonVarChar2540
55OCPVA/P Correction Invoice Reversal15AddressBill tonVarChar2540
56OCSIA/R Correction Invoice15AddressBill tonVarChar2540
57OCSVA/R Correction Invoice Reversal15AddressBill tonVarChar2540
58ODLNDelivery15AddressBill tonVarChar2540
59ODPIA/R Down Payment15AddressBill tonVarChar2540
60ODPOA/P Down Payment15AddressBill tonVarChar2540
61ODRFDrafts15AddressBill tonVarChar2540
62OEI1Outgoing Excise Invoice - Rows99AddressAddressnVarChar2540
63OIEIIncoming Excise Invoice15AddressBill tonVarChar2540
64OINVA/R Invoice15AddressBill tonVarChar2540
65OOEIOutgoing Excise Invoice15AddressBill tonVarChar2540
66OPCHA/P Invoice15AddressBill tonVarChar2540
67OPDNGoods Receipt PO15AddressBill tonVarChar2540
68OPORPurchase Order15AddressBill tonVarChar2540
69OPQTPurchase Quotation15AddressBill tonVarChar2540
70OPRQPurchase Request15AddressBill TonVarChar2540
71OPRRGoods Return Request15AddressBill tonVarChar2540
72OQUTSales Quotation15AddressBill tonVarChar2540
73ORDNReturns15AddressBill tonVarChar2540
74ORDRSales Order15AddressBill tonVarChar2540
75ORINA/R Credit Memo15AddressBill tonVarChar2540
76ORPCA/P Credit Memo15AddressBill tonVarChar2540
77ORPDGoods Return15AddressBill tonVarChar2540
78ORRRReturn Request15AddressBill tonVarChar2540
79OSALOutgoing12AddressAddressnVarChar2540
80OSFCSelf Credit Memo15AddressBill TonVarChar2540
81OSFISelf Invoice15AddressBill TonVarChar2540
82OTPIPurchase Tax Invoice21AddressBill tonVarChar2540
83OTRATransition12AddressAddressnVarChar2540
84OTSISales Tax Invoice21AddressBill tonVarChar2540
85OTXDTax Invoice Draft21AddressBill tonVarChar2540
86PCH1A/P Invoice - Rows99AddressAddressnVarChar2540
87PDN1Goods Receipt PO - Rows99AddressAddressnVarChar2540
88POR1Purchase Order - Rows99AddressAddressnVarChar2540
89PQT1Purchase Quotation - Rows99AddressAddressnVarChar2540
90PRQ1Purchase Request - Rows99AddressAddressnVarChar2540
91PRR1A/P Return Request - Rows99AddressAddressnVarChar2540
92QUT1Sales Quotation - Rows99AddressAddressnVarChar2540
93RDN1Returns - Rows99AddressAddressnVarChar2540
94RDR1Sales Order - Rows99AddressAddressnVarChar2540
95RIN1A/R Credit Memo - Rows99AddressAddressnVarChar2540
96RPC1A/P Credit Memo - Rows99AddressAddressnVarChar2540
97RPD1Goods Return - Rows99AddressAddressnVarChar2540
98RRR1A/R Return Request - Rows99AddressAddressnVarChar2540
99SFC1Self Credit Memo - Rows99AddressAddressnVarChar2540
100SFI1Self Invoice - Rows99AddressAddressnVarChar2540
TOPService
101ASC6Service Call Scheduling - History12AddressAddressnVarChar2540
102SCL6Service Call Scheduling12AddressAddressnVarChar2540