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
9OUSR101Users
10OACT114G/L Accounts

B1 8.8: Top 10 requests

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

236 columns | Print definition?B1 8.82  | ABSENTRY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ANCMNCM Code1AbsEntryIDInt110
2ATC1Attachments - Rows1AbsEntryAbsolute entryInt110
3CFN1Default Common Functions1AbsEntryInternal KeyInt110
4CPT1Cockpit Subtable1AbsEntryInternal NumberInt110
5CSPISolution Packager Information1AbsEntryabsEntryInt110
6DADBData Archive DSA Balance1AbsEntryDocument Internal IDInt110
7DATBData Archive Tax Balance1AbsEntryNumeratorInt110
8DGP1Customer List1AbsEntryInternal NumberInt110
9DGP2Expanded Selection Criteria1AbsEntryInternal NumberInt110
10DGP3Expanded Consolidation Options1AbsEntryInternal NumberInt110
11DGP4Business Place List1AbsEntryInternal NumberInt110
12DGP5Sort By List1AbsEntryInternal NumberInt110
13OATCAttachments1AbsEntryAbsolute entryInt110
14OCFNCommon Functions Widget1AbsEntryInternal KeyInt110
15OCPTCockpit Main Table1AbsEntryInternal NumberInt110
16ODABDashboard1AbsEntryInternal KeyInt110
17ODARData Archiving1AbsEntryNumeratorInt110
18ODGPDocument Generation Parameter Sets1AbsEntryInternal NumberInt110
19ODW1Default Open Documents1AbsEntryInternal KeyInt110
20OFRMFile Format1AbsEntryInternal NumberInt110
21OLLFLegal List Format1AbsEntryInternal NumberInt110
22OMAPMapping Elements1AbsEntryInternal NumberInt110
23OMPSMap Services1AbsEntryInternal NumberInt110
24OMTPMaterial Type1AbsEntryNumeratorInt110
25ONCMNCM Code1AbsEntryIDInt110
26OODWOpen Documents Widget1AbsEntryInternal KeyInt110
27OPPAPassword Administration1AbsEntryInternal IDInt1101
28OPQWPurchase Quotation Generation: Parameter Sets1AbsEntryInternal NumberInt110
29OPROProperty Object1AbsEntryProperty IDInt110
30ORLDReference Links Definition1AbsEntryInternal NumberInt110
31OTRNMultilingual Service Table1AbsEntryDoc. EntryInt110
32OWDTWidget Table1AbsEntryInternal NumberInt110
33OWPKDashboard Packages1AbsEntryInternal KeyInt110
34PQW1Purchase Quotation Generation: Line Items1AbsEntryInternal NumberInt110
35RLD1Reference Links Definition1AbsEntryInternal NumberInt110
TOPBanking
36ABO1External Bank Operation Code - Rows - Log1AbsEntryInternal NumberInt110
37ABOCExternal Bank Operation Code - Log1AbsEntryInternal NumberInt110
38ABT1Internal Bank Operation Codes - Accounts - Log1AbsEntryInternal NumberInt1100
39ABTCInternal Bank Operation Codes - 1AbsEntryInternal NumberInt1100
40ADS1House Bank Accounts43AbsEntryInternal NumberInt110
41BOC1External Bank Operation Code - Rows1AbsEntryInternal NumberInt110
42BOT1Bill of Exchange Transactions1AbsEntryTransaction No.Int110
43BTC1Internal Bank Operation Codes - Accounts1AbsEntryInternal NumberInt110
44CHO2Checks for Payment - Print Status1AbsEntryIndexInt110
45DSC1House Bank Accounts43AbsEntryInternal NumberInt110
46OBOCExternal Bank Operation Code Category1AbsEntryInternal NumberInt110
47OBOTBill Of Exchang Transaction1AbsEntryBOE Transaction keyInt110
48OBSTBoE Stamp Tax1AbsEntryInternal KeyInt110
49OBTCInternal Bank Operation Codes1AbsEntryInternal NumberInt1100
50ODSCBank Codes14AbsEntryAbsolute entryInt110
51ODTYBoE Document Type1AbsEntryInternal NumberInt110
52OIPOInternal Payment Order Number1AbsEntryInternal NumberInt110
53OISTBoE Instruction1AbsEntryInternal NumberInt110
54OPEXPayment Results Table1AbsEntryInternal NumberInt110
55OPTFBoE Portfolio1AbsEntryInternal NumberInt110
56OPWBPWZ - Bank Account1AbsEntryInternal KeyInt110
57OPYBPayment Block1AbsEntryInternal NumberInt110
58OTPWTax Payment Wizard1AbsEntryInternal KeyInt110
59PEX1Payment Results Table - Rows1AbsEntryInternal NumberInt110
60TPW1Selection Criteria1AbsEntryAbsolute Entry NoInt110
61TPW2Payable Information1AbsEntryAbsolute Entry NoInt110
62TPW3Utilization and Payment1AbsEntryAbsolute Entry NoInt110
63TPW4VAT Refund1AbsEntryAbsolute Entry NoInt110
64TPW5Challan Information1AbsEntryAbsolute Entry NoInt110
65TPW6Journal Entry Information1AbsEntryInternal KeyInt110
TOPBusiness Partners
66ACRBBusiness Partner Bank Accounts - History1AbsEntryInternal KeyInt110
67OCRBBP - Bank Account1AbsEntryInternal KeyInt110
68OVTPVendor Type1ABSEntryPrimary KeyInt110
TOPFinance
69AACPPeriods Category-Log1AbsEntryInternal NumberInt1100
70AFPRPosting Period-Log1AbsEntrySystem NumberInt110
71AJD2Withholding Tax - History1AbsEntryNumeratorInt110
72AMDRManual Distribution Rule9AbsEntryNumeratorInt110
73AWH2WTax Definition - Rows21AbsEntryNumeratorInt110
74BTF2Journal Voucher Withholding Tax - History1AbsEntryInternal NumberInt110
75CASEInternal Recon. Upgrade 2007A1AbsEntryIntl ID for Inconsistent AmtInt110
76CASE1Internal Recon. Upgrade 2007A1AbsEntryHeader Internal IDInt110
77IWZ1Accounts Revaluation History1AbsEntryInternal NumberInt110
78IWZ2Inflation Warehouse Filter1AbsEntryInternal NumberInt110
79IWZ3Items Last Revaluation Data1AbsEntryInternal NumberInt110
80JDT2Withholding Tax - History1AbsEntryNumeratorInt110
81OACPPeriods Category1AbsEntryInternal NumberInt1100
82OCIGCIG Codes1AbsEntryInternal NumberInt110
83OCUPCUP Codes1AbsEntryInternal NumberInt110
84OFPRPosting Period1AbsEntrySystem NumberInt110
85OGBIGB Interface: Common Info1AbsEntryNumeratorInt110
86OIWZInflation Wizard1AbsEntryInternal NumberInt110
87OKRTTax Report Type1AbsEntryTax Report Type IDInt110
88OMDRManual Distribution Rule9AbsEntryNumeratorInt110
89ONFMNota Fiscal Model1AbsEntryNF Model IDnVarChar60
90OSVTDefine Summary VAT Report Type1AbsEntryVAT Report Type IDInt110
91OTAXVAT Transactions1AbsEntryInternal NumberInt110
92OUTXUnreported VAT Transactions1AbsEntryInternal NumberInt110
93OVTRTax Report1AbsEntryAbs Entry (Numerator)Int110
94TAX1VAT Transactions - Rows1AbsEntryInternal IDInt110
95UTX1Unreported VAT Transactions - Rows1AbsEntryInternal IDInt110
96VTR1Tax Groups1AbsEntryAbs Entry (Numerator)Int110
97VTR2Doc. Type Filter1AbsEntryInternal NumberInt110
98VTR3Series Filter1AbsEntryInternal NumberInt110
99WHT2Withholding Tax Definition - Rows21AbsEntryNumeratorInt110
TOPInventory and Production
100ABTNBatch Numbers Master Data19AbsEntryabs entryInt110
101ABTWBatch Attributes in Location9AbsEntryabs entryInt110
102ADNFDNF Code1AbsEntryInternal KeyInt110
103AKL1Pick List - Rows - History1AbsEntryInternal NumberInt110
104AMGPMaterial Group1AbsEntryIDInt110
105APKLPick List - History1AbsEntryAbsolute entryInt110
106ASRNSerial Numbers Master Data19AbsEntryabs entryInt110
107CIVIIVI Config File1AbsEntryInternal NumberInt110
108IGE16Goods Issue - SnB properties1AbsEntryabs entryInt110
109IGE5Goods Issue - Withholding Tax1AbsEntryNumeratorInt110
110IGN16Goods Receipt - SnB properties1AbsEntryabs entryInt110
111IGN5Goods Receipt - Withholding Tax1AbsEntryNumeratorInt110
112IVLGInventory Revaluation Log File1AbsEntryInternal Unique KeyInt110
113IVRUInventory Valuation Utility1AbsEntrySuccessive No.Int110
114OBTNBatch Numbers Master Data19AbsEntryabs entryInt110
115OBTQBatch No. Quantities7AbsEntryabs entryInt110
116OBTWBatch Attributes in Location9AbsEntryabs entryInt110
117OCHPIndia Chapter ID1AbsEntryInternal KeyInt110
118ODBNBat. Nos - Draft - Master Data19AbsEntryabs entryInt110
119ODBWBatch Draft Attribs in Locat.9AbsEntryabs entryInt110
120ODNFDNF Code1AbsEntryInternal KeyInt110
121ODSNSNs - Draft - Master Data19AbsEntryabs entryInt110
122ODSWSN Draft Attribs in Location9AbsEntryabs entryInt110
123OIVEFIFO Based Sales Return3AbsEntryInternal NumberInt110
124OIVQFIFO Queue Working Table10AbsEntryInternal IDInt110
125OMGPMaterial Group1AbsEntryIDInt110
126OPKLPick List1AbsEntryAbsolute entryInt110
127OSCGService Category1AbsEntryIDInt110
128OSRNSerial Numbers Master Data19AbsEntryabs entryInt110
129OSRQSerial No. Quantities7AbsEntryabs entryInt110
130OSRWSerial No. Attribs in Location9AbsEntryabs entryInt110
131OSTQInventory Valuation Utility Queries1AbsEntryInternal NumberInt110
132PKL1Pick List - Rows1AbsEntryInternal NumberInt110
133SIVEFIFO Based Sales Return3AbsEntryInternal NumberInt110
134SIVQFIFO Queue Working Table10AbsEntryInternal IDInt110
135UIVEFIFO Based Sales Return3AbsEntryInternal NumberInt110
136UIVQFIFO Queue Working Table10AbsEntryInternal NumberInt110
137VLG1Validation of Recalc. From To1AbsEntryInternal Unique KeyInt110
138WTQ16Inventory Transfer Request - SnB Properties1AbsEntryDocument NumberInt110
139WTQ5Inventory Transfer Request - Withholding Tax1AbsEntryNumeratorInt110
140WTR16Inventory Transfer - SnB properties1AbsEntryabs entryInt110
141WTR5Inventory Transfer - Withholding Tax1AbsEntryNumeratorInt110
TOPMarketing Documents
142ADO16Draft - SnB properties1AbsEntryDocument NumberInt110
143ADO5Withholding Tax - History1AbsEntryNumeratorInt110
144CIN5AR Correction Invoice - Withholding Tax1AbsEntryNumeratorInt110
145CPI16A/P Corr. Inv - SnB properties1AbsEntryabs entryInt110
146CPI5Withholding Tax Data1AbsEntryNumeratorInt110
147CPV16A/P Correction Invoice Reversal - SnB properties1AbsEntryabs entryInt110
148CPV5A/P Correction Invoice Reversal - WTax1AbsEntryNumeratorInt110
149CSI16A/R Corr. Inv. - SnB properties1AbsEntryabs entryInt110
150CSI5A/R Correction Invoice - Withholding Tax1AbsEntryNumeratorInt110
151CSV16A/R Correction Invoice Reversal - SnB properties1AbsEntryabs entryInt110
152CSV5A/R Correction Invoice Reversal - WTax1AbsEntryNumeratorInt110
153DLN16Delivery - SnB properties1AbsEntryabs entryInt110
154DLN5Delivery - Withholding Tax1AbsEntryInternal NumberInt110
155DPI16A/R Down Payment - SnB properties1AbsEntryabs entryInt110
156DPI5A/R Down Payment - Withholding Tax1AbsEntryNumeratorInt110
157DPO16A/P Down Payment - SnB properties1AbsEntryabs entryInt110
158DPO5A/P Down Payment - Withholding Tax1AbsEntryNumeratorInt110
159DRF16Draft - SnB - Rows1AbsEntryabs entryInt110
160DRF5Draft Documents - Withholding Tax1AbsEntryNumeratorInt110
161GTI1GTS Invoice Details1AbsEntryInternal NumberInt110
162GTM1GTS Mapping Object Details1AbsEntryInternal NumberInt110
163IEI16Incoming Excise Invoice - SnB properties1AbsEntryabs entryInt110
164IEI5Incoming Excise Invoice - Withholding Tax1AbsEntryInternal NumberInt110
165INV16A/R Invoice - SnB properties1AbsEntryabs entryInt110
166INV5A/R Invoice - Withholding Tax1AbsEntryInternal NumberInt110
167IVM1Invoice Mapping Object Details1AbsEntryInternal NumberInt110
168MIN1Monthly Invoice Report Document Information2AbsEntryDocument Internal IDInt110
169MIN2Item Imformation of MI17AbsEntryDocument EntryInt110
170MIV1A/P Monthly Invoice - Document2AbsEntryInternal KeyInt110
171MIV2A/P Monthly Invoice - Item17AbsEntryDocument EntryInt110
172OEI16Outgoing Excise Invoice - SnB properties1AbsEntryabs entryInt110
173OEI5Outgoing Excise Invoice - Withholding Tax1AbsEntryInternal NumberInt110
174OGTIGTS Invoice1AbsEntryInternal NumberInt110
175OGTMGTS Mapping Object1AbsEntryInternal NumberInt110
176OIVMGTS Invoice Mapping Object1AbsEntryInternal NumberInt110
177OLGLLegal Data1AbsEntryInternal NumberInt110
178OPDTPredefined Text1AbsEntryInternal NumberInt110
179OPQNPurchase Quotation Group1AbsEntryInternal EntryInt110
180ORCLRecurring Transaction Instances1AbsEntryInternal NumberInt110
181ORCPRecurring Transaction Template1AbsEntryInternal NumberInt110
182PCH16A/P Invoice - SnB properties1AbsEntryabs entryInt110
183PCH5A/P Invoice - Withholding Tax Data1AbsEntryNumeratorInt110
184PDN16Goods Receipt PO - SnB properties1AbsEntryabs entryInt110
185PDN5Goods Reciept PO - Withholding Tax1AbsEntryNumeratorInt110
186POR16Purchase Order - SnB properties1AbsEntryabs entryInt110
187POR5Purchase Order - Withholding Tax1AbsEntryNumeratorInt110
188PQT16Purchase Quotation - SnB properties1AbsEntryabs entryInt110
189PQT5Purchase Quotation - Withholding Tax1AbsEntryNumeratorInt110
190QUT16Sales Quotation - SnB properties1AbsEntryabs entryInt110
191QUT5Sales Quotation - Tax1AbsEntryNumeratorInt110
192RDN16Returns - SnB properties1AbsEntryabs entryInt110
193RDN5Returns - Withholding Tax1AbsEntryNumeratorInt110
194RDR16Sales Order - SnB properties1AbsEntryabs entryInt110
195RDR5Sales Order - Withholding Tax1AbsEntryNumeratorInt110
196RIN16A/R Credit Memo - SnB properties1AbsEntryabs entryInt110
197RIN5A/R Credit Memo - Withholding Tax1AbsEntryNumeratorInt110
198RPC16A/P Credit Memo - SnB properties1AbsEntryabs entryInt110
199RPC5A/P Credit Memo - Withholding Tax1AbsEntryNumeratorInt110
200RPD16Goods Return - SnB properties1AbsEntryabs entryInt110
201RPD5Goods Return - Withholding Tax Data1AbsEntryNumeratorInt110
TOPMRP
202MSN1MRP Scenarios - Warehouses Array1AbsEntryInternal NumberInt110
203MSN2MRP Run Results1AbsEntryInternal NumberInt110
204MSN3MRP Pegging Information1AbsEntryInternal NumberInt110
205MSN4MRP Scenarios - Items Array1AbsEntryInternal NumberInt110
206MSN5MRP-Specific Document1AbsEntryInternal NumberInt110
207OMSNMRP Scenarios1AbsEntryInternal NumberInt110
TOPReports
208EJB1ERV-JAb Wizard Signing Persons9AbsEntryInternal NumberInt110
209EJD1ERV-JAb Signing Persons List1AbsEntryInternal NumberInt110
210OEJDCompany Details for ERV-JAb1AbsEntryInternal NumberInt110
211OLLRElectronic Report Generation Result1AbsEntryInternal NumberInt110
212OTRSTax Report Saving Object1AbsEntryInternal NumberInt110
213OTRXTransformation Documents1AbsEntryInternal NumberT110
214OTWSE-Tax Web Site1AbsEntryE-Tax Internal IDInt60
215TRS1Tax Report Saving Object - Approved Documents1AbsEntryInternal NumberInt110
216TRS2Tax Rpt Sav Obj Man Chgd Vals1AbsEntryInternal NumberInt110
TOPSales Opportunities
217AOCRDistribution Rule9AbsEntryNumeratorInt110
218ODORDoubtful Debts1AbsEntryInternal KeyInt110
219OOCRDistribution Rule9AbsEntryNumeratorInt110
TOPService
220ASGPService Group for Brazil1AbsEntryService Group IDInt110
221ATHLThresholds1AbsEntryInternal NumberInt110
222LGL1Legal Data - Rows1AbsEntryInternal IDInt110
223MDC1Master Data Cleanup - Log1AbsEntryInternal KeyInt110
224MDC2Master Data Cleanup - MD Log1AbsEntryInternal KeyInt110
225ODCCDashboard Cache Configuration1AbsEntryAbs EntryInt110
226OLNKHelp Links1AbsEntryInternal NumberInt110
227OMDCMaster Data Cleanup1AbsEntryInternal KeyInt110
228OREQExternal System Call Request1AbsEntryRequest IDInt110
229OSABSocial1AbsEntryInternal KeyInt110
230OSCDService Code Table1AbsEntryIDInt110
231OSGPService Group for Brazil1AbsEntryService Group IDInt110
232OSTBTemplate1AbsEntryInternal KeyInt110
233OTHLThresholds1AbsEntryInternal NumberInt110
234REQ1External System Call Request - Message List1AbsEntryRequest IDInt110
235REQ2External System Call Request - Argument List1AbsEntryRequest IDInt110
236REQ3External System Call Request - Message Argument List1AbsEntryRequest IDInt110