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
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

120 columns | Print definition?B1 8.8  | UPDATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AADMAdministration - Log289UpdateDateUpdate DateDate80
2ACRCCredit Cards10UpdateDateDate of UpdateDate80
3AEXDFreight Setup33UpdateDateDate of UpdateDate80
4AUSRArchive Users - History71updateDateUpdate DateDate80
5OADMAdministration289UpdateDateDate of UpdateDate80
6OCHF3123UpdateDateDate of UpdateDate80
7OCRCCredit Cards10UpdateDateDate of UpdateDate80
8ODOWData Ownership - Objects8UpdateDateDate of UpdateDate80
9ODOXData Ownership - Exceptions7UpdateDateDate of UpdateDate80
10OEXDFreight Setup33UpdateDateDate of UpdateDate80
11OUSRUsers71updateDateDate of Update - HistoryDate80
TOPBanking
12ABOCExternal Bank Operation Code - Log4UpdateDateDate of UpdateDate80
13ABOEBill of Exchange for Payment - History28UpdateDateDate of UpdateDate80
14ABTCInternal Bank Operation Codes - 10UpdateDateDate of UpdateDate80
15ACHOChecks for Payment - History31UpdateDateDate of UpdateDate80
16ADS1House Bank Accounts61UpdateDateDate of UpdateDate80
17ARCTIncoming Payment - History58UpdateDateDate of UpdateDate80
18DSC1House Bank Accounts61UpdateDateDate of UpdateDate80
19OBOCExternal Bank Operation Code Category4UpdateDateDate of UpdateDate80
20OBOEBill of Exchange for Payment28UpdateDateDate of UpdateDate80
21OBTCInternal Bank Operation Codes10UpdateDateDate of UpdateDate80
22OCHDChecks for Payment Drafts31UpdateDateDate of UpdateDate80
23OCHOChecks for Payment31UpdateDateDate of UpdateDate80
24ODPSDeposit26UpdateDateDate of UpdateDate80
25OPDFPayment Draft58UpdateDateUpdate DateDate80
26ORCTIncoming Payment58UpdateDateDate of UpdateDate80
27OVPMOutgoing Payments58UpdateDateDate of UpdateDate80
TOPBusiness Partners
28ACPRContact Persons - History23updateDateDate of UpdateDate80
29ACRDBusiness Partners - History133UpdateDateDate of UpdateDate80
30OCPRContact Persons23updateDateDate of UpdateDate80
31OCRDBusiness Partner133UpdateDateDate of UpdateDate80
TOPFinance
32AACPPeriods Category-Log15UpdateDateDate of UpdateDate80
33AACTG/L Account - History39UpdateDateDate of UpdateDate80
34AFPRPosting Period-Log22UpdateDateDate of UpdateDate80
35AJDTJournal Entry - History25UpdateDateDate of UpdateDate80
36AVTGTax Definition30UpdateDateDate of UpdateDate80
37AWHTWithholding Tax17UpdateDateDate of UpdateDate80
38OACPPeriods Category15UpdateDateDate of UpdateDate80
39OACTG/L Accounts39UpdateDateDate of UpdateDate80
40OBTFJournal Voucher Entry25UpdateDateUpdate DateDate80
41OFPRPosting Period22UpdateDateDate of UpdateDate80
42OJDTJournal Entry25UpdateDateDate of UpdateDate80
43OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material8UpdateDateDate of Rule ChangeDate80
44OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses8UpdateDateDate of Rule ChangeDate80
45OVTGTax Definition30UpdateDateDate of UpdateDate80
46OWHTWithholding Tax17UpdateDateDate of UpdateDate80
TOPHuman Resources
47AHEMEmployees98UpdateDateUpdate DateDate80
48OHEMEmployees98UpdateDateUpdate DateDate80
TOPInventory and Production
49AITBItem Groups - History51updateDateUpdate Date - HistoryDate80
50AITMItems - History167UpdateDateDate of UpdateDate80
51AITTProduct Tree - History7UpdateDateDate of UpdateDate80
52AITWItems - Warehouse - History52updateDateUpdate Date - HistoryDate80
53AMRVInventory Revaluation - History11UpdateDateUpdate DateDate80
54APKLPick List - History13UpdateDateDate of UpdateDate80
55AWHSWarehouses - History58updateDateDate of Update - HistoryDate80
56AWORProduction Order - History40UpdateDateUpdate DateDate80
57LIVIIVI Log File7UpdateDateDate of UpdateDate80
58OENTShipping Types34UpdateDateDate of UpdateDate80
59OIGEGoods Issue63UpdateDateDate of UpdateDate80
60OIGNGoods Receipt63UpdateDateDate of UpdateDate80
61OIPFLanded Costs38UpdateDateDate of UpdateDate80
62OITBItem Groups51updateDateDate of Update - HistoryDate80
63OITMItems167UpdateDateDate of UpdateDate80
64OITTProduct Tree7UpdateDateDate of UpdateDate80
65OITWItems - Warehouse52updateDateDate of Update - HistoryDate80
66OMRLAdvanced Inventory Revaluation18UpdateDateDate of UpdateDate80
67OMRVInventory Revaluation11UpdateDateDate of UpdateDate80
68OPKLPick List13UpdateDateDate of UpdateDate80
69OWHSWarehouses58updateDateDate of Update - HistoryDate80
70OWKOProduction Instructions18UpdateDateDate of UpdateDate80
71OWORProduction Order40UpdateDateUpdate DateDate80
72OWTRInventory Transfer63UpdateDateDate of UpdateDate80
73UITMItems167UpdateDateDate of UpdateDate80
74UITWItems - Warehouse52updateDateDate of Update - HistoryDate80
75UWKOProduction Instructions18UpdateDateDate of UpdateDate80
76UWORProduction Order40UpdateDateUpdate DateDate80
TOPMarketing Documents
77ADOCInvoice - History63UpdateDateUpdate DateDate80
78ATXITax Invoice - History12UpdateDateDate of UpdateDate80
79OCINA/R Correction Invoice63UpdateDateDate of UpdateDate80
80OCPIA/P Correction Invoice63UpdateDateDate of UpdateDate80
81OCPVA/P Correction Invoice Reversal63UpdateDateDate of UpdateDate80
82OCSIA/R Correction Invoice63UpdateDateDate of UpdateDate80
83OCSVA/R Correction Invoice Reversal63UpdateDateDate of UpdateDate80
84ODLNDelivery63UpdateDateDate of UpdateDate80
85ODPIA/R Down Payment63UpdateDateDate of UpdateDate80
86ODPOA/P Down Payment63UpdateDateDate of UpdateDate80
87ODRFDrafts63UpdateDateDate of UpdateDate80
88OIEIIncoming Excise Invoice63UpdateDateUpdate DateDate80
89OINVA/R Invoice63UpdateDateDate of UpdateDate80
90OOEIOutgoing Excise Invoice63UpdateDateUpdate DateDate80
91OPCHA/P Invoice63UpdateDateUpdate DateDate80
92OPDNGoods Receipt PO63UpdateDateDate of UpdateDate80
93OPORPurchase Order63UpdateDateDate of UpdateDate80
94OQUTSales Quotation63UpdateDateDate of UpdateDate80
95ORDNReturns63UpdateDateDate of UpdateDate80
96ORDRSales Order63UpdateDateDate of UpdateDate80
97ORINA/R Credit Memo63UpdateDateDate of UpdateDate80
98ORPCA/P Credit Memo63UpdateDateDate of UpdateDate80
99ORPDGoods Return63UpdateDateDate of UpdateDate80
100OSALOutgoing34UpdateDateDate of UpdateDate80
101OTPIPurchase Tax Invoice12UpdateDateDate of UpdateDate80
102OTRATransition34UpdateDateDate of UpdateDate80
103OTSISales Tax Invoice12UpdateDateDate of UpdateDate80
104OTXDTax Invoice Draft12UpdateDateDate of UpdateDate80
105WDD1Documents for Approval - Authorizers9UpdateDateDate of UpdateDate80
TOPReports
106RDOCDocument53UpdateDateDate of UpdateDate80
TOPService
107AINSCustomer Equipment Card - History41updateDateUpdate DateDate80
108ASC1Service Call Solutions - History9updateDateDate of Update - HistoryDate80
109ASC2Service Call Inventory Expenses - History17UpdateDateDate of Update - HistoryDate80
110ASC3Service Call Travel/Labor Expenses - History17UpdateDateDate of UpdateDate80
111ASC4Service Call Travel/Labor Expenses - History12UpdateDateDate of UpdateDate80
112ASC5Service Call Activities - History9UpdateDateDate of UpdateDate80
113ASCLHistory32updateDateDate of UpdateDate80
114OINSCustomer Equipment Card41updateDateDate of UpdateDate80
115OSCLService Calls32updateDateDate of UpdateDate80
116SCL1Service Call Solutions - Rows9updateDateDate of UpdateDate80
117SCL2Service Call Inventory Expenses17UpdateDateDate of UpdateDate80
118SCL3Service Call Travel/Labor Expenses17UpdateDateDate of UpdateDate80
119SCL4Expense Documents12UpdateDateDate of UpdateDate80
120SCL5Service Call Activities9UpdateDateDate of UpdateDate80