OIU_DO_PUC

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

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.
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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]
    OIU_CRUSER,      -- Created By [ERNAM]
    OIU_TIMESTAMP,   -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, BUKRS, UNIT_VNAME, COMB_PD_CD, EFF_FROM_DT)
);

Learn More