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

126 columns | Print definition?B1 9.2  | SERIES

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CSN1Certificate Series - Series2SeriesSeriesInt60
2DAR1Data Archive - Transaction Log20SeriesSeriesInt60
3NNM1Documents Numbering - Series2SeriesSeriesInt600
4NNM2Series Default3SeriesSeriesInt60
5NNM3Documents Numbering -Belgium Series2SeriesSeriesInt600
6NNM4Electronic Series2SeriesSeriesInt60
7NNM5Document Numbering - Removed Serial Numbers2SeriesSeriesInt60
8ODGPDocument Generation Parameter Sets10SeriesSeriesInt60
TOPBanking
9ARCTIncoming Payment - History62SeriesSeriesInt60
10ODPSDeposit35SeriesSeriesInt60
11OPDFPayment Draft62SeriesSeriesInt60
12OPOIIncoming Payment Order3SeriesSeriesInt60
13OPOOOutgoing Payment Order3SeriesSeriesInt60
14ORCTIncoming Payment62SeriesSeriesInt60
15OTPWTax Payment Wizard9SeriesWizard SeriesInt60
16OVPMOutgoing Payments62SeriesSeriesInt60
TOPBusiness Partners
17ACRDBusiness Partners - History298SeriesSeriesInt60
18AOATBlanket Agreement36SeriesSeriesInt60
19OCRDBusiness Partner298SeriesSeriesInt60
20OOATBlanket Agreement36SeriesSeriesInt60
TOPFinance
21AFADAsset Document - History3SeriesSeriesInt60
22AJDTJournal Entry - History41SeriesSeriesInt600
23OACDCredit Memo3SeriesSeriesInt60
24OACQCapitalization3SeriesSeriesInt60
25OBTFJournal Voucher Entry41SeriesSeriesInt600
26ODRNDepreciation Run3SeriesSeriesInt60
27OFARFixed Asset Revaluation3SeriesSeriesInt60
28OFTRTransfer3SeriesSeriesInt60
29OJDTJournal Entry41SeriesSeriesInt600
30OMDPManual Depreciation3SeriesSeriesInt60
31ORTIRetirement3SeriesSeriesInt60
TOPGeneral
32ARSCResource Master Data - Log3SeriesSeriesInt60
33FND1Folio Numbering - Document Series2SeriesSeries IDInt110
34FNS1Folio Numbering - Voided Series1SeriesSeries IDInt110
35OFNSFolio Numbering - Series1SeriesSeries IDInt110
36ORSCResources3SeriesSeriesInt60
TOPInventory and Production
37AINCInventory Counting3SeriesSeriesInt60
38AIQIInventory Opening Balance17SeriesSeriesInt60
39AIQRInventory Posting17SeriesSeriesInt60
40AITMItems - History252SeriesSeriesInt60
41AMRVInventory Revaluation - History13SeriesSeriesInt600
42AWORProduction Order - History3SeriesSeriesInt600
43IGE21Goods Issue - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
44IGN21Goods Receipt - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
45OENTShipping Types37SeriesSeriesInt60
46OICDInventory Counting Draft3SeriesSeriesInt60
47OIGEGoods Issue70SeriesSeriesInt60
48OIGNGoods Receipt70SeriesSeriesInt60
49OINCInventory Counting3SeriesSeriesInt60
50OIODInventory Opening Balance Draft17SeriesSeriesInt60
51OIPDInventory Posting Draft17SeriesSeriesInt60
52OIPFLanded Costs43SeriesSeriesInt60
53OIQIInventory Opening Balance17SeriesSeriesInt60
54OIQRInventory Posting17SeriesSeriesInt60
55OITMItems252SeriesSeriesInt60
56OMRLAdvanced Inventory Revaluation3SeriesSeriesInt600
57OMRVInventory Revaluation13SeriesSeriesInt60
58OWKOProduction Instructions22SeriesSeriesInt60
59OWORProduction Order3SeriesSeriesInt600
60OWTQInventory Transfer Request70SeriesSeriesInt60
61OWTRInventory Transfer70SeriesSeriesInt60
62SITMItems252SeriesSeriesInt60
63UITMItems252SeriesSeriesInt60
64UWKOProduction Instructions22SeriesSeriesInt60
65UWORProduction Order3SeriesSeriesInt600
66WTQ21Inventory Transfer Request - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
67WTR21Inventory Transfer - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
TOPMarketing Documents
68ADO21A/R Invoice - Document Reference Information - History14SeriesFiscal Document SeriesnVarChar30
69ADOCInvoice - History70SeriesSeriesInt60
70ATXITax Invoice - History14SeriesSeriesInt600
71CIN21Correction Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
72CPI21A/P Correction Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
73CPV21A/P Correction Invoice Reversal - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
74CSI21A/R Correction Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
75CSV21A/R Correction Invoice Reversal - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
76DLN21Delivery - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
77DPI21A/R Down Payment - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
78DPO21A/P Down Payment - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
79DRF21Draft - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
80GPA3Gross Profit Adjustment - JE Details5SeriesSeriesInt600
81GPA7Product Cost Adjustment - Journal Entry Details4SeriesSeriesInt600
82IEI21Incoming Excise Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
83INV21A/R Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
84OCINA/R Correction Invoice70SeriesSeriesInt60
85OCPIA/P Correction Invoice70SeriesSeriesInt60
86OCPVA/P Correction Invoice Reversal70SeriesSeriesInt60
87OCSIA/R Correction Invoice70SeriesSeriesInt60
88OCSVA/R Correction Invoice Reversal70SeriesSeriesInt60
89ODLNDelivery70SeriesSeriesInt60
90ODPIA/R Down Payment70SeriesSeriesInt60
91ODPOA/P Down Payment70SeriesSeriesInt60
92ODRFDrafts70SeriesSeriesInt60
93ODWZDunning Wizard37SeriesSeriesInt600
94OEI21Outgoing Excise Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
95OIEIIncoming Excise Invoice70SeriesSeriesInt60
96OINVA/R Invoice70SeriesSeriesInt60
97OMINA/R Monthly Invoice16SeriesSeriesInt60
98OMIVA/P Monthly Invoice16SeriesSeriesInt60
99OOEIOutgoing Excise Invoice70SeriesSeriesInt60
100OPCHA/P Invoice70SeriesSeriesInt60
101OPDNGoods Receipt PO70SeriesSeriesInt60
102OPORPurchase Order70SeriesSeriesInt60
103OPQTPurchase Quotation70SeriesSeriesInt60
104OPRQPurchase Request70SeriesSeriesInt60
105OQUTSales Quotation70SeriesSeriesInt60
106ORDNReturns70SeriesSeriesInt60
107ORDRSales Order70SeriesSeriesInt60
108ORINA/R Credit Memo70SeriesSeriesInt60
109ORPCA/P Credit Memo70SeriesSeriesInt60
110ORPDGoods Return70SeriesSeriesInt60
111OSALOutgoing37SeriesSeriesInt60
112OTPIPurchase Tax Invoice14SeriesSeriesInt600
113OTRATransition37SeriesSeriesInt60
114OTSISales Tax Invoice14SeriesSeriesInt600
115OTXDTax Invoice Draft14SeriesSeriesInt600
116PCH21A/P Invoice - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
117PDN21Goods Receipt PO - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
118POR21Purchase Order - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
119PQT21Purchase Quotation - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
120PRQ21Purchase Request - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
121QUT21Sales Quotation - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
122RDN21Returns - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
123RDR21Sales Order - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
124RIN21A/R Credit Memo - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
125RPC21A/P Credit Memo - Document Reference Information14SeriesFiscal Document SeriesnVarChar30
126RPD21Goods Return - Document Reference Information14SeriesFiscal Document SeriesnVarChar30