OIU_RV_VCR

Transparent Table Application Table
22 Fields 1 CDS Views

Valuation Cross Reference

OIU_RV_VCR is an SAP database table in S/4HANA. Valuation Cross Reference. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRATstValnCrsRefVH view from BASIC Value Help for VCR

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dn_no OIU_DN_NO Delivery network ID
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
KEY mp_no OIU_MP_NO Measurement Pt
KEY majpd_cd OIU_MAJPD_CD Major Product
KEY bukrs BUKRS Company Code
KEY vname JV_NAME Joint venture
KEY doi_no OIU_DOI_NO Venture/DOI
KEY ct_no OIU_CT_NO Contract
KEY freq_cd OIU_FREQ_CD Frequency
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
vcr_no OIU_VCR_NO VCR no
frml_no OIU_FRML_NO Formula Number
mp_type_cd OIU_MP_TYPE_CD MP Type
ca_dvrs_fl OIU_CT_DVRS_FL Contract Dvrs
stlmt_dvrs_fl OIU_STLMT_DVRS_FL Settlement Dvrs
vcr_appr_fl OIU_APPR_FL Approval
group_cd OIU_GROUP_CD Group Code
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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 Cross Reference
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_RV_VCR (
    MANDT,          -- Client [MANDT]
    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]
    MAJPD_CD,       -- Major Product [OIU_MAJPD_CD]
    BUKRS,          -- Company Code [BUKRS]
    VNAME,          -- Joint venture [JV_NAME]
    DOI_NO,         -- Venture/DOI [OIU_DOI_NO]
    CT_NO,          -- Contract [OIU_CT_NO]
    FREQ_CD,        -- Frequency [OIU_FREQ_CD]
    EFF_FROM_DT,    -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,      -- Effective To [OIU_EFF_TO_DT]
    VCR_NO,         -- VCR no [OIU_VCR_NO]
    FRML_NO,        -- Formula Number [OIU_FRML_NO]
    MP_TYPE_CD,     -- MP Type [OIU_MP_TYPE_CD]
    CA_DVRS_FL,     -- Contract Dvrs [OIU_CT_DVRS_FL]
    STLMT_DVRS_FL,  -- Settlement Dvrs [OIU_STLMT_DVRS_FL]
    VCR_APPR_FL,    -- Approval [OIU_APPR_FL]
    GROUP_CD,       -- Group Code [OIU_GROUP_CD]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, DN_NO, WL_NO, WC_NO, MP_NO, MAJPD_CD, BUKRS, VNAME, DOI_NO, CT_NO, FREQ_CD, EFF_FROM_DT)
);

Learn More