OIURV_DOC_DTL_BK

Transparent Table Application Table
44 Fields 1 CDS Views

Valuation Transactions Level 1 - Vltxns

OIURV_DOC_DTL_BK is an SAP database table in S/4HANA. Valuation Transactions Level 1 - Vltxns. It contains 44 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnDocTransBooking view_entity from BASIC PRA Valuation Transactions Booking

Fields (44)

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.
dn_no OIU_DN_NO Delivery network ID
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
majpd_cd OIU_MAJPD_CD Major Product
freq_cd OIU_FREQ_CD Frequency
sale_dt OIU_SALE_DT Sales Date
frml_no OIU_FRML_NO Formula Number
pos_no OIU_DOC_POS_NO Position
lvl_cd OIU_LVL_CD Level Code
group_cd OIU_GROUP_CD Group Code
ppa_rsn_cd OIU_PPA_RSN_CD PPA Reason
unit_vname JV_NAME Joint venture
doi_sum_fl OIU_DOI_SUM_FL Sum DOI lvl
rm_fee_fl OIU_RM_FEE_FL CO2 Removal Fee
dual_acct_fl OIU_DUAL_ACCT_FL Dual Accounting
txn_prcs_cd OIU_TXN_PRCS_CD Txn Process Cd
ct_type_cd OIU_CT_TYPE_CD Contract Type
vl_val_on_val_fl OIU_VL_VAL_ON_VAL_FL Value on Value
rej_reprcs_fl OIU_REJ_REPRCS_FL Rej Reprc Flag
full_smpl_plt_cd OIU_FULL_SMPL_PLT_CD Ful Siml Plt Nk
rej_zv_cd OIU_REJ_ZVCD Reject / Zero Vol
rpt_pos_no OIU_DOC_POS_NO Position
rej_rsn_cd OIU_REJ_RSN_CD Rejection Rsn
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
remt_no OIU_REMITTER Remitter
remt_seq_no OIU_OWN_ISQ_NO Own. ISQ
pu_pr_no OIU_PU_JV_NAME Purch Lease No
pu_pd_cd OIU_PU_MATNR Xref Mat
acct_perd_dt OIUH_ACCOUNTING_PERIOD10 Acctng Prd
spc_dist_cd OIUCI_SPC_DIST_FL Special Distrib
mk_rep_no OIU_MK_REP_NO Marketing Rep
mk_rep_isq_no OIU_MK_REP_ISQ_NO Mkt. Rep. ISQ
vcr_no OIU_VCR_NO VCR no

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 - Vltxns
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_DTL_BK (
    MANDT,             -- Client [MANDT]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    LINE_NO,           -- Doc Line No. [OIU_DOC_LINENR]
    DN_NO,             -- Delivery network ID [OIU_DN_NO]
    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]
    MAJPD_CD,          -- Major Product [OIU_MAJPD_CD]
    FREQ_CD,           -- Frequency [OIU_FREQ_CD]
    SALE_DT,           -- Sales Date [OIU_SALE_DT]
    FRML_NO,           -- Formula Number [OIU_FRML_NO]
    POS_NO,            -- Position [OIU_DOC_POS_NO]
    LVL_CD,            -- Level Code [OIU_LVL_CD]
    GROUP_CD,          -- Group Code [OIU_GROUP_CD]
    PPA_RSN_CD,        -- PPA Reason [OIU_PPA_RSN_CD]
    UNIT_VNAME,        -- Joint venture [JV_NAME]
    DOI_SUM_FL,        -- Sum DOI lvl [OIU_DOI_SUM_FL]
    RM_FEE_FL,         -- CO2 Removal Fee [OIU_RM_FEE_FL]
    DUAL_ACCT_FL,      -- Dual Accounting [OIU_DUAL_ACCT_FL]
    TXN_PRCS_CD,       -- Txn Process Cd [OIU_TXN_PRCS_CD]
    CT_TYPE_CD,        -- Contract Type [OIU_CT_TYPE_CD]
    VL_VAL_ON_VAL_FL,  -- Value on Value [OIU_VL_VAL_ON_VAL_FL]
    REJ_REPRCS_FL,     -- Rej Reprc Flag [OIU_REJ_REPRCS_FL]
    FULL_SMPL_PLT_CD,  -- Ful Siml Plt Nk [OIU_FULL_SMPL_PLT_CD]
    REJ_ZV_CD,         -- Reject / Zero Vol [OIU_REJ_ZVCD]
    RPT_POS_NO,        -- Position [OIU_DOC_POS_NO]
    REJ_RSN_CD,        -- Rejection Rsn [OIU_REJ_RSN_CD]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    REMT_NO,           -- Remitter [OIU_REMITTER]
    REMT_SEQ_NO,       -- Own. ISQ [OIU_OWN_ISQ_NO]
    PU_PR_NO,          -- Purch Lease No [OIU_PU_JV_NAME]
    PU_PD_CD,          -- Xref Mat [OIU_PU_MATNR]
    ACCT_PERD_DT,      -- Acctng Prd [OIUH_ACCOUNTING_PERIOD10]
    SPC_DIST_CD,       -- Special Distrib [OIUCI_SPC_DIST_FL]
    MK_REP_NO,         -- Marketing Rep [OIU_MK_REP_NO]
    MK_REP_ISQ_NO,     -- Mkt. Rep. ISQ [OIU_MK_REP_ISQ_NO]
    VCR_NO,            -- VCR no [OIU_VCR_NO]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_NO)
);

Learn More