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

Home | ERP 6.0  | OIRC_FUELS_PR
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2F_PRSSR - processing profile IDnvarchar20CHAR(N' ')NoOIRC_F_PR Allow NULL? 
3PARFNSSR - process business partner rolenvarchar40CHAR(N' ')YesOIFBRF1OIRC_PARFN Allow NULL? 
4BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
5HANTYGHandling type for transfer gainnvarchar20CHAR(N' ')YesOIH5OIH_HANTYG Allow NULL? 
6HANTYLHandling type for transfer lossnvarchar20CHAR(N' ')YesOIH5OIH_HANTYL Allow NULL? 
7IND_MMDSSR: Material movements defaultschar10CHAR(N' ')YesOIRC_IND_MMD Allow NULL? 
8LOGDOC_PBLINDLocation indicator for logistics document definitionnvarchar20CHAR(N' ')YesOIRC_LD_PBLINDOIRC_LOGDOC_PBLIND Allow NULL? 
9LOGDOCDSCHSSR Logistics document creation schedulenvarchar20CHAR(N' ')YesTFACDOIRC_LOGDOCSCH Allow NULL? 
10LOGDOCSDEFSSR Logistics document - schedule determination methodsnvarchar200CHAR(N' ')YesOIRC_LOGDOCS_VALOIRC_LOGDOCS_BADI Allow NULL? 
11TSTMPOil/Gas Test Temperature: Observed Densityfloat1516FLTP((0))YesOIB_TSTMP
12TSTEHTest Temperature Unit (Density): Measurementnvarchar30UNIT(N' ')YesT006OIB_TSTEH Allow NULL? 
13MTTMPOil/Gas Material Temperature: Observed Quantityfloat1516FLTP((0))YesOIB_MTTMP
14MTTEHOil/Gas Material Temperature Unit: Observed Quantitynvarchar30UNIT(N' ')YesT006OIB_MTTEH Allow NULL? 
15THVALHeating value at test conditions (natural gas): observedfloat1516FLTP((0))YesOIB_THVAL
16TDICHEHUnit for densities of petroleum products and natural gasnvarchar30UNIT(N' ')YesT006OIB_DNEH Allow NULL? 
17TDICHOil/Gas Test Densityfloat1516FLTP((0))YesOIB_TDICH
18MTPRESOil/gas material pressure: observed quantityfloat1516FLTP((0))YesOIB_MTPRES
19MTPRESEHOil/gas material pressure unit: observed quantitynvarchar30UNIT(N' ')YesT006OIB_MTPRESEH Allow NULL? 
20TPREDOil/gas test pressure: metering (obs. density)float1516FLTP((0))YesOIB_TPRED
21TPREDEHOil/Gas test press. unit: metering (density)nvarchar30UNIT(N' ')YesT006OIB_TPREDEH Allow NULL? 
22TPRHVNatural gas test pressure: combustion (obs. heating value )float1516FLTP((0))YesOIB_TPRHV
23TPRHVEHNatural gas test pressure unit: combustion ( heating value )nvarchar30UNIT(N' ')YesT006OIB_TPRHVEH Allow NULL? 
24TTMPHVNatural gas test temperature: combustion (obs. heat. value )float1516FLTP((0))YesOIB_TTMPHV
25TTMPHVEHNatural gas test temp. unit: combustion (heating value)nvarchar30UNIT(N' ')YesT006OIB_TTMPHVEH Allow NULL? 
26ATPRESAtmospheric pressure of the air surrounding a productfloat1516FLTP((0))YesOIB_ATPRES
27ATPRESEHAtmospheric pressure unitnvarchar30UNIT(N' ')YesT006OIB_ATPRESEH Allow NULL? 
28VAPRESVapor pressure of liquid petroleum gases (LPG)float1516FLTP((0))YesOIB_VAPRES
29VAPRESEHVapor pressure unit (LPG)nvarchar30UNIT(N' ')YesT006OIB_VAPRESEH Allow NULL? 
30THVALEHHeating value unitnvarchar30UNIT(N' ')YesT006OIB_HVEH Allow NULL? 
31MTCOMBTMPNatural gas material combustion temp.: observed quantityfloat1516FLTP((0))YesOIB_MTCOMBTMP
32MTCOMBTEHNatural gas material combustion temp. unit: obs. quantitynvarchar30UNIT(N' ')YesT006OIB_MTCOMBTEH Allow NULL? 
33MTCOMBPRESNatural gas material combustion pressure: observed quantityfloat1516FLTP((0))YesOIB_MTCOMBPRES
34MTCOMBPRESEHNatural gas material combustion pres. unit: oberved quantitynvarchar30UNIT(N' ')YesT006OIB_MTCOMBPRESEH Allow NULL? 
35TSTMPCALNatural gas: Calorimeter test temperature (density)float1516FLTP((0))YesOIB_TSTMPCAL
36TSTMPCALEHNatural gas: unit for calorimeter test temperature (density)nvarchar30UNIT(N' ')YesT006OIB_TSTMPCALEH Allow NULL? 
37TPREDCALNatural gas: Calorimeter test pressure (density)float1516FLTP((0))YesOIB_TPREDCAL
38TPREDCALEHNatural gas: Unit for calorimeter test pressure (density)nvarchar30UNIT(N' ')YesT006OIB_TPREDCALEH Allow NULL? 
39HYDROHydrometer Correction Indicatorchar10CHAR(N' ')YesOIB_HYDRO Allow NULL? 
40ABINDAir Bouyancy Indicatorchar10CHAR(N' ')YesOIB_ABIND Allow NULL? 
41ABFACAir Bouyancy Factordecimal31DEC((0))YesOIB_ABFAC
42MCFMeter correction factorfloat1516FLTP((0))YesOIB_MCF1
43BSWCNBSW %float1516FLTP((0))YesOIB_BSWCN
44BSWCNEHBSW % unit (volume %, mol %, mass % or proportion )nvarchar30UNIT(N' ')YesT006OIB_BSWCNEH Allow NULL? 
45HVCLSHeating value class (calorific value class)nvarchar20CHAR(N' ')YesOIB_HVCLS Allow NULL? 
46HVCLS_TOHeating value class (calorific value class)nvarchar20CHAR(N' ')YesOIB_HVCLS Allow NULL? 
47DEFAULT_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
48VRKMESales unitnvarchar30UNIT(N' ')YesT006VRKME Allow NULL? 
49METREVSSR Meters: end period meter event typenvarchar20CHAR(N' ')YesOIRC_GMMEOIRC_EPEVENT Allow NULL? 
50E_TIMEFSSR Meters - end period event time fromnvarchar60TIMS(N'000000')YesOIRC_E_TIMEF Allow NULL? 
51E_TIMETSSR Meters - end period event time tonvarchar60TIMS(N'000000')YesOIRC_E_TIMET Allow NULL? 
52MRDSCHSSR Meters - Meter reading schedulenvarchar20CHAR(N' ')YesTFACDOIRC_MRDSCH Allow NULL? 
53MRSDEFSSR Meters - Schedule determination methodsnvarchar200CHAR(N' ')YesOIRC_MS_VALOIRC_MS_BADI Allow NULL? 
54MRCHKSSR Meters - user check methodsnvarchar200CHAR(N' ')YesOIRC_MC_VALOIRC_MC_BADI Allow NULL? 
55PCTOLSSR Meters - Price change tolerance (in minutes)nvarchar30NUMC(N'000')YesOIRC_PCTOL Allow NULL? 
56DCTOLSSR Meters - dealer change tolerance (in minutes)nvarchar30NUMC(N'000')YesOIRC_DCTOL Allow NULL? 
57SOCEVSSR Stocks - Default SOC eventnvarchar20CHAR(N' ')YesOIISOCEOIRC_SOCEV Allow NULL? 
58IND_DRMSSR Stocks: maintenance control for dip readingschar10CHAR(N' ')YesOIRC_IND_DRM Allow NULL? 
59DRSSCHSSR Stocks - dip readings schedulenvarchar20CHAR(N' ')YesTFACDOIRC_DRDSCH Allow NULL? 
60DRSDEFSSR Stocks - schedule determination methodsnvarchar200CHAR(N' ')YesOIRC_DS_VALOIRC_DS_BADI Allow NULL? 
61PROWLWarning loss percentage tolerance limitdecimal52DEC((0))YesOIH_WLOSS
62PROELError loss percentage tolerance limitdecimal52DEC((0))YesOIH_ELOSS
63PROWGWarning gain percentage tolerance limitdecimal52DEC((0))YesOIH_WGAIN
64PROEGError gain percentage tolerance limitdecimal52DEC((0))YesOIH_EGAIN
65TOLROUTSSR Stocks - Tolerance quantity base methodsnvarchar200CHAR(N' ')YesOIRC_DT_VALOIRC_DT_BADI Allow NULL? 
66DRCHKSSR stocks - user check methodsnvarchar200CHAR(N' ')YesOIRC_DC_VALOIRC_DC_BADI Allow NULL? 
67INVCALSSR Invoicing - invoicing calendarnvarchar20CHAR(N' ')YesTFACDOIRI_INVCAL Allow NULL? 
68INVMETHInvoicing method for SSR Invoicingnvarchar30CHAR(N' ')YesOIRIMTYPOIRI_INVMETH Allow NULL? 
69EOMCALSSR Invoicing - calendar IDnvarchar20CHAR(N' ')Yes*OIRI_EOMCAL Allow NULL? 
70COMMCALCalendar for monthly commission recalculationnvarchar20CHAR(N' ')YesTFACDOIRI_COMMCAL Allow NULL? 
71ZLSCHPayment methodchar10CHAR(N' ')YesT042ZOIRI_ZLSCH Allow NULL? 
72BVTYPPartner bank type for invoicing itemsnvarchar40CHAR(N' ')YesOIRI_BVTYP Allow NULL? 
73LOGDOCDSCH_DRSSR Logistics document creation schedule (Dip reading)nvarchar20CHAR(N' ')YesTFACDOIRC_LOGDOCSCH_DR Allow NULL? 
74LOGDOCSDEF_DRSSR Logistics document - schedule determination methodsnvarchar200CHAR(N' ')YesOIRC_LOGDDR_VALOIRC_LOGDOCSDR_BADI Allow NULL? 
75ROLLOVER_CHECKSSR Meters - Rollover control methodsnvarchar200CHAR(N' ')YesOIRC_RC_VALOIRC_RC_BADI Allow NULL? 
76LIVARSSR Pricing - List variant for sales pricingnvarchar20CHAR(N' ')YesOIRC_WSTOIRC_LIVAR Allow NULL? 
77DIALOG_CHECKSSR Meters - Dialog save methodsnvarchar200CHAR(N' ')YesOIRC_MMR_VALOIRC_MMR_BADI Allow NULL? 
NamePrimaryUniqueTypeColumns
OIRC_FUELS_PR~0YesYesCLUSTEREDF_PR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy