SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

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