OIU_DO_JV

Transparent Table Application Table
25 Fields 3 CDS Views

PRA venture extension

OIU_DO_JV is an SAP database table in S/4HANA. PRA venture extension. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/pra/ofs_V_Do_jv_Pv view from Private View: Joint Venture
I_PRAJointVenture view from BASIC PRA Joint Venture
I_PRAMaintVenture view from BASIC Maintain Joint Venture for XI

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY vname jv_name Joint venture
vname_int_cd oiu_vname_int_cd Interest Code
vname_nm oiu_vname_nm Venture Name
shtxt oiu_shtxt Description
sts_code oiu_vname_status PRA Venture Sta
sts_eff_dt oiu_sts_eff_dt Status Eff Date
country land1 Country/Reg.
pri_geo_loc oiu_pri_geo_loc Primary geo.loc
sec_geo_loc oiu_sec_geo_loc Secndry geo.loc
acq_dt oiu_acq_dt Acquired date
type_cd oiu_vname_type_cd Usage Type
old_vname_no oiu_old_vname_no Old lease ID
unit_fl oiu_unit_fl Unit venture
doi_by_tr_fl oiu_doi_by_tr_fl DOI By Tract
drl_fund_fl oiu_drl_fund_fl Drill Fund
ons_ofs_cd oiu_ons_ofs_cd On/Offshore
acq_from_kunnr oiu_acq_from_kunnr Party Acq From
sld_to_kunnr oiu_sld_to_kunnr Party Sold To
leg_de_cmt_fl oiu_leg_de_cmt_fl Legal desc.
field oiu_fieldid Field
space_ord_no oiu_space_ord_no Space order no.
lpn_no oiu_lpn_no LPN No
doi_prt_fl oiu_doi_prt_fl DOI Print Flag

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.

-- PRA venture extension
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_DO_JV (
    MANDT,           -- Client [mandt]
    BUKRS,           -- Company Code [bukrs]
    VNAME,           -- Joint venture [jv_name]
    VNAME_INT_CD,    -- Interest Code [oiu_vname_int_cd]
    VNAME_NM,        -- Venture Name [oiu_vname_nm]
    SHTXT,           -- Description [oiu_shtxt]
    STS_CODE,        -- PRA Venture Sta [oiu_vname_status]
    STS_EFF_DT,      -- Status Eff Date [oiu_sts_eff_dt]
    COUNTRY,         -- Country/Reg. [land1]
    PRI_GEO_LOC,     -- Primary geo.loc [oiu_pri_geo_loc]
    SEC_GEO_LOC,     -- Secndry geo.loc [oiu_sec_geo_loc]
    ACQ_DT,          -- Acquired date [oiu_acq_dt]
    TYPE_CD,         -- Usage Type [oiu_vname_type_cd]
    OLD_VNAME_NO,    -- Old lease ID [oiu_old_vname_no]
    UNIT_FL,         -- Unit venture [oiu_unit_fl]
    DOI_BY_TR_FL,    -- DOI By Tract [oiu_doi_by_tr_fl]
    DRL_FUND_FL,     -- Drill Fund [oiu_drl_fund_fl]
    ONS_OFS_CD,      -- On/Offshore [oiu_ons_ofs_cd]
    ACQ_FROM_KUNNR,  -- Party Acq From [oiu_acq_from_kunnr]
    SLD_TO_KUNNR,    -- Party Sold To [oiu_sld_to_kunnr]
    LEG_DE_CMT_FL,   -- Legal desc. [oiu_leg_de_cmt_fl]
    FIELD,           -- Field [oiu_fieldid]
    SPACE_ORD_NO,    -- Space order no. [oiu_space_ord_no]
    LPN_NO,          -- LPN No [oiu_lpn_no]
    DOI_PRT_FL,      -- DOI Print Flag [oiu_doi_prt_fl]
    PRIMARY KEY (MANDT, BUKRS, VNAME)
);

Learn More