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
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

159 columns | Print definition?B1 8.82  | 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
9ASTCSales Tax Codes15UserSign2Updating UserInt60
10ATSCCST Code for Nota Fiscal11UserSign2Updating UserInt60
11AUSRArchive Users - History70userSign2Updating UserInt60
12CINFCompany Info188UserSign2Updating UserInt60
13OADMAdministration313UserSign2Updating UserInt60
14OADPPrint Preferences30UserSign2Updating UserInt60
15OCFPCFOP for Nota Fiscal9UserSign2Updating UserInt60
16OCRCCredit Cards12UserSign2Updating UserInt60
17OCRNCurrency Codes12UserSign2Updating UserInt60
18OEXDFreight Setup34UserSign2Updating UserInt60
19OFMLTax Formula Master Table7UserSign2Updating UserInt60
20ONCMNCM Code5UserSign2Updating UserInt60
21OSTCSales Tax Codes15UserSign2Updating UserInt60
22OTSCCST Code for Nota Fiscal11UserSign2Updating UserInt60
23OUSRUsers70userSign2Updating User - HistoryInt60
TOPBanking
24ABOCExternal Bank Operation Code - Log6UserSign2Updating UserInt60
25ABOEBill of Exchange for Payment - History77UserSign2Updating UserInt60
26ABTCInternal Bank Operation Codes - 17UserSign2Updating UserInt60
27ADS1House Bank Accounts63UserSign2Updating UserInt60
28ARCTIncoming Payment - History150UserSign2Updating UserInt60
29DSC1House Bank Accounts63UserSign2Updating UserInt60
30OBOCExternal Bank Operation Code Category6UserSign2Updating UserInt60
31OBOEBill of Exchange for Payment77UserSign2Updating UserInt60
32OBTCInternal Bank Operation Codes17UserSign2Updating UserInt60
33OPDFPayment Draft150UserSign2Updating UserInt60
34ORCTIncoming Payment150UserSign2Updating UserInt60
35OVPMOutgoing Payments150UserSign2Updating UserInt60
TOPBusiness Partners
36ABPLBusiness Place14UserSign2Updating UserInt60
37ACPNCampaign15UserSign2Updating User - HistoryInt60
38ACRDBusiness Partners - History274UserSign2Updating UserInt60
39AOATBlanket Agreement20UserSign2User Signature 2Int60
40OBPLBusiness Place14UserSign2Updating UserInt60
41OCPNCampaign15UserSign2Updating User - HistoryInt60
42OCRDBusiness Partner274UserSign2Updating UserInt60
43OOATBlanket Agreement20UserSign2User Signature 2Int60
44OSCNCustomer/Vendor Cat. No.7UserSign2Updating UserInt60
TOPFinance
45AACPPeriods Category-Log134UserSign2Updating UserInt60
46AACTG/L Account - History91UserSign2Updating UserInt60
47AFPRPosting Period-Log25UserSign2Updating UserInt60
48AJDTJournal Entry - History28UserSign2Updated byInt60
49AMDRManual Distribution Rule12UserSign2Updating UserInt60
50AMDR1Manual Distribution Rule - Rows10UserSign2Updating UserInt60
51AVTGTax Definition33UserSign2Updating UserInt60
52AWHTWithholding Tax34UserSign2Updating UserInt60
53MDR1Manual Distribution Rule - Rows10UserSign2Updating UserInt60
54OACPPeriods Category134UserSign2Updating UserInt60
55OACTG/L Accounts91UserSign2Updating UserInt60
56OBTFJournal Voucher Entry28UserSign2Updating UserInt60
57OFPRPosting Period25UserSign2Updating UserInt60
58OIWZInflation Wizard34userSign2Updating UserInt60
59OJDTJournal Entry28UserSign2Updating UserInt60
60OMDRManual Distribution Rule12UserSign2Updating UserInt60
61ONFMNota Fiscal Model5UserSign2Updating UserInt60
62OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material10UserSign2Rule Changed ByInt60
63OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses10UserSign2Rule Changed ByInt60
64OVTGTax Definition33UserSign2Updating UserInt60
65OWHTWithholding Tax34UserSign2Updating UserInt60
TOPHuman Resources
66AHEMEmployees97UserSign2Updating UserInt60
67OHEMEmployees97UserSign2Updating UserInt60
TOPInventory and Production
68ABTNBatch Numbers Master Data23UserSign2Updating UserInt60
69ABTWBatch Attributes in Location13UserSign2Updating UserInt60
70ADNFDNF Code7UserSign2Updating UserInt60
71AITBItem Groups - History50userSign2Updating User - HistoryInt60
72AITMItems - History249UserSign2Updating UserInt60
73AITTProduct Tree - History16UserSign2Updating UserInt110
74AITWItems - Warehouse - History51userSign2Updating User - HistoryInt60
75AMGPMaterial Group5UserSign2Updating UserInt60
76AMRVInventory Revaluation - History17UserSign2Updating UserInt60
77APKLPick List - History16UserSign2Updating UserInt60
78ASRNSerial Numbers Master Data23UserSign2Updating UserInt60
79AWHSWarehouses - History57userSign2Updating User - HistoryInt60
80AWORProduction Order - History39UserSign2Updating UserInt60
81OBTNBatch Numbers Master Data23UserSign2Updating UserInt60
82OBTWBatch Attributes in Location13UserSign2Updating UserInt60
83ODBNBat. Nos - Draft - Master Data23UserSign2Updating UserInt60
84ODBWBatch Draft Attribs in Locat.13UserSign2Updating UserInt60
85ODNFDNF Code7UserSign2Updating UserInt60
86ODSNSNs - Draft - Master Data23UserSign2Updating UserInt60
87ODSWSN Draft Attribs in Location13UserSign2Updating UserInt60
88OIGEGoods Issue82UserSign2Updating UserInt60
89OIGNGoods Receipt82UserSign2Updating UserInt60
90OITBItem Groups50userSign2Updating User - HistoryInt60
91OITMItems249UserSign2Updating UserInt60
92OITTProduct Tree16UserSign2Updating UserInt110
93OITWItems - Warehouse51userSign2Updating User - HistoryInt60
94OMGPMaterial Group5UserSign2Updating UserInt60
95OMRLAdvanced Inventory Revaluation25UserSign2Updating UserInt60
96OMRVInventory Revaluation17UserSign2Updating UserInt60
97OPKLPick List16UserSign2Updating UserInt60
98OSRNSerial Numbers Master Data23UserSign2Updating UserInt60
99OSRWSerial No. Attribs in Location13UserSign2Updating UserInt60
100OWHSWarehouses57userSign2Updating User - HistoryInt60
101OWORProduction Order39UserSign2Updating UserInt60
102OWTQInventory Transfer Request82UserSign2Updating UserInt60
103OWTRInventory Transfer82UserSign2Updating UserInt60
104SITMItems249UserSign2Updating UserInt60
105SITWItems - Warehouse51userSign2Updating User - HistoryInt60
106UITMItems249UserSign2Updating UserInt60
107UITWItems - Warehouse51userSign2Updating User - HistoryInt60
108UWORProduction Order39UserSign2Updating UserInt60
TOPMarketing Documents
109ADOCInvoice - History82UserSign2Updating UserInt60
110ATXITax Invoice - History27UserSign2Updating UserInt60
111OCINA/R Correction Invoice82UserSign2Updating UserInt60
112OCPIA/P Correction Invoice82UserSign2Updating UserInt60
113OCPVA/P Correction Invoice Reversal82UserSign2Updating UserInt60
114OCSIA/R Correction Invoice82UserSign2Updating UserInt60
115OCSVA/R Correction Invoice Reversal82UserSign2Updating UserInt60
116ODLNDelivery82UserSign2Updating UserInt60
117ODPIA/R Down Payment82UserSign2Updating UserInt60
118ODPOA/P Down Payment82UserSign2Updating UserInt60
119ODRFDrafts82UserSign2Updating UserInt60
120OIEIIncoming Excise Invoice82UserSign2Updating UserInt60
121OINVA/R Invoice82UserSign2Updating UserInt60
122OOEIOutgoing Excise Invoice82UserSign2Updating UserInt60
123OPCHA/P Invoice82UserSign2Updating UserInt60
124OPDNGoods Receipt PO82UserSign2Updating UserInt60
125OPORPurchase Order82UserSign2Updating UserInt60
126OPQTPurchase Quotation82UserSign2Updating UserInt60
127OQUTSales Quotation82UserSign2Updating UserInt60
128ORDNReturns82UserSign2Updating UserInt60
129ORDRSales Order82UserSign2Updating UserInt60
130ORINA/R Credit Memo82UserSign2Updating UserInt60
131ORPCA/P Credit Memo82UserSign2Updating UserInt60
132ORPDGoods Return82UserSign2Updating UserInt60
133OTPIPurchase Tax Invoice27UserSign2Updating UserInt60
134OTSISales Tax Invoice27UserSign2Updating UserInt60
135OTXDTax Invoice Draft27UserSign2Updating UserInt60
TOPReports
136OTWSE-Tax Web Site6UserSign2Updating UserInt60
137RDOCDocument55UserSign2Updating UserInt60
TOPSales Opportunities
138AOC1Distribution Rule - Rows10UserSign2Updating UserInt60
139AOCRDistribution Rule12UserSign2Updating UserInt60
140OCR1Distribution Rule - Rows10UserSign2Updating UserInt60
141OOCRDistribution Rule12UserSign2Updating UserInt60
TOPService
142AINSCustomer Equipment Card - History40userSign2Updating UserInt60
143ASC1Service Call Solutions - History8userSign2Updating User - HistoryInt60
144ASC2Service Call Inventory Expenses - History16UserSign2User Signature 2 - HistoryInt60
145ASC3Service Call Travel/Labor Expenses - History16UserSign2User Signature 2Int60
146ASC4Service Call Travel/Labor Expenses - History11UserSign2User Signature 2Int60
147ASC5Service Call Activities - History8UserSign2User Signature 2Int60
148ASCLHistory31userSign2Updating UserInt60
149ASGPService Group for Brazil5UserSign2Updating UserInt60
150ATHLThresholds9UserSign2Updating UserInt60
151OINSCustomer Equipment Card40userSign2Updating UserInt60
152OSCLService Calls31userSign2Updating UserInt60
153OSGPService Group for Brazil5UserSign2Updating UserInt60
154OTHLThresholds9UserSign2Updating UserInt60
155SCL1Service Call Solutions - Rows8userSign2Updating UserInt60
156SCL2Service Call Inventory Expenses16UserSign2User Signature 2Int60
157SCL3Service Call Travel/Labor Expenses16UserSign2User Signature 2Int60
158SCL4Expense Documents11UserSign2User Signature 2Int60
159SCL5Service Call Activities8UserSign2User Signature 2Int60