OIU_SB_DOIMP

Transparent Table Application Table
10 Fields 1 CDS Views

Cross-reference for MP and DOI

OIU_SB_DOIMP is an SAP database table in S/4HANA. Cross-reference for MP and DOI. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAMsmtPtDOICrsRef view_entity from BASIC Cross reference for MP and DOI

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mp_no oiu_mp_no Measurement Pt
KEY bukrs bukrs Company Code
KEY vname jv_name Joint venture
KEY doi_no oiu_doi_no Venture/DOI
KEY majpd_cd oiu_cond_majpd_cd Major product
KEY matnr matnr Material
KEY eff_from_dt oiu_eff_from_dt Effective From
eff_to_dt oiu_eff_to_dt Effective To
dflt_cd oiu_dflt_cd Def xRef Type

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.

-- Cross-reference for MP and DOI
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_DOIMP (
    MANDT,        -- Client [mandt]
    MP_NO,        -- Measurement Pt [oiu_mp_no]
    BUKRS,        -- Company Code [bukrs]
    VNAME,        -- Joint venture [jv_name]
    DOI_NO,       -- Venture/DOI [oiu_doi_no]
    MAJPD_CD,     -- Major product [oiu_cond_majpd_cd]
    MATNR,        -- Material [matnr]
    EFF_FROM_DT,  -- Effective From [oiu_eff_from_dt]
    EFF_TO_DT,    -- Effective To [oiu_eff_to_dt]
    DFLT_CD,      -- Def xRef Type [oiu_dflt_cd]
    PRIMARY KEY (MANDT, MP_NO, BUKRS, VNAME, DOI_NO, MAJPD_CD, MATNR, EFF_FROM_DT)
);

Learn More