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

231 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