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

148 columns | Print definition?B1 9.3  | SERIES

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CSN1Certificate Series - Series2SeriesSeriesInt60
2DAR1Data Archive - Transaction Log20SeriesSeriesInt110
3NNM1Documents Numbering - Series2SeriesSeriesInt1100
4NNM2Series Default3SeriesSeriesInt110
5NNM3Documents Numbering -Belgium Series2SeriesSeriesInt1100
6NNM4Electronic Series2SeriesSeriesInt110
7NNM5Document Numbering - Removed Serial Numbers2SeriesSeriesInt110
8ODGPDocument Generation Parameter Sets10SeriesSeriesInt110
TOPBanking
9ARCTIncoming Payment - History62SeriesSeriesInt110
10ODPSDeposit35SeriesSeriesInt110
11OPDFPayment Draft62SeriesSeriesInt110
12OPOIIncoming Payment Order3SeriesSeriesInt110
13OPOOOutgoing Payment Order3SeriesSeriesInt110
14ORCTIncoming Payment62SeriesSeriesInt110
15OTPWTax Payment Wizard9SeriesWizard SeriesInt110
16OVPMOutgoing Payments62SeriesSeriesInt110
TOPBusiness Partners
17ACRDBusiness Partners - History298SeriesSeriesInt110
18AOATBlanket Agreement36SeriesSeriesInt110
19OCRDBusiness Partner298SeriesSeriesInt110
20OOATBlanket Agreement36SeriesSeriesInt110
TOPFinance
21AFADAsset Document - History3SeriesSeriesInt110
22AJDTJournal Entry - History41SeriesSeriesInt1100
23OACDCredit Memo3SeriesSeriesInt110
24OACQCapitalization3SeriesSeriesInt110
25OBTFJournal Voucher Entry41SeriesSeriesInt1100
26ODRNDepreciation Run3SeriesSeriesInt110
27OFARFixed Asset Revaluation3SeriesSeriesInt110
28OFTRTransfer3SeriesSeriesInt110
29OJDTJournal Entry41SeriesSeriesInt1100
30OMDPManual Depreciation3SeriesSeriesInt110
31ORTIRetirement3SeriesSeriesInt110
TOPGeneral
32AIRIInput Service Distribution - Recipient Invoice3SeriesSeriesInt110
33AIRRInput Service Distribution - Recipient Credit Memo3SeriesSeriesInt110
34AISCInput Service Distribution - Credit Memo3SeriesSeriesInt110
35AISDInput Service Distribution5SeriesSeriesInt110
36AISIInput Service Distribution - Invoice3SeriesSeriesInt110
37APMGProject Management Document - History7SeriesSeriesInt110
38ARSCResource Master Data - Log3SeriesSeriesInt110
39FND1Folio Numbering - Document Series2SeriesSeries IDInt110
40FNS1Folio Numbering - Voided Series1SeriesSeries IDInt110
41OFNSFolio Numbering - Series1SeriesSeries IDInt110
42OIRIInput Service Distribution - Recipient Invoice3SeriesSeriesInt110
43OIRRInput Service Distribution - Recipient Credit Memo3SeriesSeriesInt110
44OISCInput Service Distribution - Credit Memo3SeriesSeriesInt110
45OISDInput Service Distribution5SeriesSeriesInt110
46OISIInput Service Distribution - Invoice3SeriesSeriesInt110
47OPMGProject Management Document7SeriesSeriesInt110
48ORSCResources3SeriesSeriesInt110
TOPInventory and Production
49AINCInventory Counting3SeriesSeriesInt110
50AIQIInventory Opening Balance17SeriesSeriesInt110
51AIQRInventory Posting17SeriesSeriesInt110
52AITMItems - History252SeriesSeriesInt110
53AMRVInventory Revaluation - History13SeriesSeriesInt1100
54AWORProduction Order - History3SeriesSeriesInt1100
55IGE21Goods Issue - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
56IGN21Goods Receipt - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
57OENTShipping Types37SeriesSeriesInt110
58OICDInventory Counting Draft3SeriesSeriesInt110
59OIGEGoods Issue70SeriesSeriesInt110
60OIGNGoods Receipt70SeriesSeriesInt110
61OINCInventory Counting3SeriesSeriesInt110
62OIODInventory Opening Balance Draft17SeriesSeriesInt110
63OIPDInventory Posting Draft17SeriesSeriesInt110
64OIPFLanded Costs43SeriesSeriesInt110
65OIQIInventory Opening Balance17SeriesSeriesInt110
66OIQRInventory Posting17SeriesSeriesInt110
67OITMItems252SeriesSeriesInt110
68OMRLAdvanced Inventory Revaluation3SeriesSeriesInt1100
69OMRVInventory Revaluation13SeriesSeriesInt110
70OWKOProduction Instructions22SeriesSeriesInt110
71OWORProduction Order3SeriesSeriesInt1100
72OWTQInventory Transfer Request70SeriesSeriesInt110
73OWTRInventory Transfer70SeriesSeriesInt110
74SITMItems252SeriesSeriesInt110
75UITMItems252SeriesSeriesInt110
76UWKOProduction Instructions22SeriesSeriesInt110
77UWORProduction Order3SeriesSeriesInt1100
78WTQ21Inventory Transfer Request - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
79WTR21Inventory Transfer - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
TOPMarketing Documents
80ADO21A/R Invoice - Document Reference Information - History15SeriesFiscal Document SeriesnVarChar30
81ADOCInvoice - History70SeriesSeriesInt110
82ATXITax Invoice - History14SeriesSeriesInt1100
83CIN21Correction Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
84CPI21A/P Correction Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
85CPV21A/P Correction Invoice Reversal - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
86CSI21A/R Correction Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
87CSV21A/R Correction Invoice Reversal - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
88DLN21Delivery - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
89DPI21A/R Down Payment - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
90DPO21A/P Down Payment - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
91DRF21Draft - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
92GPA3Gross Profit Adjustment - JE Details5SeriesSeriesInt1100
93GPA7Product Cost Adjustment - Journal Entry Details4SeriesSeriesInt1100
94IEI21Incoming Excise Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
95INV21A/R Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
96OCINA/R Correction Invoice70SeriesSeriesInt110
97OCPIA/P Correction Invoice70SeriesSeriesInt110
98OCPVA/P Correction Invoice Reversal70SeriesSeriesInt110
99OCSIA/R Correction Invoice70SeriesSeriesInt110
100OCSVA/R Correction Invoice Reversal70SeriesSeriesInt110
101ODLNDelivery70SeriesSeriesInt110
102ODPIA/R Down Payment70SeriesSeriesInt110
103ODPOA/P Down Payment70SeriesSeriesInt110
104ODRFDrafts70SeriesSeriesInt110
105ODWZDunning Wizard37SeriesSeriesInt1100
106OEI21Outgoing Excise Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
107OIEIIncoming Excise Invoice70SeriesSeriesInt110
108OINVA/R Invoice70SeriesSeriesInt110
109OMINA/R Monthly Invoice16SeriesSeriesInt110
110OMIVA/P Monthly Invoice16SeriesSeriesInt110
111OOEIOutgoing Excise Invoice70SeriesSeriesInt110
112OPCHA/P Invoice70SeriesSeriesInt110
113OPDNGoods Receipt PO70SeriesSeriesInt110
114OPORPurchase Order70SeriesSeriesInt110
115OPQTPurchase Quotation70SeriesSeriesInt110
116OPRQPurchase Request70SeriesSeriesInt110
117OPRRGoods Return Request70SeriesSeriesInt110
118OQUTSales Quotation70SeriesSeriesInt110
119ORDNReturns70SeriesSeriesInt110
120ORDRSales Order70SeriesSeriesInt110
121ORINA/R Credit Memo70SeriesSeriesInt110
122ORPCA/P Credit Memo70SeriesSeriesInt110
123ORPDGoods Return70SeriesSeriesInt110
124ORRRReturn Request70SeriesSeriesInt110
125OSALOutgoing37SeriesSeriesInt110
126OSFCSelf Credit Memo70SeriesSeriesInt110
127OSFISelf Invoice70SeriesSeriesInt110
128OTPIPurchase Tax Invoice14SeriesSeriesInt1100
129OTRATransition37SeriesSeriesInt110
130OTSISales Tax Invoice14SeriesSeriesInt1100
131OTXDTax Invoice Draft14SeriesSeriesInt1100
132PCH21A/P Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
133PDN21Goods Receipt PO - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
134POR21Purchase Order - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
135PQT21Purchase Quotation - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
136PRQ21Purchase Request - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
137PRR21A/P Return Request - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
138QUT21Sales Quotation - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
139RDN21Returns - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
140RDR21Sales Order - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
141RIN21A/R Credit Memo - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
142RPC21A/P Credit Memo - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
143RPD21Goods Return - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
144RRR21A/R Return Request - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
145SFC21Self Credit Memo - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
146SFI21Self Invoice - Document Reference Information15SeriesFiscal Document SeriesnVarChar30
TOPService
147ASCLHistory60SeriesSeriesInt110
148OSCLService Calls60SeriesSeriesInt110