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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
Industry Specific :: Bank Components :: Risk Analysis
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JBRHKOET581RM: Version Table Header, HIERA and BEST Ext.Cat.Prim.Trans.Risk Analysis
SQL:  selectupdate insert create

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

SELECT MANDT, RIDXRT, NGIDNR, DGUELTBIS, POBJNR, PWKN, AGGREGRULE, RMBEWREG, GFORM, GDETAIL, KATEKZ, AGGRKZ, DBLFZ, DELFZ, SFGTYP, SNOTTYPE, SNOMWHR, BNOMINAL, ASTUECK, WGSCHFT1, WGSCHFT2, BNOMI1, BNOMI2, BSALDO, DEFSZ, RANL, RHANDPL, IDX, IDXVAL, BPIDX, SPIDX, KKURSWP, DDEKSE, SSHLNG, SEZWHR, BEZWHR, RIDEXTRTEXT, BETICK, BWTICK, URANL, CTY_ID, QUOTSRC, BETICK_SEC, BWTICK_SEC, WWTICK, PPTICK, PITICK, CTY_QUANTITY, CTY_UOM, CSPREAD, CTY_ID2, CSPREAD_FWD, EXP_APPR_CAT, CONTRACT_VALUE, CONTRACT_VALUE_CURR, FORWARD_DATE, BETICK_CTY_CUNIT, LEAD_FGET FROM JBRHKOET
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2RIDXRTInternal Number of the Generic Transactionnvarchar200 Allow NULL? 
3NGIDNRSequence Number for a Transaction ID in Primary Transactionnvarchar60 Allow NULL? 
4DGUELTBIS'Valid To' Date for the Versions of the xSFGDTnvarchar80 Allow NULL? 
5POBJNRPointer to Original Transactionnvarchar220 Allow NULL? 
6PWKNRM: Pointer to TR ID Numbernvarchar130 Allow NULL? 
7AGGREGRULEAggregation Rule in Hierarchy of Data Type of Fin. Trans.nvarchar40 Allow NULL? 
8RMBEWREGValuation Rulenvarchar80 Allow NULL? 
9GFORMTransaction Formnvarchar30 Allow NULL? 
10GDETAILTransaction Form - Detail Informationnvarchar30 Allow NULL? 
11KATEKZIndicator for spot and forward transactionschar10 Allow NULL? 
12AGGRKZIndicator for aggregated transactionschar10 Allow NULL? 
13DBLFZStart of Termnvarchar80 Allow NULL? 
14DELFZEnd of Term/End of Period of Noticenvarchar80 Allow NULL? 
15SFGTYPBuy/Sellnvarchar30 Allow NULL? 
16SNOTTYPEQuotation type for option, future, security etc.char10 Allow NULL? 
17SNOMWHRCurrency of Nominal Amountnvarchar50 Allow NULL? 
18BNOMINALNominal amountdecimal172
19ASTUECKNumber of units for unit-quoted securitiesdecimal155
20WGSCHFT1Currency of Outgoing Sidenvarchar50 Allow NULL? 
21WGSCHFT2Currency of Incoming Sidenvarchar50 Allow NULL? 
22BNOMI1Nominal amount of outgoing sidedecimal172
23BNOMI2Nominal amount of incoming sidedecimal172
24BSALDOResidual balance of a contract (account)decimal172
25DEFSZDate of fixed period endnvarchar80 Allow NULL? 
26RANLSecuritynvarchar130 Allow NULL? 
27RHANDPLExchangenvarchar100 Allow NULL? 
28IDXSecurities Indexnvarchar100 Allow NULL? 
29IDXVALIndex Valuedecimal156
30BPIDXValue of an index pointdecimal172
31SPIDXCurrency of Value of an Index Pointnvarchar50 Allow NULL? 
32KKURSWPCurrent price of futures contract/option on futures contractdecimal156
33DDEKSERM: Date on which the average purchase price was determinednvarchar80 Allow NULL? 
34SSHLNGShort/Long Indicatorchar10 Allow NULL? 
35SEZWHRCurrency of external commitment capitalnvarchar50 Allow NULL? 
36BEZWHRAmount of external commit. capital in currencydecimal172
37RIDEXTRTEXTExternal Number of the External Generic Transactionnvarchar200 Allow NULL? 
38BETICKTick Amount (Commodity)decimal137
39BWTICKTick Value (Commodity)decimal137
40URANLSecurity ID Numbernvarchar130 Allow NULL? 
41CTY_IDCommodity IDnvarchar180 Allow NULL? 
42QUOTSRCQuotation Sourcenvarchar20 Allow NULL? 
43BETICK_SECTick as amountdecimal132
44BWTICK_SECTick valuedecimal132
45WWTICKTick Value Currencynvarchar50 Allow NULL? 
46PPTICKTick in percentage pointsdecimal107
47PITICKTick in index pointsdecimal116
48CTY_QUANTITYQuantitydecimal133
49CTY_UOMUnit of Measure for the Commoditynvarchar30 Allow NULL? 
50CSPREADCredit Spreaddecimal107
51CTY_ID2Commodity IDnvarchar180 Allow NULL? 
52CSPREAD_FWDCredit Spreaddecimal107
53EXP_APPR_CATCommodity Exposure Approach Categorychar10 Allow NULL? 
54CONTRACT_VALUEContract Valuedecimal132
55CONTRACT_VALUE_CURRContract Value Currencynvarchar50 Allow NULL? 
56FORWARD_DATEForward Datenvarchar80 Allow NULL? 
57BETICK_CTY_CUNITCurrency unitnvarchar50 Allow NULL? 
58LEAD_FGETSelected Transactionchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
JBRHKOET~0YesYesCLUSTEREDDGUELTBIS, NGIDNR, RIDXRT, MANDT