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

132 columns | Print definition?B1 8.8  | CREATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AUSRArchive Users - History69createDateCreation DateDate80
2ODARData Archiving4CreateDateArchive DateDate80
3ODGPDocument Generation Parameter Sets4CreateDateCreation DateDate80
4ODOWData Ownership - Objects7CreateDateCreation DateDate80
5ODOXData Ownership - Exceptions6CreateDateCreation DateDate80
6OUSRUsers69createDateCreation Date - HistoryDate80
TOPBanking
7ABOEBill of Exchange for Payment - History29CreateDateCreation DateDate80
8ACHOChecks for Payment - History32CreateDateCreation DateDate80
9ARCTIncoming Payment - History59CreateDateCreation DateDate80
10OBOEBill of Exchange for Payment29CreateDateCreation DateDate80
11OCHDChecks for Payment Drafts32CreateDateCreation DateDate80
12OCHOChecks for Payment32CreateDateCreation DateDate80
13OCRHCredit Card Management36CreateDateCreation DateDate80
14ODPSDeposit28CreateDateCreation DateDate80
15OITRInternal Reconciliation12CreateDateCreation DateDate80
16OMTHReconciliation History12createDateCreation DateDate80
17OPDFPayment Draft59CreateDateCreation DateDate80
18OPYMPayment Methods for Payment Wizard17CreateDateCreation DateDate80
19ORCTIncoming Payment59CreateDateCreation DateDate80
20OSVRSaved Reconciliations6createDateCreation DateDate80
21OTPWTax Payment Wizard5CreateDateWizard Creation DateDate80
22OVPMOutgoing Payments59CreateDateCreation DateDate80
TOPBusiness Partners
23ACRDBusiness Partners - History132CreateDateCreation DateDate80
24OCRDBusiness Partner132CreateDateCreation DateDate80
TOPFinance
25AACTG/L Account - History38CreateDateCreation DateDate80
26AJDTJournal Entry - History26CreateDateCreation DateDate80
27CASEInternal Recon. Upgrade 2007A2CreateDateCreation DateDate80
28OACTG/L Accounts38CreateDateCreation DateDate80
29OBTFJournal Voucher Entry26CreateDateRecording DateDate80
30OCFHCash Flow Statement History5CreateDateRecording DateDate80
31OGBIGB Interface: Common Info7CreateDateReport Creation DatenVarChar80
32OIWZInflation Wizard31CreateDateCreate DateDate80
33OJDTJournal Entry26CreateDateRecording DateDate80
34OJSTTDS Adjustment8CreateDateCreation DateDate80
35OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material7CreateDateDate of Rule GenerationDate80
36OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses7CreateDateDate of Rule GenerationDate80
37OSHRShareholder's Rights and Interests Report History5CreateDateReport Created onDate80
TOPInventory and Production
38AITBItem Groups - History49createDateCreation Date - HistoryDate80
39AITMItems - History166CreateDateProduction DateDate80
40AITTProduct Tree - History6CreateDateCreation DateDate80
41AITWItems - Warehouse - History50createDateCreation Date - HistoryDate80
42AMRVInventory Revaluation - History12CreateDateCreation DateDate80
43APKLPick List - History14CreateDateCreation DateDate80
44AWHSWarehouses - History56createDateCreation Date - HistoryDate80
45AWORProduction Order - History26CreateDateCreation DateDate80
46LIVI1IVI Log Array File3CreateDateCreate DateDate80
47OAIMArchive Inventory Message24CreateDateCreation DateDate80
48OBTNBatch Numbers Master Data11CreateDateCreation DateDate80
49ODBNBat. Nos - Draft - Master Data11CreateDateCreation DateDate80
50ODSNSNs - Draft - Master Data11CreateDateCreation DateDate80
51OENTShipping Types33CreateDateCreation DateDate80
52OIBTBatch No. for Item19CreateDateCreation DateDate80
53OIGEGoods Issue65CreateDateCreation DateDate80
54OIGNGoods Receipt65CreateDateCreation DateDate80
55OILMInventory Log Message34CreateDateCreation DateDate80
56OINMWhse Journal54CreateDateCreation DateDate80
57OIPFLanded Costs39CreateDateCreation DateDate80
58OIQIInventory Initial Quantity2CreateDateCreation DateDate80
59OIQRInventory Stock Posting (Reconcile)2CreateDateCreation DateDate80
60OITBItem Groups49createDateCreation Date - HistoryDate80
61OITLInventory Transactions Log23CreateDateCreation DateDate80
62OITMItems166CreateDateProduction DateDate80
63OITTProduct Tree6CreateDateCreation DateDate80
64OITWItems - Warehouse50createDateCreation Date - HistoryDate80
65OIVLWhse Journal22CreateDateCreation DateDate80
66OMRLAdvanced Inventory Revaluation19CreateDateCreation DateDate80
67OMRVInventory Revaluation12CreateDateCreation DateDate80
68OPKLPick List14CreateDateCreation DateDate80
69OSRISerial Numbers for Items19CreateDateCreation DateDate80
70OSRNSerial Numbers Master Data11CreateDateCreation DateDate80
71OWHSWarehouses56createDateCreation Date - HistoryDate80
72OWKOProduction Instructions19CreateDateCreation DateDate80
73OWORProduction Order26CreateDateCreation DateDate80
74OWTRInventory Transfer65CreateDateCreation DateDate80
75UILMIVI Inventory Log Message34CreateDateCreation DateDate80
76UITMItems166CreateDateProduction DateDate80
77UITWItems - Warehouse50createDateCreation Date - HistoryDate80
78UIVLWhse Journal22CreateDateCreation DateDate80
79UWKOProduction Instructions19CreateDateCreation DateDate80
80UWORProduction Order26CreateDateCreation DateDate80
TOPMarketing Documents
81ADOCInvoice - History65CreateDateCreation DateDate80
82ATXITax Invoice - History11CreateDateCreation DateDate80
83OCINA/R Correction Invoice65CreateDateCreation DateDate80
84OCPIA/P Correction Invoice65CreateDateCreation DateDate80
85OCPVA/P Correction Invoice Reversal65CreateDateCreation DateDate80
86OCSIA/R Correction Invoice65CreateDateCreation DateDate80
87OCSVA/R Correction Invoice Reversal65CreateDateCreation DateDate80
88ODLNDelivery65CreateDateCreation DateDate80
89ODPIA/R Down Payment65CreateDateCreation DateDate80
90ODPOA/P Down Payment65CreateDateCreation DateDate80
91ODRFDrafts65CreateDateCreation DateDate80
92ODWZDunning Wizard4CreateDateCreation DateDate80
93OIEIIncoming Excise Invoice65CreateDateCreation DateDate80
94OINVA/R Invoice65CreateDateCreation DateDate80
95OOEIOutgoing Excise Invoice65CreateDateCreation DateDate80
96OPCHA/P Invoice65CreateDateCreation DateDate80
97OPDNGoods Receipt PO65CreateDateCreation DateDate80
98OPORPurchase Order65CreateDateCreation DateDate80
99OQUTSales Quotation65CreateDateCreation DateDate80
100ORDNReturns65CreateDateCreation DateDate80
101ORDRSales Order65CreateDateCreation DateDate80
102ORINA/R Credit Memo65CreateDateCreation DateDate80
103ORPCA/P Credit Memo65CreateDateCreation DateDate80
104ORPDGoods Return65CreateDateCreation DateDate80
105OSALOutgoing33CreateDateCreation DateDate80
106OTPIPurchase Tax Invoice11CreateDateCreation DateDate80
107OTRATransition33CreateDateCreation DateDate80
108OTSISales Tax Invoice11CreateDateCreation DateDate80
109OTXDTax Invoice Draft11CreateDateCreation DateDate80
110OWDDDocs. for Confirmation11CreateDateProduction DateDate80
111WDD1Documents for Approval - Authorizers7CreateDateRequest DateDate80
TOPReports
112OLLRElectronic Report Generation Result3CreateDateCreation DateDate80
113RDOCDocument52CreateDateCreation DateDate80
114XROBJXLR Company Report Objects5CreateDateCreation DateDate80
TOPService
115AINSCustomer Equipment Card - History39createDateCreation DateDate80
116ASC1Service Call Solutions - History7createDateCreation Date - HistoryDate80
117ASC2Service Call Inventory Expenses - History15CreateDateCreation Date - HistoryDate80
118ASC3Service Call Travel/Labor Expenses - History15CreateDateCreation DateDate80
119ASC4Service Call Travel/Labor Expenses - History10CreateDateCreation DateDate80
120ASC5Service Call Activities - History7CreateDateCreation DateDate80
121ASCLHistory27createDateCreation DateDate80
122OCTRService Contracts45CreateDateCreation DateDate80
123OCTTContract Template37CreateDateCreation DateDate80
124OINSCustomer Equipment Card39createDateCreation DateDate80
125OREQExternal System Call Request4CreateDateRequest Creation DateDate80
126OSCLService Calls27createDateCreation DateDate80
127QUE2Queue Elements6createDateCreation DateDate80
128SCL1Service Call Solutions - Rows7createDateCreation DateDate80
129SCL2Service Call Inventory Expenses15CreateDateCreation DateDate80
130SCL3Service Call Travel/Labor Expenses15CreateDateCreation DateDate80
131SCL4Expense Documents10CreateDateCreation DateDate80
132SCL5Service Call Activities7CreateDateCreation DateDate80