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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data

129 columns | Print definition?B1 9.1  | 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
12OPMNPayment62SeriesSeriesInt60
13OPOIIncoming Payment Order3SeriesSeriesInt60
14OPOOOutgoing Payment Order3SeriesSeriesInt60
15ORCTIncoming Payment62SeriesSeriesInt60
16OTPWTax Payment Wizard9SeriesWizard SeriesInt60
17OVPMOutgoing Payments62SeriesSeriesInt60
TOPBusiness Partners
18ACRDBusiness Partners - History298SeriesSeriesInt60
19AOATBlanket Agreement36SeriesSeriesInt60
20OCRDBusiness Partner298SeriesSeriesInt60
21OOATBlanket Agreement36SeriesSeriesInt60
TOPFinance
22AFADAsset Document - History3SeriesSeriesInt60
23AJDTJournal Entry - History41SeriesSeriesInt600
24OACDCredit Memo3SeriesSeriesInt60
25OACQCapitalization3SeriesSeriesInt60
26OBTFJournal Voucher Entry41SeriesSeriesInt600
27ODRNDepreciation Run3SeriesSeriesInt60
28OFADAsset Document3SeriesSeriesInt60
29OFARFixed Asset Revaluation3SeriesSeriesInt60
30OFTRTransfer3SeriesSeriesInt60
31OJDTJournal Entry41SeriesSeriesInt600
32OMDPManual Depreciation3SeriesSeriesInt60
33ORTIRetirement3SeriesSeriesInt60
TOPGeneral
34AIWZSummary Wizard45SeriesSeriesInt60
35ARSCResource Master Data - Log3SeriesSeriesInt60
36ORSCResource Master Data3SeriesSeriesInt60
37TDARTemp Data Archive21SeriesSeriesInt60
TOPInventory and Production
38AINCInventory Counting3SeriesSeriesInt60
39AIQIInventory Opening Balance17SeriesSeriesInt60
40AIQRInventory Posting17SeriesSeriesInt60
41AITMItems - History252SeriesSeriesInt60
42AMRVInventory Revaluation - History13SeriesSeriesInt600
43AWORProduction Order - History3SeriesSeriesInt600
44OENTShipping Types37SeriesSeriesInt60
45OICDInventory Counting Draft3SeriesSeriesInt60
46OIGEGoods Issue70SeriesSeriesInt60
47OIGNGoods Receipt70SeriesSeriesInt60
48OINCInventory Counting3SeriesSeriesInt60
49OIODInventory Opening Balance Draft17SeriesSeriesInt60
50OIPDInventory Posting Draft17SeriesSeriesInt60
51OIPFLanded Costs43SeriesSeriesInt60
52OIQIInventory Opening Balance17SeriesSeriesInt60
53OIQRInventory Posting17SeriesSeriesInt60
54OITMItems252SeriesSeriesInt60
55OMRLAdvanced Inventory Revaluation3SeriesSeriesInt600
56OMRVInventory Revaluation13SeriesSeriesInt60
57OWKOProduction Instructions22SeriesSeriesInt60
58OWORProduction Order3SeriesSeriesInt600
59OWTQInventory Transfer Request70SeriesSeriesInt60
60OWTRInventory Transfer70SeriesSeriesInt60
61SITMItems252SeriesSeriesInt60
62UITMItems252SeriesSeriesInt60
63UWKOProduction Instructions22SeriesSeriesInt60
64UWORProduction Order3SeriesSeriesInt600
TOPMarketing Documents
65ADO21A/R Invoice (Resource Costs) - History14SeriesFiscal Document SeriesnVarChar30
66ADOCInvoice - History70SeriesSeriesInt60
67ATXITax Invoice - History14SeriesSeriesInt600
68CIN21Correction Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
69CPI21A/P Correction Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
70CPV21A/P Correction Invoice Reversal - Resource Costs14SeriesFiscal Document SeriesnVarChar30
71CSI21A/R Correction Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
72CSV21A/R Correction Invoice Reversal - Resource Costs14SeriesFiscal Document SeriesnVarChar30
73DLN21Delivery - Resource Costs14SeriesFiscal Document SeriesnVarChar30
74DOC21Mktg Docs - Resource Costs14SeriesFiscal Document SeriesnVarChar30
75DPI21A/R Down Payment - Resource Costs14SeriesFiscal Document SeriesnVarChar30
76DPO21A/P Down Payment - Resource Costs14SeriesFiscal Document SeriesnVarChar30
77DRF21Draft - Resource Costs14SeriesFiscal Document SeriesnVarChar30
78IEI21Incoming Excise Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
79IGE21Goods Issue - Resource Costs14SeriesFiscal Document SeriesnVarChar30
80IGN21Goods Receipt - Resource Costs14SeriesFiscal Document SeriesnVarChar30
81INV21A/R Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
82OCINA/R Correction Invoice70SeriesSeriesInt60
83OCPIA/P Correction Invoice70SeriesSeriesInt60
84OCPVA/P Correction Invoice Reversal70SeriesSeriesInt60
85OCSIA/R Correction Invoice70SeriesSeriesInt60
86OCSVA/R Correction Invoice Reversal70SeriesSeriesInt60
87ODLNDelivery70SeriesSeriesInt60
88ODOCMarketing Documents70SeriesSeriesInt60
89ODPIA/R Down Payment70SeriesSeriesInt60
90ODPOA/P Down Payment70SeriesSeriesInt60
91ODRFDrafts70SeriesSeriesInt60
92ODWZDunning Wizard37SeriesSeriesInt600
93OEI21Outgoing Excise Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
94OIEIIncoming Excise Invoice70SeriesSeriesInt60
95OINVA/R Invoice70SeriesSeriesInt60
96OMINA/R Monthly Invoice16SeriesSeriesInt60
97OMIVA/P Monthly Invoice16SeriesSeriesInt60
98OOEIOutgoing Excise Invoice70SeriesSeriesInt60
99OPCHA/P Invoice70SeriesSeriesInt60
100OPDNGoods Receipt PO70SeriesSeriesInt60
101OPORPurchase Order70SeriesSeriesInt60
102OPQTPurchase Quotation70SeriesSeriesInt60
103OPRQPurchase Request70SeriesSeriesInt60
104OQUTSales Quotation70SeriesSeriesInt60
105ORDNReturns70SeriesSeriesInt60
106ORDRSales Order70SeriesSeriesInt60
107ORINA/R Credit Memo70SeriesSeriesInt60
108ORPCA/P Credit Memo70SeriesSeriesInt60
109ORPDGoods Return70SeriesSeriesInt60
110OSALOutgoing37SeriesSeriesInt60
111OTPIPurchase Tax Invoice14SeriesSeriesInt600
112OTRATransition37SeriesSeriesInt60
113OTSISales Tax Invoice14SeriesSeriesInt600
114OTXDTax Invoice Draft14SeriesSeriesInt600
115PCH21A/P Invoice - Resource Costs14SeriesFiscal Document SeriesnVarChar30
116PDN21Goods Receipt PO - Resource Costs14SeriesFiscal Document SeriesnVarChar30
117POR21Purchase Order - Resource Costs14SeriesFiscal Document SeriesnVarChar30
118PQT21Purchase Quotation - Resource Costs14SeriesFiscal Document SeriesnVarChar30
119PRQ21Purchase Request - Resource Costs14SeriesFiscal Document SeriesnVarChar30
120QUT21Sales Quotation - Resource Costs14SeriesFiscal Document SeriesnVarChar30
121RDN21Returns - Resource Costs14SeriesFiscal Document SeriesnVarChar30
122RDR21Sales Order - Resource Costs14SeriesFiscal Document SeriesnVarChar30
123RIN21A/R Credit Memo - Resource Costs14SeriesFiscal Document SeriesnVarChar30
124RPC21A/P Credit Memo - Resource Costs14SeriesFiscal Document SeriesnVarChar30
125RPD21Goods Return - Resource Costs14SeriesFiscal Document SeriesnVarChar30
126WTQ21Inventory Transfer Request - Resource Costs14SeriesFiscal Document SeriesnVarChar30
127WTR21Inventory Transfer - Resource Costs14SeriesFiscal Document SeriesnVarChar30
TOPService
128ASCLHistory60SeriesSeriesInt60
129OSCLService Calls60SeriesSeriesInt60