OIURV_DOC_VOLDTL

Transparent Table Application Table
118 Fields 1 CDS Views

Valuation Transaction Level 2 -Volume

OIURV_DOC_VOLDTL is an SAP database table in S/4HANA. Valuation Transaction Level 2 -Volume. It contains 118 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnDocTransVolDetail view_entity from BASIC PRA Valuation Doc trnx volume detail

Fields (118)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY doc_no OIURV_DOCNR DocNr
KEY doc_year OIU_DOC_YEAR Document year
KEY line_no OIU_DOC_LINENR Doc Line No.
KEY pos_no OIU_DOC_POS_NO Position
land1 LAND1 Country/Reg.
pri_geo_loc OIU_PRI_GEO_LOC Primary geo.loc
sec_geo_loc OIU_SEC_GEO_LOC Secndry geo.loc
school_dist_cd OIU_SCHOOL_DIST_CD School District
tax_cls OIU_TAX_CLS Tax Class
ons_ofs_cd OIU_ONS_OFS_CD On/Offshore
system_srce_cd OIU_VL_SRCE_CD VL Txn Source
pay_cd OIU_PAY_CD Pay Code
vname_type_cd OIU_VNAME_TYPE_CD Usage Type
theo_cnd_tax_fl OIU_THEO_CND_TAX_FL Theo Cond Tax
ca_alloc_meth_cd OIU_CA_ALLOC_METH_CD Allocation Meth
related_ct OIU_RELATED_CT Rel Contract
lvl_cd OIU_LVL_CD Level Code
wi_own_no OIU_WI_OWN_NO Wrk Int Owner
wi_int_type_cd OIU_PART_INT_TYPE Interest Type
wi_own_isq_no OIU_OWN_ISQ_NO Own. ISQ
tr_bukrs BUKRS Company Code
tr_vname JV_NAME Joint venture
tr_doi OIU_DOI_NO Venture/DOI
ni_own_no OIU_NI_OWN_NO Net Int Owner
ni_int_type_cd OIU_PART_INT_TYPE Interest Type
ni_own_isq_no OIU_OWN_ISQ_NO Own. ISQ
ni_frml_no OIU_FRML_NO Formula Number
tr_doi_sum_fl OIU_DOI_SUM_FL Sum DOI lvl
tot_gri_pc OIU_TOT_GRI_PC Total GRI %
tot_nri_pc OIU_TOT_NRI_PC Total NRI %
ct_decm OIU_CT_DECM Cntrct Decimal
rel_ct_decm OIU_REL_CT_DECM Rel Ct Dec
sett_decm OIU_SETT_DECM Sett Dec
tot_mkt_grp_gri OIU_TOT_MKT_GRP_GRI Tot Mkt Grp GRI
mp_type_cd OIU_MP_TYPE_CD MP Type
orig_mp_no OIU_ORIG_MP_NO Originating MP
mp_type_cd2 OIU_MP_TYPE_CD MP Type
vl_type_cd OIU_VT_CD Volume Type
vl_cls_cd OIU_VC_CD Volume Class
frml_actl_fl OIU_ACTL_FL Actual Flag
frml_entl_fl OIU_ENTL_FL Entitled
frml_sett_fl OIU_SETT_FL Settlement
tot_ct_vl_u OIU_MEAS_U UoM
tot_ct_vl OIU_TOT_CT_VL Tot Ct Vol
tot_gr_vl_u OIU_MEAS_U UoM
tot_gr_vl OIU_TOT_GR_VL Tot Gross Vl
actl_gr_vl OIU_ACTL_GR_VL_AM Act Gross Vol
actl_gr_vl_u OIU_MEAS_U UoM
entl_gr_vl OIU_ENTL_GR_VL_AM Entitled Vol
entl_gr_vl_u OIU_MEAS_U UoM
sett_gr_vl OIU_SETT_GR_VL_AM Settlement Vol
sett_gr_vl_u OIU_MEAS_U UoM
tot_ct_energy OIU_CT_ENERGY Contract energy
actl_energy OIU_ACTL_ENERGY Energy
actl_energy_u OIU_MEAS_U UoM
entl_energy OIU_ENTL_ENERGY Energy
entl_energy_u OIU_MEAS_U UoM
sett_energy OIU_SETT_ENERGY Settlement Amt
sett_energy_u OIU_MEAS_U UoM
uncr_gr_vl_u OIU_MEAS_U UoM
uncr_gr_vl OIU_UNCR_GR_VL Uncr Gross Vol
uncr_sett_gr_vl OIU_UNCR_SETT_GR_VL Uncr Gr Vl
run_tkt_no OIU_RUN_TKT_NO Run Ticket No
tot_tkt_days OIU_TOT_TKT_DAYS Tot Tkt Days
prd_days OIU_DAYS_PROD Days produced
sale_dt_to OIU_SA_DT_TO Sales To-Date
sale_dt_from OIU_SA_DT_FROM Sales From-Date
tank_meter OIU_MP_NO Measurement Pt
grv_am OIB_BDICH Base density
density_u OIB_BDNEH Unit
dntyp OIB_DNTYP Dens. Type
heat_value_fct_u OIU_MEAS_U UoM
act_heat_val_fct OIU_ACT_HEAT_VAL_FCT Actual Heat Fct
set_heat_val_fct OIU_SET_HEAT_VAL_FCT Sett Heat Fct
ct_heat_va_fct_u OIU_MEAS_U UoM
ct_heat_val_fct OIU_CT_HEAT_VAL_FCT Cntrct Heat Fct
vl_timestamp TZNTSTMPS Time Stamp
trnsp_no OIU_TRNSP_NO Transporter
trnsp_ref_no OIU_TRNSP_REF_NO Trsprt.Ref.
trnsp_rou_cd OIU_TRNSP_ROU_CD Transp.Route Cd
gaslift_wl_no OIU_WL_NO Well
gaslift_wc_no OIU_WC_NO Well Completion
rej_rsn_cd OIU_REJ_RSN_CD Rejection Rsn
ra_pct OIU_RA_PCT RA Frm Pct
tik_pa_pc OIU_TIK_PA_PC PA Agreemnt Pct
ca_wgb_cd OIU_CA_WGB_CD Wet Gas Bal
calc_wlr_fl OIU_CALC_WETLESRES_FL Calc. WetLesRes
pct_ret_lse OIU_PCT_RET_LSE Pct Ret to Ls
actl_wlr_vl_am OIU_ACTL_WLR_VL_AM Act WLR Amount
actl_wlr_vl_am_u OIU_MEAS_U UoM
entl_wlr_vl_am OIU_ENTL_WLR_VL_AM Ent WLR Amount
entl_wlr_vl_am_u OIU_MEAS_U UoM
sett_wlr_vl_am OIU_SETT_WLR_VL_AM Vol. Amt.
sett_wlr_vl_am_u OIU_MEAS_U UoM
ent_vl_alloc_dec OIU_ENT_VL_ALLOC_DEC Ent Vol All Dec
ent_eng_allc_dec OIU_ENT_ENG_ALLC_DEC Ent En Allc Dec
ent_set_gr_vl_u OIU_MEAS_U UoM
entl_sett_gr_vl OIU_ENTL_SETT_GR_VL Ent Sett Gr Vol
entl_sett_eng_u OIU_MEAS_U UoM
entl_sett_energy OIU_ENTL_SETT_ENERGY Ent Sett Engy
cost_center KOSTL Cost Center
lse_vol OIU_LSE_VOL Lease Volume
lse_vol_u OIU_MEAS_U UoM
rej_zv_cd OIU_REJ_ZVCD Reject / Zero Vol
gplt_vname OIU_GPLT_VNAME Gplt Venture
gplt_doi_doi OIU_GPLT_DOI_NO Gplt DOI
orig_gri_pc OIU_TOT_GRI_PC Total GRI %
entl_ct_decm OIU_CT_DECM Cntrct Decimal
e_set_wlr_vl_am OIU_SETT_WLR_VL_AM Vol. Amt.
e_set_wlr_vl_a_u OIU_MEAS_U UoM
actl_ptr_vl_am OIU_ACTL_PTR_VL_AM Act PTR Amount
actl_ptr_vl_am_u OIU_MEAS_U UoM
entl_ptr_vl_am OIU_ENTL_PTR_VL_AM Ent PTR Amount
entl_ptr_vl_am_u OIU_MEAS_U UoM
sett_ptr_vl_am OIU_SETT_PTR_VL_AM Sett PTR Amount
sett_ptr_vl_am_u OIU_MEAS_U UoM
invt_dt OIU_INV_DT Inventory date

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.

