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

291 columns | Print definition?B1 8.8  | USERSIGN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AADMAdministration - Log290UserSignUser SignatureInt60
2ACRCCredit Cards8UserSignUser SignatureInt60
3AEXDFreight Setup9UserSignUser SignatureInt60
4ALT1Alerts - Users2UserSignUser SignatureInt60
5AUSRArchive Users - History68userSignCreating UserInt60
6CDRODrag & Relate - Output Fields5UserSignUser FormInt60-1
7CPRFColumn Preferences12UserSignUser SignatureInt60
8CTBRToolbars1UserSignInt60
9CUDCUser Display Cat.4UserSignUser SignatureInt60
10CUMFFolder4UserSignUser SignatureInt60
11CUMIMy Menu Items3UserSignUser SignatureInt60
12DMW1Query List3UserSignUser SignatureInt60
13NFN2NFSeq User Default2UserSignUser SignatureInt60
14NNM2Series Default2UserSignUser SignatureInt60
15OADFAddress Formats4UserSignUser SignatureInt60
16OADMAdministration290UserSignUser SignatureInt60
17OAIBReceived Alerts2UserSignUser SignatureInt60
18OALCLoading Expenses6UserSignUser SignatureInt60
19OALRAlerts10UserSignUser SignatureInt60
20OALTAlerts Template22UserSignUser SignatureInt60
21OAOBMessage Sent5UserSignUser SignatureInt60
22OCDTCredit Card Payment23UserSignUser SignatureInt60
23OCFPCFOP for Nota Fiscal7UserSignUser SignaturenVarChar60
24OCHF3122UserSignUser SignatureInt60
25OCPTCockpit Main Table6UserSignUser IDInt60
26OCRCCredit Cards8UserSignUser SignatureInt60
27OCRNCurrency Codes10UserSignUser SignatureInt60
28OCRPPayment Methods11UserSignUser SignatureInt60
29OCRYCountries4UserSignUser SignatureInt60
30OCSTStates4UserSignUser SignatureInt60
31ODARData Archiving3UserSignUser SignatureInt60
32ODGPDocument Generation Parameter Sets6UserSignUser SignatureInt60
33ODMWData Migration6UserSignUser SignatureInt60
34ODOWData Ownership - Objects5UserSignUser SignatureInt60
35ODOXData Ownership - Exceptions4UserSignUser SignatureInt60
36OERNExcise Register Numbering6UserSignUser SignatureInt60
37OERXExcise Register Numbering Ext3UserSignUser SignatureInt60
38OEXDFreight Setup9UserSignUser SignatureInt60
39OGSPGoods Shipment3UserSignUser SignatureInt60
40OIDXCPI Codes5UserSignUser SignatureInt60
41OINDTriangular Deal3UserSignUser SignatureInt60
42OLNGUser Language Table7UserSignUser SignatureInt60
43OMLSDistribution List4UserSignUser SignatureInt60
44OMLTMulti-Language Translation6UserSignUser SignatureInt60
45ONFNNota Fiscal Numbering5UserSignUser SignatureInt60
46ONNMDocument Numbering5UserSignUser SignatureInt60
47OPRFPreferences17UserSignUser SignatureInt60
48OPVLLender - Pelecard5UserSignUser SignatureInt60
49OSHPDelivery Types4UserSignUser SignatureInt60
50OSRLSerial Numbers5UserSignUser SignatureInt60
51OSSPService Supply3UserSignUser SignatureInt60
52OSTASales Tax Authorities7UserSignUser SignatureInt60
53OSTCSales Tax Codes5UserSignUser SignatureInt60
54OSTTSales Tax Authorities Type3UserSignUser SignatureInt60
55OTNN1099 Forms3UserSignUser SignatureInt60
56OTSCCST Code for Nota Fiscal6UserSignUser SignatureInt60
57OUDGUser Defaults26UserSignUser SignatureInt60
58OUPTUser Autorization Tree9UserSignUser SignatureInt60
59OUSGUsage of Nota Fiscal5UserSignUser SignaturenVarChar60
60OUSRUsers68userSignCreating User - HistoryInt60
61OWSTConfirmation Level5UserSignUser SignatureInt60
62OWTMApproval Templates6UserSignUser SignatureInt60
63SDEXDynamic Extensions8UserSignUser SignatureInt60-1
64SDISDynamic Interface (Strings)8UserSignUser SignatureInt60-1
65TNN11099 Boxes4UserSignUser SignatureInt60
TOPBanking
66ABOCExternal Bank Operation Code - Log5UserSignUser SignatureInt60
67ABOEBill of Exchange for Payment - History37UserSignUser SignatureInt60
68ABTCInternal Bank Operation Codes - 11UserSignUser SignatureInt60
69ACH1Checks for Payment - Rows - History12UserSignUser SignatureInt60
70ACHOChecks for Payment - History38UserSignUser SignatureInt60
71ARCTIncoming Payment - History68UserSignUser SignatureInt60
72BOE1Bill of Exchange for Payment - Rows12UserSignUser SignatureInt110
73CHD1Checks for Payment Drafts - Rows12UserSignUser SignatureInt60
74CHO1Checks for Payment - Rows12UserSignUser SignatureInt60
75OBNKExternal Bank Statement Received15UserSignUser SignatureInt60
76OBOCExternal Bank Operation Code Category5UserSignUser SignatureInt60
77OBOEBill of Exchange for Payment37UserSignUser SignatureInt60
78OBOTBill Of Exchang Transaction2UserSignUser SignatureInt60
79OBTCInternal Bank Operation Codes11UserSignUser SignatureInt60
80OCHDChecks for Payment Drafts38UserSignUser SignatureInt60
81OCHOChecks for Payment38UserSignUser SignatureInt60
82OCRHCredit Card Management34UserSignUser SignatureInt60
83OCRVCredit Payments27UserSignUser SignatureInt60
84OCTGPayment Terms16UserSignUser SignatureInt60
85ODPSDeposit41UserSignUser SignatureInt60
86ODPTPostdated Deposit26UserSignUser SignatureInt60
87ODSCBank Codes8UserSignUser SignatureInt60
88OITRInternal Reconciliation15UserSignUser SignatureInt60
89OMTHReconciliation History11UserSignUser SignatureInt60
90OPDFPayment Draft68UserSignUser SignatureInt60
91OPYMPayment Methods for Payment Wizard15UserSignUser SignatureInt60
92ORCTIncoming Payment68UserSignUser SignatureInt60
93OSVRSaved Reconciliations5userSignCreating UserInt60
94OTPWTax Payment Wizard8UserSignUser SignatureInt60
95OUBRBranches4UserSignUser SignatureInt60
96OUDPDepartments4UserSignUser SignatureInt60
97OVPMOutgoing Payments68UserSignUser SignatureInt60
TOPBusiness Partners
98ACPRContact Persons - History15UserSignUser SignatureInt60
99ACR1Business Partner Addresses - History10UserSignUser SignatureInt60
100ACRDBusiness Partners - History149UserSignUser SignatureInt60
101CRD1Business Partners - Addresses10UserSignUser SignatureInt60
102DDT1Withholding Tax Deduction Hierarchy - Rows6UserSignUser SignatureInt60
103OCLGActivities21UserSignUser SignatureInt60
104OCLOMeetings Location4UserSignUser SignatureInt60
105OCLSActivity Subjects5UserSignUser SignatureInt60
106OCLTActivity Types4UserSignUser SignatureInt60
107OCOGCommission Groups7UserSignUser SignatureInt60
108OCPRContact Persons15UserSignUser SignatureInt60
109OCQGCard Properties3UserSignUser SignatureInt60
110OCRDBusiness Partner149UserSignUser SignatureInt60
111OCRGCard Groups6UserSignUser SignatureInt60
112ODDTWithholding Tax Deduction Hierarchy8UserSignUser SignatureInt60
113OPRTPartners7UserSignUser SignatureInt60
114OSCNCustomer/Vendor Cat. No.6UserSignUser SignatureInt60
115OSLPSales Employee8UserSignUser SignatureInt60
TOPFinance
116AACPPeriods Category-Log16UserSignUser SignatureInt60
117AACTG/L Account - History49UserSignUser SignatureInt60
118AFPRPosting Period-Log13UserSignUser SignatureInt60
119AJD1Journal Entry - History - Rows34UserSignUser SignatureInt60
120AJDTJournal Entry - History27UserSignUser SignatureInt60
121AVTGTax Definition9UserSignUser SignatureInt60
122AWHTWithholding Tax18UserSignUser SignatureInt60
123BGT1Budget - Rows23UserSignUser SignatureInt60
124BTF1Journal Voucher 34UserSignUser SignatureInt60
125CASEInternal Recon. Upgrade 2007A4UserSignUser SignatureInt60
126JDT1Journal Entry - Rows34UserSignUser SignatureInt60
127MDR1Manual Distribution Rule - Rows6UserSignUser SignatureInt60
128OACGAccount Category6UserSignUser SignaturenVarChar60
129OACPPeriods Category16UserSignUser SignatureInt60
130OACTG/L Accounts49UserSignUser SignatureInt60
131OASCAccount Segmentation Categories5UserSignUser SignatureInt60
132OASGAccount Segmentation5UserSignUser SignatureInt60
133OBGDBudget Cost Assess. Mthd17UserSignUser SignatureInt60
134OBGSBudget Scenario10UserSignUser SignatureInt60
135OBGTBudget24UserSignUser SignatureInt60
136OBTDJournal Vouchers List9UserSignUser SignatureInt60
137OBTFJournal Voucher Entry27UserSignUser SignatureInt60
138OCFHCash Flow Statement History3UserSignUser SignatureInt60
139ODDGWithholding Tax Deduction Groups6UserSignUser SignatureInt60
140ODGLDeduction Group List3UserSignUser SignatureInt60
141OFPRPosting Period13UserSignUser SignatureInt60
142OFRCFinancial Report Categories56UserSignUser SignatureInt60
143OFRTFinancial Report Templates14UserSignUser SignatureInt60
144OGBIGB Interface: Common Info6UserSignUser SignatureInt60
145OIDCIndicator3UserSignUser SignatureInt60
146OIWZInflation Wizard33userSignCreating UserInt60
147OJDTJournal Entry27UserSignUser SignatureInt60
148OJSTTDS Adjustment7UserSignUser SignatureInt110
149OMDRManual Distribution Rule7UserSignUser SignatureInt60
150OPRJProject Codes5UserSignUser SignatureInt60
151ORCRRecurring Postings20UserSignUser SignatureInt60
152ORTMRate Differences15UserSignUser SignatureInt60
153ORTSCPI and FC Rates for Reports5UserSignUser SignatureInt60
154ORTTCPI and FC Rates5UserSignUser SignatureInt60
155OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material9UserSignRule Created ByInt60
156OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses9UserSignRule Created ByInt60
157OSHRShareholder's Rights and Interests Report History3UserSignCreater's codeInt60
158OSLMSpecial Ledger - Analytical Accounting Report: Material12UserSignUser SignatureInt60
159OSLRSpecial Ledger - Analytical Accounting Report: Revenues & Expenses12UserSignUser SignatureInt60
160OTRCJournal Entry Codes5UserSignUser SignatureInt60
161OTRTPosting Templates7UserSignUser SignatureInt60
162OVTGTax Definition9UserSignUser SignatureInt60
163OWHTWithholding Tax18UserSignUser SignatureInt60
164RCR1Recurring Postings - Rows10UserSignUser SignatureInt60
165TRT1Posting Templates - Rows8UserSignUser SignatureInt60
TOPHuman Resources
166AHEMEmployees96UserSignUser SignatureInt60
167OHEMEmployees96UserSignUser SignatureInt60
TOPInventory and Production
168AITBItem Groups - History5UserSignUser SignatureInt60
169AITMItems - History42UserSignUser SignatureInt60
170AITTProduct Tree - History10UserSignUser SignatureInt60
171AITWItems - Warehouse - History9UserSignUser SignatureInt60
172AMRVInventory Revaluation - History16UserSignUser SignatureInt60
173APKLPick List - History15UserSignUser SignatureInt60
174AWHSWarehouses - History10UserSignUser SignatureInt60
175AWORProduction Order - History15UserSignUser SignatureInt60
176ITW1Item Count Alert3UserSignUser SignatureInt60
177LIVI1IVI Log Array File9UserSignUser SignatureInt60
178OARGCustoms Groups10UserSignUser SignatureInt60
179OBTNBatch Numbers Master Data16UserSignUser SignatureInt60
180OBTWBatch Attributes in Location6UserSignUser SignatureInt60
181OCYCCycle6UserSignUser SignatureInt60
182ODBNBat. Nos - Draft - Master Data16UserSignUser SignatureInt60
183ODBWBatch Draft Attribs in Locat.6UserSignUser SignatureInt60
184ODSNSNs - Draft - Master Data16UserSignUser SignatureInt60
185ODSWSN Draft Attribs in Location6UserSignUser SignatureInt60
186OENTShipping Types40UserSignUser SignatureInt60
187OIBTBatch No. for Item26UserSignUser SignatureInt60
188OIGEGoods Issue77UserSignUser SignatureInt60
189OIGNGoods Receipt77UserSignUser SignatureInt60
190OILMInventory Log Message76UserSignUser SignatureInt60
191OINMWhse Journal30UserSignUser SignatureInt60
192OIPFLanded Costs47UserSignUser SignatureInt60
193OIQIInventory Initial Quantity11UserSignUser SignatureInt60
194OIQRInventory Stock Posting (Reconcile)11UserSignUser SignatureInt60
195OIRTInterest Prices5UserSignUser SignatureInt60
196OITBItem Groups5UserSignUser SignatureInt60
197OITGItem Properties3UserSignUser SignatureInt60
198OITMItems42UserSignUser SignatureInt60
199OITTProduct Tree10UserSignUser SignatureInt60
200OITWItems - Warehouse9UserSignUser SignatureInt60
201OIVLWhse Journal61UserSignUser SignatureInt60
202OLCTLocation3UserSignUser SignatureInt60
203OLGTLength Units8UserSignUser SignatureInt60
204OMRCManufacturers4UserSignUser SignatureInt60
205OMRLAdvanced Inventory Revaluation24UserSignUser SignatureInt60
206OMRVInventory Revaluation16UserSignUser SignatureInt60
207OOFRDefect Cause4UserSignUser SignatureInt60
208OOINInterest4UserSignUser SignatureInt60
209OOIRInterest Level4UserSignUser SignatureInt60
210OOSRInformation Source4UserSignUser SignatureInt60
211OPKLPick List15UserSignUser SignatureInt60
212OPLNPrice Lists9UserSignUser SignatureInt60
213ORCNRetail Chains11UserSignUser SignatureInt60
214OSPGSpecial Prices for Groups6UserSignUser FormInt60
215OSPPSpecial Prices9UserSignUser SignatureInt60
216OSRISerial Numbers for Items26UserSignUser SignatureInt60
217OSRNSerial Numbers Master Data16UserSignUser SignatureInt60
218OSRWSerial No. Attribs in Location6UserSignUser SignatureInt60
219OWGTWeight Units7UserSignUser SignatureInt60
220OWHSWarehouses10UserSignUser SignatureInt60
221OWKOProduction Instructions28UserSignUser SignatureInt60
222OWORProduction Order15UserSignUser SignatureInt60
223OWTRInventory Transfer77UserSignUser SignatureInt60
224UILMIVI Inventory Log Message76UserSignUser SignatureInt60
225UITMItems42UserSignUser SignatureInt60
226UITWItems - Warehouse9UserSignUser SignatureInt60
227UIVLWhse Journal61UserSignUser SignatureInt60
228UWKOProduction Instructions28UserSignUser SignatureInt60
229UWORProduction Order15UserSignUser SignatureInt60
TOPMarketing Documents
230ADOCInvoice - History77UserSignUser SignatureInt60
231ATXITax Invoice - History26UserSignUser SignatureInt60
232OCINA/R Correction Invoice77UserSignUser SignatureInt60
233OCPIA/P Correction Invoice77UserSignUser SignatureInt60
234OCPVA/P Correction Invoice Reversal77UserSignUser SignatureInt60
235OCSIA/R Correction Invoice77UserSignUser SignatureInt60
236OCSVA/R Correction Invoice Reversal77UserSignUser SignatureInt60
237ODLNDelivery77UserSignUser SignatureInt60
238ODPIA/R Down Payment77UserSignUser SignatureInt60
239ODPOA/P Down Payment77UserSignUser SignatureInt60
240ODRFDrafts77UserSignUser SignatureInt60
241ODWZDunning Wizard11UserSignUser SignatureInt60
242OIEIIncoming Excise Invoice77UserSignUser SignatureInt60
243OINVA/R Invoice77UserSignUser SignatureInt60
244OOEIOutgoing Excise Invoice77UserSignUser SignatureInt60
245OPCHA/P Invoice77UserSignUser SignatureInt60
246OPDNGoods Receipt PO77UserSignUser SignatureInt60
247OPORPurchase Order77UserSignUser SignatureInt60
248OQUTSales Quotation77UserSignUser SignatureInt60
249ORDNReturns77UserSignUser SignatureInt60
250ORDRSales Order77UserSignUser SignatureInt60
251ORINA/R Credit Memo77UserSignUser SignatureInt60
252ORPCA/P Credit Memo77UserSignUser SignatureInt60
253ORPDGoods Return77UserSignUser SignatureInt60
254OSALOutgoing40UserSignUser SignatureInt60
255OTPIPurchase Tax Invoice26UserSignUser SignatureInt60
256OTRATransition40UserSignUser SignatureInt60
257OTSISales Tax Invoice26UserSignUser SignatureInt60
258OTXDTax Invoice Draft26UserSignUser SignatureInt60
259OWDDDocs. for Confirmation10UserSignUser SignatureInt60
260WDD1Documents for Approval - Authorizers6UserSignUser SignatureInt60
TOPMRP
261OFCTSales Forecast4UserSignUser SignatureInt60
262ORCMRecommendation Data15UserSignUser SignatureInt60
TOPReports
263FLT1856 Report - Selection Criteria3UserSignUser SignatureInt60
264OFLTReport - Selection Criteria125UserSignUser SignatureInt60
265OLLRElectronic Report Generation Result2UserSignUser SignatureInt60
266OQCNQuery Catagories5UserSignUser SignatureInt60
267OQWZQuery Wizard3UserSignUser SignatureInt60
268RDOCDocument54UserSignUser SignatureInt60
TOPSales Opportunities
269OCMTCompetitors6UserSignUser SignatureInt60
270OCR1Loading Factors - Profit Center6UserSignUser SignatureInt60
271OOCRLoading Factors7UserSignUser SignatureInt60
272OOPRSales Opportunity30UserSignUser SignatureInt60
273OOSTSales Stage6UserSignUser SignatureInt60
274OPR1Sales Opportunity - Rows18UserSignUser SignatureInt60
275OPRCProfit Center7UserSignUser SignatureInt60
TOPService
276AINSCustomer Equipment Card - History38userSignCreating UserInt60
277ASC1Service Call Solutions - History6userSignCreating User - HistoryInt60
278ASC2Service Call Inventory Expenses - History14UserSignUser Signature - HistoryInt60
279ASC3Service Call Travel/Labor Expenses - History14UserSignUser SignatureInt60
280ASC4Service Call Travel/Labor Expenses - History9UserSignUser SignatureInt60
281ASC5Service Call Activities - History6UserSignUser SignatureInt60
282ASCLHistory26userSignCreating UserInt60
283OAGPAgent Name6UserSignUser SignatureInt60
284OINSCustomer Equipment Card38userSignCreating UserInt60
285OREQExternal System Call Request8UserSignLatest Update User CodenVarChar80
286OSCLService Calls26userSignCreating UserInt60
287SCL1Service Call Solutions - Rows6userSignCreating UserInt60
288SCL2Service Call Inventory Expenses14UserSignUser SignatureInt60
289SCL3Service Call Travel/Labor Expenses14UserSignUser SignatureInt60
290SCL4Expense Documents9UserSignUser SignatureInt60
291SCL5Service Call Activities6UserSignUser SignatureInt60