OIU_RV_VCR

Transparent Table Application Table
20 Fields 1 CDS Views

Valuation Cross Reference

OIU_RV_VCR is an SAP database table in S/4HANA. Valuation Cross Reference. It contains 20 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 (20)

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

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]
    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