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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

77 columns | Print definition?B1 8.82  | INSTANCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log23InstanceInstanceInt600
TOPBanking
2ABOEBill of Exchange for Payment - History40InstanceInstanceInt600
3ACHOChecks for Payment - History41InstanceInstanceInt600
4OBOEBill of Exchange for Payment40InstanceInstanceInt600
5OCHDChecks for Payment Drafts41InstanceInstanceInt600
6OCHHCheck Register25InstanceInstanceInt600
7OCHOChecks for Payment41InstanceInstanceInt600
8OCRHCredit Card Management33InstanceInstanceInt600
9OCRVCredit Payments25InstanceInstanceInt600
TOPBusiness Partners
10ACPNCampaign21InstanceInstanceInt600
11OCLGActivities40InstanceInstanceInt600
12OCPNCampaign21InstanceInstanceInt600
TOPFinance
13BGT1Budget - Rows21InstanceInstanceInt1101
14BGT2Budget - Cost Accounting4InstanceInstanceInt1101
15BGT3Budget - Cost Accounting Rows4InstanceInstanceInt1101
16OBGTBudget23InstanceInstanceInt1101
17ORCRRecurring Postings18InstanceInstanceInt600
18RCR1Recurring Postings - Rows8InstanceInstanceInt60
TOPInventory and Production
19ABTNBatch Numbers Master Data18InstanceInstanceInt600
20ABTWBatch Attributes in Location8InstanceInstanceInt600
21ASRNSerial Numbers Master Data18InstanceInstanceInt600
22OBTNBatch Numbers Master Data18InstanceInstanceInt600
23OBTWBatch Attributes in Location8InstanceInstanceInt600
24ODBNBat. Nos - Draft - Master Data18InstanceInstanceInt600
25ODBWBatch Draft Attribs in Locat.8InstanceInstanceInt600
26ODSNSNs - Draft - Master Data18InstanceInstanceInt600
27ODSWSN Draft Attribs in Location8InstanceInstanceInt600
28OIBTBatch No. for Item28InstanceInstanceInt600
29OIGEGoods Issue49InstanceInstanceInt600
30OIGNGoods Receipt49InstanceInstanceInt600
31OINMWhse Journal37InstanceInstanceInt1100
32OIPFLanded Costs41InstanceInstanceInt600
33OITLInventory Transactions Log29InstanceINSTANCEInt600
34OIVKIVL Vs OINM Keys5InstanceInstanceInt1100
35OMRLAdvanced Inventory Revaluation17InstanceInstanceInt600
36OSRISerial Numbers for Items28InstanceInstanceInt600
37OSRNSerial Numbers Master Data18InstanceInstanceInt600
38OSRWSerial No. Attribs in Location8InstanceInstanceInt600
39OWKOProduction Instructions21InstanceInstanceInt600
40OWTQInventory Transfer Request49InstanceInstanceInt600
41OWTRInventory Transfer49InstanceInstanceInt600
42SIVKIVL Vs OINM Keys5InstanceInstanceInt1100
43UIVKIVL Vs OINM Keys5InstanceInstanceInt1100
44UWKOProduction Instructions21InstanceInstanceInt600
TOPMarketing Documents
45ADOCInvoice - History49InstanceInstanceInt600
46OCINA/R Correction Invoice49InstanceInstanceInt600
47OCPIA/P Correction Invoice49InstanceInstanceInt600
48OCPVA/P Correction Invoice Reversal49InstanceInstanceInt600
49OCSIA/R Correction Invoice49InstanceInstanceInt600
50OCSVA/R Correction Invoice Reversal49InstanceInstanceInt600
51ODLNDelivery49InstanceInstanceInt600
52ODPIA/R Down Payment49InstanceInstanceInt600
53ODPOA/P Down Payment49InstanceInstanceInt600
54ODRFDrafts49InstanceInstanceInt60
55OIEIIncoming Excise Invoice49InstanceInstanceInt600
56OINVA/R Invoice49InstanceInstanceInt600
57OOEIOutgoing Excise Invoice49InstanceInstanceInt600
58OPCHA/P Invoice49InstanceInstanceInt600
59OPDNGoods Receipt PO49InstanceInstanceInt600
60OPORPurchase Order49InstanceInstanceInt600
61OPQTPurchase Quotation49InstanceInstanceInt600
62OQUTSales Quotation49InstanceInstanceInt600
63ORCLRecurring Transaction Instances3InstanceRecurrence InstanceInt1100
64ORDNReturns49InstanceInstanceInt600
65ORDRSales Order49InstanceInstanceInt600
66ORINA/R Credit Memo49InstanceInstanceInt600
67ORPCA/P Credit Memo49InstanceInstanceInt600
68ORPDGoods Return49InstanceInstanceInt600
TOPSales Opportunities
69OOPRSales Opportunity32InstanceInstanceInt600
TOPService
70AINSCustomer Equipment Card - History51InstanceInstanceInt600
71ASC4Service Call Travel/Labor Expenses - History17InstanceInstanceInt600
72ASCLHistory58InstanceInstanceInt600
73OCTRService Contracts60InstanceInstanceInt600
74OINSCustomer Equipment Card51InstanceInstanceInt600
75OSCLService Calls58InstanceInstanceInt600
76OSLTService Call Solutions16InstanceInstanceInt600
77SCL4Expense Documents17InstanceInstanceInt600