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