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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

94 columns | Print definition?B1 8.82  | DOCDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1OCCDCargo Customs Declaration Numbers5DocDateImp./Exp. Document DateDate80
TOPBanking
2ARCTIncoming Payment - History7DocDatePosting DateDate80
3OPDFPayment Draft7DocDatePosting DateDate80
4ORCTIncoming Payment7DocDatePosting DateDate80
5OVPMOutgoing Payments7DocDatePosting DateDate80
6PEX1Payment Results Table - Rows12DocDateDocument Posting DateDate80
TOPFinance
7GBI7GBI Row 7 - Accounting Vouchers3DocDateDocument DatenVarChar80
8OJSTTDS Adjustment2DocDatePosting DateDate80
9OSLMSpecial Ledger - Analytical Accounting Report: Material2DocDateDate of Report GenerationDate80
10OSLRSpecial Ledger - Analytical Accounting Report: Revenues & Expenses2DocDateDate of Report GenerationDate80
TOPInventory and Production
11AMRVInventory Revaluation - History3DocDatePosting DateDate80
12IGE1Goods Issue - Rows33DocDatePosting DateDate80
13IGN1Goods Receipt - Rows33DocDatePosting DateDate80
14OAIMArchive Inventory Message19DocDateDocument DateDate80
15OENTShipping Types6DocDatePosting DateDate80
16OIGEGoods Issue11DocDatePosting DateDate80
17OIGNGoods Receipt11DocDatePosting DateDate80
18OILMInventory Log Message24DocDateDoc DateDate80
19OINMWhse Journal6DocDatePosting DateDate80
20OIPFLanded Costs3DocDatePosting DateDate80
21OIQIInventory Initial Quantity6DocDatePosting DateDate80
22OIQRInventory Stock Posting (Reconcile)6DocDatePosting DateDate80
23OITLInventory Transactions Log16DocDateDoc. Posting DateDate80
24OIVLWhse Journal5DocDatePosting DateDate80
25OMRLAdvanced Inventory Revaluation4DocDatePosting DateDate80
26OMRVInventory Revaluation3DocDatePosting DateDate80
27OWTQInventory Transfer Request11DocDatePosting DateDate80
28OWTRInventory Transfer11DocDatePosting DateDate80
29SIVLWhse Journal5DocDatePosting DateDate80
30UILMIVI Inventory Log Message24DocDateDoc DateDate80
31UIVLWhse Journal5DocDatePosting DateDate80
32WTQ1Inventory Transfer Request - Rows33DocDatePosting DateDate80
33WTR1Inventory Transfer - Rows33DocDatePosting DateDate80
TOPMarketing Documents
34ADO1A/R Invoice (Rows) - History33DocDatePosting DateDate80
35ADOCInvoice - History11DocDatePosting DateDate80
36ATXITax Invoice - History9DocDatePosting DateDate80
37CIN1Correction Invoice - Rows33DocDatePosting DateDate80
38CPI1A/P Correction Invoice - Rows33DocDatePosting DateDate80
39CPV1A/P Correction Invoice Reversal - Rows33DocDatePosting DateDate80
40CSI1A/R Correction Invoice - Rows33DocDatePosting DateDate80
41CSV1A/R Correction Invoice Reversal - Rows33DocDatePosting DateDate80
42DLN1Delivery - Rows33DocDatePosting DateDate80
43DPI1A/R Down Payment - Rows33DocDatePosting DateDate80
44DPO1A/P Down Payment - Rows33DocDatePosting DateDate80
45DRF1Draft - Rows33DocDatePosting DateDate80
46IEI1Incoming Excise Invoice - Rows33DocDatePosting DateDate80
47INV1A/R Invoice - Rows33DocDatePosting DateDate80
48MIN1Monthly Invoice Report Document Information5DocDateDocument Posting DateDate80
49MIN2Item Imformation of MI4DocDateDocument DateDate80
50MIV1A/P Monthly Invoice - Document5DocDateDocument Posting DateDate80
51MIV2A/P Monthly Invoice - Item4DocDateDocument DateDate80
52OCINA/R Correction Invoice11DocDatePosting DateDate80
53OCPIA/P Correction Invoice11DocDatePosting DateDate80
54OCPVA/P Correction Invoice Reversal11DocDatePosting DateDate80
55OCSIA/R Correction Invoice11DocDatePosting DateDate80
56OCSVA/R Correction Invoice Reversal11DocDatePosting DateDate80
57ODLNDelivery11DocDatePosting DateDate80
58ODPIA/R Down Payment11DocDatePosting DateDate80
59ODPOA/P Down Payment11DocDatePosting DateDate80
60ODRFDrafts11DocDatePosting DateDate80
61OEI1Outgoing Excise Invoice - Rows33DocDatePosting DateDate80
62OGTIGTS Invoice9DocDateDocument DateDate80
63OIEIIncoming Excise Invoice11DocDatePosting DateDate80
64OINVA/R Invoice11DocDatePosting DateDate80
65OOEIOutgoing Excise Invoice11DocDatePosting DateDate80
66OPCHA/P Invoice11DocDatePosting DateDate80
67OPDNGoods Receipt PO11DocDatePosting DateDate80
68OPORPurchase Order11DocDatePosting DateDate80
69OPQNPurchase Quotation Group2DocDatePosting DateDate80
70OPQTPurchase Quotation11DocDatePosting DateDate80
71OQUTSales Quotation11DocDatePosting DateDate80
72ORDNReturns11DocDatePosting DateDate80
73ORDRSales Order11DocDatePosting DateDate80
74ORINA/R Credit Memo11DocDatePosting DateDate80
75ORPCA/P Credit Memo11DocDatePosting DateDate80
76ORPDGoods Return11DocDatePosting DateDate80
77OSALOutgoing6DocDatePosting DateDate80
78OTPIPurchase Tax Invoice9DocDatePosting DateDate80
79OTRATransition6DocDatePosting DateDate80
80OTSISales Tax Invoice9DocDatePosting DateDate80
81OTXDTax Invoice Draft9DocDatePosting DateDate80
82OWDDDocs. for Confirmation6DocDatePosting DateDate80
83PCH1A/P Invoice - Rows33DocDatePosting DateDate80
84PDN1Goods Receipt PO - Rows33DocDatePosting DateDate80
85POR1Purchase Order - Rows33DocDatePosting DateDate80
86PQT1Purchase Quotation - Rows33DocDatePosting DateDate80
87QUT1Sales Quotation - Rows33DocDatePosting DateDate80
88RDN1Returns - Rows33DocDatePosting DateDate80
89RDR1Sales Order - Rows33DocDatePosting DateDate80
90RIN1A/R Credit Memo - Rows33DocDatePosting DateDate80
91RPC1A/P Credit Memo - Rows33DocDatePosting DateDate80
92RPD1Goods Return - Rows33DocDatePosting DateDate80
93VRT2Tax Invoice Report Grid Info6DocDateDoc. DateDate80
TOPMRP
94ORCMRecommendation Data16DocDateGeneration DateDate80