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

303 columns | Print definition?B1 9.3  | USERSIGN2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AADMAdministration - Log313UserSign2Updating UserInt60
2AADPPrint Preferences30UserSign2Updating UserInt60
3ACFPCFOP for Nota Fiscal9UserSign2Updating UserInt60
4ACRCCredit Cards12UserSign2Updating UserInt60
5AEXDFreight Setup34UserSign2Updating UserInt60
6AFMLTax Formula Master Table7UserSign2Updating UserInt60
7AINFCompany Info188UserSign2Updating UserInt60
8ANCMNCM Code5UserSign2Updating UserInt60
9APFSPersonal Fields Setup - History8UserSign2Updating UserInt60
10APJTProject Plan6UserSign2Updating UserInt110
11ARSTRoute Stages - History5UserSign2Updating UserInt60
12ASTCSales Tax Codes15UserSign2Updating UserInt60
13ASTTSales Tax Authorities Type10UserSign2Updating UserInt60
14ATSCCST Code for Nota Fiscal11UserSign2Updating UserInt60
15AUSRUsers - History70userSign2Updating UserInt60
16AWLSWorkflow - Task Details21UserSign2Updating User - HistoryInt60
17CINFCompany Info188UserSign2Updating UserInt60
18OADMAdministration313UserSign2Updating UserInt60
19OADPPrint Preferences30UserSign2Updating UserInt60
20OCFPCFOP for Nota Fiscal9UserSign2Updating UserInt60
21OCRCCredit Cards12UserSign2Updating UserInt60
22OCRNCurrency Codes12UserSign2Updating UserInt60
23OEXDFreight Setup34UserSign2Updating UserInt60
24OFMLTax Formula Master Table7UserSign2Updating UserInt60
25ONCMNCM Code5UserSign2Updating UserInt60
26OPFSPersonal Fields Setup8UserSign2Updating UserInt60
27OPJTProject Plan6UserSign2Updating UserInt110
28ORSTRoute Stages5UserSign2Updating UserInt60
29OSTCSales Tax Codes15UserSign2Updating UserInt60
30OSTTSales Tax Authorities Type10UserSign2Updating UserInt60
31OTSCCST Code for Nota Fiscal11UserSign2Updating UserInt60
32OUSRUsers70userSign2Updating User - HistoryInt60
33OWLSWorkflow - Task Details21UserSign2Updating User - HistoryInt60
TOPBanking
34ABOCExternal Bank Operation Code - Log6UserSign2Updating UserInt60
35ABOEBill of Exchange for Payment - History77UserSign2Updating UserInt60
36ABTCInternal Bank Operation Codes - Log17UserSign2Updating UserInt60
37ACH1Checks for Payment - Rows - History21UserSign2Updating User - HistoryInt60
38ACHOChecks for Payment - History55UserSign2Updating User - HistoryInt60
39ADS1House Bank Accounts63UserSign2Updating UserInt60
40ARCTIncoming Payment - History150UserSign2Updating UserInt60
41CHD1Checks for Payment Drafts - Rows21UserSign2Updating User - HistoryInt60
42CHO1Checks for Payment - Rows21UserSign2Updating User - HistoryInt60
43DSC1House Bank Accounts63UserSign2Updating UserInt60
44OBOCExternal Bank Operation Code Category6UserSign2Updating UserInt60
45OBOEBill of Exchange for Payment77UserSign2Updating UserInt60
46OBTCInternal Bank Operation Codes17UserSign2Updating UserInt60
47OCHDChecks for Payment Drafts55UserSign2Updating User - HistoryInt60
48OCHOChecks for Payment55UserSign2Updating User - HistoryInt60
49OPDFPayment Draft150UserSign2Updating UserInt60
50ORCTIncoming Payment150UserSign2Updating UserInt60
51OVPMOutgoing Payments150UserSign2Updating UserInt60
TOPBusiness Partners
52ABPLBusiness Place14UserSign2Updating UserInt60
53ACLGActivities - History91UserSign2Updating UserInt60
54ACPNCampaign15UserSign2Updating User - HistoryInt60
55ACRDBusiness Partners - History274UserSign2Updating UserInt60
56AOATBlanket Agreement20UserSign2User Signature 2Int60
57OBPLBusiness Place14UserSign2Updating UserInt60
58OCLGActivities91UserSign2Updating UserInt60
59OCPNCampaign15UserSign2Updating User - HistoryInt60
60OCRDBusiness Partner274UserSign2Updating UserInt60
61OOATBlanket Agreement20UserSign2User Signature 2Int60
62OSCNCustomer/Vendor Cat. No.7UserSign2Updating UserInt60
TOPFinance
63AACPPeriods Category-Log134UserSign2Updating UserInt60
64AACSAsset Classes - History10UserSign2Updating UserInt60
65AACTG/L Account - History91UserSign2Updating UserInt60
66AADTFixed Assets Account Determination - History23UserSign2Updating UserInt60
67ADMCG/L Account Determination Criteria - Inventory - History8UserSign2Updating UserInt60
68ADPAFixed Asset Depreciation Areas - History11UserSign2Updating UserInt60
69ADTPFixed Assets Depreciation Types - History34UserSign2Updating UserInt60
70AEXTExpense Types8UserSign2Updating UserInt60
71AFADAsset Document - History24UserSign2Updating UserInt60
72AFPRPosting Period-Log25UserSign2Updating UserInt60
73AGARG/L Account Advanced Rules - History17UserSign2Updating UserInt60
74AJDTJournal Entry - History28UserSign2Updated byInt60
75AMDRManual Distribution Rule12UserSign2Updating UserInt60
76AMDR1Manual Distribution Rule - Rows10UserSign2Updating UserInt60
77APRJProject Codes10UserSign2Updating UserInt60
78AVTGTax Definition33UserSign2Updating UserInt60
79AWHTWithholding Tax34UserSign2Updating UserInt60
80AWTDWithholding Tax Definition19UserSign2Updating UserInt60
81AWTTWithholding Tax Type5UserSign2Updating UserInt60
82MDR1Manual Distribution Rule - Rows10UserSign2Updating UserInt60
83OACDCredit Memo24UserSign2Updating UserInt60
84OACPPeriods Category134UserSign2Updating UserInt60
85OACQCapitalization24UserSign2Updating UserInt60
86OACSAsset Classes10UserSign2Updating UserInt60
87OACTG/L Accounts91UserSign2Updating UserInt60
88OADTFixed Assets Account Determination23UserSign2Updating UserInt60
89OBTFJournal Voucher Entry28UserSign2Updating UserInt60
90ODMCG/L Account Determination Criteria - Inventory8UserSign2Updating UserInt60
91ODPAFixed Asset Depreciation Areas11UserSign2Updating UserInt60
92ODTPFixed Assets Depreciation Types34UserSign2Updating UserInt60
93OEXTExpense Types8UserSign2Updating UserInt60
94OFAAAsset Attributes7UserSign2Updating UserInt60
95OFACFixed Asset Parameter Change6UserSign2Updating UserInt60
96OFPRPosting Period25UserSign2Updating UserInt60
97OFTRTransfer24UserSign2Updating UserInt60
98OGARG/L Account Advanced Rules17UserSign2Updating UserInt60
99OIWZInflation Wizard34userSign2Updating UserInt60
100OJDTJournal Entry28UserSign2Updating UserInt60
101OMDPManual Depreciation24UserSign2Updating UserInt60
102OMDRManual Distribution Rule12UserSign2Updating UserInt60
103ONFMNota Fiscal Model5UserSign2Updating UserInt60
104OPRJProject Codes10UserSign2Updating UserInt60
105ORTIRetirement24UserSign2Updating UserInt60
106OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material10UserSign2Rule Changed ByInt60
107OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses10UserSign2Rule Changed ByInt60
108OVTGTax Definition33UserSign2Updating UserInt60
109OWHTWithholding Tax34UserSign2Updating UserInt60
110OWTDWithholding Tax Definition19UserSign2Updating UserInt60
111OWTTWithholding Tax Type5UserSign2Updating UserInt60
TOPGeneral
112ADRCG/L Account Determination Criteria - Resources - History8UserSign2Updating UserInt60
113AGRSG/L Account Advanced Rules for Resources - History17UserSign2Updating UserInt60
114AHF1Hide Functions Configuration - Rows History16UserSign2Updating UserInt60
115AHF2Hide Function Configuration - Rows History12UserSign2Updating UserInt60
116AHFCHide Functions Configuration - History11UserSign2Updating UserInt60
117AIRIInput Service Distribution - Recipient Invoice23UserSign2Updating UserInt60
118AIRRInput Service Distribution - Recipient Credit Memo23UserSign2Updating UserInt60
119AISCInput Service Distribution - Credit Memo25UserSign2Updating UserInt60
120AISDInput Service Distribution19UserSign2Updating UserInt60
121AISIInput Service Distribution - Invoice25UserSign2Updating UserInt60
122APHAProject Management Subproject - History20UserSign2Updating UserInt60
123APMGProject Management Document - History29UserSign2Updating UserInt60
124ARPARouting Permission Areas6UserSign2Updating UserInt60
125ARPRRouting Permissions6UserSign2Updating UserInt60
126ARSBResource Groups - History9userSign2Updating User - HistoryInt60
127ARSCResource Master Data - Log109UserSign2Updating UserInt60
128ATSHProject Management Time Sheet - Header - History14UserSign2Updating UserInt60
129HFC1Hide Function Configuration - Rows16UserSign2Updating UserInt60
130HFC2Hide Function Configuration - Rows12UserSign2Updating UserInt60
131NFN5NF Skipped Numbers14UserSign2Updating UserInt60
132OBTABrazil - Tax Adjustment44UserSign2Updating UserInt60
133ODRCG/L Account Determination Criteria - Resources8UserSign2Updating UserInt60
134OGRSG/L Account Advanced Rules for Resources17UserSign2Updating UserInt60
135OHFCHide Functions Configuration11UserSign2Updating UserInt60
136OIRIInput Service Distribution - Recipient Invoice23UserSign2Updating UserInt60
137OIRRInput Service Distribution - Recipient Credit Memo23UserSign2Updating UserInt60
138OISCInput Service Distribution - Credit Memo25UserSign2Updating UserInt60
139OISDInput Service Distribution19UserSign2Updating UserInt60
140OISIInput Service Distribution - Invoice25UserSign2Updating UserInt60
141OPHAProject Management Subproject20UserSign2Updating UserInt60
142OPMGProject Management Document29UserSign2Updating UserInt60
143ORPARouting Permission Areas6UserSign2Updating UserInt60
144ORPRRouting Permissions6UserSign2Updating UserInt60
145ORSBResource Groups9userSign2Updating User - HistoryInt60
146ORSCResources109UserSign2Updating UserInt60
147OTSHProject Management Time Sheet - Header14UserSign2Updating UserInt60
TOPHuman Resources
148AHEMEmployees - History97UserSign2Updating UserInt60
149OHEMEmployees97UserSign2Updating UserInt60
TOPInventory and Production
150ABATAttribute - History10UserSign2Updating UserInt60
151ABFCBin Field Configuration - History12UserSign2Updating UserInt60
152ABINBin Location - History50UserSign2Updating UserInt60
153ABSLWarehouse Sublevel - History11UserSign2Updating UserInt60
154ABTNBatch Numbers Master Data23UserSign2Updating UserInt60
155ABTWBatch Attributes in Location13UserSign2Updating UserInt60
156ADNFDNF Code7UserSign2Updating UserInt60
157AEDGDiscount Groups12UserSign2Updating UserInt60
158AIGWItem Group - Warehouse - History10UserSign2Updating UserInt60
159AINCInventory Counting16UserSign2Updating User - HistoryInt60
160AIQIInventory Opening Balance24UserSign2Update User - HistoryInt60
161AIQRInventory Posting23UserSign2Updating User - HistoryInt60
162AITBItem Groups - History50userSign2Updating User - HistoryInt60
163AITMItems - History249UserSign2Updating UserInt60
164AITTProduct Tree - History15UserSign2Updating UserInt110
165AITWItems - Warehouse - History51userSign2Updating User - HistoryInt60
166AMGPMaterial Group5UserSign2Updating UserInt60
167AMRVInventory Revaluation - History17UserSign2Updating UserInt60
168APKLPick List - History16UserSign2Updating UserInt60
169APLNPrice Lists12UserSign2Updating UserInt60
170ASPPSpecial Prices12UserSign2Updating UserInt60
171ASRNSerial Numbers Master Data23UserSign2Updating UserInt60
172ATSPTransporters9UserSign2Updating UserInt60
173AUGPUoM Group8UserSign2Updating UserInt60
174AUOMUoM Master Data8UserSign2Updating UserInt60
175AWHSWarehouses - History57userSign2Updating User - HistoryInt60
176AWORProduction Order - History38UserSign2Updating UserInt60
177OBATBin Location Attribute10UserSign2Updating UserInt60
178OBCDBar Code Master Data9UserSign2Updating UserInt60
179OBFCBin Field Configuration12UserSign2Updating UserInt60
180OBINBin Location50UserSign2Updating UserInt60
181OBSLWarehouse Sublevel11UserSign2Updating UserInt60
182OBTNBatch Numbers Master Data23UserSign2Updating UserInt60
183OBTWBatch Attributes in Location13UserSign2Updating UserInt60
184ODBNBat. Nos - Draft - Master Data23UserSign2Updating UserInt60
185ODBWBatch Draft Attribs in Locat.13UserSign2Updating UserInt60
186ODNFDNF Code7UserSign2Updating UserInt60
187ODSNSNs - Draft - Master Data23UserSign2Updating UserInt60
188ODSWSN Draft Attribs in Location13UserSign2Updating UserInt60
189OEDGDiscount Groups12UserSign2Updating UserInt60
190OICDInventory Counting Draft16UserSign2Updating User - HistoryInt60
191OIGEGoods Issue82UserSign2Updating UserInt60
192OIGNGoods Receipt82UserSign2Updating UserInt60
193OIGWItem Group - Warehouse10UserSign2Updating UserInt60
194OINCInventory Counting16UserSign2Updating User - HistoryInt60
195OIODInventory Opening Balance Draft24UserSign2Update User - HistoryInt60
196OIPDInventory Posting Draft23UserSign2Updating User - HistoryInt60
197OIQIInventory Opening Balance24UserSign2Update User - HistoryInt60
198OIQRInventory Posting23UserSign2Updating User - HistoryInt60
199OITBItem Groups50userSign2Updating User - HistoryInt60
200OITMItems249UserSign2Updating UserInt60
201OITTProduct Tree15UserSign2Updating UserInt110
202OITWItems - Warehouse51userSign2Updating User - HistoryInt60
203OMGPMaterial Group5UserSign2Updating UserInt60
204OMRLAdvanced Inventory Revaluation25UserSign2Updating UserInt60
205OMRVInventory Revaluation17UserSign2Updating UserInt60
206OPKLPick List16UserSign2Updating UserInt60
207OPLNPrice Lists12UserSign2Updating UserInt60
208OSPPSpecial Prices12UserSign2Updating UserInt60
209OSRNSerial Numbers Master Data23UserSign2Updating UserInt60
210OSRWSerial No. Attribs in Location13UserSign2Updating UserInt60
211OTSPTransporters9UserSign2Updating UserInt60
212OUGPUoM Group8UserSign2Updating UserInt60
213OUOMUoM Master Data8UserSign2Updating UserInt60
214OWHSWarehouses57userSign2Updating User - HistoryInt60
215OWORProduction Order38UserSign2Updating UserInt60
216OWTQInventory Transfer Request82UserSign2Updating UserInt60
217OWTRInventory Transfer82UserSign2Updating UserInt60
218SITMItems249UserSign2Updating UserInt60
219SITWItems - Warehouse51userSign2Updating User - HistoryInt60
220UBTNBatch Numbers Master Data23UserSign2Updating UserInt60
221UITMItems249UserSign2Updating UserInt60
222UITWItems - Warehouse51userSign2Updating User - HistoryInt60
223USRNSerial Numbers Master Data23UserSign2Updating UserInt60
224UWORProduction Order38UserSign2Updating UserInt60
TOPMarketing Documents
225ADOCInvoice - History82UserSign2Updating UserInt60
226ATROTransportation Document - History16UserSign2Updating UserInt60
227ATXITax Invoice - History27UserSign2Updating UserInt60
228OCINA/R Correction Invoice82UserSign2Updating UserInt60
229OCPIA/P Correction Invoice82UserSign2Updating UserInt60
230OCPVA/P Correction Invoice Reversal82UserSign2Updating UserInt60
231OCSIA/R Correction Invoice82UserSign2Updating UserInt60
232OCSVA/R Correction Invoice Reversal82UserSign2Updating UserInt60
233ODLNDelivery82UserSign2Updating UserInt60
234ODPIA/R Down Payment82UserSign2Updating UserInt60
235ODPOA/P Down Payment82UserSign2Updating UserInt60
236ODRFDrafts82UserSign2Updating UserInt60
237OIEIIncoming Excise Invoice82UserSign2Updating UserInt60
238OINVA/R Invoice82UserSign2Updating UserInt60
239OOEIOutgoing Excise Invoice82UserSign2Updating UserInt60
240OPCHA/P Invoice82UserSign2Updating UserInt60
241OPDNGoods Receipt PO82UserSign2Updating UserInt60
242OPORPurchase Order82UserSign2Updating UserInt60
243OPQTPurchase Quotation82UserSign2Updating UserInt60
244OPRQPurchase Request82UserSign2Updating UserInt60
245OPRRGoods Return Request82UserSign2Updating UserInt60
246OQUTSales Quotation82UserSign2Updating UserInt60
247ORDNReturns82UserSign2Updating UserInt60
248ORDRSales Order82UserSign2Updating UserInt60
249ORINA/R Credit Memo82UserSign2Updating UserInt60
250ORPCA/P Credit Memo82UserSign2Updating UserInt60
251ORPDGoods Return82UserSign2Updating UserInt60
252ORRRReturn Request82UserSign2Updating UserInt60
253OSFCSelf Credit Memo82UserSign2Updating UserInt60
254OSFISelf Invoice82UserSign2Updating UserInt60
255OTPIPurchase Tax Invoice27UserSign2Updating UserInt60
256OTROTransportation Document16UserSign2Updating UserInt60
257OTSISales Tax Invoice27UserSign2Updating UserInt60
258OTXDTax Invoice Draft27UserSign2Updating UserInt60
TOPReports
259AEC1Parameters for Various Types of Electronic Communication11UserSign2Updating UserInt60
260AEC2Electronic Transactions30UserSign2Updating UserInt60
261AEC3Statuses and Logs for Actions in Electronic Communication12UserSign2Updating UserInt60
262AEC4Import Mapping Determination11UserSign2Updating UserInt60
263AEC5List of Canceled Reconciliations for Actions in Electronic Communication10UserSign2Updating UserInt60
264AQAGQuery Authorization Groups - Log6UserSign2Item Updated ByInt60
265ATHLThresholds10UserSign2Updating UserInt60
266ECM1Parameters for Various Types of Electronic Communication11UserSign2Updating UserInt60
267ECM2Electronic Transactions30UserSign2Updating UserInt60
268ECM3Statuses and Logs for Actions in Electronic Communication12UserSign2Updating UserInt60
269ECM4Import Mapping Determination11UserSign2Updating UserInt60
270ECM5List of Related Documents for Actions in Electronic Communication10UserSign2Updating UserInt60
271OGDPGeneral Data Protection Wizard6UserSign2Updating UserInt60
272OQAGQuery Authorization Groups6UserSign2Item Updated ByInt60
273OTHLThresholds10UserSign2Updating UserInt60
274OTRBTax Report Wizard for Brazil15UserSign2Updating UserInt60
275OTWSE-Tax Web Site6UserSign2Updating UserInt60
276RDOCDocument55UserSign2Updating UserInt60
TOPSales Opportunities
277AOC1Distribution Rule - Rows10UserSign2Updating UserInt60
278AOCRDistribution Rule12UserSign2Updating UserInt60
279AOPROpportunity52UserSign2Updating UserInt60
280APRCCost Center14UserSign2Updating UserInt60
281OCR1Distribution Rule - Rows10UserSign2Updating UserInt60
282OOCRDistribution Rule12UserSign2Updating UserInt60
283OOPROpportunity52UserSign2Updating UserInt60
284OPRCCost Center14UserSign2Updating UserInt60
TOPService
285ACTRService Contracts66UserSign2Updating User - HistoryInt60
286AINSCustomer Equipment Card - History40userSign2Updating UserInt60
287ASC1Service Call Solutions - History8userSign2Updating User - HistoryInt60
288ASC2Service Call Inventory Expenses - History16UserSign2User Signature 2 - HistoryInt60
289ASC3Service Call Travel/Labor Expenses - History16UserSign2User Signature 2Int60
290ASC4Service Call Travel/Labor Expenses - History11UserSign2User Signature 2Int60
291ASC5Service Call Activities - History8UserSign2User Signature 2Int60
292ASCLHistory31userSign2Updating UserInt60
293ASGPService Group for Brazil5UserSign2Updating UserInt60
294OCTRService Contracts66UserSign2Updating User - HistoryInt60
295OINSCustomer Equipment Card40userSign2Updating UserInt60
296ORCIRecipient List7UserSign2Updating UsernVarChar60
297OSCLService Calls31userSign2Updating UserInt60
298OSGPService Group for Brazil5UserSign2Updating UserInt60
299SCL1Service Call Solutions - Rows8userSign2Updating UserInt60
300SCL2Service Call Inventory Expenses16UserSign2User Signature 2Int60
301SCL3Service Call Travel/Labor Expenses16UserSign2User Signature 2Int60
302SCL4Expense Documents11UserSign2User Signature 2Int60
303SCL5Service Call Activities8UserSign2User Signature 2Int60