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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Industry Solution Oil :: Downstream :: Service Station Retailing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIRC_FUELS_PR771SSR - Processing profileService Station Retailing
SQL:  selectupdate insert create

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

SELECT MANDT, F_PR, PARFN, BWTAR, HANTYG, HANTYL, IND_MMD, LOGDOC_PBLIND, LOGDOCDSCH, LOGDOCSDEF, TSTMP, TSTEH, MTTMP, MTTEH, THVAL, TDICHEH, TDICH, MTPRES, MTPRESEH, TPRED, TPREDEH, TPRHV, TPRHVEH, TTMPHV, TTMPHVEH, ATPRES, ATPRESEH, VAPRES, VAPRESEH, THVALEH, MTCOMBTMP, MTCOMBTEH, MTCOMBPRES, MTCOMBPRESEH, TSTMPCAL, TSTMPCALEH, TPREDCAL, TPREDCALEH, HYDRO, ABIND, ABFAC, MCF, BSWCN, BSWCNEH, HVCLS, HVCLS_TO, DEFAULT_GUID, VRKME, METREV, E_TIMEF, E_TIMET, MRDSCH, MRSDEF, MRCHK, PCTOL, DCTOL, SOCEV, IND_DRM, DRSSCH, DRSDEF, PROWL, PROEL, PROWG, PROEG, TOLROUT, DRCHK, INVCAL, INVMETH, EOMCAL, COMMCAL, ZLSCH, BVTYP, LOGDOCDSCH_DR, LOGDOCSDEF_DR, ROLLOVER_CHECK, LIVAR, DIALOG_CHECK FROM OIRC_FUELS_PR
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2F_PRSSR - processing profile IDnvarchar20 Allow NULL? 
3PARFNSSR - process business partner rolenvarchar40 Allow NULL? 
4BWTARValuation Typenvarchar100 Allow NULL? 
5HANTYGHandling type for transfer gainnvarchar20 Allow NULL? 
6HANTYLHandling type for transfer lossnvarchar20 Allow NULL? 
7IND_MMDSSR: Material movements defaultschar10 Allow NULL? 
8LOGDOC_PBLINDLocation indicator for logistics document definitionnvarchar20 Allow NULL? 
9LOGDOCDSCHSSR Logistics document creation schedulenvarchar20 Allow NULL? 
10LOGDOCSDEFSSR Logistics document - schedule determination methodsnvarchar200 Allow NULL? 
11TSTMPOil/Gas Test Temperature: Observed Densityfloat1516
12TSTEHTest Temperature Unit (Density): Measurementnvarchar30 Allow NULL? 
13MTTMPOil/Gas Material Temperature: Observed Quantityfloat1516
14MTTEHOil/Gas Material Temperature Unit: Observed Quantitynvarchar30 Allow NULL? 
15THVALHeating value at test conditions (natural gas): observedfloat1516
16TDICHEHUnit for densities of petroleum products and natural gasnvarchar30 Allow NULL? 
17TDICHOil/Gas Test Densityfloat1516
18MTPRESOil/gas material pressure: observed quantityfloat1516
19MTPRESEHOil/gas material pressure unit: observed quantitynvarchar30 Allow NULL? 
20TPREDOil/gas test pressure: metering (obs. density)float1516
21TPREDEHOil/Gas test press. unit: metering (density)nvarchar30 Allow NULL? 
22TPRHVNatural gas test pressure: combustion (obs. heating value )float1516
23TPRHVEHNatural gas test pressure unit: combustion ( heating value )nvarchar30 Allow NULL? 
24TTMPHVNatural gas test temperature: combustion (obs. heat. value )float1516
25TTMPHVEHNatural gas test temp. unit: combustion (heating value)nvarchar30 Allow NULL? 
26ATPRESAtmospheric pressure of the air surrounding a productfloat1516
27ATPRESEHAtmospheric pressure unitnvarchar30 Allow NULL? 
28VAPRESVapor pressure of liquid petroleum gases (LPG)float1516
29VAPRESEHVapor pressure unit (LPG)nvarchar30 Allow NULL? 
30THVALEHHeating value unitnvarchar30 Allow NULL? 
31MTCOMBTMPNatural gas material combustion temp.: observed quantityfloat1516
32MTCOMBTEHNatural gas material combustion temp. unit: obs. quantitynvarchar30 Allow NULL? 
33MTCOMBPRESNatural gas material combustion pressure: observed quantityfloat1516
34MTCOMBPRESEHNatural gas material combustion pres. unit: oberved quantitynvarchar30 Allow NULL? 
35TSTMPCALNatural gas: Calorimeter test temperature (density)float1516
36TSTMPCALEHNatural gas: unit for calorimeter test temperature (density)nvarchar30 Allow NULL? 
37TPREDCALNatural gas: Calorimeter test pressure (density)float1516
38TPREDCALEHNatural gas: Unit for calorimeter test pressure (density)nvarchar30 Allow NULL? 
39HYDROHydrometer Correction Indicatorchar10 Allow NULL? 
40ABINDAir Bouyancy Indicatorchar10 Allow NULL? 
41ABFACAir Bouyancy Factordecimal31
42MCFMeter correction factorfloat1516
43BSWCNBSW %float1516
44BSWCNEHBSW % unit (volume %, mol %, mass % or proportion )nvarchar30 Allow NULL? 
45HVCLSHeating value class (calorific value class)nvarchar20 Allow NULL? 
46HVCLS_TOHeating value class (calorific value class)nvarchar20 Allow NULL? 
47DEFAULT_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320 Allow NULL? 
48VRKMESales unitnvarchar30 Allow NULL? 
49METREVSSR Meters: end period meter event typenvarchar20 Allow NULL? 
50E_TIMEFSSR Meters - end period event time fromnvarchar60 Allow NULL? 
51E_TIMETSSR Meters - end period event time tonvarchar60 Allow NULL? 
52MRDSCHSSR Meters - Meter reading schedulenvarchar20 Allow NULL? 
53MRSDEFSSR Meters - Schedule determination methodsnvarchar200 Allow NULL? 
54MRCHKSSR Meters - user check methodsnvarchar200 Allow NULL? 
55PCTOLSSR Meters - Price change tolerance (in minutes)nvarchar30 Allow NULL? 
56DCTOLSSR Meters - dealer change tolerance (in minutes)nvarchar30 Allow NULL? 
57SOCEVSSR Stocks - Default SOC eventnvarchar20 Allow NULL? 
58IND_DRMSSR Stocks: maintenance control for dip readingschar10 Allow NULL? 
59DRSSCHSSR Stocks - dip readings schedulenvarchar20 Allow NULL? 
60DRSDEFSSR Stocks - schedule determination methodsnvarchar200 Allow NULL? 
61PROWLWarning loss percentage tolerance limitdecimal52
62PROELError loss percentage tolerance limitdecimal52
63PROWGWarning gain percentage tolerance limitdecimal52
64PROEGError gain percentage tolerance limitdecimal52
65TOLROUTSSR Stocks - Tolerance quantity base methodsnvarchar200 Allow NULL? 
66DRCHKSSR stocks - user check methodsnvarchar200 Allow NULL? 
67INVCALSSR Invoicing - invoicing calendarnvarchar20 Allow NULL? 
68INVMETHInvoicing method for SSR Invoicingnvarchar30 Allow NULL? 
69EOMCALSSR Invoicing - calendar IDnvarchar20 Allow NULL? 
70COMMCALCalendar for monthly commission recalculationnvarchar20 Allow NULL? 
71ZLSCHPayment methodchar10 Allow NULL? 
72BVTYPPartner bank type for invoicing itemsnvarchar40 Allow NULL? 
73LOGDOCDSCH_DRSSR Logistics document creation schedule (Dip reading)nvarchar20 Allow NULL? 
74LOGDOCSDEF_DRSSR Logistics document - schedule determination methodsnvarchar200 Allow NULL? 
75ROLLOVER_CHECKSSR Meters - Rollover control methodsnvarchar200 Allow NULL? 
76LIVARSSR Pricing - List variant for sales pricingnvarchar20 Allow NULL? 
77DIALOG_CHECKSSR Meters - Dialog save methodsnvarchar200 Allow NULL? 
NamePrimaryUniqueTypeColumns
OIRC_FUELS_PR~0YesYesCLUSTEREDF_PR, MANDT