-- Valuation Transaction Level 2 -Volume
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_VOLDTL (
    MANDT,             -- Client [MANDT]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    LINE_NO,           -- Doc Line No. [OIU_DOC_LINENR]
    POS_NO,            -- Position [OIU_DOC_POS_NO]
    LAND1,             -- Country/Reg. [LAND1]
    PRI_GEO_LOC,       -- Primary geo.loc [OIU_PRI_GEO_LOC]
    SEC_GEO_LOC,       -- Secndry geo.loc [OIU_SEC_GEO_LOC]
    SCHOOL_DIST_CD,    -- School District [OIU_SCHOOL_DIST_CD]
    TAX_CLS,           -- Tax Class [OIU_TAX_CLS]
    ONS_OFS_CD,        -- On/Offshore [OIU_ONS_OFS_CD]
    SYSTEM_SRCE_CD,    -- VL Txn Source [OIU_VL_SRCE_CD]
    PAY_CD,            -- Pay Code [OIU_PAY_CD]
    VNAME_TYPE_CD,     -- Usage Type [OIU_VNAME_TYPE_CD]
    THEO_CND_TAX_FL,   -- Theo Cond Tax [OIU_THEO_CND_TAX_FL]
    CA_ALLOC_METH_CD,  -- Allocation Meth [OIU_CA_ALLOC_METH_CD]
    RELATED_CT,        -- Rel Contract [OIU_RELATED_CT]
    LVL_CD,            -- Level Code [OIU_LVL_CD]
    WI_OWN_NO,         -- Wrk Int Owner [OIU_WI_OWN_NO]
    WI_INT_TYPE_CD,    -- Interest Type [OIU_PART_INT_TYPE]
    WI_OWN_ISQ_NO,     -- Own. ISQ [OIU_OWN_ISQ_NO]
    TR_BUKRS,          -- Company Code [BUKRS]
    TR_VNAME,          -- Joint venture [JV_NAME]
    TR_DOI,            -- Venture/DOI [OIU_DOI_NO]
    NI_OWN_NO,         -- Net Int Owner [OIU_NI_OWN_NO]
    NI_INT_TYPE_CD,    -- Interest Type [OIU_PART_INT_TYPE]
    NI_OWN_ISQ_NO,     -- Own. ISQ [OIU_OWN_ISQ_NO]
    NI_FRML_NO,        -- Formula Number [OIU_FRML_NO]
    TR_DOI_SUM_FL,     -- Sum DOI lvl [OIU_DOI_SUM_FL]
    TOT_GRI_PC,        -- Total GRI % [OIU_TOT_GRI_PC]
    TOT_NRI_PC,        -- Total NRI % [OIU_TOT_NRI_PC]
    CT_DECM,           -- Cntrct Decimal [OIU_CT_DECM]
    REL_CT_DECM,       -- Rel Ct Dec [OIU_REL_CT_DECM]
    SETT_DECM,         -- Sett Dec [OIU_SETT_DECM]
    TOT_MKT_GRP_GRI,   -- Tot Mkt Grp GRI [OIU_TOT_MKT_GRP_GRI]
    MP_TYPE_CD,        -- MP Type [OIU_MP_TYPE_CD]
    ORIG_MP_NO,        -- Originating MP [OIU_ORIG_MP_NO]
    MP_TYPE_CD2,       -- MP Type [OIU_MP_TYPE_CD]
    VL_TYPE_CD,        -- Volume Type [OIU_VT_CD]
    VL_CLS_CD,         -- Volume Class [OIU_VC_CD]
    FRML_ACTL_FL,      -- Actual Flag [OIU_ACTL_FL]
    FRML_ENTL_FL,      -- Entitled [OIU_ENTL_FL]
    FRML_SETT_FL,      -- Settlement [OIU_SETT_FL]
    TOT_CT_VL_U,       -- UoM [OIU_MEAS_U]
    TOT_CT_VL,         -- Tot Ct Vol [OIU_TOT_CT_VL]
    TOT_GR_VL_U,       -- UoM [OIU_MEAS_U]
    TOT_GR_VL,         -- Tot Gross Vl [OIU_TOT_GR_VL]
    ACTL_GR_VL,        -- Act Gross Vol [OIU_ACTL_GR_VL_AM]
    ACTL_GR_VL_U,      -- UoM [OIU_MEAS_U]
    ENTL_GR_VL,        -- Entitled Vol [OIU_ENTL_GR_VL_AM]
    ENTL_GR_VL_U,      -- UoM [OIU_MEAS_U]
    SETT_GR_VL,        -- Settlement Vol [OIU_SETT_GR_VL_AM]
    SETT_GR_VL_U,      -- UoM [OIU_MEAS_U]
    TOT_CT_ENERGY,     -- Contract energy [OIU_CT_ENERGY]
    ACTL_ENERGY,       -- Energy [OIU_ACTL_ENERGY]
    ACTL_ENERGY_U,     -- UoM [OIU_MEAS_U]
    ENTL_ENERGY,       -- Energy [OIU_ENTL_ENERGY]
    ENTL_ENERGY_U,     -- UoM [OIU_MEAS_U]
    SETT_ENERGY,       -- Settlement Amt [OIU_SETT_ENERGY]
    SETT_ENERGY_U,     -- UoM [OIU_MEAS_U]
    UNCR_GR_VL_U,      -- UoM [OIU_MEAS_U]
    UNCR_GR_VL,        -- Uncr Gross Vol [OIU_UNCR_GR_VL]
    UNCR_SETT_GR_VL,   -- Uncr Gr Vl [OIU_UNCR_SETT_GR_VL]
    RUN_TKT_NO,        -- Run Ticket No [OIU_RUN_TKT_NO]
    TOT_TKT_DAYS,      -- Tot Tkt Days [OIU_TOT_TKT_DAYS]
    PRD_DAYS,          -- Days produced [OIU_DAYS_PROD]
    SALE_DT_TO,        -- Sales To-Date [OIU_SA_DT_TO]
    SALE_DT_FROM,      -- Sales From-Date [OIU_SA_DT_FROM]
    TANK_METER,        -- Measurement Pt [OIU_MP_NO]
    GRV_AM,            -- Base density [OIB_BDICH]
    DENSITY_U,         -- Unit [OIB_BDNEH]
    DNTYP,             -- Dens. Type [OIB_DNTYP]
    HEAT_VALUE_FCT_U,  -- UoM [OIU_MEAS_U]
    ACT_HEAT_VAL_FCT,  -- Actual Heat Fct [OIU_ACT_HEAT_VAL_FCT]
    SET_HEAT_VAL_FCT,  -- Sett Heat Fct [OIU_SET_HEAT_VAL_FCT]
    CT_HEAT_VA_FCT_U,  -- UoM [OIU_MEAS_U]
    CT_HEAT_VAL_FCT,   -- Cntrct Heat Fct [OIU_CT_HEAT_VAL_FCT]
    VL_TIMESTAMP,      -- Time Stamp [TZNTSTMPS]
    TRNSP_NO,          -- Transporter [OIU_TRNSP_NO]
    TRNSP_REF_NO,      -- Trsprt.Ref. [OIU_TRNSP_REF_NO]
    TRNSP_ROU_CD,      -- Transp.Route Cd [OIU_TRNSP_ROU_CD]
    GASLIFT_WL_NO,     -- Well [OIU_WL_NO]
    GASLIFT_WC_NO,     -- Well Completion [OIU_WC_NO]
    REJ_RSN_CD,        -- Rejection Rsn [OIU_REJ_RSN_CD]
    RA_PCT,            -- RA Frm Pct [OIU_RA_PCT]
    TIK_PA_PC,         -- PA Agreemnt Pct [OIU_TIK_PA_PC]
    CA_WGB_CD,         -- Wet Gas Bal [OIU_CA_WGB_CD]
    CALC_WLR_FL,       -- Calc. WetLesRes [OIU_CALC_WETLESRES_FL]
    PCT_RET_LSE,       -- Pct Ret to Ls [OIU_PCT_RET_LSE]
    ACTL_WLR_VL_AM,    -- Act WLR Amount [OIU_ACTL_WLR_VL_AM]
    ACTL_WLR_VL_AM_U,  -- UoM [OIU_MEAS_U]
    ENTL_WLR_VL_AM,    -- Ent WLR Amount [OIU_ENTL_WLR_VL_AM]
    ENTL_WLR_VL_AM_U,  -- UoM [OIU_MEAS_U]
    SETT_WLR_VL_AM,    -- Vol. Amt. [OIU_SETT_WLR_VL_AM]
    SETT_WLR_VL_AM_U,  -- UoM [OIU_MEAS_U]
    ENT_VL_ALLOC_DEC,  -- Ent Vol All Dec [OIU_ENT_VL_ALLOC_DEC]
    ENT_ENG_ALLC_DEC,  -- Ent En Allc Dec [OIU_ENT_ENG_ALLC_DEC]
    ENT_SET_GR_VL_U,   -- UoM [OIU_MEAS_U]
    ENTL_SETT_GR_VL,   -- Ent Sett Gr Vol [OIU_ENTL_SETT_GR_VL]
    ENTL_SETT_ENG_U,   -- UoM [OIU_MEAS_U]
    ENTL_SETT_ENERGY,  -- Ent Sett Engy [OIU_ENTL_SETT_ENERGY]
    COST_CENTER,       -- Cost Center [KOSTL]
    LSE_VOL,           -- Lease Volume [OIU_LSE_VOL]
    LSE_VOL_U,         -- UoM [OIU_MEAS_U]
    REJ_ZV_CD,         -- Reject / Zero Vol [OIU_REJ_ZVCD]
    GPLT_VNAME,        -- Gplt Venture [OIU_GPLT_VNAME]
    GPLT_DOI_DOI,      -- Gplt DOI [OIU_GPLT_DOI_NO]
    ORIG_GRI_PC,       -- Total GRI % [OIU_TOT_GRI_PC]
    ENTL_CT_DECM,      -- Cntrct Decimal [OIU_CT_DECM]
    E_SET_WLR_VL_AM,   -- Vol. Amt. [OIU_SETT_WLR_VL_AM]
    E_SET_WLR_VL_A_U,  -- UoM [OIU_MEAS_U]
    ACTL_PTR_VL_AM,    -- Act PTR Amount [OIU_ACTL_PTR_VL_AM]
    ACTL_PTR_VL_AM_U,  -- UoM [OIU_MEAS_U]
    ENTL_PTR_VL_AM,    -- Ent PTR Amount [OIU_ENTL_PTR_VL_AM]
    ENTL_PTR_VL_AM_U,  -- UoM [OIU_MEAS_U]
    SETT_PTR_VL_AM,    -- Sett PTR Amount [OIU_SETT_PTR_VL_AM]
    SETT_PTR_VL_AM_U,  -- UoM [OIU_MEAS_U]
    INVT_DT,           -- Inventory date [OIU_INV_DT]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_NO, POS_NO)
);

Learn More