OIU_DO_PUC

Transparent Table Application Table
10 Fields 2 CDS Views

Property Unit Use Control

OIU_DO_PUC is an SAP database table in S/4HANA. Property Unit Use Control. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAMaintUnitVntrTract view inner BASIC Maintain Unit Venture tract
I_PRAMaintUnitVntrUseCtrl view from BASIC Maintain Property Use control

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY unit_vname jv_name Joint venture
KEY comb_pd_cd oiu_comb_pd_cd Comb. prd.cd
KEY eff_from_dt oiu_eff_from_dt Effective From
eff_to_dt oiu_eff_to_dt Effective To
puc_no oiu_puc_no PUC number
tot_tpf_pc oiu_tot_tpf_pc Total TPF
appr_fl oiu_appr_fl Approval
last_tr_seq_no oiuow_seq_no Sequence no.

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.

-- Property Unit Use Control
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_DO_PUC (
    MANDT,           -- Client [mandt]
    BUKRS,           -- Company Code [bukrs]
    UNIT_VNAME,      -- Joint venture [jv_name]
    COMB_PD_CD,      -- Comb. prd.cd [oiu_comb_pd_cd]
    EFF_FROM_DT,     -- Effective From [oiu_eff_from_dt]
    EFF_TO_DT,       -- Effective To [oiu_eff_to_dt]
    PUC_NO,          -- PUC number [oiu_puc_no]
    TOT_TPF_PC,      -- Total TPF [oiu_tot_tpf_pc]
    APPR_FL,         -- Approval [oiu_appr_fl]
    LAST_TR_SEQ_NO,  -- Sequence no. [oiuow_seq_no]
    PRIMARY KEY (MANDT, BUKRS, UNIT_VNAME, COMB_PD_CD, EFF_FROM_DT)
);

Learn More