OIURV_DOC_DTL_ZE

Transparent Table Application Table
39 Fields 1 CDS Views

Valuation Transactions Level 1 - Zero Volume

OIURV_DOC_DTL_ZE is an SAP database table in S/4HANA. Valuation Transactions Level 1 - Zero Volume. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnDocTransZeroVolume view_entity from BASIC Valuation Transaction Level Zero Volume

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY doc_no oiurv_docnr DocNr
KEY doc_year oiu_doc_year Document year
KEY seq_no oiu_doc_linenr Doc Line No.
KEY line_no oiu_doc_linenr Doc Line No.
dn_no oiu_dn_no Delivery network ID
sale_dt oiu_sale_dt Sales Date
freq_cd oiu_freq_cd Frequency
wl_no oiu_wl_no Well
wc_no oiu_wc_no Well Completion
mp_no oiu_mp_no Measurement Pt
matnr matnr Material
bukrs bukrs Company Code
vname jv_name Joint venture
doi_no oiu_doi_no Venture/DOI
ct_no oiu_ct_no Contract
ct_type_cd oiu_ct_type_cd Contract Type
unit_vname jv_name Joint venture
majpd_cd oiu_majpd_cd Major Product
school_dist_cd oiu_school_dist_cd School District
tax_class oiu_tax_cls Tax Class
vl_type_cd oiu_vt_cd Volume Type
vl_cls_cd oiu_vc_cd Volume Class
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
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
orig_mp_no oiu_orig_mp_no Originating MP
mp_type_cd oiu_mp_type_cd MP Type
frml_no oiu_frml_no Formula Number
ppa_rsn_cd oiu_ppa_rsn_cd PPA Reason
rej_rsn_cd oiu_rej_rsn_cd Rejection Rsn
rej_zv_cd oiu_rej_zvcd Reject / Zero Vol
doi_sum_fl oiu_doi_sum_fl Sum DOI lvl
rej_reprcs_fl oiu_rej_reprcs_fl Rej Reprc Flag
system_srce_cd oiu_vl_srce_cd VL Txn Source

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 Transactions Level 1 - Zero Volume
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_DTL_ZE (
    MANDT,           -- Client [mandt]
    DOC_NO,          -- DocNr [oiurv_docnr]
    DOC_YEAR,        -- Document year [oiu_doc_year]
    SEQ_NO,          -- Doc Line No. [oiu_doc_linenr]
    LINE_NO,         -- Doc Line No. [oiu_doc_linenr]
    DN_NO,           -- Delivery network ID [oiu_dn_no]
    SALE_DT,         -- Sales Date [oiu_sale_dt]
    FREQ_CD,         -- Frequency [oiu_freq_cd]
    WL_NO,           -- Well [oiu_wl_no]
    WC_NO,           -- Well Completion [oiu_wc_no]
    MP_NO,           -- Measurement Pt [oiu_mp_no]
    MATNR,           -- Material [matnr]
    BUKRS,           -- Company Code [bukrs]
    VNAME,           -- Joint venture [jv_name]
    DOI_NO,          -- Venture/DOI [oiu_doi_no]
    CT_NO,           -- Contract [oiu_ct_no]
    CT_TYPE_CD,      -- Contract Type [oiu_ct_type_cd]
    UNIT_VNAME,      -- Joint venture [jv_name]
    MAJPD_CD,        -- Major Product [oiu_majpd_cd]
    SCHOOL_DIST_CD,  -- School District [oiu_school_dist_cd]
    TAX_CLASS,       -- Tax Class [oiu_tax_cls]
    VL_TYPE_CD,      -- Volume Type [oiu_vt_cd]
    VL_CLS_CD,       -- Volume Class [oiu_vc_cd]
    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]
    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]
    ORIG_MP_NO,      -- Originating MP [oiu_orig_mp_no]
    MP_TYPE_CD,      -- MP Type [oiu_mp_type_cd]
    FRML_NO,         -- Formula Number [oiu_frml_no]
    PPA_RSN_CD,      -- PPA Reason [oiu_ppa_rsn_cd]
    REJ_RSN_CD,      -- Rejection Rsn [oiu_rej_rsn_cd]
    REJ_ZV_CD,       -- Reject / Zero Vol [oiu_rej_zvcd]
    DOI_SUM_FL,      -- Sum DOI lvl [oiu_doi_sum_fl]
    REJ_REPRCS_FL,   -- Rej Reprc Flag [oiu_rej_reprcs_fl]
    SYSTEM_SRCE_CD,  -- VL Txn Source [oiu_vl_srce_cd]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, SEQ_NO, LINE_NO)
);

Learn More