SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Cross-Application Components :: Financial MathematicsConditions :: Financial Conditions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FICOT_AMTPOS331Amount Item (Obsolete; not used for persistency)Financial Conditions
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, I_AMT, I_POSNO, O_STATUS, A_BASE, O_BASEREF, O_BASEFIXING, O_IRUNIT, A_AMT, A_AMTMIN, A_AMTMAX, A_AMTTRIV, A_AMTLIMAMT, N_COUNTLIM, N_DIVISOR, I_FORMULA, A_ADDAMT, A_ADDAMTLIM, A_AMT_2, N_FX_RATE, C_AMT_POST, P_PAYMENT, O_PERCDAY, I_FORMULA_ID, O_AMTLIM_REF, O_LEVEL_POS, O_LEVELTOFR_POS, A_AMTLIMAMT2, O_AMTLIM_REF2, O_WAIVETOFROM, O_WAIVEPRD, N_FREECOUNT_POS, I_FLDLSTID FROM FICOT_AMTPOS
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2I_AMTAmountvarbinary160
3I_POSNOCondition Item Numbernvarchar40 Allow NULL? 
4O_STATUSStatus of Validity Period of a Conditionnvarchar20 Allow NULL? 
5A_BASECalculation Basis for Interest Calculationdecimal232
6O_BASEREFBasis referencenvarchar40 Allow NULL? 
7O_BASEFIXINGCalculation Basis-Fixingnvarchar20 Allow NULL? 
8O_IRUNITTime Unit for Interest Ratenvarchar30 Allow NULL? 
9A_AMTAmount of the Amount Itemdecimal232
10A_AMTMINMinimum amountdecimal232
11A_AMTMAXMaximum Amountdecimal232
12A_AMTTRIVTrivial Amountdecimal232
13A_AMTLIMAMTAmount Limit for Date or Amount Componentsdecimal232
14N_COUNTLIMItem Limitnvarchar70 Allow NULL? 
15N_DIVISORDivisordecimal40
16I_FORMULAFormula Referencenvarchar40 Allow NULL? 
17A_ADDAMTAdditional Amount for Automatic Scaled Calculationdecimal232
18A_ADDAMTLIMAmount Limit for Automatic Scaled Calculationdecimal232
19A_AMT_2Line Item Amountdecimal232
20N_FX_RATEFixed Exchange Ratedecimal1511
21C_AMT_POSTPayment Currencynvarchar50 Allow NULL? 
22P_PAYMENTFICO: Payment Ratedecimal117
23O_PERCDAYPercentage or Number of Daysdecimal1510
24I_FORMULA_IDFormula IDnvarchar320 Allow NULL? 
25O_AMTLIM_REFReference Amount Limitnvarchar120 Allow NULL? 
26O_LEVEL_POSTiered/Interval Calculation (Item)char10 Allow NULL? 
27O_LEVELTOFR_POSCondition Item (Upper/Lower Limit)char10 Allow NULL? 
28A_AMTLIMAMT2Amount Limit Complex Tiers for Condition Determinationdecimal232
29O_AMTLIM_REF2Reference Amount Limitnvarchar120 Allow NULL? 
30O_WAIVETOFROMWaive fromchar10 Allow NULL? 
31O_WAIVEPRDWaiver Periodnvarchar20 Allow NULL? 
32N_FREECOUNT_POSNo. of Free Items (Position)nvarchar70 Allow NULL? 
33I_FLDLSTIDField Listvarbinary160
NamePrimaryUniqueTypeColumns
FICOT_AMTPOS~0YesYesCLUSTEREDI_POSNO, I_AMT, MANDT