OIU_DO_DI

Transparent Table Application Table
27 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 27 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 (27)

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
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
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]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    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