OIB_USERDEF_VMR

Transparent Table Application Table
88 Fields 1 CDS Views

User Defaults for VMR application

OIB_USERDEF_VMR is an SAP database table in S/4HANA. User Defaults for VMR application. It contains 88 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
OIB_USERDEF_VMR_CDS view from Conversion parameters for user defaults VMR

Fields (88)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bname XUBNAME User
KEY werks WERKS_D Plant
KEY matnr MATNR Material
created_at OIB_TIMESTAMP Document Timestamp
changed_at OIB_TIMESTAMP_C Document Timestamp
hydro OIB_HYDRO Hydro.corr.
abind OIB_ABIND Air Buoy. Ind.
abfac OIB_ABFAC_F Air buoy. fact.
bswcn OIB_BSWCN BSW %
mcf OIB_MCF1 MC factor
bswcneh OIB_BSWCNEH BSW % UNIT
bswind OIB_BSWIND BSW indicator
hvcls OIB_HVCLS HV class
hvcls_to OIB_HVCLS HV class
tdich OIB_TDICH Test Density
bdich OIB_BDICH Base density
tstmp OIB_TSTMP Test Temp.
tsteh OIB_TSTEH Test Temp.Unit
tstmpcal OIB_TSTMPCAL Cal. tst. temp.
tstmpcaleh OIB_TSTMPCALEH Unit
mttmp OIB_MTTMP Mat.Temperature
mtteh OIB_MTTEH Mat.Temp.Unit
cmode OIB_CMODE Conv. Mode
coeff OIB_COEFF Conv. Coeff.
coeffeh MSEHI Internal UoM
fdich OIB_FDICH Fixed Density
tdicheh OIB_DNEH Density unit
bdicheh OIB_BDNEH Unit
fdicheh OIB_BDNEH Unit
mtpres OIB_MTPRES Mat.pressure
mtpreseh OIB_MTPRESEH Mat.press.unit
tpred OIB_TPRED Test pres. den.
tpredeh OIB_TPREDEH Tpres.unit den.
tpredcal OIB_TPREDCAL Cal.tst.pres.
tpredcaleh OIB_TPREDCALEH Unit
ttmphv OIB_TTMPHV Ttemp. HVal.
ttmphveh OIB_TTMPHVEH Ttmp. unit HVal
tprhv OIB_TPRHV Test pres. HV
tprhveh OIB_TPRHVEH Tpres. unit HV
atpres OIB_ATPRES Atm.pressure
atpreseh OIB_ATPRESEH Atm. pres. unit
vapres OIB_VAPRES Vapor pressure
vapreseh OIB_VAPRESEH Vap. pres. unit
thval OIB_THVAL Tst. heat. val.
thvaleh OIB_HVEH Hval. unit
bhval OIB_BHVAL Bse. heat. val.
bhvaleh OIB_BHVEH Ht.val. unit
mtcombtmp OIB_MTCOMBTMP Mat.comb. temp.
mtcombteh OIB_MTCOMBTEH Mat.ctmp.unit
mtcombpres OIB_MTCOMBPRES Mat.comb. pres.
mtcombpreseh OIB_MTCOMBPRESEH Mat.cprs.unit
ch4ratio OIB_CH4RAT CH4 ratio
n2ratio OIB_N2RAT N2 ratio
co2ratio OIB_CO2RAT CO2 ratio
c2h6ratio OIB_C2H6RAT C2H6 ratio
c3h8ratio OIB_C3H8RAT C3H8 ratio
h2oratio OIB_H2ORAT H2O ratio
h2sratio OIB_H2SRAT H2S ratio
h2ratio OIB_H2RAT H2 ratio
coratio OIB_CORAT CO ratio
o2ratio OIB_O2RAT O2 ratio
isoc4h10ratio OIB_ISOC4H10RAT C4H10 ratio
nc4h10ratio OIB_NC4H10RAT nC4H10 ratio
isoc5h12ratio OIB_ISOC5H12RAT C5H12 ratio
nc5h12ratio OIB_NC5H12RAT nC5H12 ratio
c6h14ratio OIB_C6H14RAT nC6H14 ratio
c7h16ratio OIB_C7H16RAT nC7H16 ratio
c8h18ratio OIB_C8H18RAT nC8H18 ratio
c9h20ratio OIB_C9H20RAT nC9H20 ratio
c10h22ratio OIB_C10H22RAT nC10H20 ratio
heratio OIB_HERAT He ratio
arratio OIB_ARRAT Ar ratio
gascomprateh OIB_GASCOMPRATEH H2S % unit
molden OIB_MOLDEN Base dens. mol
moldeneh OIB_MOLDENEH Density unit
molweight OIB_MOLWEIGHT Molecul. weight
hydrocarbmolfrac OIB_HYDROCARBMOLFRAC Hydro.mol.frac.
molweighteh OIB_MOLWEIGHTEH Density unit
custparchar1 OIB_CUSTPARCHAR1 Par.char.
custparfloat1 OIB_CUSTPARFLOAT1 Fltp.par.
custeh1 OIB_CUSTEH1 Unit 1
custparchar2 OIB_CUSTPARCHAR2 Par.char.
custparfloat2 OIB_CUSTPARFLOAT2 Fltp.par.
custeh2 OIB_CUSTEH2 Unit 2
custparchar3 OIB_CUSTPARCHAR3 Par.char.
custparfloat3 OIB_CUSTPARFLOAT3 Fltp.par.
custeh3 OIB_CUSTEH3 Unit 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- User Defaults for VMR application
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIB_USERDEF_VMR (
    MANDT,             -- Client [MANDT]
    BNAME,             -- User [XUBNAME]
    WERKS,             -- Plant [WERKS_D]
    MATNR,             -- Material [MATNR]
    CREATED_AT,        -- Document Timestamp [OIB_TIMESTAMP]
    CHANGED_AT,        -- Document Timestamp [OIB_TIMESTAMP_C]
    HYDRO,             -- Hydro.corr. [OIB_HYDRO]
    ABIND,             -- Air Buoy. Ind. [OIB_ABIND]
    ABFAC,             -- Air buoy. fact. [OIB_ABFAC_F]
    BSWCN,             -- BSW % [OIB_BSWCN]
    MCF,               -- MC factor [OIB_MCF1]
    BSWCNEH,           -- BSW % UNIT [OIB_BSWCNEH]
    BSWIND,            -- BSW indicator [OIB_BSWIND]
    HVCLS,             -- HV class [OIB_HVCLS]
    HVCLS_TO,          -- HV class [OIB_HVCLS]
    TDICH,             -- Test Density [OIB_TDICH]
    BDICH,             -- Base density [OIB_BDICH]
    TSTMP,             -- Test Temp. [OIB_TSTMP]
    TSTEH,             -- Test Temp.Unit [OIB_TSTEH]
    TSTMPCAL,          -- Cal. tst. temp. [OIB_TSTMPCAL]
    TSTMPCALEH,        -- Unit [OIB_TSTMPCALEH]
    MTTMP,             -- Mat.Temperature [OIB_MTTMP]
    MTTEH,             -- Mat.Temp.Unit [OIB_MTTEH]
    CMODE,             -- Conv. Mode [OIB_CMODE]
    COEFF,             -- Conv. Coeff. [OIB_COEFF]
    COEFFEH,           -- Internal UoM [MSEHI]
    FDICH,             -- Fixed Density [OIB_FDICH]
    TDICHEH,           -- Density unit [OIB_DNEH]
    BDICHEH,           -- Unit [OIB_BDNEH]
    FDICHEH,           -- Unit [OIB_BDNEH]
    MTPRES,            -- Mat.pressure [OIB_MTPRES]
    MTPRESEH,          -- Mat.press.unit [OIB_MTPRESEH]
    TPRED,             -- Test pres. den. [OIB_TPRED]
    TPREDEH,           -- Tpres.unit den. [OIB_TPREDEH]
    TPREDCAL,          -- Cal.tst.pres. [OIB_TPREDCAL]
    TPREDCALEH,        -- Unit [OIB_TPREDCALEH]
    TTMPHV,            -- Ttemp. HVal. [OIB_TTMPHV]
    TTMPHVEH,          -- Ttmp. unit HVal [OIB_TTMPHVEH]
    TPRHV,             -- Test pres. HV [OIB_TPRHV]
    TPRHVEH,           -- Tpres. unit HV [OIB_TPRHVEH]
    ATPRES,            -- Atm.pressure [OIB_ATPRES]
    ATPRESEH,          -- Atm. pres. unit [OIB_ATPRESEH]
    VAPRES,            -- Vapor pressure [OIB_VAPRES]
    VAPRESEH,          -- Vap. pres. unit [OIB_VAPRESEH]
    THVAL,             -- Tst. heat. val. [OIB_THVAL]
    THVALEH,           -- Hval. unit [OIB_HVEH]
    BHVAL,             -- Bse. heat. val. [OIB_BHVAL]
    BHVALEH,           -- Ht.val. unit [OIB_BHVEH]
    MTCOMBTMP,         -- Mat.comb. temp. [OIB_MTCOMBTMP]
    MTCOMBTEH,         -- Mat.ctmp.unit [OIB_MTCOMBTEH]
    MTCOMBPRES,        -- Mat.comb. pres. [OIB_MTCOMBPRES]
    MTCOMBPRESEH,      -- Mat.cprs.unit [OIB_MTCOMBPRESEH]
    CH4RATIO,          -- CH4 ratio [OIB_CH4RAT]
    N2RATIO,           -- N2 ratio [OIB_N2RAT]
    CO2RATIO,          -- CO2 ratio [OIB_CO2RAT]
    C2H6RATIO,         -- C2H6 ratio [OIB_C2H6RAT]
    C3H8RATIO,         -- C3H8 ratio [OIB_C3H8RAT]
    H2ORATIO,          -- H2O ratio [OIB_H2ORAT]
    H2SRATIO,          -- H2S ratio [OIB_H2SRAT]
    H2RATIO,           -- H2 ratio [OIB_H2RAT]
    CORATIO,           -- CO ratio [OIB_CORAT]
    O2RATIO,           -- O2 ratio [OIB_O2RAT]
    ISOC4H10RATIO,     -- C4H10 ratio [OIB_ISOC4H10RAT]
    NC4H10RATIO,       -- nC4H10 ratio [OIB_NC4H10RAT]
    ISOC5H12RATIO,     -- C5H12 ratio [OIB_ISOC5H12RAT]
    NC5H12RATIO,       -- nC5H12 ratio [OIB_NC5H12RAT]
    C6H14RATIO,        -- nC6H14 ratio [OIB_C6H14RAT]
    C7H16RATIO,        -- nC7H16 ratio [OIB_C7H16RAT]
    C8H18RATIO,        -- nC8H18 ratio [OIB_C8H18RAT]
    C9H20RATIO,        -- nC9H20 ratio [OIB_C9H20RAT]
    C10H22RATIO,       -- nC10H20 ratio [OIB_C10H22RAT]
    HERATIO,           -- He ratio [OIB_HERAT]
    ARRATIO,           -- Ar ratio [OIB_ARRAT]
    GASCOMPRATEH,      -- H2S % unit [OIB_GASCOMPRATEH]
    MOLDEN,            -- Base dens. mol [OIB_MOLDEN]
    MOLDENEH,          -- Density unit [OIB_MOLDENEH]
    MOLWEIGHT,         -- Molecul. weight [OIB_MOLWEIGHT]
    HYDROCARBMOLFRAC,  -- Hydro.mol.frac. [OIB_HYDROCARBMOLFRAC]
    MOLWEIGHTEH,       -- Density unit [OIB_MOLWEIGHTEH]
    CUSTPARCHAR1,      -- Par.char. [OIB_CUSTPARCHAR1]
    CUSTPARFLOAT1,     -- Fltp.par. [OIB_CUSTPARFLOAT1]
    CUSTEH1,           -- Unit 1 [OIB_CUSTEH1]
    CUSTPARCHAR2,      -- Par.char. [OIB_CUSTPARCHAR2]
    CUSTPARFLOAT2,     -- Fltp.par. [OIB_CUSTPARFLOAT2]
    CUSTEH2,           -- Unit 2 [OIB_CUSTEH2]
    CUSTPARCHAR3,      -- Par.char. [OIB_CUSTPARCHAR3]
    CUSTPARFLOAT3,     -- Fltp.par. [OIB_CUSTPARFLOAT3]
    CUSTEH3,           -- Unit 3 [OIB_CUSTEH3]
    PRIMARY KEY (MANDT, BNAME, WERKS, MATNR)
);

Learn More