OIUOW_DTCH

Transparent Table Application Table
31 Fields 3 CDS Views

DOI Transfer Change Header

OIUOW_DTCH is an SAP database table in S/4HANA. DOI Transfer Change Header. It contains 31 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/pra/ofs_V_Transfer_Hdr_Pv view from Private View: Transfer Header
E_PRAOwnerTransferDocument view_entity from EXTENSION PRA Owner Transfer document - Extension
I_PRAOwnerTransferHeader view_entity from BASIC PRA DOI Transfer Change Header

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY doc_no OIUOW_DOC_NO Doc. number
KEY doc_year OIU_DOC_YEAR Document year
eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
doc_type OIUOW_DOC_TYP Document type
doc_desc OIUOW_DOC_DESC Description
shtxt OIU_SHTXT Description
ref_doc_no OIUOW_REF_DOC_NO Ref. doc.nr
status_cd OIUOW_STATUS_CD Status
process_dt OIUOW_PROCESS_DT Process date
process_uname OIUOW_PROCESS_UNAME Processed by
sus_eff_from_dt OIUOW_SUS_EFF_FROM_DT Sus.start dt
tfer_inv_fl OIUOW_TFER_INV_FL Xfer. inventory
tfer_imbal_fl OIUOW_TFER_IMBAL_FL Xfer. imbalance
check_in_fl OIUOW_CHECK_IN_FL Check-in DOI
tfch_rsn_cd OIU_TFCH_RSN_CD Reason Code
genr_ppa_fl OIU_GENR_PPA_FL Generate PPA
accum_interest OIUOW_ACCUM_INTEREST Accum.int
transfer_type OIUOW_TRANSFER_TYPE Transfer type
genr_do_fl OIU_GENR_DO_FL Generated DO
dopt_user_id ERNAM Created By
div_eff_dt OIU_DIV_EFF_DT Div Eff Date
mkt_chg_dt_oil OIUOW_MKT_CHG_DT_OIL Oil/condensate
mkt_chg_dt_gas OIUOW_MKT_CHG_DT_GAS Gas/NGL
ppn_process_dt OIUOW_PPN_PROCESS_DT PPN proc. date
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
burden_rule OIUOW_BURDEN_RULE Burden Alloc. Rule
funds_type OIUOW_FTYPE Owner Funds Type
simulated /PRA/FT_SIMULATED Simluated

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.

-- DOI Transfer Change Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUOW_DTCH (
    MANDT,            -- Client [MANDT]
    DOC_NO,           -- Doc. number [OIUOW_DOC_NO]
    DOC_YEAR,         -- Document year [OIU_DOC_YEAR]
    EFF_FROM_DT,      -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,        -- Effective To [OIU_EFF_TO_DT]
    DOC_TYPE,         -- Document type [OIUOW_DOC_TYP]
    DOC_DESC,         -- Description [OIUOW_DOC_DESC]
    SHTXT,            -- Description [OIU_SHTXT]
    REF_DOC_NO,       -- Ref. doc.nr [OIUOW_REF_DOC_NO]
    STATUS_CD,        -- Status [OIUOW_STATUS_CD]
    PROCESS_DT,       -- Process date [OIUOW_PROCESS_DT]
    PROCESS_UNAME,    -- Processed by [OIUOW_PROCESS_UNAME]
    SUS_EFF_FROM_DT,  -- Sus.start dt [OIUOW_SUS_EFF_FROM_DT]
    TFER_INV_FL,      -- Xfer. inventory [OIUOW_TFER_INV_FL]
    TFER_IMBAL_FL,    -- Xfer. imbalance [OIUOW_TFER_IMBAL_FL]
    CHECK_IN_FL,      -- Check-in DOI [OIUOW_CHECK_IN_FL]
    TFCH_RSN_CD,      -- Reason Code [OIU_TFCH_RSN_CD]
    GENR_PPA_FL,      -- Generate PPA [OIU_GENR_PPA_FL]
    ACCUM_INTEREST,   -- Accum.int [OIUOW_ACCUM_INTEREST]
    TRANSFER_TYPE,    -- Transfer type [OIUOW_TRANSFER_TYPE]
    GENR_DO_FL,       -- Generated DO [OIU_GENR_DO_FL]
    DOPT_USER_ID,     -- Created By [ERNAM]
    DIV_EFF_DT,       -- Div Eff Date [OIU_DIV_EFF_DT]
    MKT_CHG_DT_OIL,   -- Oil/condensate [OIUOW_MKT_CHG_DT_OIL]
    MKT_CHG_DT_GAS,   -- Gas/NGL [OIUOW_MKT_CHG_DT_GAS]
    PPN_PROCESS_DT,   -- PPN proc. date [OIUOW_PPN_PROCESS_DT]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    BURDEN_RULE,      -- Burden Alloc. Rule [OIUOW_BURDEN_RULE]
    FUNDS_TYPE,       -- Owner Funds Type [OIUOW_FTYPE]
    SIMULATED,        -- Simluated [/PRA/FT_SIMULATED]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR)
);

Learn More