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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3FMARCPAR4Parallelization of FMARC_BATCH
4/ISDFPS/CHVW_E34External Batch Where-Used List
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FMIA65Actual Line Item Table for Funds Management
8FCO_DOC_HEAD61Failure Cost Document Header
9/OPT/Z1344Reporting table: Text table for exception definitions
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
6OPOR386Purchase Order
7OJDT100Journal Entry
8OUSR101Users
9OWTR386Inventory Transfer
10OSHP5Delivery Types

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OIVL77Whse Journal
5OSRN20Serial Numbers Master Data
6ORCT154Incoming Payment
7OVPM154Outgoing Payments
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

174 columns | Print definition?B1 8.82  | UPDATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AADMAdministration - Log276UpdateDateUpdate DateDate80
2AADPPrint Preferences29UpdateDateDate of UpdateDate80
3ACFPCFOP for Nota Fiscal10UpdateDateUpdate DateDate80
4ACRCCredit Cards10UpdateDateDate of UpdateDate80
5AEXDFreight Setup33UpdateDateDate of UpdateDate80
6AFMLTax Formula Master Table8UpdateDateUpdate DateDate80
7AINFCompany Info187UpdateDateDate of UpdateDate80
8ANCMNCM Code6UpdateDateUpdate DateDate80
9ASTCSales Tax Codes16UpdateDateUpdate DateDate80
10ATSCCST Code for Nota Fiscal12UpdateDateUpdate DateDate80
11AUSRArchive Users - History71updateDateUpdate DateDate80
12CINFCompany Info187UpdateDateDate of UpdateDate80
13OADMAdministration276UpdateDateDate of UpdateDate80
14OADPPrint Preferences29UpdateDateDate of UpdateDate80
15OCFPCFOP for Nota Fiscal10UpdateDateUpdate DateDate80
16OCHF3123UpdateDateDate of UpdateDate80
17OCRCCredit Cards10UpdateDateDate of UpdateDate80
18ODOWData Ownership - Objects8UpdateDateDate of UpdateDate80
19ODOXData Ownership - Exceptions7UpdateDateDate of UpdateDate80
20OEXDFreight Setup33UpdateDateDate of UpdateDate80
21OFMLTax Formula Master Table8UpdateDateUpdate DateDate80
22ONCMNCM Code6UpdateDateUpdate DateDate80
23OSTCSales Tax Codes16UpdateDateUpdate DateDate80
24OTRNMultilingual Service Table7UpdateDateUpdate DateDate80
25OTSCCST Code for Nota Fiscal12UpdateDateUpdate DateDate80
26OUSRUsers71updateDateDate of Update - HistoryDate80
TOPBanking
27ABOCExternal Bank Operation Code - Log4UpdateDateDate of UpdateDate80
28ABOEBill of Exchange for Payment - History28UpdateDateDate of UpdateDate80
29ABTCInternal Bank Operation Codes - 10UpdateDateDate of UpdateDate80
30ACHOChecks for Payment - History31UpdateDateDate of UpdateDate80
31ADS1House Bank Accounts61UpdateDateDate of UpdateDate80
32ARCTIncoming Payment - History58UpdateDateDate of UpdateDate80
33DSC1House Bank Accounts61UpdateDateDate of UpdateDate80
34OBOCExternal Bank Operation Code Category4UpdateDateDate of UpdateDate80
35OBOEBill of Exchange for Payment28UpdateDateDate of UpdateDate80
36OBTCInternal Bank Operation Codes10UpdateDateDate of UpdateDate80
37OCHDChecks for Payment Drafts31UpdateDateDate of UpdateDate80
38OCHOChecks for Payment31UpdateDateDate of UpdateDate80
39ODPSDeposit26UpdateDateDate of UpdateDate80
40OPDFPayment Draft58UpdateDateUpdate DateDate80
41ORCTIncoming Payment58UpdateDateDate of UpdateDate80
42OVPMOutgoing Payments58UpdateDateDate of UpdateDate80
TOPBusiness Partners
43ABPLBusiness Place15UpdateDateUpdate DateDate80
44ACPNCampaign16UpdateDateDate of Update - HistoryDate80
45ACPRContact Persons - History23updateDateDate of UpdateDate80
46ACRDBusiness Partners - History133UpdateDateDate of UpdateDate80
47OBPLBusiness Place15UpdateDateUpdate DateDate80
48OCPNCampaign16UpdateDateDate of Update - HistoryDate80
49OCPRContact Persons23updateDateDate of UpdateDate80
50OCRDBusiness Partner133UpdateDateDate of UpdateDate80
TOPFinance
51AACPPeriods Category-Log15UpdateDateDate of UpdateDate80
52AACTG/L Account - History39UpdateDateDate of UpdateDate80
53AFPRPosting Period-Log22UpdateDateDate of UpdateDate80
54AJDTJournal Entry - History25UpdateDateDate of UpdateDate80
55AMDRManual Distribution Rule13updateDateDate of UpdateDate80
56AMDR1Manual Distribution Rule - Rows11updateDateDate of UpdateDate80
57AVTGTax Definition30UpdateDateDate of UpdateDate80
58AWHTWithholding Tax17UpdateDateDate of UpdateDate80
59MDR1Manual Distribution Rule - Rows11updateDateDate of UpdateDate80
60OACPPeriods Category15UpdateDateDate of UpdateDate80
61OACTG/L Accounts39UpdateDateDate of UpdateDate80
62OBTFJournal Voucher Entry25UpdateDateUpdate DateDate80
63OFPRPosting Period22UpdateDateDate of UpdateDate80
64OJDTJournal Entry25UpdateDateDate of UpdateDate80
65OMDRManual Distribution Rule13updateDateDate of UpdateDate80
66ONFMNota Fiscal Model6UpdateDateDate of UpdateDate80
67OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material8UpdateDateDate of Rule ChangeDate80
68OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses8UpdateDateDate of Rule ChangeDate80
69OVTGTax Definition30UpdateDateDate of UpdateDate80
70OWHTWithholding Tax17UpdateDateDate of UpdateDate80
TOPHuman Resources
71AHEMEmployees98UpdateDateUpdate DateDate80
72OHEMEmployees98UpdateDateUpdate DateDate80
TOPInventory and Production
73ABTNBatch Numbers Master Data24UpdateDateUpdate DateDate80
74ABTWBatch Attributes in Location14UpdateDateUpdate DateDate80
75ADNFDNF Code8UpdateDateUpdate DateDate80
76AITBItem Groups - History51updateDateUpdate Date - HistoryDate80
77AITMItems - History167UpdateDateDate of UpdateDate80
78AITTProduct Tree - History7UpdateDateDate of UpdateDate80
79AITWItems - Warehouse - History52updateDateUpdate Date - HistoryDate80
80AMGPMaterial Group6UpdateDateUpdate DateDate80
81AMRVInventory Revaluation - History11UpdateDateUpdate DateDate80
82APKLPick List - History13UpdateDateDate of UpdateDate80
83ASRNSerial Numbers Master Data24UpdateDateUpdate DateDate80
84AWHSWarehouses - History58updateDateDate of Update - HistoryDate80
85AWORProduction Order - History40UpdateDateUpdate DateDate80
86LIVIIVI Log File7UpdateDateDate of UpdateDate80
87OBTNBatch Numbers Master Data24UpdateDateUpdate DateDate80
88OBTWBatch Attributes in Location14UpdateDateUpdate DateDate80
89ODBNBat. Nos - Draft - Master Data24UpdateDateUpdate DateDate80
90ODBWBatch Draft Attribs in Locat.14UpdateDateUpdate DateDate80
91ODNFDNF Code8UpdateDateUpdate DateDate80
92ODSNSNs - Draft - Master Data24UpdateDateUpdate DateDate80
93ODSWSN Draft Attribs in Location14UpdateDateUpdate DateDate80
94OENTShipping Types34UpdateDateDate of UpdateDate80
95OIGEGoods Issue63UpdateDateDate of UpdateDate80
96OIGNGoods Receipt63UpdateDateDate of UpdateDate80
97OIPFLanded Costs38UpdateDateDate of UpdateDate80
98OITBItem Groups51updateDateDate of Update - HistoryDate80
99OITMItems167UpdateDateDate of UpdateDate80
100OITTProduct Tree7UpdateDateDate of UpdateDate80
101OITWItems - Warehouse52updateDateDate of Update - HistoryDate80
102OMGPMaterial Group6UpdateDateUpdate DateDate80
103OMRLAdvanced Inventory Revaluation18UpdateDateDate of UpdateDate80
104OMRVInventory Revaluation11UpdateDateDate of UpdateDate80
105OPKLPick List13UpdateDateDate of UpdateDate80
106OSRNSerial Numbers Master Data24UpdateDateUpdate DateDate80
107OSRWSerial No. Attribs in Location14UpdateDateUpdate DateDate80
108OWHSWarehouses58updateDateDate of Update - HistoryDate80
109OWKOProduction Instructions18UpdateDateDate of UpdateDate80
110OWORProduction Order40UpdateDateUpdate DateDate80
111OWTQInventory Transfer Request63UpdateDateDate of UpdateDate80
112OWTRInventory Transfer63UpdateDateDate of UpdateDate80
113SITMItems167UpdateDateDate of UpdateDate80
114SITWItems - Warehouse52updateDateDate of Update - HistoryDate80
115UITMItems167UpdateDateDate of UpdateDate80
116UITWItems - Warehouse52updateDateDate of Update - HistoryDate80
117UWKOProduction Instructions18UpdateDateDate of UpdateDate80
118UWORProduction Order40UpdateDateUpdate DateDate80
TOPMarketing Documents
119ADOCInvoice - History63UpdateDateUpdate DateDate80
120ATXITax Invoice - History12UpdateDateDate of UpdateDate80
121OCINA/R Correction Invoice63UpdateDateDate of UpdateDate80
122OCPIA/P Correction Invoice63UpdateDateDate of UpdateDate80
123OCPVA/P Correction Invoice Reversal63UpdateDateDate of UpdateDate80
124OCSIA/R Correction Invoice63UpdateDateDate of UpdateDate80
125OCSVA/R Correction Invoice Reversal63UpdateDateDate of UpdateDate80
126ODLNDelivery63UpdateDateDate of UpdateDate80
127ODPIA/R Down Payment63UpdateDateDate of UpdateDate80
128ODPOA/P Down Payment63UpdateDateDate of UpdateDate80
129ODRFDrafts63UpdateDateDate of UpdateDate80
130OIEIIncoming Excise Invoice63UpdateDateUpdate DateDate80
131OINVA/R Invoice63UpdateDateDate of UpdateDate80
132OOEIOutgoing Excise Invoice63UpdateDateUpdate DateDate80
133OPCHA/P Invoice63UpdateDateUpdate DateDate80
134OPDNGoods Receipt PO63UpdateDateDate of UpdateDate80
135OPORPurchase Order63UpdateDateDate of UpdateDate80
136OPQTPurchase Quotation63UpdateDateDate of UpdateDate80
137OQUTSales Quotation63UpdateDateDate of UpdateDate80
138ORCPRecurring Transaction Template16UpdateDateUpdate DateDate80
139ORDNReturns63UpdateDateDate of UpdateDate80
140ORDRSales Order63UpdateDateDate of UpdateDate80
141ORINA/R Credit Memo63UpdateDateDate of UpdateDate80
142ORPCA/P Credit Memo63UpdateDateDate of UpdateDate80
143ORPDGoods Return63UpdateDateDate of UpdateDate80
144OSALOutgoing34UpdateDateDate of UpdateDate80
145OTPIPurchase Tax Invoice12UpdateDateDate of UpdateDate80
146OTRATransition34UpdateDateDate of UpdateDate80
147OTSISales Tax Invoice12UpdateDateDate of UpdateDate80
148OTXDTax Invoice Draft12UpdateDateDate of UpdateDate80
149WDD1Documents for Approval - Authorizers9UpdateDateDate of UpdateDate80
TOPMRP
150OMSNMRP Scenarios24UpdateDateUpdate DateDate80
TOPReports
151RDC1Multilingual Report8UpdateDateUpdate DateDate80
152RDOCDocument53UpdateDateDate of UpdateDate80
TOPSales Opportunities
153AOC1Distribution Rule - Rows11updateDateDate of UpdateDate80
154AOCRDistribution Rule13updateDateDate of UpdateDate80
155OCR1Distribution Rule - Rows11updateDateDate of UpdateDate80
156OOCRDistribution Rule13updateDateDate of UpdateDate80
TOPService
157AINSCustomer Equipment Card - History41updateDateUpdate DateDate80
158ASC1Service Call Solutions - History9updateDateDate of Update - HistoryDate80
159ASC2Service Call Inventory Expenses - History17UpdateDateDate of Update - HistoryDate80
160ASC3Service Call Travel/Labor Expenses - History17UpdateDateDate of UpdateDate80
161ASC4Service Call Travel/Labor Expenses - History12UpdateDateDate of UpdateDate80
162ASC5Service Call Activities - History9UpdateDateDate of UpdateDate80
163ASCLHistory32updateDateDate of UpdateDate80
164ASGPService Group for Brazil6UpdateDateUpdate DateDate80
165ATHLThresholds10UpdateDateDate of UpdateDate80
166OINSCustomer Equipment Card41updateDateDate of UpdateDate80
167OSCLService Calls32updateDateDate of UpdateDate80
168OSGPService Group for Brazil6UpdateDateUpdate DateDate80
169OTHLThresholds10UpdateDateDate of UpdateDate80
170SCL1Service Call Solutions - Rows9updateDateDate of UpdateDate80
171SCL2Service Call Inventory Expenses17UpdateDateDate of UpdateDate80
172SCL3Service Call Travel/Labor Expenses17UpdateDateDate of UpdateDate80
173SCL4Expense Documents12UpdateDateDate of UpdateDate80
174SCL5Service Call Activities9UpdateDateDate of UpdateDate80