OIU_DO_DI

Transparent Table Application Table
25 Fields 3 CDS Views

Base Venture/DOI Relationship

OIU_DO_DI is an SAP database table in S/4HANA. Base Venture/DOI Relationship. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/pra/ofs_V_Do_Di_Pv view from Private View: Division of Interest
I_DivisionOfInterest view from BASIC Division Of Interest
I_PRAMaintDOI view from BASIC Maintain DOI for XI

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY vname jv_name Joint venture
KEY doi_no oiu_doi_no Venture/DOI
doi_nm oiu_doi_nm DOI Name
shtxt oiu_shtxt Description
comb_pd_cd oiu_comb_pd_cd Comb. prd.cd
land1 land1 Country/Reg.
pri_geo_loc oiu_pri_geo_loc Primary geo.loc
sec_geo_loc oiu_sec_geo_loc Secndry geo.loc
di_leg_de_cmt_fl oiu_di_leg_de_cmt_fl Legal Desc.
perm_tmpry_cd oiu_doi_status DOI Status
start_date oiu_start_dt Start Date
expiration_date oiu_end_dt End Date
doi_appr_cd oiu_doi_appr_cd Approval
checked_out_fl oiu_checked_out_fl Checked out
ppn_process_dt oiuow_ppn_process_dt PPN proc. date
ppn_process_fl oiuow_ppn_process_fl PPN Process Fl
own_transfer_fl oiuow_transfer_fl Transfer Flag
own_change_fl oiuow_change_fl Change Flag
check_out_date oiuow_check_out_dt Check Out Dt
check_in_date oiuow_check_in_dt Check In Date
ignore_okppi flag Indicator
check_out_user oiu_ow_chkout_user Check Out User
check_in_user oiu_ow_chkin_user Check In User

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.

-- Base Venture/DOI Relationship
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_DO_DI (
    MANDT,             -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    VNAME,             -- Joint venture [jv_name]
    DOI_NO,            -- Venture/DOI [oiu_doi_no]
    DOI_NM,            -- DOI Name [oiu_doi_nm]
    SHTXT,             -- Description [oiu_shtxt]
    COMB_PD_CD,        -- Comb. prd.cd [oiu_comb_pd_cd]
    LAND1,             -- Country/Reg. [land1]
    PRI_GEO_LOC,       -- Primary geo.loc [oiu_pri_geo_loc]
    SEC_GEO_LOC,       -- Secndry geo.loc [oiu_sec_geo_loc]
    DI_LEG_DE_CMT_FL,  -- Legal Desc. [oiu_di_leg_de_cmt_fl]
    PERM_TMPRY_CD,     -- DOI Status [oiu_doi_status]
    START_DATE,        -- Start Date [oiu_start_dt]
    EXPIRATION_DATE,   -- End Date [oiu_end_dt]
    DOI_APPR_CD,       -- Approval [oiu_doi_appr_cd]
    CHECKED_OUT_FL,    -- Checked out [oiu_checked_out_fl]
    PPN_PROCESS_DT,    -- PPN proc. date [oiuow_ppn_process_dt]
    PPN_PROCESS_FL,    -- PPN Process Fl [oiuow_ppn_process_fl]
    OWN_TRANSFER_FL,   -- Transfer Flag [oiuow_transfer_fl]
    OWN_CHANGE_FL,     -- Change Flag [oiuow_change_fl]
    CHECK_OUT_DATE,    -- Check Out Dt [oiuow_check_out_dt]
    CHECK_IN_DATE,     -- Check In Date [oiuow_check_in_dt]
    IGNORE_OKPPI,      -- Indicator [flag]
    CHECK_OUT_USER,    -- Check Out User [oiu_ow_chkout_user]
    CHECK_IN_USER,     -- Check In User [oiu_ow_chkin_user]
    PRIMARY KEY (MANDT, BUKRS, VNAME, DOI_NO)
);

Learn More