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
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

263 columns | Print definition?B1 9.2  | UPDATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AADMAdministration - Log276UpdateDateUpdate DateDate80
2AADPPrint Preferences29UpdateDateDate of UpdateDate80
3ACFPCFOP for Nota Fiscal10UpdateDateUpdate DateDate80
4ACRCCredit Cards10UpdateDateDate of UpdateDate80
5AEXDFreight Setup33UpdateDateDate of UpdateDate80
6AFMLTax Formula Master Table8UpdateDateUpdate DateDate80
7AINFCompany Info187UpdateDateDate of UpdateDate80
8ANCMNCM Code6UpdateDateUpdate DateDate80
9APJTProject Plan8UpdateDateDate of UpdateDate80
10ASTCSales Tax Codes16UpdateDateUpdate DateDate80
11ASTTSales Tax Authorities Type11UpdateDateUpdate DateDate80
12ATSCCST Code for Nota Fiscal12UpdateDateUpdate DateDate80
13AUSRArchive Users - History71updateDateUpdate DateDate80
14AWLSWorkflow - Task Details14UpdateDateUpdate Date - HistoryDate80
15CINFCompany Info187UpdateDateDate of UpdateDate80
16OADMAdministration276UpdateDateDate of UpdateDate80
17OADPPrint Preferences29UpdateDateDate of UpdateDate80
18OCFPCFOP for Nota Fiscal10UpdateDateUpdate DateDate80
19OCHF3123UpdateDateDate of UpdateDate80
20OCRCCredit Cards10UpdateDateDate of UpdateDate80
21ODOWData Ownership - Objects8UpdateDateDate of UpdateDate80
22ODOXData Ownership - Exceptions7UpdateDateDate of UpdateDate80
23OEXDFreight Setup33UpdateDateDate of UpdateDate80
24OFMLTax Formula Master Table8UpdateDateUpdate DateDate80
25ONCMNCM Code6UpdateDateUpdate DateDate80
26OPJTProject Plan8UpdateDateDate of UpdateDate80
27OSTCSales Tax Codes16UpdateDateUpdate DateDate80
28OSTTSales Tax Authorities Type11UpdateDateUpdate DateDate80
29OTRNMultilingual Service Table7UpdateDateUpdate DateDate80
30OTSCCST Code for Nota Fiscal12UpdateDateUpdate DateDate80
31OUSRUsers71updateDateDate of Update - HistoryDate80
32OWLSWorkflow - Task Details14UpdateDateUpdate Date - HistoryDate80
TOPBanking
33ABOCExternal Bank Operation Code - Log4UpdateDateDate of UpdateDate80
34ABOEBill of Exchange for Payment - History28UpdateDateDate of UpdateDate80
35ABTCInternal Bank Operation Codes - Log10UpdateDateDate of UpdateDate80
36ACHOChecks for Payment - History31UpdateDateDate of UpdateDate80
37ADS1House Bank Accounts61UpdateDateDate of UpdateDate80
38ARCTIncoming Payment - History58UpdateDateDate of UpdateDate80
39DSC1House Bank Accounts61UpdateDateDate of UpdateDate80
40OBOCExternal Bank Operation Code Category4UpdateDateDate of UpdateDate80
41OBOEBill of Exchange for Payment28UpdateDateDate of UpdateDate80
42OBTCInternal Bank Operation Codes10UpdateDateDate of UpdateDate80
43OCHDChecks for Payment Drafts31UpdateDateDate of UpdateDate80
44OCHOChecks for Payment31UpdateDateDate of UpdateDate80
45ODPSDeposit26UpdateDateDate of UpdateDate80
46OPDFPayment Draft58UpdateDateUpdate DateDate80
47ORCTIncoming Payment58UpdateDateDate of UpdateDate80
48OVPMOutgoing Payments58UpdateDateDate of UpdateDate80
TOPBusiness Partners
49ABPLBusiness Place15UpdateDateUpdate DateDate80
50ACPNCampaign16UpdateDateDate of Update - HistoryDate80
51ACPRContact Persons - History23updateDateDate of UpdateDate80
52ACRDBusiness Partners - History133UpdateDateDate of UpdateDate80
53AWD3WTax Codes Details for BP11UpdateDateDate of UpdateDate80
54AWD4WTax Codes Details for Item8UpdateDateDate of UpdateDate80
55AWD5WTax Codes Details for Freight8UpdateDateDate of UpdateDate80
56OBPLBusiness Place15UpdateDateUpdate DateDate80
57OCPNCampaign16UpdateDateDate of Update - HistoryDate80
58OCPRContact Persons23updateDateDate of UpdateDate80
59OCRDBusiness Partner133UpdateDateDate of UpdateDate80
60WTD3WTax Codes Details for BP11UpdateDateDate of UpdateDate80
61WTD4WTax Codes Details for Item8UpdateDateDate of UpdateDate80
62WTD5WTax Codes Details for Freight8UpdateDateDate of UpdateDate80
TOPFinance
63AACPPeriods Category-Log15UpdateDateDate of UpdateDate80
64AACSAsset Classes - History11UpdateDateDate of UpdateDate80
65AACTG/L Account - History39UpdateDateDate of UpdateDate80
66AADTFixed Assets Account Determination - History24UpdateDateDate of UpdateDate80
67ADMCG/L Account Determination Criteria - Inventory - History6UpdateDateDate of UpdateDate80
68ADPAFixed Asset Depreciation Areas - History12UpdateDateDate of UpdateDate80
69ADTPFixed Assets Depreciation Types - History35UpdateDateDate of UpdateDate80
70AFADAsset Document - History25UpdateDateDate of UpdateDate80
71AFPRPosting Period-Log22UpdateDateDate of UpdateDate80
72AGARG/L Account Advanced Rules - History15UpdateDateDate of UpdateDate80
73AJDTJournal Entry - History25UpdateDateDate of UpdateDate80
74AMDRManual Distribution Rule13updateDateDate of UpdateDate80
75AMDR1Manual Distribution Rule - Rows11updateDateDate of UpdateDate80
76APRJProject Codes11UpdateDateUpdate DateDate80
77AVTGTax Definition30UpdateDateDate of UpdateDate80
78AWHTWithholding Tax17UpdateDateDate of UpdateDate80
79AWTDWithholding Tax Definition17UpdateDateDate of UpdateDate80
80MDR1Manual Distribution Rule - Rows11updateDateDate of UpdateDate80
81OACDCredit Memo25UpdateDateDate of UpdateDate80
82OACPPeriods Category15UpdateDateDate of UpdateDate80
83OACQCapitalization25UpdateDateDate of UpdateDate80
84OACSAsset Classes11UpdateDateDate of UpdateDate80
85OACTG/L Accounts39UpdateDateDate of UpdateDate80
86OADTFixed Assets Account Determination24UpdateDateDate of UpdateDate80
87OBTFJournal Voucher Entry25UpdateDateUpdate DateDate80
88ODMCG/L Account Determination Criteria - Inventory6UpdateDateDate of UpdateDate80
89ODPAFixed Asset Depreciation Areas12UpdateDateDate of UpdateDate80
90ODTPFixed Assets Depreciation Types35UpdateDateDate of UpdateDate80
91OFAAAsset Attributes8UpdateDateDate of UpdateDate80
92OFACFixed Asset Parameter Change7UpdateDateDate of UpdateDate80
93OFPRPosting Period22UpdateDateDate of UpdateDate80
94OFTRTransfer25UpdateDateDate of UpdateDate80
95OGARG/L Account Advanced Rules15UpdateDateDate of UpdateDate80
96OJDTJournal Entry25UpdateDateDate of UpdateDate80
97OMDPManual Depreciation25UpdateDateDate of UpdateDate80
98OMDRManual Distribution Rule13updateDateDate of UpdateDate80
99ONFMNota Fiscal Model6UpdateDateDate of UpdateDate80
100OPRJProject Codes11UpdateDateUpdate DateDate80
101ORTIRetirement25UpdateDateDate of UpdateDate80
102OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material8UpdateDateDate of Rule ChangeDate80
103OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses8UpdateDateDate of Rule ChangeDate80
104OVTGTax Definition30UpdateDateDate of UpdateDate80
105OWHTWithholding Tax17UpdateDateDate of UpdateDate80
106OWTDWithholding Tax Definition17UpdateDateDate of UpdateDate80
TOPGeneral
107ADRCG/L Account Determination Criteria - Resources - History6UpdateDateDate of UpdateDate80
108AGRSG/L Account Advanced Rules for Resources - History15UpdateDateDate of UpdateDate80
109AHF1Hide Functions Configuration - Rows History17UpdateDateDate of UpdateDate80
110AHF2Hide Function Configuration - Rows History13UpdateDateDate of UpdateDate80
111AHFCHide Functions Configuration - History12UpdateDateDate of UpdateDate80
112ARPARouting Permission Areas5UpdateDateDate of UpdateDate80
113ARPRRouting Permissions5UpdateDateDate of UpdateDate80
114ARSBResource Groups - History10updateDateDate of Update - HistoryDate80
115ARSCResource Master Data - Log102UpdateDateDate of UpdateDate80
116ARSTRoute Stages - History13UpdateDateDate of UpdateDate80
117HFC1Hide Functions Configuration - Rows17UpdateDateDate of UpdateDate80
118HFC2Hide Function Configuration - Rows13UpdateDateDate of UpdateDate80
119MDKYMetaData Tables DKeys6UpdateDateUpdate DateDate80
120MFLDMetaData Tables Fields20UpdateDateUpdate DateDate80
121MHKYMetaData Tables HKeys7UpdateDateUpdate DateDate80
122MVALMetaData Tables Fields Vals6UpdateDateUpdate DateDate80
123NFN5NF Skipped Numbers11UpdateDateUpdate DateDate80
124OBTABrazil - Tax Adjustment47UpdateDateDate of UpdateDate80
125ODRCG/L Account Determination Criteria - Resources6UpdateDateDate of UpdateDate80
126OGRSG/L Account Advanced Rules for Resources15UpdateDateDate of UpdateDate80
127OHFCHide Functions Configuration12UpdateDateDate of UpdateDate80
128ONCPNew Cockpit Page6UpdateDateUpdate DateDate80
129ORPARouting Permission Areas5UpdateDateDate of UpdateDate80
130ORPRRouting Permissions5UpdateDateDate of UpdateDate80
131ORSBResource Groups10updateDateDate of Update - HistoryDate80
132ORSCResources102UpdateDateDate of UpdateDate80
133ORSTRoute Stages13UpdateDateDate of UpdateDate80
134RAMIRAMI17UpdateDateUpdate DateDate80
135ROBJTM Import/Export Obj3UpdateDateUpdate DateDate80
136WOBJObject Wizard43UpdateDateUpdate DateDate80
137WORFObject Wizard Related Files13UpdateDateUpdate DateDate80
TOPHuman Resources
138AHEMEmployees98UpdateDateUpdate DateDate80
139OHEMEmployees98UpdateDateUpdate DateDate80
TOPInventory and Production
140ABATAttribute - History11UpdateDateDate of UpdateDate80
141ABFCBin Field Configuration - History13UpdateDateDate of UpdateDate80
142ABINBin Location - History51UpdateDateDate of UpdateDate80
143ABSLWarehouse Sublevel - History12UpdateDateDate of UpdateDate80
144ABTNBatch Numbers Master Data24UpdateDateUpdate DateDate80
145ABTWBatch Attributes in Location14UpdateDateUpdate DateDate80
146ADNFDNF Code8UpdateDateUpdate DateDate80
147AEDGDiscount Groups14UpdateDateUpdate DateDate80
148AIGWItem Group - Warehouse - History11UpdateDateDate of UpdateDate80
149AINCInventory Counting17UpdateDateDate of Update - HistoryDate80
150AIQIInventory Opening Balance25UpdateDateDate of Update - HistoryDate80
151AIQRInventory Posting24UpdateDateDate of Update - HistoryDate80
152AIT9Item - UoM Prices16UpdateDateDate of UpdateDate80
153AITBItem Groups - History51updateDateUpdate Date - HistoryDate80
154AITMItems - History167UpdateDateDate of UpdateDate80
155AITTProduct Tree - History7UpdateDateDate of UpdateDate80
156AITWItems - Warehouse - History52updateDateUpdate Date - HistoryDate80
157AMGPMaterial Group6UpdateDateUpdate DateDate80
158AMRVInventory Revaluation - History11UpdateDateUpdate DateDate80
159APKLPick List - History13UpdateDateDate of UpdateDate80
160APLNPrice Lists13UpdateDateUpdate DateDate80
161ASPPSpecial Prices14UpdateDateUpdate DateDate80
162ASRNSerial Numbers Master Data24UpdateDateUpdate DateDate80
163AUGPUoM Group9UpdateDateDate of UpdateDate80
164AUOMUoM Master Data9UpdateDateDate of UpdateDate80
165AWHSWarehouses - History58updateDateDate of Update - HistoryDate80
166AWORProduction Order - History40UpdateDateUpdate DateDate80
167ITM9Item - UoM Prices16UpdateDateDate of UpdateDate80
168LIVIIVI Log File7UpdateDateDate of UpdateDate80
169OBATBin Location Attribute11UpdateDateDate of UpdateDate80
170OBCDBar Code Master Data10UpdateDateDate of UpdateDate80
171OBFCBin Field Configuration13UpdateDateDate of UpdateDate80
172OBINBin Location51UpdateDateDate of UpdateDate80
173OBSLWarehouse Sublevel12UpdateDateDate of UpdateDate80
174OBTNBatch Numbers Master Data24UpdateDateUpdate DateDate80
175OBTWBatch Attributes in Location14UpdateDateUpdate DateDate80
176ODBNBat. Nos - Draft - Master Data24UpdateDateUpdate DateDate80
177ODBWBatch Draft Attribs in Locat.14UpdateDateUpdate DateDate80
178ODNFDNF Code8UpdateDateUpdate DateDate80
179ODSNSNs - Draft - Master Data24UpdateDateUpdate DateDate80
180ODSWSN Draft Attribs in Location14UpdateDateUpdate DateDate80
181OEDGDiscount Groups14UpdateDateUpdate DateDate80
182OENTShipping Types34UpdateDateDate of UpdateDate80
183OICDInventory Counting Draft17UpdateDateDate of Update - HistoryDate80
184OIGEGoods Issue63UpdateDateDate of UpdateDate80
185OIGNGoods Receipt63UpdateDateDate of UpdateDate80
186OIGWItem Group - Warehouse11UpdateDateDate of UpdateDate80
187OINCInventory Counting17UpdateDateDate of Update - HistoryDate80
188OIODInventory Opening Balance Draft25UpdateDateDate of Update - HistoryDate80
189OIPDInventory Posting Draft24UpdateDateDate of Update - HistoryDate80
190OIPFLanded Costs38UpdateDateDate of UpdateDate80
191OIQIInventory Opening Balance25UpdateDateDate of Update - HistoryDate80
192OIQRInventory Posting24UpdateDateDate of Update - HistoryDate80
193OITBItem Groups51updateDateDate of Update - HistoryDate80
194OITMItems167UpdateDateDate of UpdateDate80
195OITTProduct Tree7UpdateDateDate of UpdateDate80
196OITWItems - Warehouse52updateDateDate of Update - HistoryDate80
197OMGPMaterial Group6UpdateDateUpdate DateDate80
198OMRLAdvanced Inventory Revaluation18UpdateDateDate of UpdateDate80
199OMRVInventory Revaluation11UpdateDateDate of UpdateDate80
200OPKLPick List13UpdateDateDate of UpdateDate80
201OPLNPrice Lists13UpdateDateUpdate DateDate80
202OSPPSpecial Prices14UpdateDateUpdate DateDate80
203OSRNSerial Numbers Master Data24UpdateDateUpdate DateDate80
204OSRWSerial No. Attribs in Location14UpdateDateUpdate DateDate80
205OUGPUoM Group9UpdateDateDate of UpdateDate80
206OUOMUoM Master Data9UpdateDateDate of UpdateDate80
207OWHSWarehouses58updateDateDate of Update - HistoryDate80
208OWKOProduction Instructions18UpdateDateDate of UpdateDate80
209OWORProduction Order40UpdateDateUpdate DateDate80
210OWTQInventory Transfer Request63UpdateDateDate of UpdateDate80
211OWTRInventory Transfer63UpdateDateDate of UpdateDate80
212SITMItems167UpdateDateDate of UpdateDate80
213SITWItems - Warehouse52updateDateDate of Update - HistoryDate80
214UBTNBatch Numbers Master Data24UpdateDateUpdate DateDate80
215UITMItems167UpdateDateDate of UpdateDate80
216UITWItems - Warehouse52updateDateDate of Update - HistoryDate80
217USRNSerial Numbers Master Data24UpdateDateUpdate DateDate80
218UWKOProduction Instructions18UpdateDateDate of UpdateDate80
219UWORProduction Order40UpdateDateUpdate DateDate80
TOPMarketing Documents
220ADOCInvoice - History63UpdateDateUpdate DateDate80
221ATXITax Invoice - History12UpdateDateDate of UpdateDate80
222OCINA/R Correction Invoice63UpdateDateDate of UpdateDate80
223OCPIA/P Correction Invoice63UpdateDateDate of UpdateDate80
224OCPVA/P Correction Invoice Reversal63UpdateDateDate of UpdateDate80
225OCSIA/R Correction Invoice63UpdateDateDate of UpdateDate80
226OCSVA/R Correction Invoice Reversal63UpdateDateDate of UpdateDate80
227ODLNDelivery63UpdateDateDate of UpdateDate80
228ODPIA/R Down Payment63UpdateDateDate of UpdateDate80
229ODPOA/P Down Payment63UpdateDateDate of UpdateDate80
230ODRFDrafts63UpdateDateDate of UpdateDate80
231OIEIIncoming Excise Invoice63UpdateDateUpdate DateDate80
232OINVA/R Invoice63UpdateDateDate of UpdateDate80
233OOEIOutgoing Excise Invoice63UpdateDateUpdate DateDate80
234OPCHA/P Invoice63UpdateDateUpdate DateDate80
235OPDNGoods Receipt PO63UpdateDateDate of UpdateDate80
236OPORPurchase Order63UpdateDateDate of UpdateDate80
237OPQTPurchase Quotation63UpdateDateDate of UpdateDate80
238OPRQPurchase Request63UpdateDateDate of UpdateDate80
239OQUTSales Quotation63UpdateDateDate of UpdateDate80
240ORCPRecurring Transaction Template16UpdateDateUpdate DateDate80
241ORDNReturns63UpdateDateDate of UpdateDate80
242ORDRSales Order63UpdateDateDate of UpdateDate80
243ORINA/R Credit Memo63UpdateDateDate of UpdateDate80
244ORPCA/P Credit Memo63UpdateDateDate of UpdateDate80
245ORPDGoods Return63UpdateDateDate of UpdateDate80
246OSALOutgoing34UpdateDateDate of UpdateDate80
247OTPIPurchase Tax Invoice12UpdateDateDate of UpdateDate80
248OTRATransition34UpdateDateDate of UpdateDate80
249OTSISales Tax Invoice12UpdateDateDate of UpdateDate80
250OTXDTax Invoice Draft12UpdateDateDate of UpdateDate80
251WDD1Documents for Approval - Authorizers9UpdateDateDate of UpdateDate80
TOPMRP
252OMSNMRP Scenarios24UpdateDateUpdate DateDate80
TOPReports
253AEC1Parameters for Various Types of Electronic Communication12UpdateDateUpdate DateDate80
254AEC2Electronic Transactions28UpdateDateUpdate DateDate80
255AEC3Statuses and Logs for Actions in Electronic Communication7UpdateDateUpdate DateDate80
256ATHLThresholds11UpdateDateDate of UpdateDate80
257ECM1Parameters for Various Types of Electronic Communication12UpdateDateUpdate DateDate80
258ECM2Electronic Transactions28UpdateDateUpdate DateDate80
259ECM3Statuses and Logs for Actions in Electronic Communication7UpdateDateUpdate DateDate80
260OTHLThresholds11UpdateDateDate of UpdateDate80
261OTRBTax Report Wizard for Brazil18UpdateDateDate of UpdateDate80
262RDC1Multilingual Report8UpdateDateUpdate DateDate80
263RDOCDocument53UpdateDateDate of UpdateDate80