SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

255 columns | Print definition?B1 9.2  | 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
9APJTProject Plan6UserSign2Updating UserInt110
10ASTCSales Tax Codes15UserSign2Updating UserInt60
11ASTTSales Tax Authorities Type10UserSign2Updating UserInt60
12ATSCCST Code for Nota Fiscal11UserSign2Updating UserInt60
13AUSRArchive Users - History70userSign2Updating UserInt60
14AWLSWorkflow - Task Details21UserSign2Updating User - HistoryInt60
15CINFCompany Info188UserSign2Updating UserInt60
16OADMAdministration313UserSign2Updating UserInt60
17OADPPrint Preferences30UserSign2Updating UserInt60
18OCFPCFOP for Nota Fiscal9UserSign2Updating UserInt60
19OCRCCredit Cards12UserSign2Updating UserInt60
20OCRNCurrency Codes12UserSign2Updating UserInt60
21OEXDFreight Setup34UserSign2Updating UserInt60
22OFMLTax Formula Master Table7UserSign2Updating UserInt60
23ONCMNCM Code5UserSign2Updating UserInt60
24OPJTProject Plan6UserSign2Updating UserInt110
25OSTCSales Tax Codes15UserSign2Updating UserInt60
26OSTTSales Tax Authorities Type10UserSign2Updating UserInt60
27OTSCCST Code for Nota Fiscal11UserSign2Updating UserInt60
28OUSRUsers70userSign2Updating User - HistoryInt60
29OWLSWorkflow - Task Details21UserSign2Updating User - HistoryInt60
TOPBanking
30ABOCExternal Bank Operation Code - Log6UserSign2Updating UserInt60
31ABOEBill of Exchange for Payment - History77UserSign2Updating UserInt60
32ABTCInternal Bank Operation Codes - Log17UserSign2Updating UserInt60
33ADS1House Bank Accounts63UserSign2Updating UserInt60
34ARCTIncoming Payment - History150UserSign2Updating UserInt60
35DSC1House Bank Accounts63UserSign2Updating UserInt60
36OBOCExternal Bank Operation Code Category6UserSign2Updating UserInt60
37OBOEBill of Exchange for Payment77UserSign2Updating UserInt60
38OBTCInternal Bank Operation Codes17UserSign2Updating UserInt60
39OPDFPayment Draft150UserSign2Updating UserInt60
40ORCTIncoming Payment150UserSign2Updating UserInt60
41OVPMOutgoing Payments150UserSign2Updating UserInt60
TOPBusiness Partners
42ABPLBusiness Place14UserSign2Updating UserInt60
43ACPNCampaign15UserSign2Updating User - HistoryInt60
44ACRDBusiness Partners - History274UserSign2Updating UserInt60
45AOATBlanket Agreement20UserSign2User Signature 2Int60
46OBPLBusiness Place14UserSign2Updating UserInt60
47OCPNCampaign15UserSign2Updating User - HistoryInt60
48OCRDBusiness Partner274UserSign2Updating UserInt60
49OOATBlanket Agreement20UserSign2User Signature 2Int60
50OSCNCustomer/Vendor Cat. No.7UserSign2Updating UserInt60
TOPFinance
51AACPPeriods Category-Log134UserSign2Updating UserInt60
52AACSAsset Classes - History10UserSign2Updating UserInt60
53AACTG/L Account - History91UserSign2Updating UserInt60
54AADTFixed Assets Account Determination - History23UserSign2Updating UserInt60
55ADMCG/L Account Determination Criteria - Inventory - History8UserSign2Updating UserInt60
56ADPAFixed Asset Depreciation Areas - History11UserSign2Updating UserInt60
57ADTPFixed Assets Depreciation Types - History34UserSign2Updating UserInt60
58AFADAsset Document - History24UserSign2Updating UserInt60
59AFPRPosting Period-Log25UserSign2Updating UserInt60
60AGARG/L Account Advanced Rules - History17UserSign2Updating UserInt60
61AJDTJournal Entry - History28UserSign2Updated byInt60
62AMDRManual Distribution Rule12UserSign2Updating UserInt60
63AMDR1Manual Distribution Rule - Rows10UserSign2Updating UserInt60
64APRJProject Codes10UserSign2Updating UserInt60
65AVTGTax Definition33UserSign2Updating UserInt60
66AWHTWithholding Tax34UserSign2Updating UserInt60
67AWTDWithholding Tax Definition19UserSign2Updating UserInt60
68MDR1Manual Distribution Rule - Rows10UserSign2Updating UserInt60
69OACDCredit Memo24UserSign2Updating UserInt60
70OACPPeriods Category134UserSign2Updating UserInt60
71OACQCapitalization24UserSign2Updating UserInt60
72OACSAsset Classes10UserSign2Updating UserInt60
73OACTG/L Accounts91UserSign2Updating UserInt60
74OADTFixed Assets Account Determination23UserSign2Updating UserInt60
75OBTFJournal Voucher Entry28UserSign2Updating UserInt60
76ODMCG/L Account Determination Criteria - Inventory8UserSign2Updating UserInt60
77ODPAFixed Asset Depreciation Areas11UserSign2Updating UserInt60
78ODTPFixed Assets Depreciation Types34UserSign2Updating UserInt60
79OFAAAsset Attributes7UserSign2Updating UserInt60
80OFACFixed Asset Parameter Change6UserSign2Updating UserInt60
81OFPRPosting Period25UserSign2Updating UserInt60
82OFTRTransfer24UserSign2Updating UserInt60
83OGARG/L Account Advanced Rules17UserSign2Updating UserInt60
84OIWZInflation Wizard34userSign2Updating UserInt60
85OJDTJournal Entry28UserSign2Updating UserInt60
86OMDPManual Depreciation24UserSign2Updating UserInt60
87OMDRManual Distribution Rule12UserSign2Updating UserInt60
88ONFMNota Fiscal Model5UserSign2Updating UserInt60
89OPRJProject Codes10UserSign2Updating UserInt60
90ORTIRetirement24UserSign2Updating UserInt60
91OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material10UserSign2Rule Changed ByInt60
92OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses10UserSign2Rule Changed ByInt60
93OVTGTax Definition33UserSign2Updating UserInt60
94OWHTWithholding Tax34UserSign2Updating UserInt60
95OWTDWithholding Tax Definition19UserSign2Updating UserInt60
TOPGeneral
96ADRCG/L Account Determination Criteria - Resources - History8UserSign2Updating UserInt60
97AGRSG/L Account Advanced Rules for Resources - History17UserSign2Updating UserInt60
98AHF1Hide Functions Configuration - Rows History16UserSign2Updating UserInt60
99AHF2Hide Function Configuration - Rows History12UserSign2Updating UserInt60
100AHFCHide Functions Configuration - History11UserSign2Updating UserInt60
101ARPARouting Permission Areas6UserSign2Updating UserInt60
102ARPRRouting Permissions6UserSign2Updating UserInt60
103ARSBResource Groups - History9userSign2Updating User - HistoryInt60
104ARSCResource Master Data - Log109UserSign2Updating UserInt60
105ARSTRoute Stages - History14UserSign2Updating UserInt60
106HFC1Hide Functions Configuration - Rows16UserSign2Updating UserInt60
107HFC2Hide Function Configuration - Rows12UserSign2Updating UserInt60
108NFN5NF Skipped Numbers14UserSign2Updating UserInt60
109OBTABrazil - Tax Adjustment44UserSign2Updating UserInt60
110ODRCG/L Account Determination Criteria - Resources8UserSign2Updating UserInt60
111OGRSG/L Account Advanced Rules for Resources17UserSign2Updating UserInt60
112OHFCHide Functions Configuration11UserSign2Updating UserInt60
113ORPARouting Permission Areas6UserSign2Updating UserInt60
114ORPRRouting Permissions6UserSign2Updating UserInt60
115ORSBResource Groups9userSign2Updating User - HistoryInt60
116ORSCResources109UserSign2Updating UserInt60
117ORSTRoute Stages14UserSign2Updating UserInt60
TOPHuman Resources
118AHEMEmployees97UserSign2Updating UserInt60
119OHEMEmployees97UserSign2Updating UserInt60
TOPInventory and Production
120ABATAttribute - History10UserSign2Updating UserInt60
121ABFCBin Field Configuration - History12UserSign2Updating UserInt60
122ABINBin Location - History50UserSign2Updating UserInt60
123ABSLWarehouse Sublevel - History11UserSign2Updating UserInt60
124ABTNBatch Numbers Master Data23UserSign2Updating UserInt60
125ABTWBatch Attributes in Location13UserSign2Updating UserInt60
126ADNFDNF Code7UserSign2Updating UserInt60
127AEDGDiscount Groups12UserSign2Updating UserInt60
128AIGWItem Group - Warehouse - History10UserSign2Updating UserInt60
129AINCInventory Counting16UserSign2Updating User - HistoryInt60
130AIQIInventory Opening Balance24UserSign2Update User - HistoryInt60
131AIQRInventory Posting23UserSign2Updating User - HistoryInt60
132AITBItem Groups - History50userSign2Updating User - HistoryInt60
133AITMItems - History249UserSign2Updating UserInt60
134AITTProduct Tree - History16UserSign2Updating UserInt110
135AITWItems - Warehouse - History51userSign2Updating User - HistoryInt60
136AMGPMaterial Group5UserSign2Updating UserInt60
137AMRVInventory Revaluation - History17UserSign2Updating UserInt60
138APKLPick List - History16UserSign2Updating UserInt60
139APLNPrice Lists12UserSign2Updating UserInt60
140ASPPSpecial Prices12UserSign2Updating UserInt60
141ASRNSerial Numbers Master Data23UserSign2Updating UserInt60
142AUGPUoM Group8UserSign2Updating UserInt60
143AUOMUoM Master Data8UserSign2Updating UserInt60
144AWHSWarehouses - History57userSign2Updating User - HistoryInt60
145AWORProduction Order - History39UserSign2Updating UserInt60
146OBATBin Location Attribute10UserSign2Updating UserInt60
147OBCDBar Code Master Data9UserSign2Updating UserInt60
148OBFCBin Field Configuration12UserSign2Updating UserInt60
149OBINBin Location50UserSign2Updating UserInt60
150OBSLWarehouse Sublevel11UserSign2Updating UserInt60
151OBTNBatch Numbers Master Data23UserSign2Updating UserInt60
152OBTWBatch Attributes in Location13UserSign2Updating UserInt60
153ODBNBat. Nos - Draft - Master Data23UserSign2Updating UserInt60
154ODBWBatch Draft Attribs in Locat.13UserSign2Updating UserInt60
155ODNFDNF Code7UserSign2Updating UserInt60
156ODSNSNs - Draft - Master Data23UserSign2Updating UserInt60
157ODSWSN Draft Attribs in Location13UserSign2Updating UserInt60
158OEDGDiscount Groups12UserSign2Updating UserInt60
159OICDInventory Counting Draft16UserSign2Updating User - HistoryInt60
160OIGEGoods Issue82UserSign2Updating UserInt60
161OIGNGoods Receipt82UserSign2Updating UserInt60
162OIGWItem Group - Warehouse10UserSign2Updating UserInt60
163OINCInventory Counting16UserSign2Updating User - HistoryInt60
164OIODInventory Opening Balance Draft24UserSign2Update User - HistoryInt60
165OIPDInventory Posting Draft23UserSign2Updating User - HistoryInt60
166OIQIInventory Opening Balance24UserSign2Update User - HistoryInt60
167OIQRInventory Posting23UserSign2Updating User - HistoryInt60
168OITBItem Groups50userSign2Updating User - HistoryInt60
169OITMItems249UserSign2Updating UserInt60
170OITTProduct Tree16UserSign2Updating UserInt110
171OITWItems - Warehouse51userSign2Updating User - HistoryInt60
172OMGPMaterial Group5UserSign2Updating UserInt60
173OMRLAdvanced Inventory Revaluation25UserSign2Updating UserInt60
174OMRVInventory Revaluation17UserSign2Updating UserInt60
175OPKLPick List16UserSign2Updating UserInt60
176OPLNPrice Lists12UserSign2Updating UserInt60
177OSPPSpecial Prices12UserSign2Updating UserInt60
178OSRNSerial Numbers Master Data23UserSign2Updating UserInt60
179OSRWSerial No. Attribs in Location13UserSign2Updating UserInt60
180OUGPUoM Group8UserSign2Updating UserInt60
181OUOMUoM Master Data8UserSign2Updating UserInt60
182OWHSWarehouses57userSign2Updating User - HistoryInt60
183OWORProduction Order39UserSign2Updating UserInt60
184OWTQInventory Transfer Request82UserSign2Updating UserInt60
185OWTRInventory Transfer82UserSign2Updating UserInt60
186SITMItems249UserSign2Updating UserInt60
187SITWItems - Warehouse51userSign2Updating User - HistoryInt60
188UBTNBatch Numbers Master Data23UserSign2Updating UserInt60
189UITMItems249UserSign2Updating UserInt60
190UITWItems - Warehouse51userSign2Updating User - HistoryInt60
191USRNSerial Numbers Master Data23UserSign2Updating UserInt60
192UWORProduction Order39UserSign2Updating UserInt60
TOPMarketing Documents
193ADOCInvoice - History82UserSign2Updating UserInt60
194ATXITax Invoice - History27UserSign2Updating UserInt60
195OCINA/R Correction Invoice82UserSign2Updating UserInt60
196OCPIA/P Correction Invoice82UserSign2Updating UserInt60
197OCPVA/P Correction Invoice Reversal82UserSign2Updating UserInt60
198OCSIA/R Correction Invoice82UserSign2Updating UserInt60
199OCSVA/R Correction Invoice Reversal82UserSign2Updating UserInt60
200ODLNDelivery82UserSign2Updating UserInt60
201ODPIA/R Down Payment82UserSign2Updating UserInt60
202ODPOA/P Down Payment82UserSign2Updating UserInt60
203ODRFDrafts82UserSign2Updating UserInt60
204OIEIIncoming Excise Invoice82UserSign2Updating UserInt60
205OINVA/R Invoice82UserSign2Updating UserInt60
206OOEIOutgoing Excise Invoice82UserSign2Updating UserInt60
207OPCHA/P Invoice82UserSign2Updating UserInt60
208OPDNGoods Receipt PO82UserSign2Updating UserInt60
209OPORPurchase Order82UserSign2Updating UserInt60
210OPQTPurchase Quotation82UserSign2Updating UserInt60
211OPRQPurchase Request82UserSign2Updating UserInt60
212OQUTSales Quotation82UserSign2Updating UserInt60
213ORDNReturns82UserSign2Updating UserInt60
214ORDRSales Order82UserSign2Updating UserInt60
215ORINA/R Credit Memo82UserSign2Updating UserInt60
216ORPCA/P Credit Memo82UserSign2Updating UserInt60
217ORPDGoods Return82UserSign2Updating UserInt60
218OTPIPurchase Tax Invoice27UserSign2Updating UserInt60
219OTSISales Tax Invoice27UserSign2Updating UserInt60
220OTXDTax Invoice Draft27UserSign2Updating UserInt60
TOPReports
221AEC1Parameters for Various Types of Electronic Communication11UserSign2Updating UserInt60
222AEC2Electronic Transactions27UserSign2Updating UserInt60
223AEC3Statuses and Logs for Actions in Electronic Communication6UserSign2Updating UserInt60
224ATHLThresholds10UserSign2Updating UserInt60
225ECM1Parameters for Various Types of Electronic Communication11UserSign2Updating UserInt60
226ECM2Electronic Transactions27UserSign2Updating UserInt60
227ECM3Statuses and Logs for Actions in Electronic Communication6UserSign2Updating UserInt60
228OTHLThresholds10UserSign2Updating UserInt60
229OTRBTax Report Wizard for Brazil15UserSign2Updating UserInt60
230OTWSE-Tax Web Site6UserSign2Updating UserInt60
231RDOCDocument55UserSign2Updating UserInt60
TOPSales Opportunities
232AOC1Distribution Rule - Rows10UserSign2Updating UserInt60
233AOCRDistribution Rule12UserSign2Updating UserInt60
234AOPROpportunity52UserSign2Updating UserInt60
235APRCCost Center14UserSign2Updating UserInt60
236OCR1Distribution Rule - Rows10UserSign2Updating UserInt60
237OOCRDistribution Rule12UserSign2Updating UserInt60
238OOPROpportunity52UserSign2Updating UserInt60
239OPRCCost Center14UserSign2Updating UserInt60
TOPService
240AINSCustomer Equipment Card - History40userSign2Updating UserInt60
241ASC1Service Call Solutions - History8userSign2Updating User - HistoryInt60
242ASC2Service Call Inventory Expenses - History16UserSign2User Signature 2 - HistoryInt60
243ASC3Service Call Travel/Labor Expenses - History16UserSign2User Signature 2Int60
244ASC4Service Call Travel/Labor Expenses - History11UserSign2User Signature 2Int60
245ASC5Service Call Activities - History8UserSign2User Signature 2Int60
246ASCLHistory31userSign2Updating UserInt60
247ASGPService Group for Brazil5UserSign2Updating UserInt60
248OINSCustomer Equipment Card40userSign2Updating UserInt60
249OSCLService Calls31userSign2Updating UserInt60
250OSGPService Group for Brazil5UserSign2Updating UserInt60
251SCL1Service Call Solutions - Rows8userSign2Updating UserInt60
252SCL2Service Call Inventory Expenses16UserSign2User Signature 2Int60
253SCL3Service Call Travel/Labor Expenses16UserSign2User Signature 2Int60
254SCL4Expense Documents11UserSign2User Signature 2Int60
255SCL5Service Call Activities8UserSign2User Signature 2Int60