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
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

106 columns | Print definition?B1 8.8  | USERSIGN2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AADMAdministration - Log326UserSign2Updating UserInt60
2ACRCCredit Cards12UserSign2Updating UserInt60
3AEXDFreight Setup34UserSign2Updating UserInt60
4AUSRArchive Users - History70userSign2Updating UserInt60
5OADMAdministration326UserSign2Updating UserInt60
6OCRCCredit Cards12UserSign2Updating UserInt60
7OCRNCurrency Codes12UserSign2Updating UserInt60
8OEXDFreight Setup34UserSign2Updating UserInt60
9OUSRUsers70userSign2Updating User - HistoryInt60
TOPBanking
10ABOCExternal Bank Operation Code - Log6UserSign2Updating UserInt60
11ABOEBill of Exchange for Payment - History77UserSign2Updating UserInt60
12ABTCInternal Bank Operation Codes - 17UserSign2Updating UserInt60
13ADS1House Bank Accounts63UserSign2Updating UserInt60
14ARCTIncoming Payment - History150UserSign2Updating UserInt60
15DSC1House Bank Accounts63UserSign2Updating UserInt60
16OBOCExternal Bank Operation Code Category6UserSign2Updating UserInt60
17OBOEBill of Exchange for Payment77UserSign2Updating UserInt60
18OBTCInternal Bank Operation Codes17UserSign2Updating UserInt60
19OPDFPayment Draft150UserSign2Updating UserInt60
20ORCTIncoming Payment150UserSign2Updating UserInt60
21OVPMOutgoing Payments150UserSign2Updating UserInt60
TOPBusiness Partners
22ACRDBusiness Partners - History274UserSign2Updating UserInt60
23OCRDBusiness Partner274UserSign2Updating UserInt60
24OSCNCustomer/Vendor Cat. No.7UserSign2Updating UserInt60
TOPFinance
25AACPPeriods Category-Log134UserSign2Updating UserInt60
26AACTG/L Account - History91UserSign2Updating UserInt60
27AFPRPosting Period-Log25UserSign2Updating UserInt60
28AJDTJournal Entry - History28UserSign2Updated byInt60
29AVTGTax Definition35UserSign2Updating UserInt60
30AWHTWithholding Tax34UserSign2Updating UserInt60
31OACPPeriods Category134UserSign2Updating UserInt60
32OACTG/L Accounts91UserSign2Updating UserInt60
33OBTFJournal Voucher Entry28UserSign2Updating UserInt60
34OFPRPosting Period25UserSign2Updating UserInt60
35OIWZInflation Wizard34userSign2Updating UserInt60
36OJDTJournal Entry28UserSign2Updating UserInt60
37OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material10UserSign2Rule Changed ByInt60
38OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses10UserSign2Rule Changed ByInt60
39OVTGTax Definition35UserSign2Updating UserInt60
40OWHTWithholding Tax34UserSign2Updating UserInt60
TOPHuman Resources
41AHEMEmployees97UserSign2Updating UserInt60
42OHEMEmployees97UserSign2Updating UserInt60
TOPInventory and Production
43AITBItem Groups - History50userSign2Updating User - HistoryInt60
44AITMItems - History249UserSign2Updating UserInt60
45AITTProduct Tree - History16UserSign2Updating UserInt110
46AITWItems - Warehouse - History51userSign2Updating User - HistoryInt60
47AMRVInventory Revaluation - History17UserSign2Updating UserInt60
48APKLPick List - History16UserSign2Updating UserInt60
49AWHSWarehouses - History57userSign2Updating User - HistoryInt60
50AWORProduction Order - History39UserSign2Updating UserInt60
51OIGEGoods Issue82UserSign2Updating UserInt60
52OIGNGoods Receipt82UserSign2Updating UserInt60
53OITBItem Groups50userSign2Updating User - HistoryInt60
54OITMItems249UserSign2Updating UserInt60
55OITTProduct Tree16UserSign2Updating UserInt110
56OITWItems - Warehouse51userSign2Updating User - HistoryInt60
57OMRLAdvanced Inventory Revaluation25UserSign2Updating UserInt60
58OMRVInventory Revaluation17UserSign2Updating UserInt60
59OPKLPick List16UserSign2Updating UserInt60
60OWHSWarehouses57userSign2Updating User - HistoryInt60
61OWORProduction Order39UserSign2Updating UserInt60
62OWTRInventory Transfer82UserSign2Updating UserInt60
63UITMItems249UserSign2Updating UserInt60
64UITWItems - Warehouse51userSign2Updating User - HistoryInt60
65UWORProduction Order39UserSign2Updating UserInt60
TOPMarketing Documents
66ADOCInvoice - History82UserSign2Updating UserInt60
67ATXITax Invoice - History27UserSign2Updating UserInt60
68OCINA/R Correction Invoice82UserSign2Updating UserInt60
69OCPIA/P Correction Invoice82UserSign2Updating UserInt60
70OCPVA/P Correction Invoice Reversal82UserSign2Updating UserInt60
71OCSIA/R Correction Invoice82UserSign2Updating UserInt60
72OCSVA/R Correction Invoice Reversal82UserSign2Updating UserInt60
73ODLNDelivery82UserSign2Updating UserInt60
74ODPIA/R Down Payment82UserSign2Updating UserInt60
75ODPOA/P Down Payment82UserSign2Updating UserInt60
76ODRFDrafts82UserSign2Updating UserInt60
77OIEIIncoming Excise Invoice82UserSign2Updating UserInt60
78OINVA/R Invoice82UserSign2Updating UserInt60
79OOEIOutgoing Excise Invoice82UserSign2Updating UserInt60
80OPCHA/P Invoice82UserSign2Updating UserInt60
81OPDNGoods Receipt PO82UserSign2Updating UserInt60
82OPORPurchase Order82UserSign2Updating UserInt60
83OQUTSales Quotation82UserSign2Updating UserInt60
84ORDNReturns82UserSign2Updating UserInt60
85ORDRSales Order82UserSign2Updating UserInt60
86ORINA/R Credit Memo82UserSign2Updating UserInt60
87ORPCA/P Credit Memo82UserSign2Updating UserInt60
88ORPDGoods Return82UserSign2Updating UserInt60
89OTPIPurchase Tax Invoice27UserSign2Updating UserInt60
90OTSISales Tax Invoice27UserSign2Updating UserInt60
91OTXDTax Invoice Draft27UserSign2Updating UserInt60
TOPReports
92RDOCDocument55UserSign2Updating UserInt60
TOPService
93AINSCustomer Equipment Card - History40userSign2Updating UserInt60
94ASC1Service Call Solutions - History8userSign2Updating User - HistoryInt60
95ASC2Service Call Inventory Expenses - History16UserSign2User Signature 2 - HistoryInt60
96ASC3Service Call Travel/Labor Expenses - History16UserSign2User Signature 2Int60
97ASC4Service Call Travel/Labor Expenses - History11UserSign2User Signature 2Int60
98ASC5Service Call Activities - History8UserSign2User Signature 2Int60
99ASCLHistory31userSign2Updating UserInt60
100OINSCustomer Equipment Card40userSign2Updating UserInt60
101OSCLService Calls31userSign2Updating UserInt60
102SCL1Service Call Solutions - Rows8userSign2Updating UserInt60
103SCL2Service Call Inventory Expenses16UserSign2User Signature 2Int60
104SCL3Service Call Travel/Labor Expenses16UserSign2User Signature 2Int60
105SCL4Expense Documents11UserSign2User Signature 2Int60
106SCL5Service Call Activities8UserSign2User Signature 2Int60