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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

182 columns | Print definition?B1 8.8  | ABSENTRY

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