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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

80 columns | Print definition?B1 9.3  | UPDATETS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1APFSPersonal Fields Setup - History12UpdateTSUpdate Full TimeInt110
2OPFSPersonal Fields Setup12UpdateTSUpdate Full TimeInt110
TOPBanking
3ARCTIncoming Payment - History177UpdateTSUpdate Full TimeInt110
4OITRInternal Reconciliation29UpdateTSUpdate Full TimeInt110
5OPDFPayment Draft177UpdateTSUpdate Full TimeInt110
6ORCTIncoming Payment177UpdateTSUpdate Full TimeInt110
7OVPMOutgoing Payments177UpdateTSUpdate Full TimeInt110
TOPBusiness Partners
8ACRDBusiness Partners - History336UpdateTSUpdate Full TimeInt110
9OCRDBusiness Partner336UpdateTSUpdate Full TimeInt110
TOPGeneral
10APHAProject Management Subproject - History22UpdateTSUpdate Full TimeInt110
11APMGProject Management Document - History31UpdateTSUpdate Full TimeInt110
12ATSHProject Management Time Sheet - Header - History16UpdateTSUpdate Full TimeInt110
13OPHAProject Management Subproject22UpdateTSUpdate Full TimeInt110
14OPMGProject Management Document31UpdateTSUpdate Full TimeInt110
15OTSHProject Management Time Sheet - Header16UpdateTSUpdate Full TimeInt110
TOPHuman Resources
16AHEMEmployees - History133UpdateTSUpdate Full TimeInt110
17OHEMEmployees133UpdateTSUpdate Full TimeInt110
TOPInventory and Production
18AINCInventory Counting29UpdateTSUpdate Full TimeInt110
19AIQIInventory Opening Balance32UpdateTSUpdate Full TimeInt110
20AIQRInventory Posting33UpdateTSUpdate Full TimeInt110
21AITMItems - History301UpdateTSUpdate Full TimeInt110
22AITTProduct Tree - History27UpdateTSUpdate Full TimeInt110
23AWORProduction Order - History54UpdateTSUpdate Full TimeInt110
24OICDInventory Counting Draft29UpdateTSUpdate Full TimeInt110
25OIGEGoods Issue322UpdateTSUpdate Full TimeInt110
26OIGNGoods Receipt322UpdateTSUpdate Full TimeInt110
27OINCInventory Counting29UpdateTSUpdate Full TimeInt110
28OIODInventory Opening Balance Draft32UpdateTSUpdate Full TimeInt110
29OIPDInventory Posting Draft33UpdateTSUpdate Full TimeInt110
30OIQIInventory Opening Balance32UpdateTSUpdate Full TimeInt110
31OIQRInventory Posting33UpdateTSUpdate Full TimeInt110
32OITMItems301UpdateTSUpdate Full TimeInt110
33OITTProduct Tree27UpdateTSUpdate Full TimeInt110
34OWORProduction Order54UpdateTSUpdate Full TimeInt110
35OWTQInventory Transfer Request322UpdateTSUpdate Full TimeInt110
36OWTRInventory Transfer322UpdateTSUpdate Full TimeInt110
37SITMItems301UpdateTSUpdate Full TimeInt110
38UITMItems301UpdateTSUpdate Full TimeInt110
39UWORProduction Order54UpdateTSUpdate Full TimeInt110
TOPMarketing Documents
40ADOCInvoice - History322UpdateTSUpdate Full TimeInt110
41ATROTransportation Document - History18UpdateTSUpdate Full TimeInt110
42OCINA/R Correction Invoice322UpdateTSUpdate Full TimeInt110
43OCPIA/P Correction Invoice322UpdateTSUpdate Full TimeInt110
44OCPVA/P Correction Invoice Reversal322UpdateTSUpdate Full TimeInt110
45OCSIA/R Correction Invoice322UpdateTSUpdate Full TimeInt110
46OCSVA/R Correction Invoice Reversal322UpdateTSUpdate Full TimeInt110
47ODLNDelivery322UpdateTSUpdate Full TimeInt110
48ODPIA/R Down Payment322UpdateTSUpdate Full TimeInt110
49ODPOA/P Down Payment322UpdateTSUpdate Full TimeInt110
50ODRFDrafts322UpdateTSUpdate Full TimeInt110
51OIEIIncoming Excise Invoice322UpdateTSUpdate Full TimeInt110
52OINVA/R Invoice322UpdateTSUpdate Full TimeInt110
53OOEIOutgoing Excise Invoice322UpdateTSUpdate Full TimeInt110
54OPCHA/P Invoice322UpdateTSUpdate Full TimeInt110
55OPDNGoods Receipt PO322UpdateTSUpdate Full TimeInt110
56OPORPurchase Order322UpdateTSUpdate Full TimeInt110
57OPQTPurchase Quotation322UpdateTSUpdate Full TimeInt110
58OPRQPurchase Request322UpdateTSUpdate Full TimeInt110
59OPRRGoods Return Request322UpdateTSUpdate Full TimeInt110
60OQUTSales Quotation322UpdateTSUpdate Full TimeInt110
61ORDNReturns322UpdateTSUpdate Full TimeInt110
62ORDRSales Order322UpdateTSUpdate Full TimeInt110
63ORINA/R Credit Memo322UpdateTSUpdate Full TimeInt110
64ORPCA/P Credit Memo322UpdateTSUpdate Full TimeInt110
65ORPDGoods Return322UpdateTSUpdate Full TimeInt110
66ORRRReturn Request322UpdateTSUpdate Full TimeInt110
67OSFCSelf Credit Memo322UpdateTSUpdate Full TimeInt110
68OSFISelf Invoice322UpdateTSUpdate Full TimeInt110
69OTROTransportation Document18UpdateTSUpdate Full TimeInt110
TOPReports
70AEC2Electronic Transactions32UpdateTSUpdate Time - Incl. SecsInt110
71AEC3Statuses and Logs for Actions in Electronic Communication14UpdateTSUpdate Time - Incl. SecsInt110
72AEC5List of Canceled Reconciliations for Actions in Electronic Communication12UpdateTSUpdate Time - Incl. Sec.Int110
73ECM2Electronic Transactions32UpdateTSUpdate Time - Incl. SecsInt110
74ECM3Statuses and Logs for Actions in Electronic Communication14UpdateTSUpdate Time - Incl. SecsInt110
75ECM5List of Related Documents for Actions in Electronic Communication12UpdateTSUpdate Time - Incl. Sec.Int110
76OGDPGeneral Data Protection Wizard10UpdateTSUpdate Full TimeInt110
TOPSales Opportunities
77ACEMCost Element10UpdateTSUpdate Full TimeInt110
78AOPROpportunity55UpdateTSUpdate Full TimeInt110
79OCEMCost Element10UpdateTSUpdate Full TimeInt110
80OOPROpportunity55UpdateTSUpdate Full TimeInt110